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.
A
B
C
D
1
0.828202856
2
3
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.
| Formula | Excel shows | Case |
|---|---|---|
=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 .