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

The CHISQ.DIST.RT function was introduced in Excel 2010 and calculates the right-tailed probability of the chi-squared distribution. It has replaced the CHIDIST function and RT in the function name stands for right-tailed.

Formula in cell C6:

=CHISQ.DIST.RT(C3,C4)

Excel Function Syntax

CHISQ.DIST.RT(x,deg_freedom)

Arguments

x Required. A numerical value representing a point in the probability distribution you want to be evaluated.
deg_freedom Required. A numerical value representing the degrees of freedom.

Comments

The CHISQ.DIST.RT function returns

  • #VALUE! error value if x or deg_freedom argument is non-numeric.
  • #NUM! error value if:
    • < 0 (zero)
    • deg_freedom  < 1
    • deg_freedom  > 10^10

deg_freedom argument is converted into integers.