Sunday, May 28, 2017

STANDARDIZE function

STANDARDIZE function

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

Syntax

STANDARDIZE(x,mean,standard_dev)

X     is the value you want to normalize.

Mean     is the arithmetic mean of the distribution.

Standard_dev     is the standard deviation of the distribution.

Remarks

  • If standard_dev ≤ 0, STANDARDIZE returns the #NUM! error value.

  • The equation for the normalized value is:

    Equation

Example

X

Mean

StdDev

Formula

Description (Result)

42

40

1.5

=STANDARDIZE([X],[Mean],[StdDev])

Normalized value of 42 for the specified arguments (1.333333)

No comments:

Post a Comment