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.
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