June 18, 2021

# How to use T.INV Function in Excel

The Excel T.INV function calculates 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.

Syntax:= T.INV(probability,deg_freedom)

The T.INV function syntax has the following arguments:

• Probability     Required. The probability associated with the Student’s t-distribution.
• Deg_freedom     Required. The number of degrees of freedom with which to characterize the distribution.

Example: Let’s look at some Excel T.INV function examples and explore how to use the T.INV function as a worksheet function in Microsoft Excel:

Example 1:

Suppose we are given the following data:

If we want to calculate the value of the function for a probability of 0.7, the formula to use is:

Syntax:  =T.INV(B1,B2)

Result: 0.568649063

So, the left-tailed inverse of the student’s t-distribution with a probability of 70% and 4 degrees of freedom is 0.568649063.

Example 2:

Suppose we are given the following data:

If we want to calculate the value of the function for a probability of 0.20, the formula to use is:

Syntax:  =T.INV(B1,B2)

Result: -0.91954378

So, the left-tailed inverse of the student’s t-distribution with a probability of 20% and 10 degrees of freedom is -0.91954378.

Note:

• If either argument is nonnumeric, T.INV returns the #VALUE! error value.
• If probability <= 0 or if probability > 1, T.INV returns the #NUM! error value.
• If deg_freedom is not an integer, it is truncated.
• If deg_freedom < 1, T.INV returns the #NUM! error value.

READ:  How to use COVARIANCE.P Function in Excel

#### Excel

View all posts by Excel →