Related Functions:

The CHISQ.INV.RT function returns the inverse of the right-tailed probability of the chi-squared distribution.

  • This function was introduced in Excel 2010 and so is not available in earlier versions.
  • CHISQ.INV.RT replaces the CHIINV function included in earlier versions of Excel.

Syntax

=CHISQ.INV.RT(probability,deg_freedom)

Arguments

Argument Description
probability A probability associated with the chi-squared distribution
deg_freedom The number of degrees of freedom

Note: If probability = CHISQ.DIST.RT(x, … ), then CHISQ.INV.RT(probability, … ) = x.

  • Use this function to compare observed results with expected ones in order to decide whether your original hypothesis is valid.

Examples

  A B C
1 Formula Result Notes
2 =CHISQ.INV.RT(0.5,1) 0.454936 Inverse of the one-tailed probability of the chi-squared distribution, for the arguments specified
3 =CHISQ.INV.RT(0.75,1) 0.101531  
4 =CHISQ.INV.RT(0.5,2) 1.386294  
5 =CHISQ.INV.RT(0.75,2) 0.575364  

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if any of the supplied arguments are not recognized as numeric values
#NUM! Occurs if either:

  the supplied probability value is ≤ 0 or > 1
  the supplied deg_freedom argument is < 1