EXCEL T.INV FUNCTION

The Excel T.INV function computes the left-tailed invert of the Student’s T Distribution, which is a continuous probability distribution commonly used for data analysis on tiny sample data sets.

Syntax :

=T.INV( probability, degrees_freedom )

Parameters :

  • probability – The probability (from 0 and 1) for which the inverse of the left-tailed Student’s T Distribution should be calculated.
  • degrees freedom – The amount of degrees of freedom required (must be 1).

Step By Step Guide of T.INV Function

Example :

The left-tailed Inverse Student’s T Distribution with 10 degrees of freedom is seen on the right.

If you need to determine the value of this function for a probability of 0.25, use the Excel T.Inv function, as shown below:
T.INV = T.INV ( 0.25, 10 )

This produces the value -0.699812061.

T.Inv Function
  • #NUM! – If any of the following conditions is encountered:

    The given probability is either 0 or greater than 1. or The given degrees of freedom value is 1.

  • #VALUE! – Occurs if one or both of the supplied arguments is not a number.

Related Functions

HLOOKUP Function

HLOOKUP Function

Explore Now

VLOOKUP Function

VLOOKUP Function

Explore Now

INDEX Function

INDEX Function

Explore Now

MATCH Function

MATCH Function

Explore Now

DATE Function

DATE Function

Explore Now

IF Function

IF Function

Explore Now

OR Function

OR Function

Explore Now

AND Function

AND Function

Explore Now

RANK Function

RANK Function

Explore Now

SUMIF Function

SUMIF Function

Explore Now

XIRR Function

XIRR Function

Explore Now

WORKDAYS Function

WORKDAYS Function

Explore Now