Statistical
T.DIST.2T Function in Excel
Returns the two-tailed Student's t-distribution.
Syntax
- =T.DIST.2T(x, deg_freedom)
Arguments
- x (required): Value to evaluate (must be positive)
- deg_freedom (required): Degrees of freedom
Examples
- =T.DIST.2T(1.96, 30) - Two-tailed p-value - Result: 0.059
T.DIST.2T for data analysis
- Confirm whether you need entire columns, filtered subsets, or distinct values.
- Use [COUNTIFS](/functions/countifs/) and [SUMIFS](/functions/sumifs/) for multi-criteria metrics.
- Pivot tables complement single-cell statistical formulas for exploration.
Common errors
- #NUM! if x < 0
Use cases
- Two-tailed tests
- Hypothesis testing
- P-value calculation
Frequently asked questions
- What is T.DIST.2T used for? T.DIST.2T returns the two-tailed probability from the t-distribution - the probability of getting a value as extreme as x in either direction. It's commonly used to calculate p-values for two-tailed hypothesis tests.
- How is T.DIST.2T different from T.DIST? T.DIST gives one-tailed probability (area in one tail). T.DIST.2T gives two-tailed probability (area in both tails combined). T.DIST.2T(x, df) = 2 * (1 - T.DIST(x, df, TRUE)) for positive x. Use 2T for two-sided tests.
- How do I interpret T.DIST.2T for hypothesis testing? T.DIST.2T returns the p-value directly for two-tailed tests. If T.DIST.2T(t_stat, df) < 0.05, reject the null hypothesis at 95% confidence. Example: t-statistic=2.5, df=20: =T.DIST.2T(2.5, 20) returns 0.021, so reject H0 at α=0.05.
Editorial review
- Reviewed by Excel.Directory Editorial Team. Updated May 2026.