TINV
Definition
Calculates the inverse of the twotailed TDIST function.
Sample Usage
TINV(0.35, 1)
TINV(A1, A2)
Syntax
TINV(probability, degrees_freedom)
probability
 The probability associated with the twotailed tdistribution.Must be greater than
0
and less than1
.
degrees_freedom
 The number of degrees of freedom.Truncated to an integer in the calculation if a noninteger is provided as an argument.
Must be greater than or equal to
1
.
Notes
TINV
is to be used for the inverse of twotailedTDIST
functions.TINV
is synonymous withT.INV.2T
.To calculate the negative inverse of the onetailed
TDIST
function, useT.INV
.Both arguments to
TINV
must be numeric or a destination cell whose value is numeric.
See Also
TDIST
: Calculates the probability for Student's tdistribution with a given input (x).
T.INV.2T
: Calculates the negative inverse of the onetailed TDIST function.
T.INV
: Calculates the inverse of the twotailed 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:
A

B



1


2


3


4


5


6


7


8


9


10

C



1


2


3


4


5


6


7


8


9


10
