<< Click to Display Table of Contents >> NORM.S.DIST (standard normal distribution)

Syntax:

NORM.S.DIST(x, cumulative)

Description:

Returns the standard normal (cumulative) distribution function.

The standard normal distribution is a normal distribution (see NORM.DIST/NORMDIST function) with a mean of zero and a standard deviation of 1.

x is the value to be evaluated.

Cumulative determines the type of function as a switch: If you enter the value TRUE, the cumulative distribution function of the standard normal distribution is calculated. By entering the value FALSE, the density function of the standard normal distribution is calculated.

Note:

The NORM.S.DIST function supplements the previous NORMSDIST function with the additional argument Cumulative.

Compatibility notes:

Microsoft Excel supports this function only in version 2010 or later. In older versions, the function is unknown.

Annotation:

The inverse function is NORM.S.INV

See also:

NORMSDIST, NORM.INV/NORMINV, NORM.S.INV/NORMSINV, STANDARDIZE, GAUSS, LOGNORM.INV/LOGINV, LOGNORM.DIST/LOGNORMDIST