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

.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.