Use excels to generate the binomial probability


Question 1:

The probability that seven occurs when a pair of dice is rolled is 1/6=0.167. Suppose we are Interested in the distribution of the number of sevens that would occur when a pair of dice is rolled 15 times. Use Excels to generate this distribution and turn in the output. Then answer the following questions.

1. What is the most likely number of sevens that you would see in 15 tosses of a pair of dice?

2. What is the probability of getting at most 2 sevens in 15 tosses?

3. What is the probability of getting at least one seven in 15 tosses?

4. What is the mean Number of sevens that occur in 15 tosses?

5. What is the standard deviation of the number of sevens to occur in 15 tosses?

Question 2:

Eighty percent of the population is right-handed. Use Excels to generate the binomial probability. Distribution for the number of right-handers you might find in 20 randomly chosen individuals and turn in this output. Then answer the following questions.

1. What is the most likely number of right-handers that you might find in 20 randomly chosen individuals?

2. What is the probability of getting at most 14 right-handers in 20 randomly chosen individuals?

3. What is the probability of getting at least 15 right-handers in 20 randomly chosen individuals?

4. What is the mean number of right-handers you would find in 20 randomly chosen individuals?

5. What is the standard deviation of the right-handers you would find in 20 randomly chosen individuals?


Attachment:- Labwork.rar

Request for Solution File

Ask an Expert for Answer!!
Basic Statistics: Use excels to generate the binomial probability
Reference No:- TGS01239638

Expected delivery within 24 Hours