Excel functions / Statistics

CONFIDENCE.NORM function

The margin of error for an average: add and subtract it to get the confidence interval.

Syntax

=CONFIDENCE.NORM(alpha, standard_dev, size)

Arguments

When to use it

CONFIDENCE.NORM gives the margin of error of a sample mean, using the normal distribution: the mean plus or minus this is the confidence interval. Give it alpha (0.05 for 95% confidence), the standard deviation and the sample size. For small samples, CONFIDENCE.T is more accurate.

Examples

  1. Margin of error for 50 measurements

    ABCD
    1SDSize
    28502.22

    In D2: =CONFIDENCE.NORM(0.05, A2, B2) → 2.22

    Try this example

  2. Four times the sample, half the margin

    ABCD
    1SDSize
    282001.11

    In D2: =CONFIDENCE.NORM(0.05, A2, B2) → 1.11

    Try this example

Common mistakes

CONFIDENCE.NORM 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 CONFIDENCE.

Try CONFIDENCE.NORM in the playground

Related functions