From the course: Complete Guide to Excel Statistics with Copilot
Join today to access over 25,300 courses taught by industry experts.
Continuous: Calculating normal distribution probabilities
From the course: Complete Guide to Excel Statistics with Copilot
Continuous: Calculating normal distribution probabilities
- [Instructor] The empirical rule tells us that in a normal distribution, about 68% of the distribution of data is within one standard deviation of the mean. 95% is within two standard deviations of the mean, and 99.7% is within three standard deviations of the mean. But how much of the distribution is within the range of -1.5 standard deviations and +0.5 standard deviations from the mean? Well, with the use of Z-score tables, we can find normal distribution values for Z-score of +0.5 and -1.5. And here we can see those normal distribution values. We can also see what exactly those numbers mean. This should be enough information to answer our question. First, here's what those two Z-scores and the associated normal distribution values look like on our normal curve. Remember, we're looking for the area under the curve pointed out by the red arrow. Notice, we know 30.85% of the distribution is above a Z-score of 0.50, and 6.68% of the distribution is below a Z-score of -1.50. If you add…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.