# Don’t use the numbers in this example post in your post. Please make sure all posts are unique and use different numbers. Review the criteria for a binomial in excel by going to content, week 4, lear

Don’t use the numbers in this example post in your post.  Please make sure all posts are unique and use different numbers.

Review the criteria for a binomial in excel by going to content, week 4, learning material and looking at the 4 items on binomial below Readings and Resources before selecting your problem.

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

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

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 