Practice free

CHISQ.DIST function

CHISQ.DIST gives the chance of seeing a chi-squared value up to x, using the left tail. It is the building block for goodness-of-fit and independence tests.

Example

Read it as a sentence: find the cumulative chi-square probability at 5 with 3 degrees of freedom.

Practice this in the app

Syntax

CHISQ.DIST(x, deg_freedom, cumulative)

x (required)
Value at which to evaluate; not negative.
deg_freedom (required)
Degrees of freedom, 1 or more.
cumulative (required)
TRUE for the cumulative left-tail probability, FALSE for the density.

Returns: The left-tailed chi-squared distribution value at x.

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=CHISQ.DIST(5,3,TRUE) 0.828202856 Working example
=CHISQ.DIST(5,3,FALSE) 0.073224913 Other cumulative flag
=CHISQ.DIST(5,3,0) 0.073224913 Cumulative as 0
=CHISQ.DIST("5",3,TRUE) 0.828202856 Text-number in first arg
=CHISQ.DIST({5,5},3,TRUE) 0.828202856 Array in first arg (lifts, spills)
=CHISQ.DIST(0,2,FALSE) 0.5 X 0 density df 2
=CHISQ.DIST("abc",3,TRUE) #VALUE! Non-numeric text in first arg
=CHISQ.DIST(NA(),3,TRUE) #N/A Error in first arg

Watch out for

  • Left tail only; use CHISQ.DIST.RT for p-values.
  • deg_freedom is truncated to an integer.

Where it works

Excel
CHISQ.DIST arrived in Excel 2010. Older versions do not have it.
Google Sheets
Same name, same behaviour for everyday use.

Part of Statistical functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .