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
For calculations see attached xls file.
Q 1. See attachment for histograms. Term 2 distribution is closer to Normal distribution than Term 1.
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
Middle ranked candidate (10th+11th)/2 = 10.5 th i.e., class ...
For a given sample data of students of a class with their grades, some statistical analyses are carried out.
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