T.INV.2T
The T.INV.2T function calculates the inverse of the twotailed TDIST function.
Sample Usage
T.INV.2T(0.35, 1)
T.INV.2T(A1, A2)
Syntax
T.INV.2T(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

T.INV.2T
is to be used for the inverse of twotailedTDIST
functions. 
T.INV.2T
is synonymous withTINV
. 
To calculate the negative inverse of the onetailed
TDIST
function, useT.INV
. 
Both arguments to
T.INV.2T
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
: Calculates the negative inverse of the onetailed TDIST function.
Examples
In this example, T.INV.2T
uses the probability associated with a Student's twotailed tdistribution and degrees of freedom to return its result.