Excel create normal distribution chart & z-score: standard & cumulative | Excel 1-3| IHDE Academy
HTML-код
- Опубликовано: 22 авг 2024
- This lesson is about how to plot the standard normal distribution on a graph in Microsoft Excel. For this, we will create two charts-one for the probability density and a second for the cumulative probability.
We will also calculate the 95% percentile (quantile) and plot it on the charts.
For this, we use the Microsoft Excel functions:
NORM.DIST
NORM.S.DIST
NORM.S.INV
With this knowledge, you have a reasonable basis for understanding the standard normal distribution table, calculating probabilities and quantiles yourselves, and presenting them in charts.
I wish you much success.
Rolf Ihde