# Documentation/Calc Functions/GAUSS

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.

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