document.write( "<A HREF=/cgi-bin/jump-to-question.mpl?question=1152832>Question 1152832</A>: <I><SPAN STYLE=\"word-break: break-all;\"> my question is if the probability on a excel lab is different then what you get on a calculator?   <BR>\n" );
document.write( " <BR>\n" );
document.write( " im doing a binomial probability distribution using excel and the n=20, p=.45 \r<BR>\n" );
document.write( "\n" );
document.write( "summary of my lab instructions:<BR>\n" );
document.write( "Column A<BR>\n" );
document.write( "1.	In cell A1,  type   x.<BR>\n" );
document.write( "2.	In cell A2, type 0  and press Enter.  In cell A3, type 1 and press Enter.<BR>\n" );
document.write( "3.  Highlight A2 and A3 and place your mouse on the lower right hand corner of cell A3. When your cursor changes to a cross (+  ,referred to as the fill handle), click and hold the right mouse button and drag the box to cover from A3 to A22.\r<BR>\n" );
document.write( "\n" );
document.write( "Column B <BR>\n" );
document.write( "1.	In cell B1, type   PDF.<BR>\n" );
document.write( "2.	Place your cursor in cell B2, and click on Function icon, which is  fx.<BR>\n" );
document.write( "3.	Select Statistical from Function Category.<BR>\n" );
document.write( "4.	Select BINOMDIST from Function name.<BR>\n" );
document.write( "5.	Click OK.<BR>\n" );
document.write( "      BINOMIDST (Binomial Distribution) box<BR>\n" );
document.write( "a.   Type in A2  in  Number_s. <BR>\n" );
document.write( "b.   Type in 20 in Trials.<BR>\n" );
document.write( "c.   Type in .45 in Probability_s.<BR>\n" );
document.write( "d.   Type in False in Cumulative. <BR>\n" );
document.write( "e.   Click on OK.<BR>\n" );
document.write( "Place your mouse on the lower right hand corner of cell B2. Use the fill handle to fill from B2 to B22.\r<BR>\n" );
document.write( "\n" );
document.write( "Column C<BR>\n" );
document.write( "1.	Type CDF in cell C1.<BR>\n" );
document.write( "2.	Place your cursor in cell C2, and click on fx.<BR>\n" );
document.write( "3.	Select  Statistical  and  BINOMDIST.<BR>\n" );
document.write( "4.	Click OK.<BR>\n" );
document.write( "     BINOMIDST (Binomial Distribution) box<BR>\n" );
document.write( "Repeat from a to c. <BR>\n" );
document.write( "d.   Type in True in Cumulative <BR>\n" );
document.write( "e.   Click on OK.\r<BR>\n" );
document.write( "\n" );
document.write( "Place your mouse on the lower right hand corner of cell C2. Use the fill handle to copy the function down through cell C22. <BR>\n" );
document.write( "   \r<BR>\n" );
document.write( "<BR>\n" );
document.write( "\n" );
document.write( "the question i have to do: <BR>\n" );
document.write( "p(the summer of success is exactly ten)<BR>\n" );
document.write( "p(the number of successes is at most 5 )<BR>\n" );
document.write( "p(the number of successes is at least 15) \r<BR>\n" );
document.write( "<BR>\n" );
document.write( "\n" );
document.write( "using the lab the answers would be:<BR>\n" );
document.write( "1: .162300371<BR>\n" );
document.write( "2: 0.004933408<BR>\n" );
document.write( "3: 0.978585644\r<BR>\n" );
document.write( "\n" );
document.write( "but if I use the calculator: <BR>\n" );
document.write( "1: 0.159349455 <BR>\n" );
document.write( "2: .0553341877<BR>\n" );
document.write( "3:  I believe is .0064335525<BR>\n" );
document.write( " <BR>\n" );
document.write( "my lab says to use the chart but is it right?\r<BR>\n" );
document.write( "\n" );
document.write( "thank you for helping \r<BR>\n" );
document.write( "\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 #774927 by </B><A HREF=/tutors/aboutme.mpl?userid=ikleyn><B>ikleyn(52800)</B></A><img src=\"/images/stars/stars-13.gif\" alt=\"\" >&nbsp;<A HREF=/tutors/aboutme.mpl?userid=ikleyn><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/cgi-bin/show-face.mpl?user=ikleyn><BR>You can <A HREF=\"/cgi-bin/embed-solution.mpl?show=1&solution=774927\">put this solution on YOUR website!</A><BR><SPAN STYLE=\"word-break: break-all;\"> .\r<BR>\n" );
document.write( "<BR>\n" );
document.write( "\n" );
document.write( "Read my lessons\r<BR>\n" );
document.write( "\n" );
document.write( "&nbsp;&nbsp;&nbsp;&nbsp;- <A  rel=nofollow HREF=https://www.algebra.com/algebra/homework/Probability-and-statistics/Solving-problems-on-Binomial-distribution-manually.lesson>Solving problems on Binomial distribution</A> \r<BR>\n" );
document.write( "\n" );
document.write( "&nbsp;&nbsp;&nbsp;&nbsp;- <A  rel=nofollow HREF=https://www.algebra.com/algebra/homework/Probability-and-statistics/How-to-calculate-binomial-probabilities-using-Technology.lesson>How to calculate Binomial probabilities using Technology</A> \r<BR>\n" );
document.write( "\n" );
document.write( "&nbsp;&nbsp;&nbsp;&nbsp;- <A  rel=nofollow HREF=https://www.algebra.com/algebra/homework/Probability-and-statistics/Solving-problems-on-Binomial-distribution-using-Technology.lesson>Solving problems on Binomial distribution with Technology</A> \r<BR>\n" );
document.write( "\n" );
document.write( "in this site.\r<BR>\n" );
document.write( "<BR>\n" );
document.write( "\n" );
document.write( "Learn the subject from there.\r<BR>\n" );
document.write( "<BR>\n" );
document.write( "\n" );
document.write( "After reading these lessons, please let me know \r<BR>\n" );
document.write( "<BR>\n" );
document.write( "\n" );
document.write( "<PRE STYLE=\"white-space: pre-wrap; white-space: -moz-pre-wrap; white-space: -pre-wrap; white-space: -o-pre-wrap; word-wrap: break-word;\">\r\n" );
document.write( "    a)  if everything is clear to you in the lessons\r\n" );
document.write( "\r\n" );
document.write( "and\r\n" );
document.write( "\r\n" );
document.write( "    b)  if it helped you to solve your problem, finally.\r\n" );
document.write( "</PRE>\r<BR>\n" );
document.write( "\n" );
document.write( " </SPAN>\n" );
document.write( "</TD></TR></TABLE>\n" );