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:
where the z argument is the real number at which you want to evaluate the Gauss function.
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.
For further details and examples of the Excel Gauss function, see the Microsoft Office website.
If you get an error from the Excel Gauss Function, this is likely to be one of the following:
|#NUM!||-||Occurs if the supplied value of z is not a valid number.|
|#VALUE!||-||Occurs if supplied argument is non-numeric.|