T.INV (Probability, DegreesOfFreedom) T.INV (Probability; DegreesOfFreedom)
Probability
Number Number
The probability associated with the distribution, which must be strictly between 0 and 1.
DegreesOfFreedom
Number Number
The degrees of freedom for the distribution, which must be at least 1. This value is truncated to an integer.
Returns
Number Number
The t-value at which the cumulative Student's t-distribution equals the given probability.
Returns the inverse of the left-tailed T.DIST function. Given a probability and degrees of freedom, this function returns the t-value at which the cumulative Student's t-distribution equals the given probability. This is useful for determining critical values in t-tests and for constructing confidence intervals when the population standard deviation is unknown.
Example
T.INV (0.66, 2)
T.INV (0,66; 2)
Returns roughly 0.48.