# the criteria for a binomial in excel

*Review the criteria for a binomial in excel.*

*Example*

*a) On this example we will examine the probability a couple who has 8 children has exactly 5 boys.*

*b) Next we will look at the probability that they have more than 5 boys.*

*c) Finally we will look at the probability that they have at most 5 boys.*

*Assume a .5 chance of having a boy.*

*Solution can be solved using excel.*

*a) On this example we will examine the probability a couple who has 8 children has exactly 5 boys.*

*Type this in an excel cell*

*=binom.dist(5,8,.5,False)*

*and then hit enter*

*.21875 would be the answer*

*b) Next we will look at the probability that they have more than 5 boys.*

*Type this in an excel cell*

*=1-binom.dist(5,8,.5,True)*

*and then hit enter*

*.144531 would be the answer*

*c) Finally we will look at the probability that they have at most 5 boys.*

*Assume a .5 chance of having a boy.*

*Type this in an excel cell*

*=binom.dist(5,8,.5,True)*

*and hit enter*

*.855469 would be the answer*

Instructions:

- For your post you will make up a problem similar to this example. Try to have at least 3 scenarios. You will not solve your own problem.