Skip to main content

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.

See Also

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:

 

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

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.

Contact Support Close