Excel functions / Statistics
CHISQ.DIST function
The chi-square distribution: the chance of a value of x or less, or the height of the curve at x.
Syntax
=CHISQ.DIST(x, deg_freedom, cumulative)
Arguments
x: The value, 0 or more.deg_freedom: The degrees of freedom. Decimals are cut off.cumulative: TRUE for the chance of x or less; FALSE for the height of the curve at x.
When to use it
CHISQ.DIST gives the chance of a value of x or less in a chi-square distribution (with TRUE), or the height of its curve.
Examples
Below 0.5 with 1 degree of freedom
A B C D 1 x df 2 0.5 1 0.5205 In D2:
=CHISQ.DIST(A2, B2, TRUE)→ 0.5205
Common mistakes
- p-values. For the p-value of a chi-square statistic, use CHISQ.DIST.RT.
CHISQ.DIST in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: CHISQ.DIST
- Danish: CHI2.FORDELING
- Dutch: CHIKW.VERD
- Finnish: CHINELIÖ.JAKAUMA
- French: LOI.KHIDEUX.N
- German: CHIQU.VERT
- Hungarian: KHINÉGYZET.ELOSZLÁS
- Italian: DISTRIB.CHI.QUAD
- Norwegian: KJIKVADRAT.FORDELING
- Polish: ROZKŁ.CHI
- Portuguese (Brazil): DIST.QUIQUA
- Portuguese (Portugal): DIST.CHIQ
- Russian: ХИ2.РАСП
- Spanish: DISTR.CHICUAD
- Swedish: CHI2.FÖRD
- Turkish: KİKARE.DAĞ
Try CHISQ.DIST in the playground
Related functions
- CHISQ.DIST.RT: The right tail of the chi-square distribution: the chance of a value greater than x. This is the p-value of a chi-square statistic.
- CHISQ.INV: The value below which a given share of the chi-square distribution falls.
- CHISQ.TEST: The chi-square test of independence: the chance of counts this far from the expected ones if nothing but chance were at work.