Output (View of Correlations) - Aster Analytics

Teradata Aster Analytics Foundation User Guide

Product
Aster Analytics
Release Number
6.21
Published
November 2016
Language
English (United States)
Last Update
2018-04-14
dita:mapPath
kiu1466024880662.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1021
lifecycle
previous
Product Category
Software
PCA Example View v_pca_health_corr_input, Columns 1-8
pid pca_1 pca_2 pca_3 age bmi bloodpressure glucose
1 15.4479999925239 95.6063494855112 -144.813884414743 50 33.6 72 148
2 9.38828381804583 54.0203436788621 -93.1642974316123 31 26.6 66 85
3 16.4562085141836 106.037696072979 -173.023717761683 32 23.3 64 183
4 102.765035084519 34.4211125353598 -92.8198997861495 21 28.1 66 89
5 181.746678156338 251.60582517126 -76.7873728335953 33 43.1 40 137
6 10.7165341344642 45.3918741685635 -130.361541710363 30 25.6 74 116
7 96.3460432611523 40.8714816471788 -74.3408072276598 26 31 50 78
8 10.4826993814663 40.6386392479444 -95.2075494656953 29 35.3 0 115
9 560.396754962081 48.6448813248549 -155.430694416748 53 30.5 70 197
10 11.9215857535403 49.7974281943461 -153.440157326562 54 0 96 125
11 10.3068415817 43.1982704402206 -133.30321137986 30 37.6 92 110
12 15.2827930280187 90.0718255965771 -167.310396453308 34 38 74 168
13 13.5332840582506 172.129432304726 -135.082617375201 57 27.1 80 139
14 860.562747564309 63.5444807135366 -125.049203724188 59 30.1 60 189
15 190.457102950088 91.1554213623796 -152.330669708236 51 25.8 72 166
16 9.36646167258605 71.3689044734852 -77.4493074289404 32 30 0 100
17 242.000092281589 76.2015591039508 -105.674466212198 31 45.8 84 118
18 9.99684287848697 48.7881615552709 -122.067685941854 31 29.6 74 107
19 93.9194009716571 41.4321906209861 -86.0707423033147 33 43.3 30 103
20 107.610631620675 76.0189342246316 -109.754823547146 32 34.6 70 115
21 247.290353480677 92.1018846926632 -112.112500012403 27 39.3 88 126
22 9.83325145607444 60.8650374623456 -120.763638056819 50 35.4 84 99
23 17.8451088790566 87.8002159712053 -200.263354330633 41 39.8 90 196
24 12.3985316709805 52.6325871176354 -128.090051863924 29 29 80 119
25 160.200377629451 54.5407906248303 -148.692017737866 51 36.6 94 143
PCA Example View v_pca_health_corr_input, Columns 9-12
strokes cigarettes insulin hdl
6 35 0 62.7
1 29 0 35.1
8 0 0 67.2
1 23 94 16.7
0 35 168 228.8
5 0 0 20.1
3 32 88 24.8
10 0 0 13.4
2 45 543 15.8
8 0 0 23.2
4 0 0 19.1
10 0 0 53.7
10 0 0 144.1
1 23 846 39.8
5 19 175 58.7
7 0 0 48.4
0 47 230 55.1
7 0 0 25.4
1 38 83 18.3
1 30 96 52.9
3 41 235 70.4
8 0 0 38.8
7 0 0 45.1
9 35 0 26.3
11 33 146 25.4

To compute the correlations between the original values for each attribute, use the preceding view and the functions Corr_Map and Corr_Reduce (described in Correlation).