Excel functions / Statistics

T.DIST function

Student's t-distribution: the chance of a t of x or less, or the height of the curve at x.

Syntax

=T.DIST(x, deg_freedom, cumulative)

Arguments

When to use it

T.DIST gives the chance of a t-value of x or less (with TRUE), or the height of the curve, in Student's t-distribution. The t-distribution replaces the normal one for small samples.

Examples

  1. Below t = 60 with 1 degree of freedom

    ABCD
    1tdf
    26010.99470

    In D2: =T.DIST(A2, B2, TRUE) → 0.99470

    Try this example

Common mistakes

T.DIST 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 in the playground

Related functions