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

Комментарии •