The following table of grades definition is taken from a Students' handbook and it defines the scale of the final grades in a Post Graduate program.
The last two columns the number of students that got that grade in classes of the same subject that was run in two different terms.
Calculate and Display, using Excel, the following:
1. Draw the statistics as a histogram. Do they resemble the Normal Distribution?
2. Find the median, the average grade and the standard deviation of the two terms.
3. Calculate using the t-student distribution to find out if there is a significant difference among these two terms.
(Submit the answer as a file)
|
Grade
|
Range
|
Numeric Grade
|
Number of Students in
term 1
|
Number of Students in term 2
|
|
Outstanding (A*)
|
80 +
|
85
|
1
|
1
|
|
Excellent (A)
|
70-79
|
75
|
3
|
4
|
|
Very Good (B)
|
60-69
|
65
|
8
|
7
|
|
Good (C)
|
50-59
|
55
|
5
|
7
|
|
Marginal Fail (D)
|
40-49
|
45
|
2
|
4
|
|
Fail (F)
|
Below 40
|
0
|
1
|
2
|
|
Total
|
|
|
20
|
25
|