Nama : Nofriana Delsia Manafe
Nim : 20160302205
Sesi : 10
Tugas : Analisis Regresi (Pertemuan 8, Hal 123-124)
1. Lakukan prediksi CHOL dengan variabel independen TRIG dan UM :
UM
|
CHOL
|
TRIG
|
UM
|
CHOL
|
TRIG
|
UM
|
CHOL
|
TRIG
|
40
|
218
|
194
|
37
|
212
|
140
|
55
|
319
|
191
|
46
|
265
|
188
|
40
|
244
|
132
|
58
|
212
|
216
|
69
|
197
|
134
|
32
|
217
|
140
|
41
|
209
|
154
|
44
|
188
|
155
|
56
|
227
|
279
|
60
|
224
|
198
|
41
|
217
|
191
|
49
|
218
|
101
|
50
|
184
|
129
|
56
|
240
|
207
|
50
|
241
|
213
|
48
|
222
|
115
|
48
|
222
|
155
|
46
|
234
|
168
|
49
|
229
|
148
|
49
|
244
|
235
|
52
|
231
|
242
|
39
|
204
|
164
|
41
|
190
|
167
|
51
|
297
|
142
|
40
|
211
|
104
|
38
|
209
|
186
|
46
|
230
|
240
|
47
|
230
|
218
|
36
|
208
|
179
|
60
|
258
|
173
|
67
|
230
|
239
|
39
|
214
|
129
|
47
|
243
|
175
|
57
|
222
|
183
|
59
|
238
|
220
|
58
|
236
|
199
|
50
|
213
|
190
|
56
|
219
|
155
|
66
|
193
|
201
|
43
|
238
|
259
|
44
|
241
|
201
|
52
|
193
|
193
|
55
|
234
|
156
|
Ø Hitung Sum of Square for Regression (X)
Ø Hitung Sum of Square for Residual
Ø Hitung Means Sum of Square for Regression (X)
Ø Hitung Means Sum of Square for Residual
Ø Hitung nilai F
Ø Hitung nilai r2
Ø Tulis model regresi
Jawaban :
v CHOLESTEROL & UMUR
a) Sum of Square Total adalah
= 28646.44
b) Sum of Square Residual adalah :
= 27990.82
c) Sum of Square Regression adalah :
SSY-SSE = 28646.44-27990.82 = 655.62
d) Mean Sum of Square Regression =
SSRegr/df = 655.62/1 = 655.62
e) Mean Sum of Square Residual =
SSRed/df = 655.62/43 = 15.247
F= MS-Reg/ MS-Resd = 655.62/650.95 = 1.00717
Nilai Fh = 1.00717 < Ft = 4.08, nilai P > 0.05. tidak linear.
Artinya kita menerima hipotesa nol, dan kita menyatakan bahwa; umur tidak mempengaruhi kadar cholesterol.
f) r2= (SSY-SSE)/SSY = (28646.44-27990.82)/28646.44 = (0.023)2 = 0.0005
v CHOLESTEROL & TRIGLISERIDA
a) Sum of Square Total adalah
= 28646.44
b) Sum of Square Residual adalah :
= 27464.77
c) Sum of Square Regression adalah :
SSY-SSE = 28646.44-27464.77 = 1181.67
d) Mean Sum of Square Regression =
SSRegr/df = 1181.67/1 = 1181.67
e) Mean Sum of Square Residual =
SSRed/df = 27464.77/43 = 638.72
F= MS-Reg/ MS-Resd = 1181.67/638.72 = 1.85005
Nilai Fh = 1.85005 < Ft = 4.08, nilai P > 0.05. tidak linear.
Artinya kita menerima hipotesa nol, dan kita menyatakan bahwa; trigliserida tidak mempengaruhi kadar cholesterol.
f) r2= (SSY-SSE)/SSY = (28646.44-27464.77)/28646.44 = (0.041)2 = 0.0016
v MODEL REGRESI
CHOL = 192.155 + 0.291829 UM + 0.107923 TRIG
Pada individu yang berumur 40 tahun dengan nilai TRIG = 194, maka Cholesterol-nya di prediksi sebesar : 192.155 + (0.291829*40) + (0.107923*194)
= 192.155 + 11.67316 + 20.937062 = 224.77 dibulatkan menjadi 225
2. Lakukan prediksi Berat Badan (BB) dengan variabel independen Tinggi Badan (TB), Berat tanpa Lemak (BTL), dan Asupan Kalori (AK).
BB
|
TB
|
BTL
|
AK
|
79.2
|
149
|
54.1
|
2670
|
64
|
152
|
44.3
|
820
|
67
|
155.7
|
47.8
|
1210
|
78.4
|
159
|
53.9
|
2678
|
66
|
163.3
|
47.5
|
1205
|
63
|
166
|
43
|
815
|
65.9
|
169
|
47.1
|
1200
|
63.1
|
172
|
44
|
1180
|
73.2
|
174.5
|
44.1
|
1850
|
66.5
|
176.1
|
48.3
|
1260
|
61.9
|
176.5
|
43.5
|
1170
|
72.5
|
179
|
43.3
|
1852
|
101.1
|
182
|
66.4
|
1790
|
66.2
|
170.4
|
47.5
|
1250
|
99.9
|
184.9
|
66
|
1889
|
63
|
169
|
44
|
915
|
Ø Hitung Sum of Square for Regression (X)
Ø Hitung Sum of Square for Residual
Ø Hitung Means Sum of Square for Regression (X)
Ø Hitung Means Sum of Square for Residual
Ø Hitung nilai F
Ø Hitung nilai r2
Ø Tulis model regresi
Jawaban :
v BB & TB
a) Sum of Square Total adalah
= 2288.954
b) Sum of Square Residual adalah :
= 1962.751
c) Sum of Square Regression adalah :
SSY-SSE = 2288.954-1962.751 = 326.203
d) Mean Sum of Square Regression =
SSRegr/df = 326.203/1 = 326.203
e) Mean Sum of Square Residual =
SSRed/df = 1962.751/14 = 140.1965
F= MS-Reg/ MS-Resd = 326.203/140.1965 = 2.3267557
Nilai Fh = 2.3267557 < Ft = 4.60, nilai P > 0.05. tidak linear.
Artinya kita menerima hipotesa nol, dan kita menyatakan bahwa; tinggi badan tidak mempengaruhi berat badan.
f) r2= (SSY-SSE)/SSY = (2288.954-1962.751)/2288.954 = (0.142)2 = 0.020164
v BB & BTL
a) Sum of Square Total adalah
= 2288.954
b) Sum of Square Residual adalah :
= 243.8553
c) Sum of Square Regression adalah :
SSY-SSE = 2288.954-243.8553 = 2045.099
d) Mean Sum of Square Regression =
SSRegr/df = 2045.099/1 = 2045.099
e) Mean Sum of Square Residual =
SSRed/df = 243.8553/14 = 17.41824
F= MS-Reg/ MS-Resd = 2045.099/243.8553 = 8.386527
Nilai Fh = 8.386527< Ft = 4.60, nilai P < 0.05. Linear.
Artinya kita menolak hipotesa nol, dan kita menyatakan bahwa; Berat Tanpa Lemak mempengaruhi Berat Badan.
f) r2= (SSY-SSE)/SSY = (2288.954-243.8553)/2288.954 = (0.893)2 = 0.797
v BB & AK
a) Sum of Square Total adalah
= 2288.954
b) Sum of Square Residual adalah :
= 1416.653
c) Sum of Square Regression adalah :
SSY-SSE = 2288.954-1416.653 = 872.301
d) Mean Sum of Square Regression =
SSRegr/df = 872.301/1 = 872.301
e) Mean Sum of Square Residual =
SSRed/df = 1416.653/14 = 101.1895
F= MS-Reg/ MS-Resd = 872.301/101.1895 = 8.6204695
Nilai Fh = 8.6204695< Ft = 4.60, nilai P < 0.05. Linear.
Artinya kita menolak hipotesa nol, dan kita menyatakan bahwa; Asupan Kalori mempengaruhi Berat Badan.
f) r2= (SSY-SSE)/SSY = (2288.954-1416.653)/2288.954 = (0.381)2 = 0.145
v MODEL REGRESI
BB = -33.412 + 0.2104 TB + 1.2906 BTL + 0.0044 AK
Pada individu yang Asupan Kalori 2670 dengan nilai Berat Tanpa Lemak = 54.1, dan Tinggi Badan = 79.2, maka Cholesterol-nya di prediksi sebesar : -33.412 + (0.2104*79.2) + (1.2906*54.1) + (0.0044*2670)
= -33.412 + 16.66368 + 69.82146 + 11.748 = 64.82114 dibulatkan menjadi 65.
Tidak ada komentar:
Posting Komentar