Skip to Content

STANDARDIZE

Returns a normalized value from a distribution characterized by mean and standard_dev

Syntax

STANDARDIZE(x, mean, standard_dev)

Parameters

  • x: Required. The value you want to normalize
  • mean: Required. The arithmetic mean of the distribution
  • standard_dev: Required. The standard deviation of the distribution

Example

=STANDARDIZE(42, 40, 1.5)
Returns: NumberSince: Excel 2003