T.DIST Function

Returns the left-tailed Student's t distribution.

Category

Statistical

Available in

Excel 2010+, Microsoft 365

Returns

A number

Want to practice T.DIST in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

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

=T.DIST(x, deg_freedom, cumulative) Explain

Arguments

ArgumentRequired?What it does
xYesThe t value.
deg_freedomYesDegrees of freedom — usually the sample size minus 1 (decimals are truncated); must be at least 1.
cumulativeYesTRUE 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.

B4fx=T.DIST(B2,B3,TRUE)
AB
1MeasureValue
2t1.5
3Degrees of freedom10
4Left tail0.9177
5Density0.1274
=T.DIST(B2,B3,TRUE) Explain

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

Kyle Stott

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.