Lakukan
prediksi CHOL dengan variabel independen TRIG, UM dan UM kuadrat.
a.
Hitung
SS for Regression (X3 | X1, X2)
b.
Hitung
SS for Residual
c.
Hitung
Means SS for Regression (X3 | X1, X2)
d.
Hitung
Means SS for Residual
e.
Hitung
nilai F parsial
f.
Hitung
nilai r2
g.
Buktikan
bahwa penambahan X3 berperan dalam meprediksi 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 = β0 + β1 TRIG
|
Model Summary
|
||||
|
Model
|
R
|
R Square
|
Adjusted R
Square
|
Std. Error of
the Estimate
|
|
1
|
.203a
|
.041
|
.019
|
25.273
|
|
|
||||
|
ANOVAb
|
||||||
|
Model
|
Sum of
Squares
|
df
|
Mean Square
|
F
|
Sig.
|
|
|
1
|
Regression
|
1181.676
|
1
|
1181.676
|
1.850
|
.181a
|
|
Residual
|
27464.768
|
43
|
638.716
|
|
|
|
|
Total
|
28646.444
|
44
|
|
|
|
|
|
Coefficientsa
|
||||||
|
Model
|
Unstandardized
Coefficients
|
Standardized
Coefficients
|
|
|||
|
B
|
Std. Error
|
Beta
|
t
|
Sig.
|
||
|
1
|
(Constant)
|
203.123
|
17.156
|
|
11.840
|
.000
|
|
Trigliserida
|
.127
|
.093
|
.203
|
1.360
|
.181
|
|
Model 2 : CHOL = β0 + β1 UM
|
Model Summary
|
||||
|
Model
|
R
|
R Square
|
Adjusted R
Square
|
Std. Error of
the Estimate
|
|
1
|
.151a
|
.023
|
.000
|
25.514
|
|
a. Predictors: (Constant), Umur
|
||||
|
ANOVAb
|
||||||
|
Model
|
Sum of
Squares
|
df
|
Mean Square
|
F
|
Sig.
|
|
|
1
|
Regression
|
655.625
|
1
|
655.625
|
1.007
|
.321a
|
|
Residual
|
27990.819
|
43
|
650.949
|
|
|
|
|
Total
|
28646.444
|
44
|
|
|
|
|
|
a. Predictors: (Constant), Umur
|
||||||
|
b. Dependent Variable: Cholesterol
|
||||||
|
Coefficientsa
|
||||||
|
Model
|
Unstandardized
Coefficients
|
Standardized
Coefficients
|
|
|||
|
B
|
Std. Error
|
Beta
|
t
|
Sig.
|
||
|
1
|
(Constant)
|
204.048
|
22.093
|
|
9.236
|
.000
|
|
Umur
|
.445
|
.444
|
.151
|
1.004
|
.321
|
|
|
a. Dependent Variable: Cholesterol
|
||||||
Model 3 : CHOL = β0 + β1 UMSQ
|
Model Summary
|
||||
|
Model
|
R
|
R Square
|
Adjusted R Square
|
Std. Error of
the Estimate
|
|
1
|
.118a
|
.014
|
-.009
|
25.632
|
|
a. Predictors: (Constant), UMSQ
|
||||
|
ANOVAb
|
||||||
|
Model
|
Sum of
Squares
|
df
|
Mean Square
|
F
|
Sig.
|
|
|
1
|
Regression
|
396.227
|
1
|
396.227
|
.603
|
.442a
|
|
Residual
|
28250.217
|
43
|
656.982
|
|
|
|
|
Total
|
28646.444
|
44
|
|
|
|
|
|
a. Predictors: (Constant), UMSQ
|
||||||
|
b. Dependent Variable: Cholesterol
|
||||||
|
Coefficientsa
|
||||||
|
Model
|
Unstandardized
Coefficients
|
Standardized
Coefficients
|
|
|||
|
B
|
Std. Error
|
Beta
|
t
|
Sig.
|
||
|
1
|
(Constant)
|
217.420
|
11.555
|
|
18.816
|
.000
|
|
UMSQ
|
.003
|
.004
|
.118
|
.777
|
.442
|
|
|
a. Dependent Variable: Cholesterol
|
||||||
Model 4 : CHOL = β0 + β1 TRIG
+ β2 UM
|
Model Summary
|
||||
|
Model
|
R
|
R Square
|
Adjusted R
Square
|
Std. Error of
the Estimate
|
|
1
|
.224a
|
.050
|
.005
|
25.452
|
|
a. Predictors: (Constant), Umur,
Trigliserida
|
||||
|
ANOVAb
|
||||||
|
Model
|
Sum of
Squares
|
df
|
Mean Square
|
F
|
Sig.
|
|
|
1
|
Regression
|
1437.719
|
2
|
718.860
|
1.110
|
.339a
|
|
Residual
|
27208.725
|
42
|
647.827
|
|
|
|
|
Total
|
28646.444
|
44
|
|
|
|
|
|
a. Predictors: (Constant), Umur,
Trigliserida
|
||||||
|
b. Dependent Variable: Cholesterol
|
||||||
|
Coefficientsa
|
||||||
|
Model
|
Unstandardized
Coefficients
|
Standardized
Coefficients
|
|
|||
|
B
|
Std. Error
|
Beta
|
t
|
Sig.
|
||
|
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
|
||||||
Model 5 : CHOL = β0 + β1 TRIG
+ β2 UMSQ
|
Model Summary
|
||||
|
Model
|
R
|
R Square
|
Adjusted R
Square
|
Std. Error of
the Estimate
|
|
1
|
.212a
|
.045
|
.000
|
25.520
|
|
a. Predictors: (Constant), UMSQ,
Trigliserida
|
||||
|
ANOVAb
|
||||||
|
Model
|
Sum of
Squares
|
df
|
Mean Square
|
F
|
Sig.
|
|
|
1
|
Regression
|
1292.618
|
2
|
646.309
|
.992
|
.379a
|
|
Residual
|
27353.826
|
42
|
651.282
|
|
|
|
|
Total
|
28646.444
|
44
|
|
|
|
|
|
a. Predictors: (Constant), UMSQ,
Trigliserida
|
||||||
|
b. Dependent Variable: Cholesterol
|
||||||
|
Coefficientsa
|
||||||
|
Model
|
Unstandardized
Coefficients
|
Standardized
Coefficients
|
|
|||
|
B
|
Std. Error
|
Beta
|
t
|
Sig.
|
||
|
1
|
(Constant)
|
200.525
|
18.433
|
|
10.879
|
.000
|
|
Trigliserida
|
.115
|
.098
|
.185
|
1.173
|
.247
|
|
|
UMSQ
|
.002
|
.005
|
.065
|
.413
|
.682
|
|
|
a. Dependent Variable: Cholesterol
|
||||||
Model 5 : CHOL = β0 + β1 TRIG
+ β2 UM + β3 UMSQ
|
Model Summary
|
||||
|
Model
|
R
|
R Square
|
Adjusted R
Square
|
Std. Error of
the Estimate
|
|
1
|
.378a
|
.143
|
.080
|
24.475
|
|
a. Predictors: (Constant), UMSQ,
Trigliserida, Umur
|
||||
|
ANOVAb
|
||||||
|
Model
|
Sum of
Squares
|
df
|
Mean Square
|
F
|
Sig.
|
|
|
1
|
Regression
|
4086.344
|
3
|
1362.115
|
2.274
|
.094a
|
|
Residual
|
24560.100
|
41
|
599.027
|
|
|
|
|
Total
|
28646.444
|
44
|
|
|
|
|
|
a. Predictors: (Constant), UMSQ,
Trigliserida, Umur
|
||||||
|
b. Dependent Variable: Cholesterol
|
||||||
|
Coefficientsa
|
||||||
|
Model
|
Unstandardized
Coefficients
|
Standardized
Coefficients
|
|
|||
|
B
|
Std. Error
|
Beta
|
t
|
Sig.
|
||
|
1
|
(Constant)
|
-21.969
|
104.532
|
|
-.210
|
.835
|
|
Trigliserida
|
.079
|
.095
|
.126
|
.825
|
.414
|
|
|
Umur
|
9.220
|
4.269
|
3.132
|
2.160
|
.037
|
|
|
UMSQ
|
-.088
|
.042
|
-3.035
|
-2.103
|
.042
|
|
|
a. Dependent Variable: Cholesterol
|
||||||
|
No.
|
Model
Estimasi
|
F
|
r2
|
|
1
|
Y
= 203.123 + 0.127 TRIG
(.093)
|
1.850
|
.041
|
|
2
|
Y
= 204.048 + 0.445 UM
(.444)
|
1.007
|
.023
|
|
3
|
Y
= 217.420 + 0.003 UMSQ
(.004)
|
0.603
|
.014
|
|
4
|
Y
= 192.155 + 0.108 TRIG + 0.292 UM
(.098)
(.464)
|
1.110
|
.050
|
|
5
|
Y
= 200.525 + 0.115 TRIG + .002 UMSQ
(.098) (.005)
|
0.992
|
.045
|
|
6
|
Y
= -21.969 + 0.079 TRIG + 9.220 UM +
-0.088 UMSQ
|
2.274
|
.143
|
Dari
ke enam model estimasi terlihat bahwa variable TRIG secara konsisten sangan
berpengaruh terhadap CHOL (p<0.05). pada model estimasi 1 tampak nilai r2
sebesar .041 dan bila dibandingkan dengan model estimasi 4,5, dan 6 penambahan
r2 relatif kecil masing-masing .050, .045 dan .143 atau hanya
bertambah sekitar .009, .004, dan .102,ini sangat tidak berarti.
Dengan
demikian kita bisa berkesimpulan TRIG sangat bermakna pengaruhnya terhadap
CHOL. Sebaliknya penambahan variable UM dab UMSQ tidak berperan dalam menjelaskan
variasi CHOL dan kita tidak perlu menambajkan kdua variable tersebut ke dalam
model. Model akhir yaitu : Y = 203.123 + 0.127 TRIG
Tidak ada komentar:
Posting Komentar