From the course: Complete Guide to Excel Statistics with Copilot
Unlock this course with a free trial
Join today to access over 24,400 courses taught by industry experts.
Empirical rule
From the course: Complete Guide to Excel Statistics with Copilot
Empirical rule
- [Instructor] As was discussed earlier in this course, the normal distribution, it pops up in all sorts of ways in nature. Heights, weights, test scores, blood pressure. In those types of circumstances, when we have those types of datasets, we often assume that the population is normally distributed, in which case, we would expect our data to follow the empirical rule. The empirical rule states that we should expect 68% of our data to be within one standard deviation of the mean, 95% of our data to be within two standard deviations of the mean, and 99.7% of our data to be within three standard deviations of the mean. So only 0.3% of data points are likely to be farther than three standard deviations from the mean. Again, I must remind you, this works when we have the well-centered, symmetrical, bell-shaped curve. Unfortunately, the empirical rule begins to lose value the farther our dataset strays from the classic normal distribution. But don't be too concerned. You'll be surprised…
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.