GUSSE function - The function returns the probability that an element of the population is normalized in Excel
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!
You should read it
- CONFIDENCE.NORM function - The function returns the confidence interval of the population by using a normalized distribution in Excel
- ZTEST function - Returns the probability value on one side of the z test in Excel
- TTEST - Returns the probability associated with a Student's t-Test in Excel
- NORM.S.INV function - The function returns the inverse of the normalized distribution with an average value of 0 and a standard deviation of 1 in Excel
- F.INV function - The function returns the inverse of the probability distribution F in Excel
- F.INV.RT function - The function returns the right-inverse head value of the probability distribution F in Excel
Office information
HARMEAN function - The function returns the harmonic average of a data set in Excel
HYPGEOM.DIST - The function returns the hyperbolic distribution in Excel
KURT function - The function returns the sharp coefficient of a dataset in Excel
LARGE function - The function returns the kth largest value in a dataset in Excel
LOGEST - The function returns an array of data that describes an exponential curve that fits the data given in Excel
LOGNORM.DIST - Function returns the logarithmic distribution of x in Excel