T.DIST.2T Function
Returns the two-tailed Student's t distribution — a two-sided p-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.DIST.2T returns the probability in both tails beyond ±x: the two-sided p-value for a t statistic. A p-value is the chance of seeing a difference at least this big if there were really no difference. Below 0.05 is the usual cut-off for calling a result statistically significant.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| x | Yes | The t value; must be 0 or more (use ABS for a negative statistic). |
| deg_freedom | Yes | Degrees of freedom — usually the sample size minus 1 (decimals are truncated); must be at least 1. |
Examples
Example 1 — p-value for a t statistic
A test gave t = 2.1 with 15 degrees of freedom.
| A | B | |
|---|---|---|
| 1 | Measure | Value |
| 2 | t statistic | 2.1 |
| 3 | Degrees of freedom | 15 |
| 4 | Two-tailed p | 0.0531 |
p ≈ 0.053 — just above 0.05, so not quite significant two-sided.
Common mistakes
- #NUM! x is negative or deg_freedom is less than 1. Wrap a negative statistic in ABS.
Notes

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.