Membuat
persamaan garis lurus dari data Indeks Massa Tubuh (IMT) dan Glukosa Post
Prandial (GPP) dengan cara sebagai berikut :
IMT (y)
|
GPP (x)
|
Y-Rerata Y
|
X-Rerata X
|
(Y - Rerata Y)(X-Rerata X)
|
|||
18,6
|
150
|
-3,003703704
|
7,962962963
|
-23,91838134
|
63,4087791
|
||
28,1
|
150
|
6,496296296
|
7,962962963
|
51,7297668
|
63,4087791
|
||
25,1
|
120
|
3,496296296
|
-22,037037
|
-77,04801097
|
485,631001
|
||
21,6
|
150
|
-0,003703704
|
7,962962963
|
-0,029492455
|
63,4087791
|
||
28,4
|
190
|
6,796296296
|
47,96296296
|
325,9705075
|
2300,44582
|
||
20,8
|
110
|
-0,803703704
|
-32,037037
|
25,74828532
|
1026,37174
|
||
23,2
|
150
|
1,596296296
|
7,962962963
|
12,71124829
|
63,4087791
|
||
15,9
|
130
|
-5,703703704
|
-12,037037
|
68,65569273
|
144,890261
|
||
16,4
|
130
|
-5,203703704
|
-12,037037
|
62,63717421
|
144,890261
|
||
18,2
|
120
|
-3,403703704
|
-22,037037
|
75,00754458
|
485,631001
|
||
17,9
|
130
|
-3,703703704
|
-12,037037
|
44,58161866
|
144,890261
|
||
21,8
|
140
|
0,196296296
|
-2,03703704
|
-0,399862826
|
4,14951989
|
||
16,1
|
100
|
-5,503703704
|
-42,037037
|
231,3593964
|
1767,11248
|
||
21,5
|
150
|
-0,103703704
|
7,962962963
|
-0,825788752
|
63,4087791
|
||
24,5
|
130
|
2,896296296
|
-12,037037
|
-34,86282579
|
144,890261
|
||
23,7
|
180
|
2,096296296
|
37,96296296
|
79,58161866
|
1441,18656
|
||
21,9
|
140
|
0,296296296
|
-2,03703704
|
-0,603566529
|
4,14951989
|
||
18,6
|
135
|
-3,003703704
|
-7,03703704
|
21,13717421
|
49,5198903
|
||
27
|
140
|
5,396296296
|
-2,03703704
|
-10,99245542
|
4,14951989
|
||
18,9
|
100
|
-2,703703704
|
72,74552756
|
-196,6823523
|
5291,91178
|
||
16,7
|
100
|
-4,903703704
|
-42,037037
|
206,1371742
|
1767,11248
|
||
18,5
|
170
|
-3,103703704
|
27,96296296
|
-86,78875171
|
781,927298
|
||
19,4
|
150
|
-2,203703704
|
7,962962963
|
-17,54801097
|
63,4087791
|
||
24
|
160
|
2,396296296
|
17,96296296
|
43,04458162
|
322,668038
|
||
26,8
|
200
|
5,196296296
|
57,96296296
|
301,1927298
|
3359,70508
|
||
28,7
|
190
|
7,096296296
|
47,96296296
|
340,3593964
|
2300,44582
|
||
21
|
120
|
-0,603703704
|
-22,037037
|
13,30384088
|
485,631001
|
||
RERATA
|
21,603704
|
142,037
|
|||||
SD
|
3,9633398
|
27,25447
|
|||||
JUMLAH
|
7,28306E-14
|
114,7825646
|
1453,458251
|
22837,7623
|
|||
|
0,0636428
|
||||||
|
12,564074
|
2. Membuat
persamaan garis lurus dari data Indeks Massa Tubuh (IMT) dan Trigliserida
dengan cara sebagai berikut :
IMT (y)
|
GPP (x)
|
Y-Rerata Y
|
X-Rerata X
|
(Y - Rerata Y)(X-Rerata X)
|
||
18,6
|
180
|
-3,003703704
|
6,481481481
|
-19,46844993
|
42,0096022
|
|
28,1
|
180
|
6,496296296
|
6,481481481
|
42,10562414
|
42,0096022
|
|
25,1
|
160
|
3,496296296
|
-13,5185185
|
-47,26474623
|
182,750343
|
|
21,6
|
180
|
-0,003703704
|
6,481481481
|
-0,024005487
|
42,0096022
|
|
28,4
|
210
|
6,796296296
|
36,48148148
|
247,9389575
|
1330,89849
|
|
20,8
|
140
|
-0,803703704
|
-33,5185185
|
26,93895748
|
1123,49108
|
|
23,2
|
180
|
1,596296296
|
6,481481481
|
10,34636488
|
42,0096022
|
|
15,9
|
160
|
-5,703703704
|
-13,5185185
|
77,10562414
|
182,750343
|
|
16,4
|
160
|
-5,203703704
|
-13,5185185
|
70,34636488
|
182,750343
|
|
18,2
|
150
|
-3,403703704
|
-23,5185185
|
80,05006859
|
553,120713
|
|
17,9
|
160
|
-3,703703704
|
-13,5185185
|
50,06858711
|
182,750343
|
|
21,8
|
170
|
0,196296296
|
-3,51851852
|
-0,690672154
|
12,3799726
|
|
16,1
|
130
|
-5,503703704
|
-43,5185185
|
239,5130316
|
1893,86145
|
|
21,5
|
180
|
-0,103703704
|
6,481481481
|
-0,672153635
|
42,0096022
|
|
24,5
|
160
|
2,896296296
|
-13,5185185
|
-39,15363512
|
182,750343
|
|
23,7
|
210
|
2,096296296
|
36,48148148
|
76,47599451
|
1330,89849
|
|
21,9
|
170
|
0,296296296
|
-3,51851852
|
-1,042524005
|
12,3799726
|
|
18,6
|
165
|
-3,003703704
|
-8,51851852
|
25,58710562
|
72,5651578
|
|
27
|
170
|
5,396296296
|
-3,51851852
|
-18,98696845
|
12,3799726
|
|
18,9
|
140
|
-2,703703704
|
112,7612121
|
-304,8729068
|
12715,091
|
|
16,7
|
130
|
-4,903703704
|
-43,5185185
|
213,4019204
|
1893,86145
|
|
18,5
|
200
|
-3,103703704
|
26,48148148
|
-82,19067215
|
701,268861
|
|
19,4
|
180
|
-2,203703704
|
6,481481481
|
-14,28326475
|
42,0096022
|
|
24
|
190
|
2,396296296
|
16,48148148
|
39,49451303
|
271,639232
|
|
26,8
|
230
|
5,196296296
|
56,48148148
|
293,494513
|
3190,15775
|
|
28,7
|
240
|
7,096296296
|
66,48148148
|
471,7722908
|
4419,78738
|
|
21
|
160
|
-0,603703704
|
-13,5185185
|
8,161179698
|
182,750343
|
|
RERATA
|
21,603704
|
173,5185
|
||||
SD
|
3,9633398
|
27,23879
|
||||
JUMLAH
|
7,28306E-14
|
146,2797306
|
1444,151099
|
30882,3406
|
||
0,046763
|
||||||
13,489456
|