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


NORMDIST

Syntax: NORMDIST(X, M, S, C)

X = a numeric value
M = the mean of the normal distribution
S = the standard deviation of the normal distribution
C = a boolean value (1 = ``cumulative'')

The cumulative normal distribution from minus infinity to X for mean M and standard deviation S. If C is True (non-zero), the cumulative distribution function F(X) is returned; otherwise, the probability mass function f(X) is returned. The standard deviation S must be greater than zero.

The mathematical formulation is given by:

For C = 0:

\begin{displaymath}
f(X) = \frac{1}{\sqrt{2\pi \times S}}  
e^{-\frac{(X-M)^2}{2S^2}}
\end{displaymath}

For C = 1:

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

Examples:

NORMDIST(1.41, 1, 0, 0) = 0.1476385

NORMDIST(1.41, 1, 0, 1) = 0.92073016

NORMDIST(1.41, 1, 0, 0) = Error

Excel function: NORMDIST


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