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
x: The value.mean: The mean of the data.standard_dev: The standard deviation of the data.
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
How far Chloe is above the average
A B C D 1 Name Score 2 Ana 72 1.17 3 Ben 48 4 Chloe 90 5 Dev 65 6 Eve 81 In D2:
=STANDARDIZE(B4, AVERAGE(B2:B6), STDEV(B2:B6))→ 1.17Ben is below it
A B C D 1 Name Score 2 Ana 72 -1.45 3 Ben 48 4 Chloe 90 5 Dev 65 6 Eve 81 In D2:
=STANDARDIZE(B3, AVERAGE(B2:B6), STDEV(B2:B6))→ -1.45
Common mistakes
- Argument order. The value comes first, then the mean, then the standard deviation.
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.
- Czech: STANDARDIZE
- Danish: STANDARDISER
- Dutch: NORMALISEREN
- Finnish: NORMITA
- French: CENTREE.REDUITE
- German: STANDARDISIERUNG
- Hungarian: NORMALIZÁLÁS
- Italian: NORMALIZZA
- Norwegian: NORMALISER
- Polish: NORMALIZUJ
- Portuguese (Brazil): PADRONIZAR
- Portuguese (Portugal): NORMALIZAR
- Russian: НОРМАЛИЗАЦИЯ
- Spanish: NORMALIZACION
- Swedish: STANDARDISERA
- Turkish: STANDARTLAŞTIRMA
Try STANDARDIZE in the playground
Related functions
- NORM.S.DIST: The standard normal distribution (mean 0, standard deviation 1) at a z-score.
- AVERAGE: The arithmetic mean of the numbers.
- STDEV: Standard deviation of a sample.
- NORM.DIST: The normal distribution: the chance of a value at or below x, or the height of the bell curve at x.