Excel functions / Statistics
CHISQ.INV function
The value below which a given share of the chi-square distribution falls.
Syntax
=CHISQ.INV(probability, deg_freedom)
Arguments
probability: A probability, between 0 and 1.deg_freedom: The degrees of freedom. Decimals are cut off.
When to use it
CHISQ.INV gives the chi-square value below which a share of the distribution falls.
Examples
The 93rd percentile with 1 degree of freedom
A B C D 1 p df 2 0.93 1 3.283 In D2:
=CHISQ.INV(A2, B2)→ 3.283
Common mistakes
- Critical values. For the critical value of a test, CHISQ.INV.RT is the one.
CHISQ.INV 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
- Danish: CHI2.INV
- Dutch: CHIKW.INV
- Finnish: CHINELIÖ.KÄÄNT
- French: LOI.KHIDEUX.INVERSE
- German: CHIQU.INV
- Hungarian: KHINÉGYZET.INVERZ
- Italian: INV.CHI.QUAD
- Norwegian: KJIKVADRAT.INV
- Polish: ROZKŁ.CHI.ODWR
- Portuguese (Brazil): INV.QUIQUA
- Portuguese (Portugal): INV.CHIQ
- Russian: ХИ2.ОБР
- Spanish: INV.CHICUAD
- Swedish: CHI2.INV
- Turkish: KİKARE.TERS
Try CHISQ.INV in the playground
Related functions
- CHISQ.INV.RT: The chi-square value with a given share of the distribution above it: the critical value of a chi-square test.
- CHISQ.DIST: The chi-square distribution: the chance of a value of x or less, or the height of the curve at x.