Excel functions / Statistics
TDIST function
The tail of the t-distribution beyond x, on one side or both. The older form of T.DIST.RT and T.DIST.2T.
Syntax
=TDIST(x, deg_freedom, tails)
Arguments
x: The t-value, 0 or more.deg_freedom: The degrees of freedom. Decimals are cut off.tails: 1 for one tail, 2 for both.
When to use it
TDIST is the older form of T.DIST.RT and T.DIST.2T: the tail probability beyond x, with 1 for one tail or 2 for both.
Examples
Two tails
A B C D 1 t df 2 1.96 60 0.0546 In D2:
=TDIST(A2, B2, 2)→ 0.0546
Common mistakes
- Negative t. TDIST needs x of 0 or more.
TDIST in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: TDIST
- Danish: TFORDELING
- Dutch: T.VERD
- Finnish: TJAKAUMA
- French: LOI.STUDENT
- German: TVERT
- Hungarian: T.ELOSZLÁS
- Italian: DISTRIB.T
- Norwegian: TFORDELING
- Polish: ROZKŁAD.T
- Portuguese (Brazil): DISTT
- Portuguese (Portugal): DISTT
- Russian: СТЬЮДРАСП
- Spanish: DISTR.T
- Swedish: TFÖRD
- Turkish: TDAĞ