T.DIST function
T.DIST converts a t statistic into a left-tailed Student t probability or density, which suits small samples. It is the basis for many t-tests, and negative values are allowed.
Example
Read it as a sentence: find the cumulative probability that a t value is 1.96 or less with 60 degrees of freedom, which gives 0.972677535.
A
B
C
D
1
0.972677535
2
3
Syntax
T.DIST(x, deg_freedom, cumulative)
-
x(required) - The t value.
-
deg_freedom(required) - Degrees of freedom, a positive integer.
-
cumulative(required) - TRUE for the cumulative left-tail probability, FALSE for density.
Returns: The left-tailed Student t probability or density.
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(1.96,60,TRUE) | 0.972677535 | Working example |
=T.DIST(1.96,60,FALSE) | 0.059847906 | Other cumulative flag |
=T.DIST(1.96,60,0) | 0.059847906 | Cumulative as 0 |
=T.DIST("1.96",60,TRUE) | 0.972677535 | Text-number in first arg |
=T.DIST({1.96,1.96},60,TRUE) | 0.972677535 | Array in first arg (lifts, spills) |
=T.DIST(-1.96,60,TRUE) | 0.027322465 | Negative x |
=T.DIST("abc",60,TRUE) | #VALUE! | Non-numeric text in first arg |
=T.DIST(NA(),60,TRUE) | #N/A | Error in first arg |
Watch out for
- Negative x is allowed here but not in T.DIST.2T.
- Degrees of freedom is truncated to an integer.
Where it works
- Excel
- T.DIST arrived in Excel 2010. Older versions do not have it.
- Google Sheets
- Same name, but behaves differently. Sheets has TDIST (right/two-tail) and T.DIST; check cumulative handling.
Part of Statistical functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .