Statistics 3

 

Hi Everyone,

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. 
  You MUST provide the correct answer for your problem -- a key, so that classmates will know whether or not their answers to you are correct.
  Let the classmate provide the details of how they worked the problem.
• Then, you will answer 2 classmate’s problems in detail.
  (1) Copy the question, type the excel formulas in an excel spreadsheet and attach it to your post so everyone can check your work.
  (2) Then, write a brief summary after the problem you copied in your post.

Instructions: Your initial post may not be 250 words. Please respond to at least 2 other students. Responses should be a minimum of 100 words