The Excel GAUSS Function

Related Function:
NORM.S.DIST

Function Description

The Excel GAUSS function returns the probability that a member of a standard normal population will fall between the mean and a specified number of standard deviations from the mean.

Note: The Gauss function is new in Excel 2013 and so is not available in earlier versions of Excel.

The syntax of the function is:

GAUSS( z )

where the z argument is the real number at which you want to evaluate the Gauss function.


Gauss Function Examples

Gauss Function Chart
Gauss Function for -6 ≤ z ≤ 6

The above chart on the right shows the Gauss Function for values of z between -6 and +6.

In the spreadsheets below, the Excel Gauss function is used to evaluate this function for four different values of z.

 Formulas:
 A
1=GAUSS( -5 )
2=GAUSS( 0 )
3=GAUSS( 0.1 )
4=GAUSS( 2.5 )
 Results:
 A
1-0.499999713
20
30.039827837
40.493790335

For further details and examples of the Excel Gauss function, see the Microsoft Office website.


Gauss Function Errors

If you get an error from the Excel Gauss Function, this is likely to be one of the following:

Common Errors
#NUM!-Occurs if the supplied value of z is not a valid number.
#VALUE!-Occurs if supplied argument is non-numeric.