Excel functions / Statistics
T.DIST.2T function
The two-tailed t-distribution: the chance of a t further from 0 than x, on either side. This is the p-value of a two-sided t-test.
Syntax
=T.DIST.2T(x, deg_freedom)
Arguments
x: The t-value, 0 or more.deg_freedom: The degrees of freedom. Decimals are cut off.
When to use it
T.DIST.2T gives the chance of a t-value further from 0 than x, on either side: the p-value of a two-sided t-test from its t statistic.
Examples
p-value for t = 1.96 with 60 degrees of freedom
A B C D 1 t df 2 1.96 60 0.0546 In D2:
=T.DIST.2T(A2, B2)→ 0.0546
Common mistakes
- A negative t. T.DIST.2T needs t of 0 or more. Wrap a negative t in ABS.
T.DIST.2T 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: T.DIST.2T
- Danish: T.FORDELING.2T
- Dutch: T.VERD.2T
- Finnish: T.JAKAUMA.2S
- French: LOI.STUDENT.BILATERALE
- German: T.VERT.2S
- Hungarian: T.ELOSZLÁS.2SZ
- Italian: DISTRIB.T.2T
- Norwegian: T.FORDELING.2T
- Polish: ROZKŁ.T.DS
- Portuguese (Brazil): DIST.T.BC
- Portuguese (Portugal): DIST.T.2C
- Russian: СТЬЮДЕНТ.РАСП.2Х
- Spanish: DISTR.T.2C
- Swedish: T.FÖRD.2T
- Turkish: T.DAĞ.2K
Try T.DIST.2T in the playground
Related functions
- T.DIST.RT: The right tail of the t-distribution: the chance of a t greater than x.
- T.TEST: Student's t-test: the chance that two samples would differ this much if they came from populations with the same mean.
- T.INV.2T: The t-value with a given share of the distribution beyond it, counting both tails. This is the critical value of a two-sided test.