Documentation/Calc Functions/GAUSS

From The Document Foundation Wiki
Jump to navigation Jump to search


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.

Examples:

Formula Description Returns
=GAUSS(0.19) Calculates a value from the cumulative distribution function of the standard normal distribution minus 0.5 for 0.19. 0.075345434734796
=GAUSS(0.0375) Calculates a value from the cumulative distribution function of the standard normal distribution minus 0.5 for 0.0375. 0.01495682992591

Related LibreOffice functions:

NORMSDIST

NORMDIST

NORM.S.DIST

ODF standard:

Section 6.18.33

Equivalent Excel functions:

GAUSS