Excel functions / Statistics
T.INV function
The t-value below which a given share of the t-distribution falls.
Syntax
=T.INV(probability, deg_freedom)
Arguments
probability: A probability, between 0 and 1.deg_freedom: The degrees of freedom. Decimals are cut off.
When to use it
T.INV gives the t-value below which a share of the t-distribution falls.
Examples
The 75th percentile with 2 degrees of freedom
A B C D 1 p df 2 0.75 2 0.8165 In D2:
=T.INV(A2, B2)→ 0.8165
Common mistakes
- Critical values. For the critical value of a two-sided test, T.INV.2T is simpler.
T.INV in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: T.INV
- Danish: T.INV
- Dutch: T.INV
- Finnish: T.KÄÄNT
- French: LOI.STUDENT.INVERSE.N
- German: T.INV
- Hungarian: T.INVERZ
- Italian: INVT
- Norwegian: T.INV
- Polish: ROZKŁ.T.ODWR
- Portuguese (Brazil): INV.T
- Portuguese (Portugal): INV.T
- Russian: СТЬЮДЕНТ.ОБР
- Spanish: INV.T
- Swedish: T.INV
- Turkish: T.TERS
Related functions
- T.INV.2T: The t-value with a given share of the distribution beyond it, counting both tails. This is the critical value of a two-sided test.
- T.DIST: Student's t-distribution: the chance of a t of x or less, or the height of the curve at x.
- NORM.S.INV: The z-score below which a given share of the standard normal distribution falls.