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 grouped frequency distributions and probability distributions.

Topic. This lesson covers: Relative Frequency Distribution and z-scores

  • Statistics with Microsoft Excel by Beverly J. Dretzke, 5th ed.,FREQUENCY( bin:data ) P. 45 – 48, P. 59 – 76

Excel Lecture #9


Relative Frequency Distribution in Excel

Exit Ticket

A veterinarian records the weights of cats treated at a clinic. The weights are normally distributed, with a mean of 9 pounds and a standard deviation of 2 pounds. Find the weights x corresponding to z-scores of 1.96,  –0.44, and 0.