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:

T.INV Function - How to use T.INV Function in Excel

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

T.INV Function in Excel - How to use T.INV Function in Excel

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:

T.INV Function 2 - How to use T.INV Function in Excel

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

T.INV Function 1 - How to use T.INV Function in Excel

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 T.DIST.RT Function in Excel

Add a Comment

Your email address will not be published. Required fields are marked *