CHISQ.DIST.RT function - The function returns the right end probability of the distribution when squared in Excel

CHISQ.DIST - Function returns 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 in Excel

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

CHISQ.DIST.RT function - The function returns the right end probability of the distribution when squared in Excel Picture 1

Description: 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)

Inside:

- x: Value to evaluate distribution.

- deg_freedom: Number of degrees of freedom.

Attention:

- If any value of the parameter is not numeric -> the function returns the error value #VALUE!

- If deg_freedom is not an integer -> it is truncated to an integer.

- If deg_freedom <1 or deg_freedom> 10 ^ 10 -> the function returns the #NUM! Error value

For example:

Calculate the probability of right end when the square of the distribution according to the data in the table below:

CHISQ.DIST.RT function - The function returns the right end probability of the distribution when squared in Excel Picture 2

- In the cell to calculate enter the formula: = CHISQ.DIST.RT (C6, C7)

CHISQ.DIST.RT function - The function returns the right end probability of the distribution when squared in Excel Picture 3

- Press Enter -> probability of the right end of the distribution when the square is:

CHISQ.DIST.RT function - The function returns the right end probability of the distribution when squared in Excel Picture 4

- Case 1 of the values of the parameters is not a number -> the function returns the error value #VALUE!

CHISQ.DIST.RT function - The function returns the right end probability of the distribution when squared in Excel Picture 5

- If the number of degrees of freedom is less than 1 or greater than 10 ^ 10 -> the function returns the #NUM! Error value

CHISQ.DIST.RT function - The function returns the right end probability of the distribution when squared in Excel Picture 6

Above are instructions and some specific examples when using the CHISQ.DIST.RT function in Excel.

Good luck!

Marvin Fry

Update 19 May 2020

You should read it

May be interested

GAMMA.INV function - The function returns the inverse of the gamma distribution in Excel
gamma.inv: the function returns the inverse of the gamma distribution, using this function to study their distribution variables that may be symmetrical. support functions from excel 2010 onwards. syntax: gamma.inv (probability, alpha, beta)
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])
T.INV function - The function returns the inverse value of the Student t distribution in Excel
t.inv: the function returns the inverse value of the student t-distribution. support functions from excel 2010 onwards. syntax: t.inv (probability, deg_freedom)
BETA.INV function - The function returns the inverse of the cumulative distribution function for a specified beta distribution in Excel
beta.inv function: the function returns the inverse of the cumulative distribution function for a specified beta distribution. support functions from excel 2010 version. syntax: beta.inv (probability, alpha, beta, [a], [b])
NEGBINOM.DIST function - Function returns the negative binomial distribution in Excel
negbinom.dist: the function returns the negative binomial distribution, the probability that there will be number_f failures before the number_s th success, with the probability of success being probability_s. support functions from excel 2010 onwards. syntax: negbinom.dist (number_f, number_s, probab
T.INV.2T - The function returns the two-sided inverse of the Student's t-distribution in Excel
t.inv.2t: the function returns the two-sided inverse of the student's t-distribution. support functions from excel 2010 onwards. syntax: t.inv (probability, deg_freedom)
CHISQ.TEST function - The function returns the independence test in Excel
chisq.test function: the function returns the independence test. the function returns the value from the distribution (({chi ^ 2})) when squared for statistics and the appropriate degrees of freedom. support function from excel 2010 version. syntax: chisq.test (actual_range, expected_range)
NORM.INV function - The function returns the inverse of the standard cumulative distribution in Excel
norm.inv function: the function returns the inverse of the standard cumulative distribution with the standard deviation and the specified mean. support functions from excel 2010 onwards. syntax: norm.inv (probability, mean, standard_dev)
WEIBULL function - The function returns the Weibull distribution in Excel
the function performs the calculation and returns the weibull distribution. based on this distribution to analyze reliability in theory such as calculating the average life of the device or used in the field of meteorology, hydrology and weather forecast.
ZTEST function - Returns the probability value on one side of the z test in Excel
ztest function: the function returns the one-sided probability value of the z test. for the hypothetical population mean, the function returns the probability that the sample mean will be greater than the sample mean observed in the data set or array.

CHISQ.DIST.RT function - The function returns the right end probability of the distribution when squared in Excel

You should read it

May be interested

Office information