T.INV.2T Function
Returns the two-tailed inverse of the Student's t distribution — the critical t value.
Category
Statistical
Available in
Excel 2010+, Microsoft 365
Returns
A number
Overview
The t distribution is a bell curve with heavier tails, used instead of the normal distribution when the standard deviation is estimated from a small sample. The more degrees of freedom, the closer it gets to the normal curve.
T.INV.2T returns the positive t value that leaves the given probability split across both tails. With 0.05 it gives the multiplier for a 95% confidence interval.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| probability | Yes | The total two-tailed probability, such as 0.05; between 0 and 1. |
| deg_freedom | Yes | Degrees of freedom — usually the sample size minus 1 (decimals are truncated); must be at least 1. |
Examples
Example 1 — Critical values for 95% confidence
Smaller samples need a bigger multiplier than the normal curve's 1.96. Column B is filled down from B2.
| A | B | |
|---|---|---|
| 1 | Sample size | t multiplier |
| 2 | 5 | 2.7764 |
| 3 | 10 | 2.2622 |
| 4 | 20 | 2.0930 |
| 5 | 30 | 2.0452 |
| 6 | 100 | 1.9842 |
With 5 values the multiplier is 2.78; by 100 it's close to 1.96.
Common mistakes
- #NUM! probability is 0 or less or more than 1, or deg_freedom is less than 1.
- Two tails already. Pass 0.05 for 95% confidence, not 0.025.
Notes
- T.INV.2T replaces the older TINV function.
- Related functions: T.INV, CONFIDENCE.T, T.DIST.2T.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.