TINV Function Explained

The TINV Function in Microsoft Excel calculates the inverse of the t-distribution for a given probability and degrees of freedom. It returns the critical value of the t-distribution with a given probability and degrees of freedom. The syntax for the TINV Function is: TINV(probability, degrees_freedom).

TINV Function Syntax

TINV(probability, degrees_freedom)

  • probability: The probability associated with the two-tailed Student’s t-distribution. The probability must be a value between 0 and 1.
  • degrees_freedom: The number of degrees of freedom with which to characterize the distribution. Degrees of freedom must be greater than 0.