T.INV FunctionWayne Becker20151018T22:32:51+00:00
The T.INV function returns the lefttailed inverse of the 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 function should not be confused with the TINV function, available in earlier versions of Excel. The TINV function calculated the twotailed inverse Student’s TDistribution and is replaced by the T.INV.2T function in Excel 2010.
Syntax
=T.INV(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 
1 
Formula 
Result 
Notes 
2 
=T.INV(0.75,2) 
0.816497 
The lefttailed inverse of the Student’s tdistribution with a probability of 75% and 2 degrees of freedom 
3 
=T.INV(0.75,5) 
0.726687 
The lefttailed inverse of the Student’s tdistribution with a probability of 75% and 5 degrees of freedom 
Common Function Error(s)
Problem 
What went wrong 
#VALUE! 
Occurs if either of the supplied arguments are nonnumeric 
#NUM! 
Occurs if either:

• 
the supplied probability argument is ≤ 0 or > 1 

• 
the supplied deg_freedom argument is < 1 
