HALAMAN 154
Latihan
2.
Lakukan
prediksi BB dengan variabel independent TB, BTL dan AK.
a. Hitung
SS for Regression ( X3 | X1 , X2 ) ;
b. Hitung
SS for Residual ;
c. Hitung
Means SS for Regression ( X3 |
X1 , X2 ) ;
d. Hitung
Mean SS for Residual ;
e. Hitung
nilai F parsial ;
f. Hitung
nilai r2
g. Buktikan
bahwa penambahan X3 berperan dalam memprediksi Y.
jawaban :
- · HASIL SPSS DAN HASIL MODEL 1
|
Variables Entered/Removedb
|
|||
|
Model
|
Variables Entered
|
Variables Removed
|
Method
|
|
1
|
Tinggi Badana
|
.
|
Enter
|
|
a. All requested variables entered.
|
|
||
|
b. Dependent Variable: Berat Badan
|
|||
|
Model Summary
|
||||
|
Model
|
R
|
R Square
|
Adjusted R Square
|
Std. Error of the Estimate
|
|
1
|
.378a
|
.143
|
.081
|
11.8405
|
|
a. Predictors: (Constant), Tinggi Badan
|
|
|||
|
ANOVAb
|
||||||
|
Model
|
Sum of Squares
|
df
|
Mean Square
|
F
|
Sig.
|
|
|
1
|
Regression
|
326.204
|
1
|
326.204
|
2.327
|
.149a
|
|
Residual
|
1962.751
|
14
|
140.196
|
|
|
|
|
Total
|
2288.954
|
15
|
|
|
|
|
|
a. Predictors: (Constant), Tinggi Badan
|
|
|
|
|||
|
b. Dependent Variable: Berat Badan
|
|
|
|
|||
|
Coefficientsa
|
||||||
|
Model
|
Unstandardized Coefficients
|
Standardized Coefficients
|
t
|
Sig.
|
||
|
B
|
Std. Error
|
Beta
|
||||
|
1
|
(Constant)
|
-2.492
|
48.880
|
|
-.051
|
.960
|
|
Tinggi Badan
|
.441
|
.289
|
.378
|
1.525
|
.149
|
|
|
a. Dependent Variable: Berat Badan
|
|
|
|
|||
Model
1. BB ß0 + ß1 TB
|
Coefficient
|
Standart Error
|
Partial F
|
|
ß0 = -2.492
|
|
|
|
ß1 = .441
|
Sß1 = .289
|
2.327
|
Estimasi
Model 1 : BB = -2.492 + 0.441 TB
ANOVA Tabel
|
Sumber
|
df
|
SS
|
MS
|
F
|
r2
|
|
Regresi
|
1
|
326.204
|
326.204
|
2.327
|
.143
|
|
Residual
|
14
|
1962.751
|
140.196
|
||
|
Total
|
15
|
2288.954
|
|
|
|
- · HASIL SPSS DAN HASIL MODEL 2
|
Variables Entered/Removedb
|
|||
|
Model
|
Variables Entered
|
Variables Removed
|
Method
|
|
1
|
Berat Badan Tanpa Lemak a
|
.
|
Enter
|
|
a. All requested variables entered.
|
|
||
|
b. Dependent Variable: Berat Badan
|
|||
|
Model Summary
|
||||
|
Model
|
R
|
R Square
|
Adjusted R Square
|
Std. Error of the Estimate
|
|
1
|
.945a
|
.893
|
.886
|
4.1735
|
|
a. Predictors: (Constant), Berat Badan Tanpa Lemak
|
||||
|
ANOVAb
|
||||||
|
Model
|
Sum of Squares
|
Df
|
Mean Square
|
F
|
Sig.
|
|
|
1
|
Regression
|
2045.099
|
1
|
2045.099
|
117.411
|
.000a
|
|
Residual
|
243.855
|
14
|
17.418
|
|
|
|
|
Total
|
2288.954
|
15
|
|
|
|
|
|
a. Predictors: (Constant), Berat Badan Tanpa Lemak
|
|
|
||||
|
b. Dependent Variable: Berat Badan
|
|
|
|
|||
|
Coefficientsa
|
||||||
|
Model
|
Unstandardized Coefficients
|
Standardized Coefficients
|
t
|
Sig.
|
||
|
B
|
Std. Error
|
Beta
|
||||
|
1
|
(Constant)
|
-4.303
|
7.112
|
|
-.605
|
.555
|
|
Berat Badan Tanpa Lemak
|
1.554
|
.143
|
.945
|
10.836
|
.000
|
|
|
a. Dependent Variable: Berat Badan
|
|
|
|
|
||
Model
2. BB ß0 + ß1 BTL
|
Coefficient
|
Standart Error
|
Partial F
|
|
ß0 = -4.303
|
|
|
|
ß1 = 1.554
|
Sß1 = 0.143
|
|
Estimasi
Model 2 : BB -4.303 + -1.554 BTL
ANOVA Tabel
|
Sumber
|
df
|
SS
|
MS
|
F
|
r2
|
|
Regresi
|
1
|
2045.099
|
2045.099
|
117.411
|
.893
|
|
Residual
|
14
|
243.855
|
17.418
|
||
|
Total
|
15
|
2288.954
|
|
|
|
- · HASIL SPSS DAN HASIL MODEL 3
|
Variables Entered/Removedb
|
|||
|
Model
|
Variables Entered
|
Variables Removed
|
Method
|
|
1
|
Asupan Kalori a
|
.
|
Enter
|
|
a. All requested variables entered.
|
|
||
|
b. Dependent Variable: Berat Badan
|
|||
|
Model Summary
|
||||
|
Model
|
R
|
R Square
|
Adjusted R Square
|
Std. Error of the Estimate
|
|
1
|
.617a
|
.381
|
.337
|
10.0593
|
|
a. Predictors: (Constant), Asupan Kalori
|
|
|||
|
ANOVAb
|
||||||
|
Model
|
Sum of Squares
|
df
|
Mean Square
|
F
|
Sig.
|
|
|
1
|
Regression
|
872.301
|
1
|
872.301
|
8.620
|
.011a
|
|
Residual
|
1416.653
|
14
|
101.190
|
|
|
|
|
Total
|
2288.954
|
15
|
|
|
|
|
|
a. Predictors: (Constant), Asupan Kalori
|
|
|
|
|||
|
b. Dependent Variable: Berat Badan
|
|
|
|
|||
|
Coefficientsa
|
||||||
|
Model
|
Unstandardized Coefficients
|
Standardized Coefficients
|
t
|
Sig.
|
||
|
B
|
Std. Error
|
Beta
|
||||
|
1
|
(Constant)
|
52.517
|
7.074
|
|
7.423
|
.000
|
|
Asupan Kalori
|
.013
|
.004
|
.617
|
2.936
|
.011
|
|
|
a. Dependent Variable: Berat Badan
|
|
|
|
|||
Model
3. BB ß0 + ß1 AK
|
Coefficient
|
Standart Error
|
Partial F
|
|
ß0 = 52.517
|
|
|
|
ß1 = 0 .013
|
Sß1 = 0.004
|
8.620
|
Estimasi
Model 3 : BB -
52.517 + 0 .013 AK
ANOVA Tabel
|
Sumber
|
df
|
SS
|
MS
|
F
|
r2
|
|
Regresi
|
1
|
872.301
|
872.301
|
8.620
|
.381
|
|
Residual
|
14
|
1416.653
|
101.190
|
||
|
Total
|
15
|
2288.954
|
|
|
|
- · HASIL SPSS DAN HASIL MODEL 4
|
Variables Entered/Removedb
|
|||
|
Model
|
Variables Entered
|
Variables Removed
|
Method
|
|
1
|
Berat Badan Tanpa Lemak , Tinggi Badana
|
.
|
Enter
|
|
a. All requested variables entered.
|
|
||
|
b. Dependent Variable: Berat Badan
|
|||
|
Model Summary
|
||||
|
Model
|
R
|
R Square
|
Adjusted R Square
|
Std. Error of the Estimate
|
|
1
|
.954a
|
.910
|
.896
|
3.9870
|
|
a. Predictors: (Constant), Berat Badan Tanpa Lemak , Tinggi
Badan
|
||||
|
ANOVAb
|
||||||
|
Model
|
Sum of Squares
|
df
|
Mean Square
|
F
|
Sig.
|
|
|
1
|
Regression
|
2082.309
|
2
|
1041.154
|
65.499
|
.000a
|
|
Residual
|
206.645
|
13
|
15.896
|
|
|
|
|
Total
|
2288.954
|
15
|
|
|
|
|
|
a. Predictors: (Constant), Berat Badan Tanpa Lemak , Tinggi
Badan
|
|
|||||
|
b. Dependent Variable: Berat Badan
|
|
|
|
|||
|
Coefficientsa
|
||||||
|
Model
|
Unstandardized Coefficients
|
Standardized Coefficients
|
t
|
Sig.
|
||
|
B
|
Std. Error
|
Beta
|
||||
|
1
|
(Constant)
|
-27.527
|
16.631
|
|
-1.655
|
.122
|
|
Tinggi Badan
|
.155
|
.101
|
.132
|
1.530
|
.150
|
|
|
Berat Badan Tanpa Lemak
|
1.496
|
.142
|
.910
|
10.511
|
.000
|
|
|
a. Dependent Variable: Berat Badan
|
|
|
|
|
||
Model
4. BB ß0 + ß1 TB +
ß2 UM
|
Coefficient
|
Standart Error
|
Partial F
|
|
ß0 = -27.527
|
|
|
|
ß1 = 0.155
|
Sß1 = 0.101
|
165.499
|
|
ß2 = 1.496
|
Sß2 = 0.142
|
|
Estimasi
Model 4 : BB -27.527 + 0.155 TB + 0.1496 BTL
ANOVA Tabel
|
Sumber
|
df
|
SS
|
MS
|
F
|
r2
|
|
Regresi
|
2
|
2082.309
|
1041.154
|
165.499
|
.910
|
|
Residual
|
13
|
206.645
|
15.896
|
||
|
Total
|
15
|
2288.954
|
|
|
|
- · HASIL SPSS DAN HASIL MODEL 5
|
Variables Entered/Removedb
|
|||
|
Model
|
Variables Entered
|
Variables Removed
|
Method
|
|
1
|
Asupan Kalori , Tinggi Badana
|
.
|
Enter
|
|
a. All requested variables entered.
|
|
||
|
b. Dependent Variable: Berat Badan
|
|||
|
Model Summary
|
||||
|
Model
|
R
|
R Square
|
Adjusted R Square
|
Std. Error of the Estimate
|
|
1
|
.747a
|
.557
|
.489
|
8.8280
|
|
a. Predictors: (Constant), Asupan Kalori , Tinggi Badan
|
||||
|
ANOVAb
|
||||||
|
Model
|
Sum of Squares
|
df
|
Mean Square
|
F
|
Sig.
|
|
|
1
|
Regression
|
1275.821
|
2
|
637.911
|
8.185
|
.005a
|
|
Residual
|
1013.133
|
13
|
77.933
|
|
|
|
|
Total
|
2288.954
|
15
|
|
|
|
|
|
a. Predictors: (Constant), Asupan Kalori , Tinggi Badan
|
|
|
||||
|
b. Dependent Variable: Berat Badan
|
|
|
|
|||
|
Coefficientsa
|
||||||
|
Model
|
Unstandardized Coefficients
|
Standardized Coefficients
|
t
|
Sig.
|
||
|
B
|
Std. Error
|
Beta
|
||||
|
1
|
(Constant)
|
-31.333
|
37.369
|
|
-.838
|
.417
|
|
Tinggi Badan
|
.492
|
.216
|
.421
|
2.275
|
.040
|
|
|
Asupan Kalori
|
.014
|
.004
|
.646
|
3.491
|
.004
|
|
|
a. Dependent Variable: Berat Badan
|
|
|
|
|||
Model
5. CHOL ß0 + ß1 (UM)2
+ ß2 TG
|
Coefficient
|
Standart Error
|
Partial F
|
|
ß0 = -31.333
|
|
|
|
ß1 = 0.492
|
Sß1 = 0.216
|
8.185
|
|
ß2 = 0.014
|
Sß2 = 0.044
|
|
Estimasi
Model 5 : -31.333+.492+.014 AK
ANOVA Tabel
|
Sumber
|
df
|
SS
|
MS
|
F
|
r2
|
|
Regresi
|
2
|
1275.821
|
637.911
|
8.185
|
.557
|
|
Residual
|
13
|
1013.133
|
77.933
|
||
|
Total
|
15
|
2288.954
|
|
|
|
- · HASIL SPSS DAN HASIL MODEL 6
|
Variables Entered/Removedb
|
|||
|
Model
|
Variables Entered
|
Variables Removed
|
Method
|
|
1
|
Asupan Kalori , Tinggi Badan, Berat Badan Tanpa Lemak a
|
.
|
Enter
|
|
a. All requested variables entered.
|
|
||
|
b. Dependent Variable: Berat Badan
|
|||
|
Model Summary
|
||||
|
Model
|
R
|
R Square
|
Adjusted R Square
|
Std. Error of the Estimate
|
|
1
|
.969a
|
.939
|
.923
|
3.4224
|
|
a. Predictors: (Constant), Asupan Kalori , Tinggi Badan, Berat
Badan Tanpa Lemak
|
||||
|
ANOVAb
|
||||||
|
Model
|
Sum of Squares
|
df
|
Mean Square
|
F
|
Sig.
|
|
|
1
|
Regression
|
2148.400
|
3
|
716.133
|
61.141
|
.000a
|
|
Residual
|
140.554
|
12
|
11.713
|
|
|
|
|
Total
|
2288.954
|
15
|
|
|
|
|
|
a. Predictors: (Constant), Asupan Kalori , Tinggi Badan, Berat
Badan Tanpa Lemak
|
||||||
|
b. Dependent Variable: Berat Badan
|
|
|
|
|||
|
Coefficientsa
|
||||||
|
Model
|
Unstandardized Coefficients
|
Standardized Coefficients
|
T
|
Sig.
|
||
|
B
|
Std. Error
|
Beta
|
||||
|
1
|
(Constant)
|
-33.412
|
14.489
|
|
-2.306
|
.040
|
|
Tinggi Badan
|
.210
|
.090
|
.180
|
2.339
|
.037
|
|
|
Berat Badan Tanpa Lemak
|
1.291
|
.150
|
.785
|
8.631
|
.000
|
|
|
Asupan Kalori
|
.004
|
.002
|
.209
|
2.375
|
.035
|
|
|
a. Dependent Variable: Berat Badan
|
|
|
|
|
||
Model
6. BB = ß0 + ß1 TB
+ ß3 AK + E
|
Coefficient
|
Standart Error
|
Partial F
|
|
ß0 = -33.412
|
|
|
|
ß1 = .210
|
Sß1 = .090
|
61.141
|
|
ß2 = 1.291
|
Sß2 = .150
|
|
|
ß3 = .004
|
Sß3 = .002
|
|
Estimasi
Model 6 : -21.969 + 0.079 TRIG + 9.220 UM – 0.088 UMSQ
ANOVA Tabel
|
Sumber
|
df
|
SS
|
MS
|
F
|
r2
|
|
Regresi
|
3
|
2148.400
|
716.133
|
61.141
|
.939
|
|
Residual
|
12
|
140.554
|
11.713
|
||
|
Total
|
15
|
2288.954
|
|
|
|
Uji parsial F
ANOVA tabel untuk BB dengan variabel independent TB, BTL, dan AK
|
Sumber
|
df
|
SS
|
MS
|
F
|
r²
|
|
X1
Regresi X2|X3
X3|X1,X2
|
1
1
1
|
326.204
1756.105
66.091
|
326.204
1756.105
66.091
|
29.195
157.17
5.915
|
0.142
|
|
Residual
|
41
|
140.554
|
11.173
|
||
|
Total
|
44
|
2288.954
|
*P<0.05
Ringkasan
Table analisis yang bisa memantu memilih model estimasi terbaik :
|
No.
|
Model Estimasi
|
F
|
r²
|
|
1
|
Y= -2,492 + 0,441 TB
(.289)
|
2.327
|
0,014
|
|
2
|
Y= -4,303 + 1,554 BTL
(.143)
|
117.411
|
0,893
|
|
3
|
Y=52,217 + 0,013 AK
(.004)*
|
8.620
|
0,381
|
|
4
|
Y=-27,527 + 0,155 TB + 1,496 BTL
(.101) (.142)
|
65.499
|
0,909
|
|
5
|
Y= -31,333 + 0,492 TB + 0,014 AK
(.216) (.004)
|
8.185
|
0,557
|
|
6
|
Y= -33,412 + 0,210 TB + 1,291 BTL
+ 0,004 AK
(.090) (.150) (.002)
|
61.141
|
0,938
|
*bermakna
p<0,05
Uji F= (326,204/1)/ (1756,105+66,091+140,554/14)= 2,326
(F tabel = 4,60) Hasil data p>0,05=tidak signifikan
Dari keenam model estimasi terlihat bahwa variable tinggi badan secara
konsisten tidak berpengaruh terhadap berat badan (p<0,05). pada model
estimasi 1 tampak nilai r² sebesar 0,014 dan bila dibandingkan dengan model
estimasi lainnya (2,3,4,5,6) mengalami kenailam yang signifikan dengan jumlah
yang cukup berarti, Hingga di model ke 6 mencapai 0,938 dari 0,014 di model 1.
dengan demikian kita bisa berkesimpulan variable tinggi badan tidak
memiliki pengaruh berarti pada peningkatan berat badan, namun pada model ke
enam dimana penambahan variable berat tanpa lemak dan asupan kalori mampu
menjelaskan variasi berat badan dan perlu ditambahkan ke dalam model. model
akhir yaitu :
Y= -33,412 + 0,210 TB + 1,291 BTL + 0,004AK
Tidak ada komentar:
Posting Komentar