STANDARDIZE
Returns a normalized value.
StatisticalStatistics & Analysis
What it does
Standardizes a value from a distribution (Z-score).
Syntax
STANDARDIZE(x, mean, standard_dev)
Arguments
x(number) — Value.mean(number) — Mean.standard_dev(number) — SD.
Examples
Z-Score
Standardize 42 (Mean 40, SD 2).
FORMULA
=STANDARDIZE(42, 40, 2)
RESULT
1
SAMPLE DATA
| A | B | C | |
|---|---|---|---|
| 1 | X | M | S |
| 2 | 42 | 40 | 2 |