Practice free

T.DIST.2T function

T.DIST.2T turns a t statistic into a two-tailed p-value, the number you compare with 0.05. Negative t values return #NUM!, so use ABS on the t first.

Example

Read it as a sentence: find the two-tailed probability for the t value in D1 with 60 degrees of freedom, which gives 1.

Practice this in the app

Syntax

T.DIST.2T(x, deg_freedom)

x (required)
The t value; must be zero or positive.
deg_freedom (required)
Degrees of freedom, a positive integer.

Returns: The two-tailed Student t probability.

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=T.DIST.2T(1.96,60) 0.05464493 Working example
=T.DIST.2T("1.96",60) 0.05464493 Text-number in first arg
=T.DIST.2T({1.96,1.96},60) 0.05464493 Array in first arg (lifts, spills)
=T.DIST.2T(0,10) 1 X 0
=T.DIST.2T(Data!D1,60) 1 Blank cell as first arg
=T.DIST.2T("abc",60) #VALUE! Non-numeric text in first arg
=T.DIST.2T(NA(),60) #N/A Error in first arg
=T.DIST.2T(-1,10) #NUM! Negative x

The Data sheet these formulas read

A cell that starts with = holds that formula.

Watch out for

  • Negative x returns #NUM!; use ABS(t).
  • It is the p-value, not the probability of the null being true.

Where it works

Excel
T.DIST.2T arrived in Excel 2010. Older versions do not have it.
Google Sheets
Same name, but behaves differently. Sheets has T.DIST.2T.

Part of Statistical functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .