Solution) The embedded spreadsheet below contains the scores of a previous class on a midterm exam. Exam
Question: The embedded spreadsheet below contains the scores of a previous class on a midterm exam.
Exam Scores
60
73
65
66
83
63
57
75
59
64
74
67
69
62
50
54
69
83
66
62
72
70
68
64
75
73
67
61
85
66
68
65
46
76
65
62
65
68
70
75
61
79
83
70
67
71
54
73
64
61
92
84
57
57
62
60
51
54
76
a) Fill the frequency and relative frequency tables shown below.
Class Frequency Relative Frequency
40 to 49
50 to 59
60 to 69
70 to 79
80 to 89
90 to 99
b) Calculate the mean, median, mode(s) and standard deviation for the exam scores.
mean
median
stdev
mode
Compute the actual percentage of exam scores that fall within one and two standard deviations of the mean
c) Compare the results of the preceding with the empirical guidelines.
d) Calculate the 30th percentile of the scores.
Type of Deliverable: Word Document
