Excel like a finance pro.
← The libraryPractice · 2 questions →
Statistical function
T.DIST.RT
Returns the right-tailed Student t distribution.
Rarely usedDifficulty 1500 · AdvancedUsage rank #411 of 520
When to use it
The right-tailed t probability: the one-tailed p-value.
The shape of it
- Syntax
=T.DIST.RT(x, deg_freedom)
Worked examples
One-tailed p
=T.DIST.RT(2,10) → 0.036694
Half the two-tailed value.
Zero
=T.DIST.RT(0,10) → 0.5
At zero.
Critical value check
=T.DIST.RT(1.812,10) → 0.05
The one-tailed 5% critical value.
Worth knowing
- Use when the hypothesis has a direction.
- Equals 1 - T.DIST(x,df,TRUE).
- Replaces TDIST with tails 1.
Where it goes wrong
- Negative x gives probabilities above 0.5, which is correct but confusing.
- Degrees of freedom are truncated.
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.