CHIDIST function
CHIDIST returns the p-value for a chi-square statistic, which is the upper-tail area beyond x. It is a compatibility function; use CHISQ.DIST.RT in new workbooks.
Example
Read it as a sentence: find the right-tail chi-square probability for the value in D1 (empty, so 0) with 2 degrees of freedom.
Excel shows 1
D
1
Data
Syntax
CHIDIST(x, deg_freedom)
-
x(required) - The chi-square value to test.
-
deg_freedom(required) - Degrees of freedom, a whole number of 1 or more.
Returns: Right-tail probability of the chi-square distribution.
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 |
|---|---|---|
=CHIDIST(2,2) | 0.367879441 | Working example |
=CHIDIST("2",2) | 0.367879441 | Text-number in first arg |
=CHIDIST({2,2},2) | 0.367879441 | Array in first arg (lifts, spills) |
=CHIDIST(2,2.9) | 0.367879441 | Fractional df truncated |
=CHIDIST(Data!D1,2) | 1 | Blank cell as first arg |
=CHIDIST("abc",2) | #VALUE! | Non-numeric text in first arg |
=CHIDIST(NA(),2) | #N/A | Error in first arg |
=CHIDIST(-1,2) | #NUM! | Negative x |
The Data sheet these formulas read
A cell that starts with = holds that formula.
D
1
Data
Watch out for
- Superseded by CHISQ.DIST.RT; use that in new workbooks.
- Gives the right tail only; do not read it as a cumulative value.
Where it works
- Excel
- CHIDIST is in every version of Excel from 2007 on. Compatibility function: still works in every version, but newer replacements exist.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Compatibility functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .