# Documentation/Calc Functions/GAUSS

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## 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:

## ODF standard:

## Equivalent Excel functions:

GAUSS