Excel functions / Statistics
CHISQ.INV.RT function
The chi-square value with a given share of the distribution above it: the critical value of a chi-square test.
Syntax
=CHISQ.INV.RT(probability, deg_freedom)
Arguments
probability: The share in the right tail, such as 0.05.deg_freedom: The degrees of freedom. Decimals are cut off.
When to use it
CHISQ.INV.RT gives the chi-square value with a given share of the distribution above it: the critical value a chi-square statistic must pass.
Examples
Critical value at 5% with 10 degrees of freedom
A B C D 1 alpha df 2 0.05 10 18.307 In D2:
=CHISQ.INV.RT(A2, B2)→ 18.307
Common mistakes
- Degrees of freedom. For a table, the degrees of freedom are (rows - 1) × (columns - 1).
CHISQ.INV.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.INV.RT
- Danish: CHI2.INV.RT
- Dutch: CHIKW.INV.RECHTS
- Finnish: CHINELIÖ.KÄÄNT.OH
- French: LOI.KHIDEUX.INVERSE.DROITE
- German: CHIQU.INV.RE
- Hungarian: KHINÉGYZET.INVERZ.JOBB
- Italian: INV.CHI.QUAD.DS
- Norwegian: KJIKVADRAT.INV.H
- Polish: ROZKŁ.CHI.ODWR.PS
- Portuguese (Brazil): INV.QUIQUA.CD
- Portuguese (Portugal): INV.CHIQ.DIR
- Russian: ХИ2.ОБР.ПХ
- Spanish: INV.CHICUAD.CD
- Swedish: CHI2.INV.RT
- Turkish: KİKARE.TERS.SAĞK
Also written as CHIINV.
Try CHISQ.INV.RT 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.TEST: The chi-square test of independence: the chance of counts this far from the expected ones if nothing but chance were at work.