Related Functions:
The T.INV.2T function returns the inverse of 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.INV.2T function replaces the TINV function included in earlier versions of Excel.
Syntax
=T.INV.2T(probability,deg_freedom)
Arguments
Argument  Description 

probability  The probability, between 0 and 1, associated with the Student’s tdistribution 
deg_freedom  An integer indicating the number of degrees of freedom – must be ≥ 1 
Examples
A  B  C  D  

1  Data  Description  
2  0.816497  Probability associated with the twotailed Student’s tdistribution  
3  40  Degrees of freedom  
4  
5  Formula  Result  Notes  
6  =T.INV.2T(A2,A3)  0.233587  Twotailed tvalue of the Student’s tdistribution for the terms above  
7  =T.INV.2T(A2*2,A3)  0.91243  Onetailed tvalue of the Student’s tdistribution for the terms above returned by multiplying the probability by 2 
Note: T.INV.2T function calculates the inverse of the twotailed Student’s T Distribution. If you want to calculate the inverse of the onetailed tdistribution, simply double the probability, i.e. T.INV.2T(2*probability,deg_freedom).
Common Function Error(s)
Problem  What went wrong  

#VALUE!  Occurs if either of the supplied arguments are nonnumeric  
#NUM!  Occurs if either:


#NAME?  Occurs when Analysis ToolPak addin is not enabled 