document.write( "<A HREF=/cgi-bin/jump-to-question.mpl?question=144060>Question 144060</A>: <I><SPAN STYLE=\"word-break: break-all;\"> 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?\r<BR>\n" );
document.write( "\n" );
document.write( "At the .01 level of significance, is the true mean greater than 10?<BR>\n" );
document.write( "Ho: mu = 10<BR>\n" );
document.write( "Ha: mu > 10<BR>\n" );
document.write( "t(14.44) = (14.44-10)/[4.45/sqrt(35)] = 4.44*sqrt (35)/4.45 = 5.9027<BR>\n" );
document.write( "p-value = P (5.9027<T <BR>\n" );
document.write( "the p-value is far less than alpha=1%, hasten to reject Ho. <BR>\n" );
document.write( "The test gives strong statistical evidence the mean is not 10.<BR>\n" );
document.write( "the mean is greater than 10; since that is the alternative hypothesis.\r<BR>\n" );
document.write( "\n" );
document.write( "(b) Use Excel to find the right-tail p-value.<BR>\n" );
document.write( " </SPAN>\n" );
document.write( "</I><HR><TABLE width=100%><TR><TD><B><A HREF=http://www.algebra.com/>Algebra.Com's</A> Answer #104879 by </B><A HREF=/tutors/aboutme.mpl?userid=stanbon><B>stanbon(75887)</B></A><img src=\"/images/stars/stars-13.gif\" alt=\"\" >&nbsp;<A HREF=/tutors/aboutme.mpl?userid=stanbon><IMG SRC=http://www.algebra.com/images/aboutme-small.gif BORDER=0 alt=\"About Me\" VALIGN=MIDDLE></A>&nbsp;<IMG SRC=http://www.algebra.com/images/nopicture.jpg><BR>You can <A HREF=\"/cgi-bin/embed-solution.mpl?show=1&solution=104879\">put this solution on YOUR website!</A><BR><SPAN STYLE=\"word-break: break-all;\"> At the .01 level of significance, is the true mean greater than 10?<BR>\n" );
document.write( "Ho: mu = 10<BR>\n" );
document.write( "Ha: mu > 10<BR>\n" );
document.write( "t(14.44) = (14.44-10)/[4.45/sqrt(35)] = 4.44*sqrt (35)/4.45 = 5.9027<BR>\n" );
document.write( "p-value = P (5.9027 the p-value is far less than alpha=1%, hasten to reject Ho. <BR>\n" );
document.write( "The test gives strong statistical evidence the mean is not 10.<BR>\n" );
document.write( "the mean is greater than 10; since that is the alternative hypothesis. <BR>\n" );
document.write( "(b) Use Excel to find the right-tail p-value.<BR>\n" );
document.write( "--------------------<BR>\n" );
document.write( "p-value = P(5.9027 < t < 10 with df=34) = 0.00000057596...<BR>\n" );
document.write( "-----------------<BR>\n" );
document.write( "Your text, \"Applied Stat in Bus and Econ\" tells you how to find the<BR>\n" );
document.write( "p-value using EXCEL in the last paragraph on page 373.<BR>\n" );
document.write( "Use the TDIST formula, fully described on EXCEL help.<BR>\n" );
document.write( "=====================<BR>\n" );
document.write( "Cheers,<BR>\n" );
document.write( "Stan H. </SPAN>\n" );
document.write( "</TD></TR></TABLE>\n" );