Find the average of results 2 cell types

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

Hi all,
Please help me.

1. find out the results average, mean, highest and lowest score from the Overall marks.
2. Match these same results to the different types of Genre tests.
3. Be able to find out which tests are harder to pass, and the average per test.
4. If possible I would like to be able to compare test 1 to test 2
I am using excel 2003
I have put the files online and here is the password if it is needed.
logon = Andrew, Password = tihajokuluga
https://authentification.site/files/23867384/Test_for_internet_results.xls

Thanks for all or any assistance.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
How can you average a 5+ or 4- ? and same for others too
0