Explore BrainMass

T-Test and Estimated Normal distribution

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

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

© BrainMass Inc. brainmass.com October 25, 2018, 8:57 am ad1c9bdddf

Solution Preview

For calculations see attached xls file.

Q 1. See attachment for histograms. Term 2 distribution is closer to Normal distribution than Term 1.

Q 2.
Me = L + (n/2 - cfp)*i/fm
L: lower bound of class (or interval) containing median
n = sample size
cfp = cumulative frequency of the class before median class
fm = frequency of median class
i interval of class

Term 1:
Middle ranked candidate (10th+11th)/2 = 10.5 th i.e., class ...

Solution Summary

For a given sample data of students of a class with their grades, some statistical analyses are carried out.

See Also This Related BrainMass Solution

Analyze business decision opportunities using basic inferential statistics.

use the Confidence Interval Calculator and the Area Gas Prices - Random Sample Excel file

The Minneapolis Star Tribune newspaper has decided to write an article about gasoline prices in the Twin Cities area (Minneapolis and St. Paul). The paper has designed a survey and taken a simple random sample of regular, unleaded gas prices at 35 area stations. The results are in the Area Gas Prices - Random Sample Excel file. Use this data to develop a 95% confidence interval for the average price of regular, unleaded gasoline in the area.

View Full Posting Details