Quick Navigation

T.DIST.2T Function

Excel 2010+

Summary

The T.DIST.2T function calculates the two-tailed probability of the Student's t-distribution, essential for statistical hypothesis testing with small sample datasets. It replaces traditional t-distribution tables by providing precise probability values directly within Excel formulas.

Syntax

T.DIST.2T(x, deg_freedom)

Parameters

Parameter	Type	Required	Description
x	`Number`	Yes	The numeric value at which to evaluate the t-distribution. Must be non-negative.
deg_freedom	`Integer`	Yes	An integer representing the degrees of freedom. Must be 1 or greater.

Using the T.DIST.2T Function

T.DIST.2T is primarily used in statistical analysis for calculating p-values in two-tailed t-tests. This function is crucial when testing hypotheses about population means using sample data, particularly when sample sizes are small and population standard deviation is unknown.

Common T.DIST.2T Examples

Basic Two-Tailed T-Distribution

=T.DIST.2T(1.96,60)

Calculates the two-tailed probability for t-value 1.96 with 60 degrees of freedom. Returns approximately 0.0546 (5.46%), representing the probability of observing this t-value or more extreme in a two-tailed test.

Hypothesis Test P-Value

=T.DIST.2T(ABS(T.INV(0.95,30)),30)

Demonstrates relationship with T.INV by calculating p-value for 95% one-tailed critical value with 30 degrees of freedom.

Frequently Asked Questions

A two-tailed t-distribution considers extreme values in both tails of the distribution, used when testing if the population mean differs from a hypothesized value (in either direction).

Use T.DIST.2T for two-tailed tests (testing for difference in either direction). Use T.DIST.RT for one-tailed tests (testing for difference in one specific direction).

Yes, as degrees of freedom increase, the t-distribution approaches the normal distribution, and T.DIST.2T provides accurate results.

Common Errors and Solutions

#VALUE!

Cause: Non-numeric input for x or deg_freedom

Solution: Ensure both arguments are valid numbers

#NUM!

Cause: deg_freedom < 1 or x < 0

Solution: Use deg_freedom ≥ 1 and x ≥ 0

Unexpected results with x=0

Cause: T.DIST.2T(0, df) returns 1.0

Solution: This is correct - probability of t ≤ 0 is 100%

Notes

If x < 0, returns #NUM! error
Degrees of freedom must be integer ≥ 1
For large degrees of freedom (>100), results approximate normal distribution
Use ABS() around test statistic for proper two-tailed calculation

Compatibility

Available in: Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365

Not available in: Excel 2007, Excel 2003, Earlier versions

Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2010+