document.write( "<A HREF=/cgi-bin/jump-to-question.mpl?question=1153955>Question 1153955</A>: <I><SPAN STYLE=\"word-break: break-all;\"> GreenBeam Ltd. claims that its compact fluorescent bulbs average no more than 3.55 mg of mercury. A sample of 40 bulbs shows a mean of 3.62 mg of mercury. The standard deviation is 0.23mg and I found the test statistic which is 1.92 but I need help Finding the p-value. (Round intermediate calculations to 2 decimal places. Round your answer to 4 decimal places.) I don't understand how to do it in excel.  </SPAN>\n" );
document.write( "</I><HR><TABLE width=100%><TR><TD><B><A HREF=http://www.algebra.com/>Algebra.Com's</A> Answer #776400 by </B><A HREF=/tutors/aboutme.mpl?userid=jim_thompson5910><B>jim_thompson5910(35256)</B></A><img src=\"/images/stars/stars-13.gif\" alt=\"\" >&nbsp;<A HREF=/tutors/aboutme.mpl?userid=jim_thompson5910><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=776400\">put this solution on YOUR website!</A><BR><SPAN STYLE=\"word-break: break-all;\"> <font color=black size=3><BR>\n" );
document.write( "You have the correct z test statistic. Nice work so far.\r<BR>\n" );
document.write( "<BR>\n" );
document.write( "\n" );
document.write( "Now you'll use the <font color=blue>NORM.DIST</font> function in excel. More info can be found <a  rel=nofollow HREF= \"https://support.office.com/en-us/article/norm-dist-function-edb1cc14-a21c-4e53-839d-8082074c9f8d\">here</a>\r<BR>\n" );
document.write( "<BR>\n" );
document.write( "\n" );
document.write( "The general template of the function is<BR>\n" );
document.write( "<font color=blue>=NORM.DIST(x, mean, standard_dev, cumulative)</font><BR>\n" );
document.write( "In your case, you will type in<BR>\n" );
document.write( "<font color=blue>=NORM.DIST(1.92, 0, 1, 1)</font><BR>\n" );
document.write( "The x is the z score you got<BR>\n" );
document.write( "the mean and standard deviation are 0 and 1 respectively<BR>\n" );
document.write( "Cumulative is set to 1 to indicate we want the area under the normal curve. You can use \"TRUE\" in place of \"1\" for the cumulative part. So your command could look like this: <font color=blue>=NORM.DIST(1.92, 0, 1, TRUE)</font>\r<BR>\n" );
document.write( "<BR>\n" );
document.write( "\n" );
document.write( "The result of that excel calculation is approximately 0.97257105<BR>\n" );
document.write( "This is the area under the curve to the left of z = 1.92<BR>\n" );
document.write( "Subtract this from 1 (see note below) to get<BR>\n" );
document.write( "1-0.97257105 = 0.02742895<BR>\n" );
document.write( "which is also approximate<BR>\n" );
document.write( "This is the approximate area under the standard normal curve that is to the right of z = 1.92\r<BR>\n" );
document.write( "<BR>\n" );
document.write( "\n" );
document.write( "<font color=red>The p value is approximately 0.0274</font>\r<BR>\n" );
document.write( "<BR>\n" );
document.write( "\n" );
document.write( "Note: the reason why I knew to subtract from 1 is because of the hypothesis. The null hypothesis is <IMG STYLE=\"max-width:80%;\" SRC=/cgi-bin/plot-formula.mpl?expression=mu+%3C=+3.55 ALIGN=MIDDLE  ALT=\"mu+%3C=+3.55\"   DISABLED_style= \"max-width:90%; height:auto;\" > (which is where the claim is being made) and the alternative hypothesis is <IMG STYLE=\"max-width:80%;\" SRC=/cgi-bin/plot-formula.mpl?expression=mu+%3E+3.55 ALIGN=MIDDLE  ALT=\"mu+%3E+3.55\"   DISABLED_style= \"max-width:90%; height:auto;\" > which runs counter or opposite to the claim made in the null. The alternative hypothesis tells us we have a right tailed test. <BR>\n" );
document.write( "</font> </SPAN>\n" );
document.write( "</TD></TR></TABLE>\n" );