Question 144060: ok i have answered the question but i am lost on how to apply this to excel has anyone done this before or know how to use this?
At the .01 level of significance, is the true mean greater than 10?
Ho: mu = 10
Ha: mu > 10
t(14.44) = (14.44-10)/[4.45/sqrt(35)] = 4.44*sqrt (35)/4.45 = 5.9027
p-value = P (5.9027
the p-value is far less than alpha=1%, hasten to reject Ho.
The test gives strong statistical evidence the mean is not 10.
the mean is greater than 10; since that is the alternative hypothesis.
(b) Use Excel to find the right-tail p-value.
Answer by stanbon(75887)   (Show Source):
You can put this solution on YOUR website! At the .01 level of significance, is the true mean greater than 10?
Ho: mu = 10
Ha: mu > 10
t(14.44) = (14.44-10)/[4.45/sqrt(35)] = 4.44*sqrt (35)/4.45 = 5.9027
p-value = P (5.9027 the p-value is far less than alpha=1%, hasten to reject Ho.
The test gives strong statistical evidence the mean is not 10.
the mean is greater than 10; since that is the alternative hypothesis.
(b) Use Excel to find the right-tail p-value.
--------------------
p-value = P(5.9027 < t < 10 with df=34) = 0.00000057596...
-----------------
Your text, "Applied Stat in Bus and Econ" tells you how to find the
p-value using EXCEL in the last paragraph on page 373.
Use the TDIST formula, fully described on EXCEL help.
=====================
Cheers,
Stan H.
|
|
|
