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

Syntax:

NORM.S.DIST(x, cumulative)

Description:

This 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 probability 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. The function is unknown in older versions.

Additional info:

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