# The required values for this lab can be computed by using Microsoft Excel

**tutor4helpyou**

The required values for this lab can be computed by using Microsoft Excel. The required graphs can be created by either Excel or hand-drawing.

All answers must be entered on this WORD document. Cutting and Pasting from Excel is one very acceptable method to enter the answers into this Word document. The finished document can be submitted in either electronic form to the drop box (for Week 5) or in hard-copy form during class. (Note: Do not submit the Excel file.)

Part 0 -- Binomial Probability Distribution

Based on the values in the Contingency Table, 17.5% of women have systolic blood pressures above 120.

You randomly select 11 women and independently measure the blood pressures for each of these 11 women.

1. Use the above information to construct a binomial distribution showing the probabilities for each possible number of women having systolic blood pressures above 120. In other words, complete the following table.

Binomial Probability Distribution

(where x is the number of Women having Systolic Blood Pressures Above 120 | Probability P() |

0 | 0.120501772 |

1 | 0.281170802 |

2 | 0.298211456 |

3 | 0.189770927 |

4 | 0.080508878 |

5 | 0.023908697 |

6 | 0.005071542 |

7 | 0.000768415 |

8 | 8.14986E-05 |

9 | 5.76253E-06 |

10 | 2.44471E-07 |

11 | 4.71431E-09 |

2. What is the sum of the probabilities in the above table?

3. Use the values in the Binomial Probability Distribution Table to calculate the Mean Value, µ.

4. Use the values in the Binomial Probability Distribution Table to calculate the Standard Deviation, σ.

5. Because this is a binomial probability distribution, there is a simplified formula for the mean value, µ.

What are the letters in that equation? (Write the equation.)

What numerical value did you compute?

How does that value compare with the value computed in #3?

6. Because this is a binomial probability distribution, there is a simplified formula for the standard deviation, σ.

What are the letters in that equation? (Write the equation.)

What numerical value did you compute?

How does that value compare with the value computed in #4?

7. What is the probability that exactly 3 of the women would have systolic blood pressures above 120?

8. What is the probability that fewer than 3 of the women would have systolic blood pressures above 120?

9. What is the probability that more than 3 of the women would have systolic blood pressures above 120?

10. Use the data in the Binomial Probability Distribution table to create and insert a Probability Histogram.

Part I -- Binomial Probability Distribution

Based on the values in the Contingency Table, 52.5% of women have BMI values below 24.9.

You randomly select 9 women and independently measure/compute the BMI values for each of these 9 women.

1. Use the above information to construct a binomial distribution showing the probabilities for each possible number of women having BMI values below 24.9. In other words, complete the following table.

Binomial Probability Distribution

(Number of Women having BMI Values Below 24.9) | Probability P() |

0 | 0.001230956 |

1 | 0.012244772 |

2 | 0.05413478 |

3 | 0.139610748 |

4 | 0.231459924 |

5 | 0.255824127 |

6 | 0.188501988 |

7 | 0.089290415 |

8 | 0.024672352 |

9 | 0.003029938 |

2. What is the sum of the probabilities in the above table?

3. Use the values in the Binomial Probability Distribution Table to calculate the Mean Value, µ.

4. Use the values in the Binomial Probability Distribution Table to calculate the Standard Deviation, σ.

5. Because this is a binomial probability distribution, there is a simplified formula for the mean value, µ.

What are the letters in that equation? (Write the equation.)

What numerical value did you compute?

How does that value compare with the value computed in #3?

6. Because this is a binomial probability distribution, there is a simplified formula for the standard deviation, σ.

What are the letters in that equation? (Write the equation.)

What numerical value did you compute?

How does that value compare with the value computed in #4?

7. What is the probability that exactly 4 of the women would have BMI values below 24.9?

8. What is the probability that fewer than 4 of the women would have BMI values below 24.9?

9. What is the probability that more than 4 of the women would have BMI values below 24.9?

10. Use the data in the Binomial Probability Distribution table to create and insert a Probability Histogram.

Part 2 -- Poisson Probability Distribution.

The website for the National Center for Health Statistics shows that the number of physician office visits per 100 persons is 320. In other words, the average number of visits per person per year is about 3.2.

1. Use the above information to construct a Poisson probability distribution showing the probabilities for reasonable numbers of office visits for randomly selected individuals. In other words, complete the following table.

Poisson Probability Distribution

(Number of Office Visits) | Probability P() |

0 | 0.040762204 |

1 | 0.130439053 |

2 | 0.208702484 |

3 | 0.222615983 |

4 | 0.178092787 |

5 | 0.113979383 |

6 | 0.060789005 |

7 | 0.027789259 |

8 | 0.011115704 |

9 | 0.00395225 |

10 | 0.00126472 |

11 | 0.000367919 |

12 | 9.81116E-05 |

2. What is the sum of the probabilities in the above table?

3. Use the values in the Poisson Probability Distribution Table to calculate the Mean Value, µ.

How does this computed value compare with the indicated average of 3.2?

4. Use the values in the Poisson Probability Distribution Table to calculate the Standard Deviation, σ.

5. Because this is a Poisson probability distribution, there is a simplified formula for the standard deviation, σ.

What are the letters in that equation? (Write the equation.)

What numerical value did you compute?

How does that value compare with the value computed in #4?

6. What is the probability that a randomly selected person will have made exactly zero physician office visits in the last year?

7. What is the probability that a randomly selected person will have made exactly one physician office visits in the last year?

8. What is the probability that a randomly selected person will have made at least one physician office visits in the last year?

9. What is the probability that a randomly selected person will have made exactly three physician office visits in the last year?

10. Use the data in the Poisson Probability Distribution table to create and insert a Probability Histogram.

- 10 years ago

**The required values for this lab can be computed by using Microsoft Excel**

Purchase the answer to view it

- answer.docx
- data.xlsx