Related Functions:

The T.DIST.2T function returns the two-tailed Student’s T Distribution, which is a continuous probability distribution that is frequently used for testing hypotheses on small sample data sets.

• This function was introduced in Excel 2010 and so is not available in earlier versions.
• The T.DIST.2T function, along with the T.DIST.RT function, replace the TDIST function included in earlier versions of Excel.

### Syntax

=T.DIST.2T(x,deg_freedom)

#### Arguments

Argument Description
x The value at which you want to evaluate the distribution
deg_freedom An integer indicating the number of degrees of freedom – must be ≥ 1

#### Examples

A B C D
1 Data Description
2 1.856954 Value at which to evaluate the distribution
3 40 Degrees of freedom
4
5 Formula Result Notes
6 =T.DIST.2T(A2,A3) 7.07% Two-tailed distribution (0.070692 or 7.07%)

#### Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if either of the supplied arguments are non-numeric
#NUM! Occurs if either:

 • the supplied x argument is < 0 • the supplied deg_freedom argument is < 1