Excel like a finance pro.
← The libraryPractice · 2 questions →
Statistical function
CHISQ.DIST.RT
Returns the right-tailed probability of the chi-squared distribution.
Rarely usedDifficulty 1500 · AdvancedUsage rank #387 of 520
When to use it
The right-tailed chi-squared probability: the p-value for a chi-squared statistic.
The shape of it
- Syntax
=CHISQ.DIST.RT(x, deg_freedom)
Worked examples
p-value
=CHISQ.DIST.RT(4,1) → 0.045500264
A statistic of 4 on 1 degree of freedom is significant at 5%.
Critical value check
=CHISQ.DIST.RT(3.841,1) → 0.05
The 5% critical value.
Two degrees of freedom
=CHISQ.DIST.RT(2,2) → 0.367879441
e to the minus 1.
Worth knowing
- Goodness of fit: compute the statistic with SUMPRODUCT((obs-exp)^2/exp), then CHISQ.DIST.RT.
- CHISQ.TEST does the whole calculation from the two tables.
- Replaces CHIDIST.
Where it goes wrong
- #NUM! for negative x.
- Degrees of freedom are truncated to integers.
Related
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.