# Documentation/Calc Functions/NORM.DIST

Jump to navigation Jump to search

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

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

• 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

None

NORM.DIST