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
- NORM.S.DIST function - The function returns the normalized distribution with a mean of 0 and a standard deviation of 1 in Excel
- TDIST function - The function returns the probability of the Student distribution in Excel
- CHIDIST function - Function returns the right end probability of the distribution when squared in Excel
- T.TEST function - The function returns the probability associated with Student's t-Test in Excel
- F.DIST - The function returns the probability distribution F in Excel
- STANDARDIZE function - The function returns the normalized value from a specific distribution in Excel
Maybe you are interested
How to turn a photo into a painting using the Generative Fill function in Photoshop
How to use the TREND function in Excel
Google Sheets Functions to Simplify Your Budget Spreadsheets
Instructions for using the TRIMRANGE function to clean up Excel tables
How to master numerical data in Google Sheets with the AVERAGE function
Don't buy headphones if they lack this important function!