Excel STANDARDIZE Function

Statistical Function ยท Intermediate Level

What is STANDARDIZE?

Returns a normalized value (z-score) from a distribution. Converts value to standard normal.

Syntax

=STANDARDIZE(x, mean, standard_dev)

Example

Formula: =STANDARDIZE(75, 60, 10)

Result: 1.5

How It Works

Returns z-score of 1.5, meaning 75 is 1.5 standard deviations above the mean of 60.

Learn More Excel Functions