Excel functions / Statistics

CONFIDENCE.T function

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.

Syntax

=CONFIDENCE.T(alpha, standard_dev, size)

Arguments

When to use it

CONFIDENCE.T gives the margin of error of a sample mean using Student's t-distribution, which suits small samples better than CONFIDENCE.NORM.

Examples

  1. Margin of error for 50 values with SD 1

    ABCD
    1SDSize
    21500.2842

    In D2: =CONFIDENCE.T(0.05, A2, B2) → 0.2842

    Try this example

Common mistakes

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

Related functions