Ask a question

Hypothesis excel worksheet

a random sample is selected from a normal population. The population mean is µ=60 and the population standard deviation is σ=15. After a treatment is given to the members of the sample, the sample mean is M=65. The sample size is n=25.
A) The Hypothesis Test:
H0: µ=60
H1: µ<>60
a= 0.05

1 Answer by Expert Tutors

Tutors, sign in to answer this question.
Andre W. | Friendly tutor for ALL math and physics coursesFriendly tutor for ALL math and physics ...
5.0 5.0 (3 lesson ratings) (3)
Since the population standard deviation is known, you would use the z-score to find the P-value for this hypothesis.
We have
z = (M-µ)/(σ/√n) =(65-60)/(15/5) = 1.67.
Use a table or the TI-83 or Excel to find the P-value,
P = 0.096
Since P > a=0.05, the result is NOT significant at the 5% level, so you do NOT reject the null hypothesis µ=60.
It is significant at the 10% level though.