Related Function:

The T.INV function returns the left-tailed 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 two-tailed inverse Student’s T-Distribution 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 t-distribution
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 left-tailed inverse of the Student’s t-distribution with a probability of 75% and 2 degrees of freedom
3 =T.INV(0.75,5) 0.726687 The left-tailed inverse of the Student’s t-distribution 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 non-numeric
#NUM! Occurs if either:

 • the supplied probability argument is ≤ 0 or > 1 • the supplied deg_freedom argument is < 1