GUSSE function - The function returns the probability that an element of the population is normalized in Excel

GUSSE function: 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)

The following article introduces you to the GAUSS function - one of the functions in the statistical function group is very popular in Excel.

GUSSE function - The function returns the probability that an element of the population is normalized in Excel Picture 1GUSSE function - The function returns the probability that an element of the population is normalized in Excel Picture 1

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:

GUSSE function - The function returns the probability that an element of the population is normalized in Excel Picture 2GUSSE function - The function returns the probability that an element of the population is normalized in Excel Picture 2

- In the cell to calculate enter the formula : = GAUSS (C6)

GUSSE function - The function returns the probability that an element of the population is normalized in Excel Picture 3GUSSE function - The function returns the probability that an element of the population is normalized in Excel Picture 3

- Press Enter -> normalized overall probability is:

GUSSE function - The function returns the probability that an element of the population is normalized in Excel Picture 4GUSSE function - The function returns the probability that an element of the population is normalized in Excel Picture 4

- Similarly copying the formula for the remaining values ​​results:

GUSSE function - The function returns the probability that an element of the population is normalized in Excel Picture 5GUSSE function - The function returns the probability that an element of the population is normalized in Excel Picture 5

- Where x is not a number -> the function returns the error value #VALUE!

GUSSE function - The function returns the probability that an element of the population is normalized in Excel Picture 6GUSSE function - The function returns the probability that an element of the population is normalized in Excel Picture 6

The above are instructions and some specific examples when using GAUSS function in Excel.

Good luck!

4 ★ | 2 Vote