Hi everyone! Read through the material below, watch the videos, work on the Excel lecture and follow up with your instructor if you have questions.


Learning Outcomes.

  • Create probability distributions, as well as identify bell shaped distributions (normal).
  • Assign probabilities to events using the normal distribution.

Topic. This lesson covers: Finding Normal Probabilities

WeBWorK. Set 6.2



Using Excel to Find Normal Probabilities

The Applied View

Watch the video normal calculations.

  1. What is another name for the Empirical rule?
  2. How tall must a woman be to join the Boston Beanstalks Club?
  3. How do you calculate a z-score?
  4. Based on z-scores, are eligibility requirements to join the Boston Beanstalks more difficult to meet for men or for women?

Watch the video Checking Assumption of Normality.

  1. What is the shape of a normal distribution curve?
  2. What characteristics do you expect to see in a histogram of normal data?
  3. What characteristics do you expect to see in a boxplot of normal data?
  4. What pattern in a normal quantile plot tells you that data come from a normal distribution?
  5. Suppose a normal quantile plot has a curved, concave down pattern. Would you expect a histogram of the data to be symmetric, skewed to the right, or skewed to the left?

Exit Ticket

Triglycerides are a type of fat in the bloodstream. The mean triglyceride level in the United States is 134 milligrams per deciliter. Assume the triglyceride levels of the population of the United States are normally distributed with a standard deviation of 35 milligrams per deciliter. You randomly select a person from the United States. What is the probability that the person’s triglyceride level is less than 80? Use Excel to find the probability.