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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!