In this article
T.DIST.2T turns a t statistic into a two-tailed p-value, the usual one for ‘is there any difference?’.
Advertisement
Syntax
=T.DIST.2T(x, deg_freedom)| Argument | What it means |
|---|---|
x |
t statistic (positive) |
deg_freedom |
df |
Examples
Example 1
=ROUND(T.DIST.2T(A2,B2),4)Result: 0.0621. See the worked example table below for more cases.
T.DIST.2T in practice
Where you will use it
- p-value from a t statistic
- Regression coefficient tests
- Before/after comparisons
Worked example
| t | df | Formula | Result |
|---|---|---|---|
| 2.1 | 10 | =ROUND(T.DIST.2T(A2,B2),4) | 0.0621 |
| 1 | 20 | =ROUND(T.DIST.2T(A3,B3),4) | 0.3293 |
| 3.5 | 5 | =ROUND(T.DIST.2T(A4,B4),4) | 0.0173 |
Results calculated in Excel.
Mistakes people make
| Mistake | What to do instead |
|---|---|
| Negative t | #NUM!; use ABS(t) |
| One vs two tailed | Two-tailed tests any difference |
Related functions
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
Advertisement
✨ Ask AI about this article
Stuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong