** Please review the lesson for this weekbeforediving into this discussion assignment. **

THEN work through the two examples provided below so you're ready to completetheforum assignment according to the instructions provided nearthe bottom of this assignment description.

IMPORTANT: Theseexamples and Excel steps are not just for this forum -- they should reallyhelp you with this week's WebAssign homework/quiz.

EXAMPLE ONE:

a) In 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.

The solution can be found withExcel using these notes.

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 thisin an Excel cell

=binom.dist(5,8,.5,True)

and hit enter

.855469 would be the answer

Note: We use "true" if we're calculating a cumulative probability. We use "false" to calculate the exact probability. In a nutshell, type "TRUE" when you have a "less than" probability (like if the exercise has a strictly "<" sign) and type "FALSE" when you have a strictly "equals" probability.Phrasing like "at least 5" or "5 or more" usually require use of the compliment concept (subtracting from 1).

EXAMPLE TWO:Binomial Distribution in Excel

For binomial distribution exercise, we use the binom.dist command in Excel.

(For Excel 2007 and older, use the command "binomdist.")

Note: We use "true" if we're calculating a cumulative probability. We use "false" to calculate the exact probability. In a nutshell, type "TRUE" when you have a "less than" probability (like if the exercise has a strictly "<" sign) and type "FALSE" when you have a strictly "equals" probability.

Example: A recent survey found that 17% of adults dislike Marshmallow Fluff. Suppose you randomly select four adults and ask them if they like Marshmallow Fluff.

a. What is the probability that exactly two of them dislike Marshmallow Fluff?

b. What is the probability that fewer than two of them dislike Marshmallow Fluff?

c. What is the probability that at least two of them dislike Marshmallow Fluff?

d. What is the probability that 2 or fewer dislike Marshmallow Fluff?

Part a: n = 4, P = 0.17 and x = 2 (we use x = 2 and "FALSE" because we're calculating the exact probability for "equals 2")

Part b: n = 4, P = 0.17 and x < 2 ("fewer than two" means zero or oneso we use x = 1 and "TRUE" because we're adding the probabilities of 0 and 1)

Part c: n = 4, P = 0.17 and x >= 2 ("at least two" means two, three, or four; note that this is thecomplimentof part b)

Part d:n = 4, P = 0.17 and x <= 2 ("two or fewer" means zero, one or two so we use x = 2 and "TRUE" because we're adding the probabilities of 0, 1, and 2)

Instructions for your initial post to this week's forum:

For your initial post, create asimilar problem (make sure it satisfies the definition of a binomial experiment)with3 similar scenariosfor your classmates to solve. Creativity and originality are encouraged!No minimum word count required.Do not give the answers in your initial post - that will be one of your response posts (keep reading....).

At least two response posts are required as described here (no minimum word count required):

POST #1:answer a classmate's exercise- show your Excel work/steps and explain your thought process.

this is the assignment