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

When to use it

T.INV gives the t-value below which a share of the t-distribution falls.

Examples

  1. The 75th percentile with 2 degrees of freedom

    ABCD
    1pdf
    20.7520.8165

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

    Try this example

Common mistakes

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.

Translate a whole formula

Try T.INV in the playground

Related functions