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).