question archive Don’t use the numbers in this example post in your post
Don’t use the numbers in this example post in your post
Subject:MathPrice: Bought3
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.
