Author: Oscar Cronquist Article last updated on September 28, 2018

The CHISQ.INV.RT function was introduced in Excel 2010 and calculates the inverse of the right-tailed probability of the chi-squared distribution. It has replaced the CHIINV function.

Formula in cell C6:

=CHISQ.INV.RT(C3,C4)

Excel Function Syntax

CHISQ.INV.RT(probability,deg_freedom)

Arguments

probability Required. A numerical value representing the probability of the chi-squared function distribution.
deg_freedom Required. A numerical value representing the degrees of freedom.

Comments

The CHISQ.INV.RT function returns

  • #VALUE! error value
    • if probability or deg_freedom argument is non-numeric.
    • if the iterative search can't find a solution after 64 iterations.
  • #NUM! error value if:
    • probability < 0 (zero)
    • probability > 1 (zero)
    • deg_freedom < 1

deg_freedom argument is converted into integers if necessary. CHISQ.DIST.RT and CHISQ.INV.RT are related:

  • CHISQ.DIST.RT(x, deg_freedom) = probability
  • CHISQ.INV.RT(probability,deg_freedom) = x