CHISQ.DIST Function
Returns the left-tailed chi-square distribution.
Category
Statistical
Available in
Excel 2010+, Microsoft 365
Returns
A number
Overview
The chi-square distribution describes sums of squared differences — it underlies tests of whether counts match what you expected and of whether two categories are related. It's always positive and skewed to the right.
CHISQ.DIST with cumulative TRUE returns the probability of a value up to x. For test p-values you'll usually want the right tail, CHISQ.DIST.RT.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| x | Yes | The value; can't be negative. |
| deg_freedom | Yes | Degrees of freedom — usually the sample size minus 1 (decimals are truncated); must be at least 1. |
| cumulative | Yes | TRUE for the cumulative (left-tail) probability, FALSE for the density. |
Examples
Example 1 — Left tail and density
Chi-square values with 1 and 4 degrees of freedom.
| A | B | |
|---|---|---|
| 1 | Formula | Result |
| 2 | CHISQ.DIST(3.84,1,TRUE) | 0.9500 |
| 3 | CHISQ.DIST(5,4,FALSE) | 0.1026 |
3.84 is the familiar 5% cut-off for 1 degree of freedom: 95% of the distribution lies below it.
Common mistakes
- #NUM! x is negative, or deg_freedom is less than 1.
Notes
- Related functions: CHISQ.DIST.RT, CHISQ.INV, CHISQ.TEST, GAMMA.DIST.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.