Documentation/Calc Functions/NORM.S.DIST

Function name:
NORM.S.DIST

Category:
Statistical Analysis

Summary:
Calculates values of the probability density function or cumulative distribution function for the standard normal distribution. The standard normal distribution has a mean of zero and a standard deviation of one.

Syntax:
NORM.S.DIST(Number; Cumulative)

Returns:
Returns a real number in the range [0, 1] which is the value of the probability density function or cumulative distribution function for the standard normal distribution for the specified value.

Arguments:
Number is a real number or a reference to the cell containing that number which is the value for which the standard normal distribution is to be calculated.

Cumulative can be 0 or False to calculate the probability density function. It can be any other value or True to calculate the cumulative distribution function.

Additional details:

 * The formula for NORM.S.DIST is:

If Cumulative is FALSE, NORM.S.DIST returns the probability density function value

If Cumulative is TRUE, NORM.S.DIST returns the cumulative distribution function value
 * For more details on the standard normal distribution, visit Wikipedia.

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/NORM.INV NORM.INV]

[[Special:MyLanguage/Documentation/Calc_Functions/NORMSDIST NORMSDIST]

[[Special:MyLanguage/Documentation/Calc_Functions/NORM.S.INV NORM.S.INV]

[[Special:MyLanguage/Documentation/Calc_Functions/NORMDIST NORMDIST]

[[Special:MyLanguage/Documentation/Calc_Functions/NORMINV NORMINV]

[[Special:MyLanguage/Documentation/Calc_Functions/NORM.DIST NORM.DIST]

[[Special:MyLanguage/Documentation/Calc_Functions/NORMSINV NORMSINV]

ODF standard:
None

Equivalent Excel functions:
NORM.S.DIST