Question: Hello, I am having troubles figuring out how to solve this and the correct Excel formulas to get the right answers. Can you please explain
Hello, I am having troubles figuring out how to solve this and the correct Excel formulas to get the right answers. Can you please explain how to solve that and the Excel formulas you used for it? :
Remark: For all problems below state precisely your null and alternative hypotheses in terms of your parameter and state your final conclusion about rejecting or not your null hypothesis.
1. It is believed that the mean height of middle school students who play basketball on the school team is 71.5 inches. A random sample of 40 players is chosen. The sample mean was 71 inches, and the sample standard deviation was 1.7 inches. Do the data support the claim that the mean height is less than 71.5 inches? Test at level of significance = 5%.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
