Buzz
Unveiling the GAUSS function, one of the statistical functions widely favored in Excel.
Description: The function returns the probability of an element in the standardized universe, falling within the mean and standard deviation values. Supported from Excel 2013 onward.
Syntax: GAUSS(z)
In which:
- z: The value to calculate the probability in the standardized population, a mandatory parameter.
Note:
- If the z value of the function is not a numeric type -> the function returns an error value #VALUE!
- If z is an invalid number -> the function returns an error value #NUM!
- The GAUSS function always yields a value less than 0.5 as NORM.S.DIST (0, True) always returns 0.5
Example:
Calculate the standardized population probability of values in the dataset below:
- In the cell where you want to calculate, enter the formula: =GAUSS(C6)
- Press Enter -> the standardized population probability is:
- Similarly, copy the formula for the remaining values to get the results:
- If the x is not a number -> the function returns an error value #VALUE!
Here is a guide along with some specific examples of using the GAUSS function in Excel.
Wishing you all success!
