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