Rabu, 23 November 2016

TUGAS ANALISIS REGRESI PERTEMUAN 9

Lakukan prediksi CHOL dengan variabel independen TB, 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.
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
1150,9
2698,4
784,8
23754


Model  1 : BB = β0 + β1 TB
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

B
Std. Error
Beta
t
Sig.
1
(Constant)
-2.492
48.880

-.051
.960
Tinggi Badan
.441
.289
.378
1.525
.149
a. Dependent Variable: Berat Badan

Model  2 : BB = β0 + β1 BTL


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
B
Std. Error
Beta
1
(Constant)
-4.303
7.112

Berat Badan Tanpa Lemak
1.554
.143
.945
a. Dependent Variable: Berat Badan

Coefficientsa
Model

t
Sig.
1
(Constant)
-.605
.555
Berat Badan Tanpa Lemak
10.836
.000
a. Dependent Variable: Berat Badan

Model  3 : BB = β0 + β1 AK


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

B
Std. Error
Beta
t
Sig.
1
(Constant)
52.517
7.074

7.423
.000
Asupan Kalori
.013
.004
.617
2.936
.011
a. Dependent Variable: Berat Badan

Model  4 : BB = β0 + β1 TB + β2 BTL


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
B
Std. Error
Beta
1
(Constant)
-27.527
16.631

Tinggi Badan
.155
.101
.132
Berat Badan Tanpa Lemak
1.496
.142
.910
a. Dependent Variable: Berat Badan

Coefficientsa
Model

t
Sig.
1
(Constant)
-1.655
.122
Tinggi Badan
1.530
.150
Berat Badan Tanpa Lemak
10.511
.000
a. Dependent Variable: Berat Badan

Model  5 : BB = β0 + β1 TB + β2 AK


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

B
Std. Error
Beta
t
Sig.
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  6 : BB = β0 + β1 TB + β2 BTL + β3 AK


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
B
Std. Error
Beta
1
(Constant)
-33.412
14.489

Tinggi Badan
.210
.090
.180
Berat Badan Tanpa Lemak
1.291
.150
.785
Asupan Kalori
.004
.002
.209
a. Dependent Variable: Berat Badan

Coefficientsa
Model

t
Sig.
1
(Constant)
-2.306
.040
Tinggi Badan
2.339
.037
Berat Badan Tanpa Lemak
8.631
.000
Asupan Kalori
2.375
.035
a. Dependent Variable: Berat Badan

No.
Model Estimasi
F
r2
1
Y =  -2.492 + .441 TB
(.289)
2.327
.143
2
Y = -4.303 + 1.554 BTL
(.143)
117.411
.893
3
Y = 52.517+ 0.013 AK
(.004)
 8.620
.381
4
Y = -27.527 + .155 TB + 1.496 BTL
(.101) (.142)
65.499
.910
5
Y = -31.333 + .492 TB +  .014 AK
(.216)  (.004)
8.185
.557
6
Y =  -33.412 + .210 TB + 1.291 BTL + .004 AK
61.141
.939

Dari ke enam model estimasi terlihat bahwa variable TB secara konsisten sangan berpengaruh terhadap BB  (p<0.05). pada model estimasi 1 tampak nilai r2 sebesar . 143 dan bila dibandingkan dengan model estimasi 4,5, dan 6 penambahan r2 relatif kecil masing-masing  .910, .557, dan .939 atau hanya bertambah sekitar .767, .414, dan .796 ini sangat tidak berarti.
Dengan demikian kita bisa berkesimpulan TB sangat bermakna pengaruhnya terhadap BB. Sebaliknya penambahan variable BTL dab AK tidak berperan dalam menjelaskan variasi BB dan kita tidak perlu menambajkan kdua variable tersebut ke dalam model. Model akhir yaitu :  Y =  -2.492 + .441 TB



Tidak ada komentar:

Posting Komentar