Calculates the probability of a standard normal variable falling between the mean and z standard deviations from the mean.
Sample Usage
GAUSS(2)
GAUSS(A2)
Syntax
GAUSS(number)
- number - The number of standard deviations from the mean.
Examples
GAUSS(2) returns a value of 0.4772
Notes
- A negative z value causes GAUSS to return a negative number.
- GAUSS(A2) returns 0 if there's no data in the cell A2.