T.INV.2T (Probability, DegreesOfFreedom) T.INV.2T (Probability; DegreesOfFreedom)
Probability
Number Number
The probability associated with the distribution, which must be greater than 0 and at most 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 two-tailed Student's t-distribution equals the given probability.
Returns the inverse of the two-tailed T.DIST.2T function. Given a probability, this function returns the value that a value of Student's t-distribution exceeds in either direction with that probability. This is the critical value of a two-tailed t-test at the significance level given by the Probability parameter.
Example
T.INV.2T (0.546449, 60)
T.INV.2T (0,546449; 60)
Returns roughly 0.61.