STANDARDIZE

Definition: The STANDARDIZE function in Excel is used to normalize a set of data to a standard distribution.

Syntax: ==STANDARDIZE(x, mean, standard_dev).

Situation: This formula is appropriate in situations where you need to normalize a set of data to a standard distribution.

Example: If you have a value of 60, a mean of 50, and a standard deviation of 5, you would use the formula =STANDARDIZE(60, 50, 5). This would return a value of 2, which is the normalized value of 60.