# Documentation/Calc Functions/GAUSS

Jump to navigation Jump to search

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.

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

GAUSS