Excel like a finance pro.
← The libraryPractice · 2 questions →
Statistical function
T.INV
Returns the left-tailed inverse of the Student t distribution.
Rarely usedDifficulty 1500 · AdvancedUsage rank #412 of 520
When to use it
The t value at a given left-tail probability.
The shape of it
- Syntax
=T.INV(probability, deg_freedom)
Worked examples
Upper critical value
=T.INV(0.975,10) → 2.228138852
The 97.5th percentile on 10 degrees of freedom.
Lower tail
=T.INV(0.05,10) → -1.812461123
The 5th percentile is negative.
Median
=T.INV(0.5,10) → 0
The median.
Worth knowing
- For a two-sided interval use T.INV.2T or T.INV(1-alpha/2,df).
- Confidence interval for a mean: mean ± T.INV(0.975,n-1)*sd/SQRT(n).
- Replaces the manual sign handling of TINV.
Where it goes wrong
- #NUM! for probability outside 0 to 1 or df below 1.
- Left-tailed, so 0.05 gives a negative number.
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.