Nama :
Wida Kurnia
NIM :
20160302156
Tugas Pertemuan ke-9
Analisis Regresi Hal. 153
Latihan 1
Lakukan prediksi CHOL dengan variabel independen TRIG,UM,dan
UM kuadrat.
a.
Hitung SS for Regression (X3 l X1,
X2) ;
b.
Hitung SS for Residual;
c.
Hitung Mean SS for Regression (X3 l X1,
X2) ;
d.
Hitung Mean SS for Residual ;
e.
Hitung nilai F parsial ;
f.
Hitung nilai r2 ;
g.
Buktikan bahwa penambahan X3 berperan
memprediksi Y.
UM
|
CHOL
|
TRIG
|
40
|
218
|
194
|
46
|
265
|
188
|
69
|
197
|
134
|
44
|
188
|
155
|
41
|
217
|
191
|
56
|
240
|
207
|
48
|
222
|
155
|
49
|
244
|
235
|
41
|
190
|
167
|
38
|
209
|
186
|
36
|
208
|
179
|
39
|
214
|
129
|
59
|
238
|
220
|
56
|
219
|
155
|
44
|
241
|
201
|
37
|
212
|
140
|
40
|
244
|
132
|
32
|
217
|
140
|
56
|
227
|
279
|
49
|
218
|
101
|
50
|
241
|
213
|
46
|
234
|
168
|
52
|
231
|
242
|
51
|
297
|
142
|
46
|
230
|
240
|
60
|
258
|
173
|
47
|
243
|
175
|
58
|
236
|
199
|
66
|
193
|
201
|
52
|
193
|
193
|
55
|
319
|
191
|
58
|
212
|
216
|
41
|
209
|
154
|
60
|
224
|
198
|
50
|
184
|
129
|
48
|
222
|
115
|
49
|
229
|
148
|
39
|
204
|
164
|
40
|
211
|
104
|
47
|
230
|
218
|
67
|
230
|
239
|
57
|
222
|
183
|
50
|
213
|
190
|
43
|
238
|
259
|
55
|
234
|
156
|
Model 1. CHOL=
Coefficients(a)
Model
|
|
Unstandardized
Coefficients
|
Standardized
Coefficients
|
t
|
Sig.
|
|
B |
Std.
Error
|
Beta
|
B
|
Std.
Error
|
||
1
|
(Constant)
|
203.123
|
17.156
|
|
11.840
|
.000
|
TRIGLISERIDA |
.127
|
.093
|
.203
|
1.360
|
.181
|
a
Dependent Variable: CHOLESTEROL
Coefficient
|
Standard Error
|
Partial
|
203.123
|
|
|
0.127
|
0.093
|
1.850
|
Estimasi model 1:
CHOL = 203.123 + 0.127 TRIG
ANOVA(b)
Model
|
|
Sum of Squares
|
df
|
Mean Square
|
F
|
Sig.
|
1
|
Regression
|
1181.676
|
1
|
1181.676
|
1.850
|
.181(a)
|
Residual |
27464.768
|
43
|
638.716
|
|
|
|
Total |
28646.444
|
44
|
|
|
|
a Predictors: (Constant), TRIGLISERIDA
b Dependent Variable: CHOLESTEROL
Model 2: CHOL=
Coefficients(a)
Model
|
|
Unstandardized Coefficients
|
Standardized Coefficients
|
t
|
Sig.
|
|
B |
Std. Error
|
Beta
|
B
|
Std. Error
|
||
1
|
(Constant)
|
204.048
|
22.093
|
|
9.236
|
.000
|
UMUR |
.445
|
.444
|
.151
|
1.004
|
.321
|
a Dependent Variable: CHOLESTEROL
Estimasi model 2 : CHOL = 204.048 +
0.445 UM
ANOVA(b)
Model
|
|
Sum of Squares
|
df
|
Mean Square
|
F
|
Sig.
|
1
|
Regression
|
655.625
|
1
|
655.625
|
1.007
|
.321(a)
|
Residual |
27990.819
|
43
|
650.949
|
|
|
|
Total |
28646.444
|
44
|
|
|
|
a Predictors: (Constant), UMUR
b Dependent Variable: CHOLESTEROL
Model 3: CHOL=
Coefficients(a)
Model
|
|
Unstandardized Coefficients
|
Standardized Coefficients
|
t
|
Sig.
|
|
B |
Std. Error
|
Beta
|
B
|
Std. Error
|
||
1
|
(Constant)
|
217.420
|
11.555
|
|
18.816
|
.000
|
UMUR KUADRAT |
.003
|
.004
|
.118
|
.777
|
.442
|
a Dependent Variable: CHOLESTEROL
Estimasi model 3 : CHOL = 217.420 +
0.003 UMSQ
ANOVA(b)
Model
|
|
Sum of Squares
|
df
|
Mean Square
|
F
|
Sig.
|
1
|
Regression
|
396.227
|
1
|
396.227
|
.603
|
.442(a)
|
Residual |
28250.217
|
43
|
656.982
|
|
|
|
Total |
28646.444
|
44
|
|
|
|
a Predictors: (Constant), UMUR KUADRAT
b Dependent Variable: CHOLESTEROL
Model 4: CHOL=
Coefficients(a)
Model
|
|
Unstandardized Coefficients
|
Standardized Coefficients
|
t
|
Sig.
|
|
B |
Std. Error
|
Beta
|
B
|
Std. Error
|
||
1
|
(Constant)
|
192.155
|
24.554
|
|
7.826
|
.000
|
TRIGLISERIDA |
.108
|
.098
|
.173
|
1.099
|
.278
|
|
UMUR |
.292
|
.464
|
.099
|
.629
|
.533
|
a Dependent Variable: CHOLESTEROL
Estimasi model 4 : CHOL = 192.155 +
0.108 TRIG + 0.292 UM
ANOVA(b)
Model
|
|
Sum of Squares
|
df
|
Mean Square
|
F
|
Sig.
|
1
|
Regression
|
1437.719
|
2
|
718.860
|
1.110
|
.339(a)
|
Residual |
27208.725
|
42
|
647.827
|
|
|
|
Total |
28646.444
|
44
|
|
|
|
a Predictors: (Constant), UMUR, TRIGLISERIDA
b Dependent Variable: CHOLESTEROL
Model 5: CHOL=
Coefficients(a)
Model
|
|
Unstandardized Coefficients
|
Standardized Coefficients
|
t
|
Sig.
|
|
B |
Std. Error
|
Beta
|
B
|
Std. Error
|
||
1
|
(Constant)
|
200.525
|
18.433
|
|
10.879
|
.000
|
TRIGLISERIDA |
.115
|
.098
|
.185
|
1.173
|
.247
|
|
UMUR KUADRAT |
.002
|
.005
|
.065
|
.413
|
.682
|
a Dependent Variable: CHOLESTEROL
Estimasi model 5 : CHOL = 200.525 +
0.115 TRIG + 0.002 UMSQ
ANOVA(b)
Model
|
|
Sum of Squares
|
df
|
Mean Square
|
F
|
Sig.
|
1
|
Regression
|
1292.618
|
2
|
646.309
|
.992
|
.379(a)
|
Residual |
27353.826
|
42
|
651.282
|
|
|
|
Total |
28646.444
|
44
|
|
|
|
a Predictors: (Constant), UMUR KUADRAT,
TRIGLISERIDA
b Dependent Variable: CHOLESTEROLModel 6: CHOL=
Coefficients(a)
Model
|
|
Unstandardized Coefficients
|
Standardized Coefficients
|
t
|
Sig.
|
|
B |
Std. Error
|
Beta
|
B
|
Std. Error
|
||
1
|
(Constant)
|
-21.969
|
104.532
|
|
-.210
|
.835
|
TRIGLISERIDA |
.079
|
.095
|
.126
|
.825
|
.414
|
|
UMUR |
9.220
|
4.269
|
3.132
|
2.160
|
.037
|
|
UMUR KUADRAT |
-.088
|
.042
|
-3.035
|
-2.103
|
.042
|
a Dependent Variable: CHOLESTEROL
Estimasi model 6 : CHOL = -21.969 +
0.079 TRIG + 9.220 UM + (-0.088) UMSQ
ANOVA(b)
Model
|
|
Sum of Squares
|
df
|
Mean Square
|
F
|
Sig.
|
1
|
Regression
|
4086.344
|
3
|
1362.115
|
2.274
|
.094(a)
|
Residual |
24560.100
|
41
|
599.027
|
|
|
|
Total |
28646.444
|
44
|
|
|
|
a Predictors: (Constant), UMUR KUADRAT,
TRIGLISERIDA, UMUR
b Dependent Variable: CHOLESTEROL
Dari ke enam model
estimasi di atas kita bisa menduga model estimasi ke 6 dengan independen
variable TRIG, UM dan (UM)2 adalah yang terbaik bila di lihat dari besaran
r2 yaitu 0.05. Namun sebaiknya kita perhatikam uraian di bawah ini.
Kita dapat memperinci
nilai-nilai Sum Square of Regression dalam tabel ANOVA sbb :
Sumber
|
df
|
SS
|
MS
|
F
|
R2
|
Regresi
X1
X2 I X1
X3 I X1,X2
|
1
1
1
|
1181.676
256.043
2648.625
|
1181.676
256.043
2648.625
|
1.972
0.395
4.42
|
0.05
|
Residual
|
41
|
24560.100
|
599.027
|
|
|
Total
|
44
|
28646.444
|
|
|
|
Tidak ada komentar:
Posting Komentar