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.
Excel shows 1
D
1
Data
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.
| Formula | Excel shows | Case |
|---|---|---|
=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.
D
1
Data
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 .