T.INV Function Explained

The T.INV Function in Microsoft Excel returns the t-value of the Student’s t-distribution, given a probability and the degrees of freedom. It is used to calculate the critical value of the Student’s t-distribution, which is used in hypothesis testing. The syntax for the function is T.INV(probability, degrees_freedom), where probability is the probability associated with the two-tailed Student’s t-distribution, and degrees_freedom is the number of degrees of freedom.

T.INV Function Syntax

T.INV(probability, degrees_freedom)

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