Hi Everyone,
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.
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.
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.
*Only during the first week of class are assignments not due until 11:59 p.m., ET, Sunday. After Week 1, all initial posts will be due Thursday, by 11:59 pm, ET.
Rubric for grading discussions: 60% – Initial Post; 20% – Each Response up to 2
Please sign ALL your Discussion posts with the name that you like to be called – it makes it so much easier for the rest of us to address you by your preferred name when we respond.