This function returns the probability (in the form of a numeric value) specifying that a member of a standard normal population will fall between the mean and specified standard deviations from the mean.

Syntax

GAUSS(z)

Arguments

For the argument, you can specify any real number.

Remarks

This function returns an error value if z is not a valid number or a valid data type.

Data Types

Accepts numeric data. Returns numeric data.

Examples

GAUSS(10) gives the result 0.5

GAUSS(-5) gives the result -0.499