next up previous contents index
Next: NORMSINV Up: A. Function Reference Previous: NORMINV   Contents   Index


NORMSDIST

Syntax: NORMSDIST(X)

X = a numeric value

The cumulative standard normal distribution funtion F(X) integrated from minus infinity to X.

The mathematical formulation is given by:

\begin{displaymath}
F(X) = \int_{-\infty}^{X} \frac{1}{\sqrt{2\pi}}  
e^{-\frac{t^2}{2}}   dt
\end{displaymath}

Examples:

NORMSDIST(1.41) = 0.92073016

NORMSDIST(-1.41) = 0.079269841

NORMSDIST(1.96) = 0.9750021

Excel function: NORMSDIST


next up previous contents index
Next: NORMSINV Up: A. Function Reference Previous: NORMINV   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003