Syntax
T.DIST.2T(x, deg_freedom)
| Parameter | Description |
|---|---|
| x | Parameter of the T.DIST.2T function. |
| deg_freedom | Parameter of the T.DIST.2T function. |
Examples
Two-tailed p-value for t=2.1
Formula
=T.DIST.2T(2.1, 25)
Returns ~0.0459. The two-tailed p-value is about 4.6%, indicating statistical significance at the 5% level.
Non-significant result
Formula
=T.DIST.2T(1.2, 15)
Returns ~0.2489. A p-value of 24.9% is well above typical significance thresholds — no evidence to reject the null.
Highly significant result
Formula
=T.DIST.2T(4, 50)
Returns ~0.0002. A t-value of 4 with 50 degrees of freedom is extremely significant (p < 0.001).
Common Errors
#NUM!
x must be non-negative (pass the absolute value of your test statistic). Degrees of freedom must be at least 1.
#VALUE!
Occurs when arguments are non-numeric.
Tips
x must be non-negative
T.DIST.2T requires x >= 0 because the two-tailed probability is symmetric. If your test statistic is negative, use ABS() to wrap it.
Equals twice the right tail
T.DIST.2T(x, df) = 2 * T.DIST.RT(x, df) when x >= 0. The two-tailed probability is just double the one-tailed probability due to symmetry.
Most common for hypothesis testing
Two-tailed tests are the default in most research. Use T.DIST.2T when you want to test whether a parameter differs from the null in either direction.
Try T.DIST.2T in Viztab
Import your data and use T.DIST.2T with 370+ other formulas. No signup required.
Open Viztab