Question
In theory a scenario that requires the use of a binomial distribution. Before posting your problem, please review the criteria for binomial distributions by reviewing
In theory a scenario that requires the use of a binomial distribution. Before posting your problem, please review the criteria for binomial distributions by reviewing Week 5 Binomial distribution and Binomial Distribution in Excel
Try to have 3 scenarios. If you can, try a probability different from .5. In your problem, make sure that the probability stays the same for each trial! You will answer problems from classmates for your responses. Copy the question and your Excel formulas into your forum posts so we can check your work. Then, write brief summary of the results after the problem you copied in your post. You MUST provide the correct answer for your problem -- a key, so that classmates will know whether or not their answers to you are correct. Let the classmate provide the details of HOW they worked the problem. Give your classmates some hints and ideas of how to solve the problem (websites/videos/resources/etc.). What could their answer mean in the real world? Also, what other issues could be a factor in their solution's analysis? How do you see this type of problem to be useful in your real life? This is your main post.
On each, post a copy of their problem, and then show your work explaining HOW you worked the problem IN DETAIL with your answer.
Of course, there will be more than one comment on each person's work.
Be helpful in your answers to your classmates.
To earn full credit for this discussion, you must respond to at least two (2) of your peers and post your initial post by Thursday.
_______________________________________________________________
Example initial post:
For this example, assume that a family has 8 children, and the probability that any one child is a boy is .5.
a) Find the probability that the family has exactly 5 boys.
b) Find the probability that the family has more than 5 boys.
c) Find the probability that the family has at most 5 boys.
____________________________________________________________________________________
For your response posts, here is how to solve these problems in Excel.
a) Find the probability that the family has exactly 5 boys.
Type into an Excel cell
=binom.dist(5,8,.5,False)
You should get .21875
b) Find the probability that the family has at most 5 boys.
Type into an Excel cell
=binom.dist(5,8,.5,True)
.855469 should be your answer
c) Find the probability that the family has more than 5 boys.
Type into an Excel cell:
=1-binom.dist(5,8,.5,True)
.144531 should be your answer
Notice that this answer is just 1 minus the answer from part b. Then, describe what these results mean by summarizing the results.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started