Excel functions / Statistics
T.INV.2T function
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.
Syntax
=T.INV.2T(probability, deg_freedom)
Arguments
probability: The share in both tails together, such as 0.05.deg_freedom: The degrees of freedom. Decimals are cut off.
When to use it
T.INV.2T gives the t-value with a given share of the distribution beyond it, both tails together: the critical value of a two-sided test, and what multiplies the standard error in a confidence interval.
Examples
Critical t at 5% with 10 degrees of freedom
A B C D 1 alpha df 2 0.05 10 2.228 In D2:
=T.INV.2T(A2, B2)→ 2.228
Common mistakes
- Alpha, not confidence. Give 0.05 for a 95% interval, not 0.95.
T.INV.2T 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.2T
- Danish: T.INV.2T
- Dutch: T.INV.2T
- Finnish: T.KÄÄNT.2S
- French: LOI.STUDENT.INVERSE.BILATERALE
- German: T.INV.2S
- Hungarian: T.INVERZ.2SZ
- Italian: INV.T.2T
- Norwegian: T.INV.2T
- Polish: ROZKŁ.T.ODWR.DS
- Portuguese (Brazil): INV.T.BC
- Portuguese (Portugal): INV.T.2C
- Russian: СТЬЮДЕНТ.ОБР.2Х
- Spanish: INV.T.2C
- Swedish: T.INV.2T
- Turkish: T.TERS.2K
Also written as TINV.
Try T.INV.2T in the playground
Related functions
- T.INV: The t-value below which a given share of the t-distribution falls.
- CONFIDENCE.T: The margin of error of a sample mean, using Student's t-distribution. Add it to and subtract it from the mean for the confidence interval.
- T.DIST.2T: The two-tailed t-distribution: the chance of a t further from 0 than x, on either side. This is the p-value of a two-sided t-test.