### TINV(probability, degrees_freedom)

Returns the t-value of the distribution as a function of the probability and the degrees of freedom.

 probability The probability associated with the distribution. degrees_freedom The number of degrees of freedom.

#### Remarks

 * T.INV.2T was added in Excel 2010 to replace this function.* The t distribution is a continuous distribution.* The random variable returned by this function is often referred to as a critical value.* If "probability" < 0, then #NUM! is returned.* If "probability" > 1, then #NUM! is returned.* If "probability" is not numeric, then #VALUE! is returned.* If "degrees_freedom" < 1, then #NUM! is returned.* If "degrees_freedom" is not an integer, it is truncated.* If "degrees_freedom" is not numeric, then #VALUE! is returned.* In Excel 2010 the accuracy of this function was improved.* For the Microsoft documentation refer to support.microsoft.com

 A 1 =TINV(100%,1) = 0.000 2 =TINV(50%,1) = 1.000 3 =TINV(25%,1) = 2.414 4 =TINV(10%,1) = 6.314 5 =TINV(2%,1) = 31.821 6 =TINV(1%,1) = 63.657 7 =TINV(0.5%,1) = 127.321