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.
The GAUSS function syntax has the following arguments:
- Z (required argument) – This is the real number at which we want to evaluate the GAUSS function.
Example: Let’s look at some Excel GAUSS function examples and explore how to use the GAUSS function as a worksheet function in Microsoft Excel:
Based on the Excel spreadsheet above, the following GAUSS examples would return:
- #VALUE! error – Occurs when any of the number arguments that are provided directly to the function are text strings that cannot be interpreted as numbers – that is, the value provided for Z is non-numeric.
- #NUM! error – Occurs when the given value of Z is an invalid number.
- As NORM.S.DIST(0,True) always returns 0.5, GAUSS(z) will always be 0.5 less than NORM.S.DIST(z,True).
- The GAUSS function is not particularly meaningful for negative values of z. To calculate the probability that something falls in the range of -1.5 to the mean, we need to use the formula =GAUSS(1.5).
- If we use Excel 2010 or earlier versions, the formula is =NORM.S.DIST(z,True)-0.5.