Order Grade A+ Academic Papers Instantly!

assignment help 9783

assignment help 9783.

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.

assignment help 9783

Solution:

15% off for this assignment.

Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!

Why US?

100% Confidentiality

Information about customers is confidential and never disclosed to third parties.

Timely Delivery

No missed deadlines – 97% of assignments are completed in time.

Original Writing

We complete all papers from scratch. You can get a plagiarism report.

Money Back

If you are convinced that our writer has not followed your requirements, feel free to ask for a refund.