# CHISQ.INV.RT

Formulas / CHISQ.INV.RT
Calculate the inverse of the right-tailed probability of a chi-square distribution.
`CHISQ.INV.RT(probability,deg_freedom)`
• probability - a probability associated with the chi-squared distribution
• deg_freedom - the number of degrees of freedom

## Examples

• `=CHISQ.INV.RT(5,0.1)`

The CHISQ.INV.RT function can be used to calculate the inverse of the probability of the chi-squared distribution with a degrees of freedom of A2 and A3. For example, this example returns the inverse of the probability of the chi-squared distribution with a degrees of freedom of 5 and 0.1.

• `=CHISQ.INV.RT(5,0.1)`

The inverse of the probability of the chi-squared distribution is a measure of how much the observed values differ from the expected values. For example, this formula returns the inverse of the probability of the chi-squared distribution with a degrees of freedom of 4 and 0.05. This can be used to determine if the observed values differ significantly from the expected values.

• `=CHISQ.INV.RT(5,0.95)`

The CHISQ.INV.RT function can also be used to calculate the critical value of the chi-squared distribution. For example, this returns the inverse of the probability of the chi-squared distribution with a degrees of freedom of 5 and 0.95. This can be used to determine the critical value for the chi-squared distribution.

## Summary

The CHISQ.INV.RT function is used to compare observed and expected values, such as in financial analysis. It calculates the inverse of the right-tailed probability of a chi-square distribution.

• The CHISQ.INV.RT function was introduced in Excel 2010 and is an updated version of the CHIINV function.
• The CHISQ.INV.RT function can be used to compare observed and expected values for a data set.