Explore BrainMass

Answering Hypothesis Testing Questions in Excel

A business student claims that on average an MBA student is required to prepare more than five cases per week. To examine the claim, a statistics professor asks a random sample of ten MBA students to report the number of cases they prepare weekly. The results are exhibited here. Can the professor conclude at the 5% significance level that the claim is true, assuming that the number of cases is normally distributed with a standard deviation of 1.5?

2 7 4 8 9 5 11 3 7 4

Solution Summary

This solution provides answers to hypothesis test questions in Excel.