ne Insert Draw Page Layout Formulas Data Review View Automate $$ Tell me

Probability Density Function $($PDF$)$

Calculating the propability $($in Excel$)$

$xL$ NORM.DIST$($L$,$mean,std dev,cumulative$)$

$x>U-$ NORM.DIST$($U$,$mean,std dev,cumulative$)$

Jte: The area under the Normal Distribution curve sums up to $100\%$

Ie Normal Distribution is characterised by the Mean and the Standard Deviation

$1$e Standard Normal Distribution is is a special case with Mean$=0$ and Std Dev$=1\mathrm{.}0$

Cumulative Distribution $($CDF$)$ Function

$\backslash$table$[[,$CDF$,$PDF$],[-4\mathrm{.}00,0\mathrm{.}00\%,0\mathrm{.}01\%=$ NORM.S$.$DIST$($L$16,1)],[-3\mathrm{.}75,0\mathrm{.}01\%,0\mathrm{.}04\%=$ NORM.S$.$DIST$($L$17,0)],[-3\mathrm{.}50,0\mathrm{.}02\%,0\mathrm{.}09\%$