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

Want to practice T.DIST.2T 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.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

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

Arguments

ArgumentRequired?What it does
xYesThe t value; must be 0 or more (use ABS for a negative statistic).
deg_freedomYesDegrees 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.

B4fx=T.DIST.2T(B2,B3)
AB
1MeasureValue
2t statistic2.1
3Degrees of freedom15
4Two-tailed p0.0531
=T.DIST.2T(B2,B3) Explain

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

  • T.DIST.2T replaces the older TDIST(x, df, 2).
  • Related functions: T.DIST.RT, T.INV.2T, T.TEST.
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.