Calculates the negative inverse of the one-tailed TDIST function.
probability- The probability associated with the 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.INVis to be used for the negative inverse of the one-tailed
Both arguments to
T.INVmust be numeric or a destination cell whose value is numeric.
TDIST: Calculates the probability for Student's t-distribution with a given input (x).
TINV: Calculates the inverse of the two-tailed TDIST function.
In this example,
T.INV uses a
probability value of
45 to compute the result.