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

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

  1. Critical t at 5% with 10 degrees of freedom

    ABCD
    1alphadf
    20.05102.228

    In D2: =T.INV.2T(A2, B2) → 2.228

    Try this example

Common mistakes

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.

Translate a whole formula

Also written as TINV.

Try T.INV.2T in the playground

Related functions