TINV

Definition: The TINV function in Excel is used to find the value of t for a given probability and degrees of freedom for a Student’s t-distribution.

Syntax: ==TINV(probability, degrees_freedom).

Situation: This formula is appropriate in situations where you need to find the value of t for a given probability and degrees of freedom.

Example: If you have a probability of 0.05 and 10 degrees of freedom, you would use the formula =TINV(0.05, 10). This would return a value of -1.812461123, which is the value of t for a given probability and degrees of freedom.