GAUSS function: Description, Usage, Syntax, Examples and Explanation
What is GAUSS function in Excel?
Syntax of GAUSS function
GAUSS(z)
The GAUSS function syntax has the following arguments.
- Z Required. Returns a number.
GAUSS formula explanation
- If z is not a valid number, GAUSS returns the #NUM! error value.
- If z is not a valid data type, GAUSS returns the #VALUE! error value.
- Because NORM.S.DIST(0,True) always returns 0.5, GAUSS (z) will always be 0.5 less than NORM.S.DIST(z,True).
Example of GAUSS function
Steps to follow:
1. Open a new Excel worksheet.
2. Copy data in the following table below and paste it in cell A1
Note: For formulas to show results, select them, press F2 key on your keyboard and then press Enter.
You can adjust the column widths to see all the data, if need be.
| Formula | Description | Result |
| ‘=GAUSS(2) | Probability that a member of a standard normal population will fall between the mean and 2 standard deviations from the mean (result is 0.47725). | =GAUSS(2) |