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

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

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 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 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 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 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 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 6

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

Good luck!

David Pac

Update 19 May 2020

You should read it

May be interested

F.DIST - The function returns the probability distribution F in Excel
f.dist function: the function returns the probability distribution f. the function supports the version from excel 2010. syntax: f.dist (x, deg_freedom1, deg_freedom2, cumulative)
STANDARDIZE function - The function returns the normalized value from a specific distribution in Excel
standardize function: the function returns the normalized value from a distribution characterized by mean and standard_dev arguments. syntax: standardize (x, mean, standard_dev)
CHISQ.INV.RT function - The function returns the inverse of the right end probability of the distribution when squared in Excel
chisq.inv.rt function: the function returns the inverse of the right end probability of the distribution when squared. support function from excel 2010 version. syntax: chisq.inv.rt (probability, deg_freedom)
F.DIST.RT function - The function returns the right probability distribution F for 2 data sets in Excel
f.dist.rt function: the function returns the right probability distribution f for 2 data sets. support functions from the excel 2010 version. syntax: f.dist (x, deg_freedom1, deg_freedom2)
CONFIDENCE.T function - The function returns the confidence interval of the population by using the Student's t-distribution in Excel
confidence.t function: the function returns the confidence interval of the population by using the student's t-distribution. support functions from excel 2010 onwards. syntax: confidence.norm (alpha, standard_dev, size)
CHISQ.INV function - The function returns the inverse of the probability of the left end of the distribution when squared in Excel
chisq.inv function: the function returns the inverse of the probability of the left end of the distribution when squared. support functions from the excel 2010 version. syntax: chisq.inv (probability, deg_freedom)
BINOM.DIST function - Function returns the probability of binomial distribution of individual terms in Excel
binom.dist function: the function returns the binomial distribution probability of an individual term. support functions from the excel 2010 version. syntax: binom.dist (number_s, trials, probability_s, cumulative)
CHISQ.DIST.RT function - The function returns the right end probability of the distribution when squared in Excel
chisq.dist.rt function: the function returns the probability of the right end of the distribution when squared. support function from excel 2010 version. syntax: chisq.dist.rt (x, deg_freedom)
PROB function - The function returns the probability that values in a range are between two limits in Excel
prob function: the function returns the probability that values in a range are between two limits. syntax: prob (x_range, prob_range, [lower_limit], [upper_limit])
BINOM.DIST.RANGE function - The function returns the probability of a test result using binomial distribution in Excel
binom.dist.range function: the function returns the probability of a test result using binomial distribution. support functions from the excel 2010 version. syntax: binom.dist.range (trials, probability_s, number_s, [number_s2])

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

You should read it

May be interested

Office information