T.INV.2T
Definition
Calculates the inverse of the two-tailed 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 two-tailed t-distribution.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 non-integer 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 two-tailedTDIST
functions.T.INV.2T
is synonymous withTINV
.To calculate the negative inverse of the one-tailed
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 t-distribution with a given input (x).
TINV
: Calculates the inverse of the two-tailed TDIST function.
T.INV
: Calculates the negative inverse of the one-tailed TDIST function.
Examples
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.
In order to use the T.INV.2T formula, start with your edited Excellentable:
Then type in the T.INV.2T Formula in the area you would like to display the outcome:
By adding the values you would like to calculate the T.INV.2T 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
|