STANDARDIZE

Syntax:

STANDARDIZE ( x , mean , standard-dev )

Description: Computes a normalized value from a distribution characterized by mean and standard-dev.

Mathematical Formula:

Arguments:

Name

Type

Description

x

number

The number whose value is to be normalized.

mean

number

The the arithmetic mean of the distribution.

standard-dev

number

The standard deviation of the distribution.

Return Type and Value: number – A normalized value from a distribution.

However, if standard-dev ≤ 0, #NUM! is returned.

example: