Draw the statistics as a histogram do they resemble the


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

Solution Preview :

Prepared by a verified Expert
Basic Statistics: Draw the statistics as a histogram do they resemble the
Reference No:- TGS01260353

Now Priced at $20 (50% Discount)

Recommended (91%)

Rated (4.3/5)