SOLUTION: my question is if the probability on a excel lab is different then what you get on a calculator? im doing a binomial probability distribution using excel and the n=20, p=.4

Question 1152832: my question is if the probability on a excel lab is different then what you get on a calculator?

im doing a binomial probability distribution using excel and the n=20, p=.45
summary of my lab instructions:
Column A
1. In cell A1, type x.
2. In cell A2, type 0 and press Enter. In cell A3, type 1 and press Enter.
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.
Column B
1. In cell B1, type PDF.
2. Place your cursor in cell B2, and click on Function icon, which is fx.
3. Select Statistical from Function Category.
4. Select BINOMDIST from Function name.
5. Click OK.
BINOMIDST (Binomial Distribution) box
a. Type in A2 in Number_s.
b. Type in 20 in Trials.
c. Type in .45 in Probability_s.
d. Type in False in Cumulative.
e. Click on OK.
Place your mouse on the lower right hand corner of cell B2. Use the fill handle to fill from B2 to B22.
Column C
1. Type CDF in cell C1.
2. Place your cursor in cell C2, and click on fx.
3. Select Statistical and BINOMDIST.
4. Click OK.
BINOMIDST (Binomial Distribution) box
Repeat from a to c.
d. Type in True in Cumulative
e. Click on OK.
Place your mouse on the lower right hand corner of cell C2. Use the fill handle to copy the function down through cell C22.

the question i have to do:
p(the summer of success is exactly ten)
p(the number of successes is at most 5 )
p(the number of successes is at least 15)

using the lab the answers would be:
1: .162300371
2: 0.004933408
3: 0.978585644
but if I use the calculator:
1: 0.159349455
2: .0553341877
3: I believe is .0064335525

my lab says to use the chart but is it right?
thank you for helping

Answer by ikleyn(52798)   (Show Source): You can put this solution on YOUR website!
.

Read my lessons
    - Solving problems on Binomial distribution
    - How to calculate Binomial probabilities using Technology
    - Solving problems on Binomial distribution with Technology
in this site.

Learn the subject from there.

After reading these lessons, please let me know

    a)  if everything is clear to you in the lessons

and

    b)  if it helped you to solve your problem, finally.

RELATED QUESTIONS
All assignments will only be accepted in Word 2003 (.doc) format. That means if you do an (answered by solver91311)

Hello! I am doing probability distributions and finding the mean and standard deviation... (answered by robertb)

i have a 73% in my english class, on the lab i got a 90%, the lab is worth 25% of my... (answered by ewatrrr)

The percentage of the adult population in a large city that are women is 45%. A court is (answered by greenestamps)

Using a calculator. TI-83Plus. Okay i have had a brain lapse and this is a dumb... (answered by stanbon)

im helping my daughter with homework and were on a prob. 3n =426 someone please HELP (answered by jim_thompson5910)

The engines on an airliner operate independently and the chance of an engine... (answered by greenestamps)

How to present the solution of the following problem on Excel spread sheet as well as on... (answered by sudhanshu_kmr)

In a recent survey of women, 88% admitted that they have never seen a copy of... (answered by greenestamps)