# TINV

## Definition

Calculates the inverse of the two-tailed TDIST function.

#### Sample Usage

`TINV(0.35, 1)`

`TINV(A1, A2)`

#### Syntax

`TINV(probability, degrees_freedom)`

• `probability` - The probability associated with the two-tailed t-distribution.

• Must be greater than `0` and less than `1`.

• `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

• `TINV` is to be used for the inverse of two-tailed `TDIST` functions.

• `TINV` is synonymous with `T.INV.2T`.

• To calculate the negative inverse of the one-tailed `TDIST` function, use `T.INV`.

• Both arguments to `TINV` must 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.

#### By adding the values you would like to calculate the TINV formula for, Excellentable will generate the outcome:

A
B
1
Student
Probability associated with the Student's two-tailed t-distribution
2
Tom
0.75
3
Bob
0.05464
4
Peter
0.6
5
John
0.8
6
Steve
0.7
7
Dan
0.65
8
Brendon
0.75
9
10
The t-value of the Student's t-distribution based on the arguments in B3 and C3:
C
1
The number of degrees of freedom with which to characterize the distribution.
2
2
3
60
4
4
5
5
6
6
7
7
8
8
9
10
1.960041186

JavaScript errors detected