Documentation/Calc Functions/GAUSS

Function name:
GAUSS

Category:
Statistical Analysis

Summary:
Calculates a value from the cumulative distribution function of the standard normal distribution minus 0.5. The standard normal distribution is a special case of the normal distribution, with a mean of 0 and a standard deviation of 1. It is GAUSS(x)=NORMSDIST(x)-0.5.

Syntax:
GAUSS(Number)

Returns:
Returns a real number which is 0.5 less than the cumulative distribution function of the standard normal distribution. It ranges from -0.5 to 0.5, i.e. [-0.5,0.5].

Arguments:
Number is a real number or a reference to the cell containing that number which is the value to be used in the calculation.

Additional details:
For more details on the normal distribution in general, and the standard normal distribution in particular, visit Wikipedia.

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/NORMSDIST NORMSDIST]

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

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

ODF standard:
Section 6.18.33

Equivalent Excel functions:
GAUSS