Documentation/Calc Functions/NORMDIST

From The Document Foundation Wiki
Jump to: navigation, search

Function name:

NORMDIST

Category:

Statistical Analysis

Summary:

Calculates values of the probability density function or cumulative distribution function for the normal distribution for the given arguments.

Syntax:

NORMDIST(Number; Mean; StDev[; C])

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 normal distribution for the given arguments.

Arguments:

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

Mean is a real number or a reference to the cell containing that number which is the mean value of the normal distribution.

StDev is a positive real number or a reference to the cell containing that number which is the standard deviation of the normal distribution.

C 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. By default, its value is TRUE() hence the function calculates the cumulative distribution function if this argument is not passed.

  • If StDev is negative or zero then the function returns an error value.

Additional details:

  • For values of arguments, Mean=0 and StDev=1, NORMDIST calculates the same value as NORM.S.DIST, which is the standard normal distribution.
  • The formula for NORMDIST is:

If C is FALSE(), NORMDIST returns the probability density function value

Normdistp.png

If C is TRUE(), NORMDIST returns the cumulative distribution function value

Normdistc.png
  • For more details on the ormal distribution, visit Wikipedia.

Examples:

Formula Description Returns
=NORMDIST(7.14;1.5;3.2) Calculates the cumulative distribution function(default value is TRUE()) of the normal distribution for the given argument values. 0.961007571808867
=NORMDIST(7.14;1.5;3.2;1) Calculates the cumulative distribution function of the normal distribution for the given argument values. 0.961007571808867
=NORMDIST(7.14;1.5;3.2;0) Calculates the probability density function of the normal distribution for the given argument values. 0.026376219058927
=NORMDIST(1;0;0.25;0) Calculates the probability density function of the normal distribution for the given argument values. 0.00053532090306
=NORMDIST(-7.14;1.5;3.2;0) Calculates the probability density function of the normal distribution for the given argument values. 0.003256542129507
=NORMDIST(7.14;1.5;0;1) For negative and zero value of StDev the function returns an error value. Err:502

Related LibreOffice functions:

NORM.INV

NORM.S.DIST

NORM.S.INV

NORM.DIST

NORMINV

NORMSDIST

NORMSINV

ODF standard:

Section 6.18.52, part 2

Equivalent Excel functions:

NORMDIST