Question 888624: It is known that 70% of the customers in a sporting goods store purchase a pair of running shoes. A random sample of 25 customers is selected. Assume that the customers’ purchases are made independently. In this binomial distribution application, which Excel statement will find the probability of 5 or fewer customers purchasing a pair of running shoes?
a.=BINOMDIST(5,25,70%,FALSE)
b.=BINOMDIST(5, 25, 70%,TRUE)
c.=1-BINOMDIST(5,25,70%,FALSE)
d.=1- BINOMDIST(5, 25, 70%,TRUE
Answer by Theo(13342) (Show Source):
You can put this solution on YOUR website! =BINOMDIST(5,25,0.7,TRUE) is the formula to use.
you could also enter =BINOMDIST(5,25,70%,TRUE)
that would be selection b.
the TRUE option makes the results cumulative from 0 to 5.
the FALSE option would give you the probability of 5 only.
the excel results are shown below:
|
|
|