T.DIST.2T FunctionWayne Becker20151018T22:32:01+00:00
The T.DIST.2T function returns the twotailed 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% 
Twotailed distribution (0.070692 or 7.07%) 
Common Function Error(s)
Problem 
What went wrong 
#VALUE! 
Occurs if either of the supplied arguments are nonnumeric 
#NUM! 
Occurs if either:

• 
the supplied x argument is < 0 

• 
the supplied deg_freedom argument is < 1 
