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.
- 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.
Instructions: Your initial post may not be 250 words.
It should look something like the below example and also do the excel with the answer the part that is bold and italic up top
For this example I am choosing coin tosses. The side of the coin I am concerned with is heads.
Assuming a .5 chance of heads and you flip the coin 11 times
what are the chances of the coin landing on heads exactly 7 times?
what are the chances of the coin landing on heads more than 7 times?
what are the chances of the coin landing on heads 7 times at most?
0 comments