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
TINVis to be used for the inverse of two-tailed
TINVis synonymous with
To calculate the negative inverse of the one-tailed
Both arguments to
TINVmust 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.2T: Calculates the negative inverse of the one-tailed TDIST function.
T.INV: Calculates the inverse of the two-tailed TDIST function.
In order to use the TINV formula, start with your edited Excellentable:
Then type in the TINV formula in the area you would like to display the outcome
By adding the values you would like to calculate the TINV formula for, Excellentable will generate the outcome: