Documentation/Calc Functions/NORMSDIST

From The Document Foundation Wiki
Jump to: navigation, search

Function name:

NORMSDIST

Category:

Statistical Analysis

Summary:

Calculates values of the cumulative distribution function for the standard normal distribution. The standard normal distribution has a mean of zero and a standard deviation of one. It is GAUSS(x)=NORMSDIST(x)-0.5

Syntax:

NORMSDIST(Number)

Returns:

Returns a real number in the range [0, 1] which is the value of the 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.

Additional details:

  • The formula for NORMSDIST is:
Normsdist.png
  • this is exactly NORMDIST(x;0;1;TRUE()).
  • For more details on the standard normal distribution, visit Wikipedia.

Examples:

Formula Description Returns
=NORMSDIST(1) The area below the standard normal distribution curve to the left of X value 1 is around 84% of the total area. 0.841344746068543
=NORMSDIST(7.14) Calculates the cumulative distribution function of the standard normal distribution for the given value. 0.999999999999533
=NORMSDIST(-7.14) Calculates the cumulative distribution function of the standard normal distribution for the given value. 4.66654595751322E-13

Related LibreOffice functions:

NORM.INV

NORM.S.DIST

NORM.S.INV

NORMDIST

NORMINV

NORM.DIST

NORMSINV

ODF standard:

Section 6.18.54, part 2

Equivalent Excel functions:

NORMSDIST