Select Page

Review the criteria for a binomial in excel.Examplea) 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 answerb) 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 answerc) 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 answerInstructions: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.

#### Why Choose Us

• 100% non-plagiarized Papers
• Affordable Prices
• Any Paper, Urgency, and Subject
• Will complete your papers in 6 hours
• On-time Delivery
• Money-back and Privacy guarantees
• Unlimited Amendments upon request
• Satisfaction guarantee

#### How it Works

• Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
• Fill in your paper’s requirements in the "PAPER DETAILS" section.