From the course: Excel Statistics Essential Training: 1
Unlock the full course today
Join today to access over 23,400 courses taught by industry experts.
Continuous: Z-score tables - Microsoft Excel Tutorial
From the course: Excel Statistics Essential Training: 1
Continuous: Z-score tables
- [Narrator] What do we know so far? We know normal distribution is a continuous distribution. Typically, it's illustrated via the normal curve. We also know that z-scores provide a relative distance from the mean. A data point with a z-score of 2.0 is two standard deviations above the mean. We've also learned about the power of the empirical rule, and we learned how to calculate z-scores for individual data points in our data sets. Those z-scores can tell us how far that data point is from the mean. But z-scores also allow us to calculate probabilities in a continuous distribution. For example, we know 68% of data points are within one standard deviation of the mean, which tells us that 32% of data points are outside of that area. Because the normal curve is symmetrical, we know 16% of those data points are more than one standard deviation from the mean in the positive direction and 16% are more than one standard…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.