Excel functions / Statistics

STANDARDIZE function

A z-score: how many standard deviations a value is above (or below) the mean.

Syntax

=STANDARDIZE(x, mean, standard_dev)

Arguments

When to use it

STANDARDIZE turns a value into a z-score: how many standard deviations it is above or below the mean. It puts scores from different tests on the same footing.

Examples

  1. How far Chloe is above the average

    ABCD
    1NameScore
    2Ana721.17
    3Ben48
    4Chloe90
    5Dev65
    6Eve81

    In D2: =STANDARDIZE(B4, AVERAGE(B2:B6), STDEV(B2:B6)) → 1.17

    Try this example

  2. Ben is below it

    ABCD
    1NameScore
    2Ana72-1.45
    3Ben48
    4Chloe90
    5Dev65
    6Eve81

    In D2: =STANDARDIZE(B3, AVERAGE(B2:B6), STDEV(B2:B6)) → -1.45

    Try this example

Common mistakes

STANDARDIZE 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 STANDARDIZE in the playground

Related functions