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

Do you require help with your paper? Use our custom writing service to achieve better grades and meet your deadlines. Trust our team of writing experts with your work today, and enjoy peace of mind.


Order a Similar Paper Order a Different Paper

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

Our writing experts are ready and waiting to assist with any writing project you may have. From simple essays, research papers, lab reports, and dissertations, to online classes, you can be sure we have a service that perfectly matches your needs.


Order a Similar Paper Order a Different Paper