TDIST function
TDIST converts a t statistic into a t-distribution tail probability, or p-value. It is a compatibility function, so use T.DIST.2T or T.DIST.RT in new workbooks.
Example
Read it as a sentence: find the probability for the t value in D1 with 1 degree of freedom, using 2 tails, which gives 1.
Excel shows 1
D
1
Data
Syntax
TDIST(x, deg_freedom, tails)
-
x(required) - Positive t value.
-
deg_freedom(required) - Degrees of freedom.
-
tails(required) - 1 for one-tailed, 2 for two-tailed.
Returns: The t-distribution tail 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 |
|---|---|---|
=TDIST(1,1,2) | 0.5 | Working example |
=TDIST("1",1,2) | 0.5 | Text-number in first arg |
=TDIST({1,1},1,2) | 0.5 | Array in first arg (lifts, spills) |
=TDIST(1,1,1) | 0.25 | One tail |
=TDIST(Data!D1,1,2) | 1 | Blank cell as first arg |
=TDIST("abc",1,2) | #VALUE! | Non-numeric text in first arg |
=TDIST(NA(),1,2) | #N/A | Error in first arg |
=TDIST(-1,1,2) | #NUM! | Negative x |
The Data sheet these formulas read
A cell that starts with = holds that formula.
D
1
Data
Watch out for
- Superseded by T.DIST.2T / T.DIST.RT; use that in new workbooks.
- x must not be negative; use ABS(t) first.
- tails must be 1 or 2.
Where it works
- Excel
- TDIST is in every version of Excel from 2007 on. Compatibility function: still works in every version, but newer replacements exist.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Compatibility functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .