In: Statistics and Probability
During the course of a semester, 10 students in Mr. Smith’s class took three exams. Use Microsoft®Excel® to compute all the descriptive statistics for the following set of three test scores over the course of a semester. Which test had the highest average score? Which test had the smallest amount of variability? How would you interpret the differences between exams, and note the range, means, and standard deviations over time?
Test 1 |
Test 2 |
Test 3 |
90 |
94 |
95 |
65 |
75 |
90 |
51 |
77 |
91 |
88 |
84 |
93 |
72 |
88 |
92 |
75 |
84 |
90 |
60 |
75 |
83 |
78 |
85 |
90 |
80 |
80 |
92 |
84 |
88 |
94 |
Test 1 | Test 2 | Test 3 | |
90 | 94 | 95 | |
65 | 75 | 90 | |
51 | 77 | 91 | |
88 | 84 | 93 | |
72 | 88 | 92 | |
75 | 84 | 90 | |
60 | 75 | 83 | |
78 | 85 | 90 | |
80 | 80 | 92 | |
84 | 88 | 94 | |
Mean | 74.3 | 83 | 91 |
Standard Deviation | 12.53 | 6.24 | 3.30 |
Range | 39 | 19 | 12 |
The formulas are:
Test 1 | Test 2 | Test 3 | |
90 | 94 | 95 | |
65 | 75 | 90 | |
51 | 77 | 91 | |
88 | 84 | 93 | |
72 | 88 | 92 | |
75 | 84 | 90 | |
60 | 75 | 83 | |
78 | 85 | 90 | |
80 | 80 | 92 | |
84 | 88 | 94 | |
Mean | =AVERAGE(TEST 1 DATA SET) | =AVERAGE(TEST 2) | =AVERAGE(TEST 3) |
Standard Deviation | =STDEV(TEST 1 DATA SET) | =STDEV(TEST 2) | =STDEV(TEST 3) |
Range | =MAX(TEST 1 DATA SET)-MIN(TEST 1 DATA SET) | =MAX(TEST 2)-MIN(TEST 2) | =MAX(TEST 3)-MIN(TEST 3() |
Which test had the highest average score?
Test 3
Which test had the smallest amount of variability?
Test 3
How would you interpret the differences between exams, and note the range, means, and standard deviations over time?
Test 1 scores have the greatest difference, Test 3 has the highest average score & Test 1 score has the greatest amount of variability.