Standardize

Analytics

Standardize

Hi,

Has anyone discovered a function in Teradata that is Equivalent for MS Excel standardize function in Teradata?
ie : STANDARDIZE

See Also

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:

1 REPLY
Junior Contributor

Re: Standardize

Hi Scott,
AFAIK the standardize function should return the same as (x-mean)/standard_dev.

mean -> AVG
standard_dev -> STDDEV_SAMP if it's based on a sample, else STDDEV_POP

If you need it for each row you have to join to a Derived Table doing the aggregate (before TD12), but in TD12 there's an OLAP version for STDDEV_SAMP, too.

Dieter