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.

Frequently Asked Questions

What is the CHISQ.INV.RT function?
The CHISQ.INV.RT function is a Sourcetable function which calculates the inverse of the right-tailed probability of the chi-squared distribution. The chi-squared distribution is used to determine whether a hypothesis is valid, and is calculated using the chi-squared test.
How does the CHISQ.INV.RT function work?
The CHISQ.INV.RT function uses an iterative search technique to calculate the inverse of the right-tailed probability of the chi-squared distribution.
What errors can occur when using the CHISQ.INV.RT function?
The CHISQ.INV.RT function throws a #VALUE! error if either argument is nonnumeric, and throws a #NUM! error if the probability is less than 0 or greater than 1.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV