Excel functions / Statistics
CHISQ.DIST.RT function
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.
Syntax
=CHISQ.DIST.RT(x, deg_freedom)
Arguments
x: The chi-square statistic, 0 or more.deg_freedom: The degrees of freedom. Decimals are cut off.
When to use it
CHISQ.DIST.RT gives the chance of a chi-square value greater than x: the p-value of a chi-square statistic worked out by hand.
Examples
p-value of 18.307 with 10 degrees of freedom
A B C D 1 x df 2 18.307 10 0.0500 In D2:
=CHISQ.DIST.RT(A2, B2)→ 0.0500
Common mistakes
- From the data. With the observed and expected counts in hand, CHISQ.TEST gives the p-value in one step.
CHISQ.DIST.RT 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.RT
- Danish: CHI2.FORD.RT
- Dutch: CHIKW.VERD.RECHTS
- Finnish: CHINELIÖ.JAKAUMA.OH
- French: LOI.KHIDEUX.DROITE
- German: CHIQU.VERT.RE
- Hungarian: KHINÉGYZET.ELOSZLÁS.JOBB
- Italian: DISTRIB.CHI.QUAD.DS
- Norwegian: KJIKVADRAT.FORDELING.H
- Polish: ROZKŁ.CHI.PS
- Portuguese (Brazil): DIST.QUIQUA.CD
- Portuguese (Portugal): DIST.CHIQ.DIR
- Russian: ХИ2.РАСП.ПХ
- Spanish: DISTR.CHICUAD.CD
- Swedish: CHI2.FÖRD.RT
- Turkish: KİKARE.DAĞ.SAĞK
Also written as CHIDIST.
Try CHISQ.DIST.RT in the playground
Related functions
- 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.
- CHISQ.INV.RT: The chi-square value with a given share of the distribution above it: the critical value of a chi-square test.