Excel functions / Statistics

T.DIST.2T function

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.

Syntax

=T.DIST.2T(x, deg_freedom)

Arguments

When to use it

T.DIST.2T gives the chance of a t-value further from 0 than x, on either side: the p-value of a two-sided t-test from its t statistic.

Examples

  1. p-value for t = 1.96 with 60 degrees of freedom

    ABCD
    1tdf
    21.96600.0546

    In D2: =T.DIST.2T(A2, B2) → 0.0546

    Try this example

Common mistakes

T.DIST.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

Try T.DIST.2T in the playground

Related functions