T.DIST Function
Returns the left-tailed Student's t distribution.
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 with cumulative TRUE returns the probability of a t value up to x (the left tail). For tests you'll more often want T.DIST.RT or T.DIST.2T.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| x | Yes | The t value. |
| deg_freedom | Yes | Degrees of freedom — usually the sample size minus 1 (decimals are truncated); must be at least 1. |
| cumulative | Yes | TRUE for the cumulative (left-tail) probability, FALSE for the density. |
Examples
Example 1 — Share of the t curve below a value
A t value of 1.5 with 10 degrees of freedom.
| A | B | |
|---|---|---|
| 1 | Measure | Value |
| 2 | t | 1.5 |
| 3 | Degrees of freedom | 10 |
| 4 | Left tail | 0.9177 |
| 5 | Density | 0.1274 |
About 92% of the curve lies below 1.5 (compared with 93% for the normal curve — the t curve's tails are heavier).
Common mistakes
- #NUM! deg_freedom is less than 1.
- Which tail? T.DIST is left-tailed. Use T.DIST.RT for the right tail and T.DIST.2T for both.
Notes
- Related functions: T.DIST.RT, T.DIST.2T, T.INV, T.TEST, NORM.S.DIST.

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.