Wauvel

Excel like a finance pro.

← The library

Compatibility function

CHIDIST

Returns the right-tailed chi-squared probability; replaced by CHISQ.DIST.RT.

Rarely usedDifficulty 1450 · AdvancedUsage rank #425 of 520
Practice · 2 questions →

When to use it

The right-tailed chi-squared probability. Replaced by CHISQ.DIST.RT.

The shape of it

Syntax
=CHIDIST(x, deg_freedom)

Worked examples

  • p-value

    =CHIDIST(4,1) → 0.045500264

    A statistic of 4 on 1 degree of freedom.

  • Critical value check

    =CHIDIST(18.307,10) → 0.050001

    The 5% critical value on 10 df.

  • Two df

    =CHIDIST(2,2) → 0.367879441

    e to the minus 1.

Worth knowing

  • Right-tailed only; CHISQ.DIST gives the left tail.
  • Same results as CHISQ.DIST.RT.
  • Degrees of freedom are truncated.

Where it goes wrong

  • #NUM! for negative x.
  • Flagged by the Compatibility Checker.

Related

FORECASTMODEPERCENTILEQUARTILERANKSTDEV

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.