# TINV

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.* You can use the T.DIST function to* You can use the T.DIST.2T function to* You can use the T.DIST.RT function to* You can use the T.INV function to* You can use the T.TEST function to* 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