The following article introduces you to the GAUSS function - one of the functions in the statistical function group is very popular in Excel.
Description: The function returns the probability that an element of the normalized population will fall into the mean and the standard deviation. Support functions from Excel 2013 onwards.
Syntax: GAUSS (z)
Inside:
- z: The value to calculate the standardized overall probability, which is a required parameter.
Attention:
- If the function's z value is not numeric -> the function returns the #VALUE! Error value
- If z is an invalid number -> the function returns the #NUM! Error value
- The value of the GAUSS function returns less than 0.5 because NORM.S.DIST (0, True) always returns 0.5
For example:
Calculate the normalized overall probability of the values in the following data table:
- In the cell to calculate enter the formula : = GAUSS (C6)
- Press Enter -> normalized overall probability is:
- Similarly copying the formula for the remaining values results:
- Where x is not a number -> the function returns the error value #VALUE!
The above are instructions and some specific examples when using GAUSS function in Excel.
Good luck!