Wauvel

Excel like a finance pro.

← The library

Statistical function

CHISQ.INV.RT

Returns the inverse of the right-tailed chi-squared distribution.

Rarely usedDifficulty 1500 · AdvancedUsage rank #389 of 520
Practice · 2 questions →

When to use it

The chi-squared critical value for a right-tail probability: the number a test statistic must exceed to be significant.

The shape of it

Syntax
=CHISQ.INV.RT(probability, deg_freedom)

Worked examples

  • 5%, 1 df

    =CHISQ.INV.RT(0.05,1) → 3.841458821

    The familiar 3.84.

  • 5%, 4 df

    =CHISQ.INV.RT(0.05,4) → 9.487729037

    A 3×3 table has 4 degrees of freedom.

  • 1%, 10 df

    =CHISQ.INV.RT(0.01,10) → 23.20925116

    1% on 10 degrees of freedom.

Worth knowing

  • Compare the statistic with this value, or compare CHISQ.DIST.RT with alpha; same decision.
  • Replaces CHIINV.
  • Degrees of freedom are truncated.

Where it goes wrong

  • #NUM! for probability outside 0 to 1.
  • Confusing left and right tails gives the wrong critical value.

Related

AVERAGECOUNTCOUNTACOUNTIFCOUNTIFSMAX

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.