Persamaan regresi garis lurus
adalah
Y = -133.309 + 1.198X
Pertanyaan:
Berapakah berat badan anak bila tingginya:
- 150 cm
-133.309 + 179.7
= 46.39
- 155 cm
-133.309 + (1.198
x 155)
-133.309 + 185.69
= 52.38
- 165 cm
-133.309 + (1.198
x 165)
-133.309 + 197.67
= 64.36
LATIHAN
BUAT PERSAMAAN GARIS LURUS DARI DATA BERIKUT (GUNAKAN RUMUS-RUMUS YANG SUDAH DIBERIKAN) DAN UNTUK MEMUDAHKAN PERHITUNGAN GUNAKAN MS EXCEL.
1. Data Indeks Massa Tubuh (IMT) dan Glukosa Post Prandial (GPP)
BUAT PERSAMAAN GARIS LURUS DARI DATA BERIKUT (GUNAKAN RUMUS-RUMUS YANG SUDAH DIBERIKAN) DAN UNTUK MEMUDAHKAN PERHITUNGAN GUNAKAN MS EXCEL.
1. Data Indeks Massa Tubuh (IMT) dan Glukosa Post Prandial (GPP)
|
KASUS
|
IMT
|
TRIG
|
Y- Ӯ
|
X-rerataX
|
(Y-Ӯ)(X-
|
(X-
|
|
1
|
18.6
|
180
|
-3.0037
|
6.481481
|
-19.4684
|
42.0096
|
|
2
|
28.1
|
180
|
6.496296
|
6.481481
|
42.10562
|
42.0096
|
|
3
|
25.1
|
160
|
3.496296
|
-13.5185
|
-47.2647
|
182.7503
|
|
4
|
21.6
|
180
|
-0.0037
|
6.481481
|
-0.02401
|
42.0096
|
|
5
|
28.4
|
210
|
6.796296
|
36.48148
|
247.939
|
1330.898
|
|
6
|
20.8
|
140
|
-0.8037
|
-33.5185
|
26.93896
|
1123.491
|
|
7
|
23.2
|
180
|
1.596296
|
6.481481
|
10.34636
|
42.0096
|
|
8
|
15.9
|
160
|
-5.7037
|
-13.5185
|
77.10562
|
182.7503
|
|
9
|
16.4
|
160
|
-5.2037
|
-13.5185
|
70.34636
|
182.7503
|
|
10
|
18.2
|
150
|
-3.4037
|
-23.5185
|
80.05007
|
553.1207
|
|
11
|
17.9
|
160
|
-3.7037
|
-13.5185
|
50.06859
|
182.7503
|
|
12
|
21.8
|
170
|
0.196296
|
-3.51852
|
-0.69067
|
12.37997
|
|
13
|
16.1
|
130
|
-5.5037
|
-43.5185
|
239.513
|
1893.861
|
|
14
|
21.5
|
180
|
-0.1037
|
6.481481
|
-0.67215
|
42.0096
|
|
15
|
24.5
|
160
|
2.896296
|
-13.5185
|
-39.1536
|
182.7503
|
|
16
|
23.7
|
210
|
2.096296
|
36.48148
|
76.47599
|
1330.898
|
|
17
|
21.9
|
170
|
0.296296
|
-3.51852
|
-1.04252
|
12.37997
|
|
18
|
18.6
|
165
|
-3.0037
|
-8.51852
|
25.58711
|
72.56516
|
|
19
|
27
|
170
|
5.396296
|
-3.51852
|
-18.987
|
12.37997
|
|
20
|
18.9
|
140
|
-2.7037
|
-33.5185
|
90.62414
|
1123.491
|
|
21
|
16.7
|
130
|
-4.9037
|
-43.5185
|
213.4019
|
1893.861
|
|
22
|
18.5
|
200
|
-3.1037
|
26.48148
|
-82.1907
|
701.2689
|
|
23
|
19.4
|
180
|
-2.2037
|
6.481481
|
-14.2833
|
42.0096
|
|
24
|
24
|
190
|
2.396296
|
16.48148
|
39.49451
|
271.6392
|
|
25
|
26.8
|
230
|
5.196296
|
56.48148
|
293.4945
|
3190.158
|
|
26
|
28.7
|
240
|
7.096296
|
66.48148
|
471.7723
|
4419.787
|
|
27
|
21
|
160
|
-0.6037
|
-13.5185
|
8.16118
|
182.7503
|
|
|
|
|
|
|
|
|
|
RERATA
|
21.6037
|
173.5185
|
|
|
|
|
|
SD
|
3.96334
|
27.23879
|
|
|
|
|
|
JUMLAH
|
|
|
|
|
1839.648
|
19290.74
|
|
ᵝ1
|
0.095364
|
|
|
|
|
|
|
ᵝ0
|
5.05623
|
|
|
|
|
|
Persamaan regresi garis lurus
adalah:
Y
=
5.0562 + 0.0953X
2. Data Indeks Massa Tubuh (IMT) dan Trigliserida
|
KASUS
|
IMT (Y)
|
GPP (X)
|
(Y-Ӯ)
|
(X-
|
(Y-Ӯ)(X-
|
(X-
|
|
1
|
18.6
|
150
|
-3.0037
|
128.4
|
-385.6644
|
16485.61
|
|
2
|
28.1
|
150
|
6.4963
|
128.4
|
834.10038
|
16485.61
|
|
3
|
25.1
|
120
|
3.4963
|
98.396
|
344.02261
|
9681.831
|
|
4
|
21.6
|
150
|
-0.0037
|
128.4
|
-0.475542
|
16485.61
|
|
5
|
28.4
|
190
|
6.7963
|
168.4
|
1144.4711
|
28357.31
|
|
6
|
20.8
|
110
|
-0.8037
|
88.396
|
-71.04443
|
7813.905
|
|
7
|
23.2
|
150
|
1.5963
|
128.4
|
204.95853
|
16485.61
|
|
8
|
15.9
|
130
|
-5.7037
|
108.4
|
-618.2604
|
11749.76
|
|
9
|
16.4
|
130
|
-5.2037
|
108.4
|
-564.0622
|
11749.76
|
|
10
|
18.2
|
120
|
-3.4037
|
98.396
|
-334.9118
|
9681.831
|
|
11
|
17.9
|
130
|
-3.7037
|
108.4
|
-401.4678
|
11749.76
|
|
12
|
21.8
|
140
|
0.1963
|
118.4
|
23.240754
|
14017.68
|
|
13
|
16.1
|
100
|
-5.5037
|
78.396
|
-431.47
|
6145.979
|
|
14
|
21.5
|
150
|
-0.1037
|
128.4
|
-13.31517
|
16485.61
|
|
15
|
24.5
|
130
|
2.8963
|
108.4
|
313.94779
|
11749.76
|
|
16
|
23.7
|
180
|
2.0963
|
158.4
|
332.04557
|
25089.39
|
|
17
|
21.9
|
140
|
0.2963
|
118.4
|
35.080384
|
14017.68
|
|
18
|
18.6
|
135
|
-3.0037
|
113.4
|
-340.6089
|
12858.72
|
|
19
|
27
|
140
|
5.3963
|
118.4
|
638.9015
|
14017.68
|
|
20
|
18.9
|
100
|
-2.7037
|
78.396
|
-211.9604
|
6145.979
|
|
21
|
16.7
|
100
|
-4.9037
|
78.396
|
-384.4322
|
6145.979
|
|
22
|
18.5
|
170
|
-3.1037
|
148.4
|
-460.5781
|
22021.46
|
|
23
|
19.4
|
160
|
-2.2037
|
138.4
|
-304.9844
|
19153.53
|
|
24
|
24
|
160
|
2.3963
|
138.4
|
331.63853
|
19153.53
|
|
25
|
26.8
|
200
|
5.1963
|
178.4
|
927.00001
|
31825.24
|
|
26
|
28.7
|
190
|
7.0963
|
168.4
|
1194.99
|
28357.31
|
|
27
|
21
|
120
|
-0.6037
|
98.396
|
-59.40221
|
9681.831
|
|
RERATA
|
21.6037
|
142.4074
|
||||
|
SD
|
3.96334
|
27.4342
|
||||
|
JUMLAH
|
1741.7593
|
413594
|
||||
|
|
0.004211
|
|||||
|
|
21.00399
|
Persamaan garis lurusnya adalah
Y
= 21.003
Komentar
Posting Komentar