The T.INV.2T function calculates the inverse of the two-tailed TDIST function.
probability- The probability associated with the two-tailed t-distribution.
Must be greater than
0and less than
degrees_freedom- The number of degrees of freedom.
Truncated to an integer in the calculation if a non-integer is provided as an argument.
Must be greater than or equal to
T.INV.2Tis to be used for the inverse of two-tailed
T.INV.2Tis synonymous with
To calculate the negative inverse of the one-tailed
Both arguments to
T.INV.2Tmust be numeric or a destination cell whose value is numeric.
TDIST: Calculates the probability for Student's t-distribution with a given input (x).
T.INV: Calculates the negative inverse of the one-tailed TDIST function.
In this example,
T.INV.2T uses the probability associated with a Student's two-tailed t-distribution and degrees of freedom to return its result.