[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

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:

STANDARDIZE(42,40,1.5) results in 1.333333333

end example]