NORMSDIST


Calculates values for the cumulative distribution function of a normal distribution.

Syntax:

NORMSDIST(x)

The standard normal distribution is a normal distribution with mean μ = 0 and standard deviation σ = 1.
NORMSDIST calculates the cumulative distribution function of the standard normal distribution.
It is equivalent to NORMDIST(x, 0, 1, 1).

Example:

NORMSDIST(0)
returns 0.5. The standard normal distribution curve is centred on 0, hence half of the curve is below 0.
NORMDIST(0, 0, 1, 1)
also returns 0.5.






 
Created with Zapof