Related Functions:

The CHISQ.DIST.RT function returns 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.DIST.RT replaces the CHIDIST function included in earlier versions of Excel.




Argument Description
x The value at which you want to evaluate the chi-square distribution – must be ≥ 0
deg_freedom The number of degrees of freedom – must be an integer between 1 and 1010


  A B C
1 Formula Result Notes
2 =CHISQ.DIST.RT(0.5,2) 0.778801 One-tailed probability of the chi-squared distribution, for the arguments specified
3 =CHISQ.DIST.RT(2,2) 0.367879  
4 =CHISQ.DIST.RT(0.5,3) 0.918891  
5 =CHISQ.DIST.RT(2,3) 0.572407  

Common Function Error(s)

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

  the supplied value of x is negative
  the supplied deg_freedom argument is < 1 or > 1010