1.1 - 8.10 - Location and Scale for Statistical Methods - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Teradata Vantage
Release Number
October 2019
Content Type
Programming Reference
Publication ID
English (United States)

Two important parameters in scaling are location and scale. The values that the function uses for location and scale depend on the ScaleMethod syntax element value, as the following table shows. In the table, X represents an input column, and Xmean, minX, and maxX are the mean, minimum, and maximum values of the column X.

ScaleMethod Location Scale
mean X mean 1
sum 0 Σ X
ustd 0 Standard deviation, calculated according to biased estimator of variance.
std X mean Standard deviation, calculated according to unbiased estimator of variance.
range minX maxX - minX
midrange (maxX+minX)/2 (maxX - minX)/2
maxabs 0 Maximum of absolute value of X.