CHISQ.DIST Function

Returns the left-tailed chi-square distribution.

Category

Statistical

Available in

Excel 2010+, Microsoft 365

Returns

A number

Want to practice CHISQ.DIST in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

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

=CHISQ.DIST(x, deg_freedom, cumulative) Explain

Arguments

ArgumentRequired?What it does
xYesThe value; can't be negative.
deg_freedomYesDegrees of freedom — usually the sample size minus 1 (decimals are truncated); must be at least 1.
cumulativeYesTRUE 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.

B2fx=CHISQ.DIST(3.84,1,TRUE)
AB
1FormulaResult
2CHISQ.DIST(3.84,1,TRUE)0.9500
3CHISQ.DIST(5,4,FALSE)0.1026
=CHISQ.DIST(3.84,1,TRUE) Explain

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

Kyle Stott

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.