T.INV

Definition: The T.INV function in Excel is used to find the inverse of the left-tailed probability of the Student’s t-distribution.

Syntax: ==T.INV(probability, degrees_freedom).

Situation: This formula is appropriate in situations where you need to find the inverse of the left-tailed probability of the Student’s t-distribution.

Example: If you have a probability of 0.05 and 10 degrees of freedom, you would use the formula =T.INV(0.05, 10). This would return a value that indicates the inverse of the left-tailed probability of the t-distribution.