Excel create normal distribution chart & z-score: standard & cumulative | Excel 1-3| IHDE Academy
2.7 هزار بار بازدید -
2 سال پیش
-
This lesson is about how
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
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
2 سال پیش
در تاریخ 1401/09/25 منتشر شده
است.
2,705
بـار بازدید شده