SOLUTION: 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 me

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.
RELATED QUESTIONS
I have done this work before and I had no problem but now I have a fraction so I am lost. (answered by stanbon)

I have done these before but I can not remember how I am suppose to do this?Simplify. (answered by checkley75)

This is a unusual question but I came here because I don’t have anyone else to ask... (answered by MathLover1,ikleyn)

ok i am so so at square roots but this has me lost 6 square root of 2 i have tried... (answered by Edwin McCravy)

I tried to prove this but I am lost on how to finish or am I done? Proof: ∀ x, (answered by solver91311)

I need help on this question. I know the answer but i dont understand how to get to... (answered by amoresroy,Alan3354)

Can anyone help me? I did the first step to this question and am lost on how to complete... (answered by edjones)

Quadratic Functions and Equations The first question I gave it go at. Solve.... (answered by richwmiller,solver91311)

In evaluating the problem x+y/10 where x=58 and y=12, how would you do this? I do not... (answered by mananth)