HALAMAN
221
Latihan
Soal 1
Lakukan prediksi
TRI dengan variabel independent IMT, Umur dan Umur kuadrat bekerjasama di
Laboraturium.
a.
Lakukan
analisa regresi masing-masing independent variabel
b.
Hitung
SS for regression (X3|X1,X2)
c.
Hitung
SS for residual
d.
Hitung
Means SS for regression (X3|X1,X2)
e.
Hitung
Means SS for residual
f.
Hitung
nilai F Parsial
g.
Hitung
nilai r2
h.
Bukti
penambahan X3 Berperan dalam memprediksi Y.
|
TRI
|
IMT
|
UM
|
TRI
|
IMT
|
UM
|
TRI
|
IMT
|
UM
|
|
135
|
28
|
45
|
230
|
32
|
41
|
136
|
31
|
49
|
|
101
|
37
|
52
|
146
|
29
|
54
|
139
|
28
|
47
|
|
57
|
37
|
60
|
160
|
36
|
48
|
124
|
23
|
44
|
|
56
|
46
|
64
|
186
|
39
|
59
|
138
|
40
|
51
|
|
113
|
41
|
64
|
138
|
36
|
56
|
150
|
35
|
54
|
|
42
|
30
|
50
|
160
|
34
|
49
|
142
|
30
|
46
|
|
84
|
32
|
57
|
142
|
34
|
56
|
145
|
37
|
58
|
|
186
|
33
|
53
|
153
|
32
|
50
|
149
|
33
|
54
|
|
164
|
30
|
48
|
139
|
28
|
43
|
128
|
29
|
43
|
|
205
|
38
|
63
|
170
|
41
|
63
|
155
|
39
|
62
|
Jawaban :
a.
Analisa Regresi
masing-masing independent variabel
MODEL
1 DAN HASILNYA
|
Variables Entered/Removedb
|
|||
|
Model
|
Variables Entered
|
Variables Removed
|
Method
|
|
1
|
Indeks Massa Tubuha
|
.
|
Enter
|
|
a. All requested variables entered.
|
|
||
|
b. Dependent Variable: Trigliserida
|
|
||
|
Model Summary
|
||||
|
Model
|
R
|
R Square
|
Adjusted R Square
|
Std. Error of the Estimate
|
|
1
|
.057a
|
.003
|
-.032
|
41.696
|
|
a. Predictors: (Constant), Indeks Massa Tubuh
|
||||
|
ANOVAb
|
||||||
|
Model
|
Sum of Squares
|
df
|
Mean Square
|
F
|
Sig.
|
|
|
1
|
Regression
|
160.067
|
1
|
160.067
|
.092
|
.764a
|
|
Residual
|
48678.633
|
28
|
1738.523
|
|
|
|
|
Total
|
48838.700
|
29
|
|
|
|
|
|
a. Predictors: (Constant), Indeks Massa Tubuh
|
|
|
||||
|
b. Dependent Variable: Trigliserida
|
|
|
|
|||
|
Coefficientsa
|
||||||
|
Model
|
Unstandardized Coefficients
|
Standardized Coefficients
|
t
|
Sig.
|
||
|
B
|
Std. Error
|
Beta
|
||||
|
1
|
(Constant)
|
154.991
|
52.922
|
|
2.929
|
.007
|
|
Indeks Massa Tubuh
|
-.468
|
1.543
|
-.057
|
-.303
|
.764
|
|
|
a. Dependent Variable: Trigliserida
|
|
|
|
|
||
Model
1 : TRI = ß0 + ß1 IMT
Hasilnya
:
|
Coefficient
|
Standard Error
|
Partial F
|
|
ß0 =
154.991
|
|
|
|
ß1 =
-0.468
|
Sß1
= 1.543
|
0.092
|
Estimasi
Model 1 : Model 1 : TRI = 154.991
+ -0.468 IMT
|
Sumber
|
SS
|
df
|
MS
|
F
|
r2
|
|
Regresi
|
160.067
|
1
|
160.067
|
0.92
|
0.003
|
|
Residual
|
48678.633
|
28
|
1738.523
|
||
|
Total
|
48838.700
|
29
|
|
|
|
MODEL 2 DAN
HASILNYA
|
Variables Entered/Removedb
|
|||
|
Model
|
Variables Entered
|
Variables Removed
|
Method
|
|
1
|
Umura
|
.
|
Enter
|
|
a. All requested variables entered.
|
|
||
|
b. Dependent Variable: Trigliserida
|
|
||
|
Model Summary
|
||||
|
Model
|
R
|
R Square
|
Adjusted R Square
|
Std. Error of the Estimate
|
|
1
|
.170a
|
.029
|
-.006
|
41.154
|
|
a. Predictors: (Constant), Umur
|
|
|||
|
ANOVAb
|
||||||
|
Model
|
Sum of Squares
|
df
|
Mean Square
|
F
|
Sig.
|
|
|
1
|
Regression
|
1416.088
|
1
|
1416.088
|
.836
|
.368a
|
|
Residual
|
47422.612
|
28
|
1693.665
|
|
|
|
|
Total
|
48838.700
|
29
|
|
|
|
|
|
a. Predictors: (Constant), Umur
|
|
|
|
|
||
|
b. Dependent Variable: Trigliserida
|
|
|
|
|||
|
Coefficientsa
|
||||||
|
Model
|
Unstandardized Coefficients
|
Standardized Coefficients
|
T
|
Sig.
|
||
|
B
|
Std. Error
|
Beta
|
||||
|
1
|
(Constant)
|
193.196
|
59.636
|
|
3.240
|
.003
|
|
Umur
|
-1.025
|
1.121
|
-.170
|
-.914
|
.368
|
|
|
a. Dependent Variable: Trigliserida
|
|
|
|
|||
Model
2 : TRI = ß0 + ß1 UM
Hasilnya
:
|
Coefficient
|
Standard Error
|
Partial F
|
|
ß0 =
193.196
|
|
|
|
ß1 =
-1.025
|
Sß1 =1.121
|
0.836
|
Estimasi
Model 2 : Model 1 : TRI = 193.196+
-1.025 IMT
ANOVA
Table
|
Sumber
|
SS
|
df
|
MS
|
F
|
r2
|
|
Regresi
|
1416.088
|
1
|
1416.088
|
0.836
|
0.029
|
|
Residual
|
47422.612
|
28
|
1693.665
|
||
|
Total
|
48838.700
|
29
|
|
|
|
MODEL
3 DAN HASILNYA
|
Variables Entered/Removedb
|
|||
|
Model
|
Variables Entered
|
Variables Removed
|
Method
|
|
1
|
Umur Kuadrata
|
.
|
Enter
|
|
a. All requested variables entered.
|
|
||
|
b. Dependent Variable: Trigliserida
|
|
||
|
Model Summary
|
||||
|
Model
|
R
|
R Square
|
Adjusted R Square
|
Std. Error of the Estimate
|
|
1
|
.162a
|
.026
|
-.008
|
41.210
|
|
a. Predictors: (Constant), Umur Kuadrat
|
|
|||
|
ANOVAb
|
||||||
|
Model
|
Sum of Squares
|
df
|
Mean Square
|
F
|
Sig.
|
|
|
1
|
Regression
|
1287.955
|
1
|
1287.955
|
.758
|
.391a
|
|
Residual
|
47550.745
|
28
|
1698.241
|
|
|
|
|
Total
|
48838.700
|
29
|
|
|
|
|
|
a. Predictors: (Constant), Umur Kuadrat
|
|
|
|
|||
|
b. Dependent Variable: Trigliserida
|
|
|
|
|||
|
Coefficientsa
|
||||||
|
Model
|
Unstandardized Coefficients
|
Standardized Coefficients
|
t
|
Sig.
|
||
|
B
|
Std. Error
|
Beta
|
||||
|
1
|
(Constant)
|
165.049
|
30.732
|
|
5.371
|
.000
|
|
Umur Kuadrat
|
-.009
|
.011
|
-.162
|
-.871
|
.391
|
|
|
a. Dependent Variable: Trigliserida
|
|
|
|
|||
Model
3 : TRI = ß0 + ß1 UMSQ
Hasilnya
:
|
Coefficient
|
Standard Error
|
Partial F
|
|
ß0 =
165.049
|
|
|
|
ß1 =
-0.009
|
Sß1 =
0.011
|
0.758
|
Estimasi
Model 3 : Model 1 : TRI = 165.049
+ -0.009 UMSQ
ANOVA
Table
|
Sumber
|
SS
|
df
|
MS
|
F
|
r2
|
|
Regresi
|
1287.955
|
1
|
1287.955
|
0.758
|
0.026
|
|
Residual
|
47550.745
|
28
|
1698.241
|
||
|
Total
|
48838.700
|
29
|
|
|
|
MODEL
4 DAN HASILNYA
|
Variables Entered/Removedb
|
|||
|
Model
|
Variables Entered
|
Variables Removed
|
Method
|
|
1
|
Indeks Massa Tubuh, Umura
|
.
|
Enter
|
|
a. All requested variables entered.
|
|
||
|
b. Dependent Variable: Trigliserida
|
|
||
|
Model Summary
|
||||
|
Model
|
R
|
R Square
|
Adjusted R Square
|
Std. Error of the Estimate
|
|
1
|
.215a
|
.046
|
-.024
|
41.536
|
|
a. Predictors: (Constant), Indeks Massa Tubuh, Umur
|
||||
|
ANOVAb
|
||||||
|
Model
|
Sum of Squares
|
df
|
Mean Square
|
F
|
Sig.
|
|
|
1
|
Regression
|
2256.283
|
2
|
1128.141
|
.654
|
.528a
|
|
Residual
|
46582.417
|
27
|
1725.275
|
|
|
|
|
Total
|
48838.700
|
29
|
|
|
|
|
|
a. Predictors: (Constant), Indeks Massa Tubuh, Umur
|
|
|
||||
|
b. Dependent Variable: Trigliserida
|
|
|
|
|||
|
Coefficientsa
|
||||||
|
Model
|
Unstandardized Coefficients
|
Standardized Coefficients
|
t
|
Sig.
|
||
|
B
|
Std. Error
|
Beta
|
||||
|
1
|
(Constant)
|
188.027
|
60.643
|
|
3.101
|
.004
|
|
Umur
|
-2.075
|
1.883
|
-.345
|
-1.102
|
.280
|
|
|
Indeks Massa Tubuh
|
1.785
|
2.558
|
.218
|
.698
|
.491
|
|
|
a. Dependent Variable: Trigliserida
|
|
|
|
|
||
MODEL 4 : TRI =
β0 + β1 IMT + β2 UM
Hasilnya
:
|
Coefficient
|
Standard Error
|
Partial F
|
|
ß0 =
188.207
|
|
|
|
ß1 =
-2.075
|
Sß1 =
1.883
|
0.654
|
|
ß3
= 1.785
|
Sß2 =
2.558
|
|
MODEL 4 : TRI = 188.207
+ (-2.075) IMT + 1.785 UM
ANOVA
Table
|
Sumber
|
SS
|
df
|
MS
|
F
|
r2
|
|
Regresi
|
2256.283
|
2
|
1128.141
|
0.654
|
0.046
|
|
Residual
|
46582.417
|
27
|
1725.275
|
||
|
Total
|
48838.700
|
29
|
|
|
|
MODEL
5 DAN HASILNYA
|
Variables Entered/Removedb
|
|||
|
Model
|
Variables Entered
|
Variables Removed
|
Method
|
|
1
|
Umur Kuadrat, Indeks Massa Tubuha
|
.
|
Enter
|
|
a. All requested variables entered.
|
|
||
|
b. Dependent Variable: Trigliserida
|
|
||
|
Model Summary
|
||||
|
Model
|
R
|
R Square
|
Adjusted R Square
|
Std. Error of the Estimate
|
|
1
|
.204a
|
.042
|
-.029
|
41.634
|
|
a. Predictors: (Constant), Umur Kuadrat, Indeks Massa Tubuh
|
||||
|
ANOVAb
|
||||||
|
Model
|
Sum of Squares
|
df
|
Mean Square
|
F
|
Sig.
|
|
|
1
|
Regression
|
2036.327
|
2
|
1018.163
|
.587
|
.563a
|
|
Residual
|
46802.373
|
27
|
1733.421
|
|
|
|
|
Total
|
48838.700
|
29
|
|
|
|
|
|
a. Predictors: (Constant), Umur Kuadrat, Indeks Massa Tubuh
|
|
|
||||
|
b. Dependent Variable: Trigliserida
|
|
|
|
|||
|
Coefficientsa
|
||||||
|
Model
|
Unstandardized Coefficients
|
Standardized Coefficients
|
t
|
Sig.
|
||
|
B
|
Std. Error
|
Beta
|
||||
|
1
|
(Constant)
|
133.975
|
56.573
|
|
2.368
|
.025
|
|
Indeks Massa Tubuh
|
1.706
|
2.597
|
.209
|
.657
|
.517
|
|
|
Umur Kuadrat
|
-.019
|
.018
|
-.330
|
-1.040
|
.307
|
|
|
a. Dependent Variable: Trigliserida
|
|
|
|
|
||
MODEL 5 : TRI =
β0 + β1 IMT + β2 UMSQ
Hasilnya
:
|
Coefficient
|
Standard Error
|
Partial F
|
|
ß0 =
133.975
|
|
|
|
ß1 =
1.706
|
Sß1 =
2.597
|
0.587
|
|
ß2 =
-0.019
|
Sß2 =
0.018
|
|
MODEL 5 : TRI = 133.975
+ 1.706 IMT + -0.019 UMSQ
ANOVA
Table
|
Sumber
|
SS
|
df
|
MS
|
F
|
r2
|
|
Regresi
|
2036.327
|
2
|
1018.163
|
0.587
|
0.042
|
|
Residual
|
46802.373
|
27
|
1733.421
|
||
|
Total
|
48838.700
|
29
|
|
|
|
MODEL
6 DAN HASILNYA
|
Variables Entered/Removedb
|
|||
|
Model
|
Variables Entered
|
Variables Removed
|
Method
|
|
1
|
Umur Kuadrat, Indeks Massa Tubuh, Umura
|
.
|
Enter
|
|
a. All requested variables entered.
|
|
||
|
b. Dependent Variable: Trigliserida
|
|
||
|
Model Summary
|
||||
|
Model
|
R
|
R Square
|
Adjusted R Square
|
Std. Error of the Estimate
|
|
1
|
.237a
|
.056
|
-.053
|
42.103
|
|
a. Predictors: (Constant), Umur Kuadrat, Indeks Massa Tubuh,
Umur
|
||||
|
ANOVAb
|
||||||
|
Model
|
Sum of Squares
|
df
|
Mean Square
|
F
|
Sig.
|
|
|
1
|
Regression
|
2750.563
|
3
|
916.854
|
.517
|
.674a
|
|
Residual
|
46088.137
|
26
|
1772.621
|
|
|
|
|
Total
|
48838.700
|
29
|
|
|
|
|
|
a. Predictors: (Constant), Umur Kuadrat, Indeks Massa Tubuh,
Umur
|
|
|||||
|
b. Dependent Variable: Trigliserida
|
|
|
|
|||
|
Coefficientsa
|
||||||
|
Model
|
Unstandardized Coefficients
|
Standardized Coefficients
|
t
|
Sig.
|
||
|
B
|
Std. Error
|
Beta
|
||||
|
1
|
(Constant)
|
453.925
|
507.281
|
|
.895
|
.379
|
|
Indeks Massa Tubuh
|
1.511
|
2.644
|
.185
|
.572
|
.573
|
|
|
Umur
|
-12.042
|
18.970
|
-2.000
|
-.635
|
.531
|
|
|
Umur Kuadrat
|
.095
|
.180
|
1.685
|
.528
|
.602
|
|
|
a. Dependent Variable: Trigliserida
|
|
|
|
|
||
MODEL 6 : TRI =
β0 + β1 IMT + β2 UM + β3 UMSQ
Hasilnya
:
|
Coefficient
|
Standard Error
|
Partial F
|
|
ß0 =
453.925
|
|
|
|
ß1 =
1.511
|
Sß1 =
2.644
|
0.517
|
|
ß2=-12.042
|
Sß2 = 18.970
|
|
|
ß3=
0.095
|
Sß3 =
0.180
|
|
MODEL 6 : TRI =
β0 + β1 IMT + β2 UM + β3 UMSQ
ANOVA
Table
|
Sumber
|
SS
|
df
|
MS
|
F
|
r2
|
|
Regresi
|
2750.563
|
3
|
916.854
|
0.517
|
0.056
|
|
Residual
|
46088.137
|
26
|
1772.621
|
||
|
Total
|
48838.700
|
29
|
|
|
|
a. Y = β0 + β1X1
TRI
= β0 + β1 IMT
TRI
= 154.991 – 0.468 IMT => Nilai F hitung (0.092) < F tabel (4.2) maka Ho
diterima sehingga dapat disimpukan bahwa IMT tidak mempengaruhi TRIGLISERIDA.
Y
= β0 + β1X1
TRI
= β0 + β1 UM
TRI
= 193.196 – 1.025 UM => Nilai F hitung (0.836) < F tabel (4.2) maka Ho
diterima sehingga dapat disimpukan bahwa UMUR tidak mempengaruhi TRIGLISERIDA.
Y
= β0 + β1X1
TRI
= β0 + β1 UMKWT
TRI
= 1287.955 + 47550.745 UMKWT => Nilai F hitung (0.758) < F tabel (4.2)
maka Ho sehingga diterima dapat disimpukan bahwa UMUR Kuadrat tidak
mempengaruhi TRIGLISERIDA.
b. Nilai SS for
Regression
adalah 2750.563
c. Nilai SS for
Residual adalah
46088.137
d. Nilai Means
SS for Regression
adalah 916.854
e. Nilai Means SS for Residual adalah
772.621
i. Nilai nilai F parsial adalah
0.517
j. Nilai r2 adalah 0.056
k. Buktikan penambahan
berperan dalam memprediksi Y
TRI
= 453.925 + 1.511 IMT – 12.042 UM + 0.095
UMKWT
Pada
model 6 diatas, nilai F untuk penambahan independen variabel X3 =
0.157 < F tabel (2.98), ini berarti
hipotesa Ho : β3 = 0 diterima atau gagal ditolak,
artinya penambahan Umur Kuadrat (X3) tidak
secara bermakna dapat memprediksi Y.
Tidak ada komentar:
Posting Komentar