Documentation/Calc Functions/NORM.DIST

From The Document Foundation Wiki
Jump to navigation Jump to search


Function name:

NORM.DIST

Category:

Statistical Analysis

Summary:

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

Syntax:

NORM.DIST(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.

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

Additional details:

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

If C is FALSE(), NORM.DIST returns the probability density function value

Normdistp.png

If C is TRUE(), NORM.DIST returns the cumulative distribution function value

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

Examples:

Formula Description Returns
=NORM.DIST(7.14;1.5;3.2;1) Calculates the cumulative distribution function of the normal distribution for the given argument values. 0.961007571808867
=NORM.DIST(7.14;1.5;3.2;0) Calculates the probability density function of the normal distribution for the given argument values. 0.026376219058927
=NORM.DIST(1;0;0.25;0) Calculates the probability density function of the normal distribution for the given argument values. 0.00053532090306
=NORM.DIST(-7.14;1.5;3.2;0) Calculates the probability density function of the normal distribution for the given argument values. 0.003256542129507
=NORM.DIST(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

NORMDIST

NORMINV

NORMSDIST

NORMSINV

ODF standard:

None

Equivalent Excel functions:

NORM.DIST