Rabu, 23 November 2016

TUGAS ANALISIS REGRESI PERTEMUAN KE 9

HAL 154
2. Lakukan prediksi BB dengan variabel independen TB, BTL, dan AK
No
BB
TB
BTL
AK
1
79.2
149
54.1
2670
2
64
152
44.3
820
3
67
155.7
47.8
1210
4
78.4
159
53.9
2678
5
66
163.3
47.5
1205
6
63
166
43
815
7
65.9
169
47.1
1200
8
63.1
172
44
1180
9
73.2
174.5
44.1
1850
10
66.5
176.1
48.3
1260
11
61.9
176.5
43.5
1170
12
72.5
179
43.3
1852
13
101.1
182
66.4
1790
14
66.2
170.4
47.5
1250
15
99.9
184.9
66
1889
16
63
169
44
915
                                                 
BB : Berat Badan
TB : Tinggi Badan
BTL : Berat Badan Tanpa Lemak
AK : Asupan Kalori



MODEL 1.
BB= β₀ + β₁TB
Coefficient
Standar Error
Partial F
β₀ = -2.492

2.327
β₁ = .441
.289

Variables Entered/Removedb
Model
Variables Entered
Variables Removed
Method
1
TBa
.
Enter
a. All requested variables entered.
b. Dependent Variable: BB


Model Summary
Model
R
R Square
Adjusted R Square
Std. Error of the Estimate
1
,378a
,143
,081
11,84046
a. Predictors: (Constant), Tb

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), TB
b. Dependent Variable: BB
 Estimasi model 1 : BB = -2.492 + 0.441 TB
Coefficientsa
Model
Unstandardized Coefficients
Standardized Coefficients
t
Sig.
B
Std. Error
Beta
1
(Constant)
-2,492
48,880

-,051
,960
TB
,441
,289
,378
1,525
,149
a. Dependent Variable: BB



MODEL 2. 
 BB = β₀ + β₂BTL+E
Coefficient
Standar Error
Partial F
β₀ = -4.303

117.411
β₁ = 1.554
.143


Variables Entered/Removedb
Model
Variables Entered
Variables Removed
Method
1
Berat Badan Tanpa Lemak
.
Enter
a. All requested variables entered.
b. Dependent Variable: BB


Model Summary
Model
R
R Square
Adjusted R Square
Std. Error of the Estimate
1
,945a
,893
,886
4,17352
a. Predictors: (Constant), BTL

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), BTL
b. Dependent Variable: BB

Estimasi model 2 : BB = -4.303 + 1.554 BTL
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: BB

MODEL 3.
 BB= β₀ + β₃AK+E
Coefficient
Standar Error
Partial F
β₀ = 52.517

8.620
β₁ = .013
.004


a. All requested variables entered.
b. Dependent Variable: BB


Model Summary
Model
R
R Square
Adjusted R Square
Std. Error of the Estimate
1
,617a
,381
,337
10,05930
a. Predictors: (Constant), AK

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), AK
b. Dependent Variable: BB

Estimasi model 3 : BB = 52.517 + 0.013 AK
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: BB

MODEL 4.
BB= β₀ + β₁ TB + β₂BTL+E
Coefficient
Standar Error
Partial F
β₀ = -27.527

165.499
β₁ = .155
.101

β₂ = 1.496
.142


Variables Entered/Removedb
Model
Variables Entered
Variables Removed
Method
1
BTL, TB
.
Enter
a. All requested variables entered.
b. Dependent Variable: BB


Model Summary
Model
R
R Square
Adjusted R Square
Std. Error of the Estimate
1
,954a
,910
,896
3,98695
a. Predictors: (Constant), BTL, TB

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), BTL, TB
b. Dependent Variable: BB

Estimasi model 4 : BB = -27.527 + 0.155 TB + 1.496 BTL
Coefficientsa
Model
Unstandardized Coefficients
Standardized Coefficients
t
Sig.
B
Std. Error
Beta
1
(Constant)
-27,527
16,631

-1,655
,122
TB
,155
,101
,132
1,530
,150
BTL
1,496
,142
,910
10,511
,000
a. Dependent Variable: B

MODEL 5.  
BB = β₀ + β₁TB+β₃AK+E
Coefficient
Standar Error
Partial F
β₀ = -31.333

8.185
β₁ = .492
.216

β₃ = .014
.004


Variables Entered/Removedb
Model
Variables Entered
Variables Removed
Method
1
AK, TBa
.
Enter
a. All requested variables entered.
b. Dependent Variable: BB

Model Summary
Model
R
R Square
Adjusted R Square
Std. Error of the Estimate
1
,747a
,557
,489
8,82798
a. Predictors: (Constant), AK, TB


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), AK, TB
b. Dependent Variable: BB

Estimasi model : BB = -31.333+.492+.014 AK
Coefficientsa
Model
Unstandardized Coefficients
Standardized Coefficients
t
Sig.
B
Std. Error
Beta
1
(Constant)
-31,333
37,369

-,838
,417
TB
,492
,216
,421
2,275
,040
AK
,014
,004
,646
3,491
,004
a. Dependent Variable: BB

 2 TB + 0.014 
MODEL 6. 
 BB= β₀ + β₁TB+β₂ BTL+β₃AK+E
Coefficient
Standar Error
Partial F
β₀ = -33.412

61.141
β₁ = .210
.090

β₂ = 1.291
.150

β₃ = .004
.002


Variables Entered/Removedb
Model
Variables Entered
Variables Removed
Method
1
AK, TB, BTLa
.
Enter
a. All requested variables entered.
b. Dependent Variable: BB

Model Summary
Model
R
R Square
Adjusted R Square
Std. Error of the Estimate
1
,969a
,938
,923
3,43220
a. Predictors: (Constant), AK, TB, BTL

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), AK, TB, BTL
b. Dependent Variable: BB

Estimasi model 6: BB = -33.412+.210+1.291 + .004 

Coefficientsa
Model
Unstandardized Coefficients
Standardized Coefficients
t
Sig.
B
Std. Error
Beta
1
(Constant)
-33,412
14,489

-2,306
,040
TB
,210
,090
,180
2,339
,037
BTL
1,291
,150
,784
8,631
,000
AK
,004
,002
,209
2,374
,035
a. Dependent Variable: BB



Kita lakukan uji parsial F
ANOVA tabel untuk CHOL dengan TRIG, UM, UMSQ
Sumber
df
SS
MS
F
            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="" span="">


Ringkasan Table analisis yang bisa memantu memilih model estimasi terbaik :
No.
Model Estimasi
F
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 span="">

Tidak ada komentar:

Posting Komentar