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

The CHISQ.DIST function calculates the probability of the chi-squared distribution. Use this function to check if a hypothesize is valid. It allows you to calculate the cumulative distribution or the probability density function.

The CHISQ.DIST function was introduced in Excel 2010 and has replaced the CHIDIST function.

Formula in cell C6:

=CHISQ.DIST(C3,C4)

Excel Function Syntax

CHISQ.DIST(x,deg_freedom,cumulative)

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.
cumulative Required. A boolean value.
TRUE - Cumulative distribution function
FALSE - Probability density function

Comments

The CHISQ.DIST function returns

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

deg_freedom argument is converted into integers.