7.00.02 - Output - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)
Last Update
2018-04-17

As explained in the description of the Intercept argument, the formula for computing the scaled value X' from the input value X when intercept is -min is:

X' = - scaledmin + 1 * (X - location)/scale

The formula for computing scaledmin when intercept is -min is:

scaledmin = (minX - location)/scale

For example, consider row 1 of the price column in the input table (Input) and the following output table:
Item Value
Input value X 42000
Minimum input price value minX 42000
Maximum input price value maxX 88500
location (88500+42000)/2 = 65250
scale (88500-42000)/2 = 23250
scaledmin (42000 - 65250)/23250 = -1
Scaled output value X' -(-1) + 1 * (42000 - 65250)/23250 = 0
Scale Example 2 Output Table
id price lotsize bedrooms bathrms stories
1 0 1.55431754874652 2 0 0.666666666666667
3 0.32258064516129 0 2 0 0
4 0.795698924731183 2 2 0 0.666666666666667
5 0.817204301075269 1.83844011142061 0 0 0
6 1.03225806451613 0.612813370473538 2 0 0
8 1.16129032258065 0.612813370473538 2 0 1.33333333333333
9 1.79784946236559 0.969359331476323 2 0 0
10 2 1.35933147632312 2 2 2