Updated: 9 August 2010

Use STANDARDIZE to calculate a normalized value from a distribution characterized by mean and standard deviation:

SELECT [wctStatistics].[wct].[STANDARDIZE] (

<@X, float,>

,<@Mean, float,>

,<@Standard_dev, float,>)

is the value to be normalized. @*X *is an expression of type **float** or of a type that can be implicitly converted to **float**.

is the arithmetic mean of the distribution. @*Mean *is an expression of type **float** or of a type that can be implicitly converted to **float**.

is the standard deviation of the distribution. @*Standard_dev *is an expression of type **float** or of a type that can be implicitly converted to **float**.

float

· If *@Standard_dev* ≤ 0, STANDARDIZE returns an error

Select wct.STANDARDIZE(-4.6159,10,5)

This produces the following result

----------------------

-2.92318

(1 row(s) affected)