Review the criteria for a binomial in the announcements before selecting your problem.
Need help with this assignment?Get an original answer from a qualified tutor — from $10/page.
Get it written →Review the criteria for a binomial in the announcements before selecting your problem.
Example
a) On this example we will examine the probability a couple who has 8 children and 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.
Then you will answer 2 classmates problems. Copy the question, type the excel formulas in an excel spreadsheet and attach it to your post so your professor and classmates can check your work. Then write a brief summary after the problem you copied in your post.
Get a plagiarism-free answer to this question
Send us your instructions and we’ll match you with the best writer in your subject.
- 100% human-written, zero AI
- Turnitin report included
- Confidential — we never share your data
- Free revisions & refunds