Uji AsumsiKlasik_desya(TugasEkonometrika)

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 24

SUMMARY OUTPUT

Regression Statistics
Multiple R 0.340554
R Square 0.115977
Adjusted R 0.050494
Standard E 1.438495
Observatio 30

ANOVA
df SS MS F Significance F
Regression 2 7.329744 3.664872 1.771095 0.189347
Residual 27 55.87026 2.069269
Total 29 63.2

Coefficients
Standard Error t Stat P-value Lower 95%Upper 95%Lower 95.0%
Upper 95.0%
Intercept 4.444538 1.555683 2.856969 0.008134 1.25254 7.636535 1.25254 7.636535
X Variable 0.335762 0.205594 1.633129 0.114051 -0.086083 0.757607 -0.086083 0.757607
X Variable -0.177081 0.231644 -0.764454 0.451227 -0.652375 0.298213 -0.652375 0.298213

RESIDUAL OUTPUT

ObservationPredicted Y Residuals
1 5.573705 2.426295
2 5.415024 1.584976
3 6.104949 -1.104949
4 6.086549 -0.086549
5 4.902181 1.097819
6 5.256343 0.743657
7 5.256343 0.743657
8 5.927867 2.072133
9 5.237943 -1.237943
10 5.060862 -0.060862
11 5.415024 0.584976
12 5.097662 -1.097662
13 6.422311 -3.422311
14 5.415024 -0.415024
15 5.750786 0.249214
16 6.086549 1.913451
17 5.909467 -1.909467
18 5.060862 -0.060862
19 4.902181 -0.902181
20 5.927867 -0.927867
21 6.422311 -0.422311
22 5.237943 -0.237943
23 5.237943 -0.237943
24 5.415024 -0.415024
25 5.592105 -1.592105
26 4.902181 -1.902181
27 5.573705 2.426295
28 6.26363 1.73637
29 5.769186 0.230814
30 6.776473 0.223527
Kelas A Kelas B Kelas AB Y Pred e Ze Ze (sort) Tabel Z Ft
No
( X1 ) ( X2) (Y)
1 6 5 8 5.573705 2.426295 1.7480 -2.47 0.99 -0.49
2 5 4 7 5.415024 1.584976 0.1419 -1.38 0.92 -0.42
3 6 2 5 6.104949 -1.104949 -0.7961 -1.37 0.91 -0.41
4 7 4 6 6.086549 -0.086549 -0.0624 -1.15 0.87 -0.37
5 4 5 6 4.902181 1.097819 0.7909 -0.89 0.81 -0.31
6 4 3 6 5.256343 0.743657 0.5358 -0.80 0.79 -0.29
7 4 3 6 5.256343 0.743657 0.5358 -0.79 0.79 -0.29
8 6 3 8 5.927867 2.072133 1.4929 -0.67 0.75 -0.25
9 5 5 4 5.237943 -1.237943 -0.8919 -0.65 0.74 -0.24
10 5 6 5 5.060862 -0.060862 -0.0438 -0.30 0.62 -0.12
11 5 4 6 5.415024 0.584976 0.4215 -0.30 0.62 -0.12
12 3 2 4 5.097662 -1.097662 -0.7908 -0.30 0.62 -0.12
13 8 4 3 6.422311 -3.422311 -2.4656 -0.17 0.57 -0.07
14 5 4 5 5.415024 -0.415024 -0.2990 -0.17 0.57 -0.07
15 6 4 6 5.750786 0.249214 0.1795 -0.06 0.52 -0.02
16 7 4 8 6.086549 1.913451 1.3786 -0.04 0.52 -0.02
17 7 5 4 5.909467 -1.909467 -1.3757 -0.04 0.52 -0.02
18 5 6 5 5.060862 -0.060862 -0.0438 0.14 0.56 1.06
19 4 5 4 4.902181 -0.902181 -0.6500 0.16 0.56 1.06
20 6 3 5 5.927867 -0.927867 -0.6685 0.17 0.57 1.07
21 8 4 6 6.422311 -0.422311 -0.3043 0.18 0.57 1.07
22 5 5 5 5.237943 -0.237943 -0.1714 0.42 0.66 1.16
23 5 5 5 5.237943 -0.237943 -0.1714 0.54 0.71 1.21
24 5 4 5 5.415024 -0.415024 -0.2990 0.54 0.71 1.21
25 5 3 4 5.592105 -1.592105 -1.1470 0.79 0.79 1.29
26 4 5 3 4.902181 -1.902181 -1.3704 1.25 0.89 1.39
27 6 5 8 5.573705 2.426295 1.7480 1.38 0.92 1.42
28 7 3 8 6.26363 1.736370 1.2510 1.49 0.93 1.43
29 5 2 6 5.769186 0.230814 0.1663 1.75 0.96 1.46
30 8 2 7 6.776473 0.223527 0.1610 1.75 0.96 1.46
Rata 0.00
Stdev 1.3880059602
Fs (Ft-Fs) |(Ft-Fs)|

0.033 -0.527 0.527


0.067 -0.483 0.483
0.100 -0.515 0.515
0.133 -0.508 0.508
0.167 -0.480 0.480
0.200 -0.488 0.488
0.233 -0.519 0.519
0.267 -0.515 0.515
0.300 -0.542 0.542
0.333 -0.451 0.451
0.367 -0.485 0.485
0.400 -0.518 0.518
0.433 -0.501 0.501
0.467 -0.534 0.534
0.500 -0.524 0.524
0.533 -0.549 0.549
0.567 -0.583 0.583
0.600 0.456 0.456
0.633 0.430 0.430
0.667 0.401 0.401
0.700 0.371 0.371
0.733 0.429 0.429
0.767 0.439 0.439
0.800 0.405 0.405
0.833 0.452 0.452
0.867 0.528 0.528
0.900 0.516 0.516
0.933 0.499 0.499
0.967 0.493 0.493
1.000 0.460 0.460
Max 0.583 > 0.161
Kelas A Kelas B Kelas AB
No
( X1 ) ( X2) (Y)
1 6 5 8
2 5 4 7
3 6 2 5
4 7 4 6
5 4 5 6
6 4 3 6
7 4 3 6
8 6 3 8
9 5 5 4
10 5 6 5
11 5 4 6
12 3 2 4
13 8 4 3
14 5 4 5
15 6 4 6
16 7 4 8
17 7 5 4
18 5 6 5
19 4 5 4
20 6 3 5
21 8 4 6
22 5 5 5
23 5 5 5
24 5 4 5
25 5 3 4
26 4 5 3
27 6 5 8
28 7 3 8
29 5 2 6
30 8 2 7
r -0.102
r2 0.010
TOL 0.990
VIF 1.010
Karena nilai VIF sebesar 1.010 yang dimana lebih kecil dari 10 maka data terjadi multikolinieritas
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.340554
R Square 0.115977
Adjusted R 0.050494
Standard E 1.438495
Observatio 30

ANOVA
df SS MS F Significance F
Regression 2 7.329744 3.664872 1.771095 0.189347
Residual 27 55.87026 2.069269
Total 29 63.2

Coefficients
Standard Error t Stat P-value Lower 95%Upper 95%Lower 95.0%
Upper 95.0%
Intercept 4.444538 1.555683 2.856969 0.008134 1.25254 7.636535 1.25254 7.636535
X Variable 0.335762 0.205594 1.633129 0.114051 -0.086083 0.757607 -0.086083 0.757607
X Variable -0.177081 0.231644 -0.764454 0.451227 -0.652375 0.298213 -0.652375 0.298213

RESIDUAL OUTPUT

ObservationPredicted Y Residuals
1 5.573705 2.426295
2 5.415024 1.584976
3 6.104949 -1.104949
4 6.086549 -0.086549
5 4.902181 1.097819
6 5.256343 0.743657
7 5.256343 0.743657
8 5.927867 2.072133
9 5.237943 -1.237943
10 5.060862 -0.060862
11 5.415024 0.584976
12 5.097662 -1.097662
13 6.422311 -3.422311
14 5.415024 -0.415024
15 5.750786 0.249214
16 6.086549 1.913451
17 5.909467 -1.909467
18 5.060862 -0.060862
19 4.902181 -0.902181
20 5.927867 -0.927867
21 6.422311 -0.422311
22 5.237943 -0.237943
23 5.237943 -0.237943
24 5.415024 -0.415024
25 5.592105 -1.592105
26 4.902181 -1.902181
27 5.573705 2.426295
28 6.26363 1.73637
29 5.769186 0.230814
30 6.776473 0.223527
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.236459
R Square 0.055913
Adjusted R-0.016709
Standard E 0.845536
Observatio 29

ANOVA
df SS MS F Significance F
Regression 2 1.100875 0.550438 0.769917 0.473322
Residual 26 18.5882 0.714931
Total 28 19.68908

Coefficients
Standard Error t Stat P-value Lower 95%Upper 95%Lower 95.0%
Upper 95.0%
Intercept 0.21513 0.923003 0.233076 0.817528 -1.682131 2.11239 -1.682131 2.11239
6 0.149082 0.121299 1.229045 0.230063 -0.100252 0.398416 -0.100252 0.398416
5 -0.003963 0.138331 -0.028651 0.977362 -0.288308 0.280381 -0.288308 0.280381

0,05
Dari nilai P value menunjukan bahwa nilai X1 sebesar 0,2300 > 0,05 sehingga nilai X
begitu juga dengan nilai X2 sebesar 0.9773 > 0,05 sehingga nilai X2 tidak signifikan
r 0,2300 > 0,05 sehingga nilai X1 tidak signifikan
hingga nilai X2 tidak signifikan
Kelas A Kelas B Kelas AB Y Pred e |e|
No
( X1 ) ( X2) (Y)
1 6 5 8 5.573705 2.426295 2.426
2 5 4 7 5.415024 1.584976 1.585
3 6 2 5 6.104949 -1.104949 1.105
4 7 4 6 6.086549 -0.086549 0.087
5 4 5 6 4.902181 1.097819 1.098
6 4 3 6 5.256343 0.743657 0.744
7 4 3 6 5.256343 0.743657 0.744
8 6 3 8 5.927867 2.072133 2.072
9 5 5 4 5.237943 -1.237943 1.238
10 5 6 5 5.060862 -0.060862 0.061
11 5 4 6 5.415024 0.584976 0.585
12 3 2 4 5.097662 -1.097662 1.098
13 8 4 3 6.422311 -3.422311 3.422
14 5 4 5 5.415024 -0.415024 0.415
15 6 4 6 5.750786 0.249214 0.249
16 7 4 8 6.086549 1.913451 1.913
17 7 5 4 5.909467 -1.909467 1.909
18 5 6 5 5.060862 -0.060862 0.061
19 4 5 4 4.902181 -0.902181 0.902
20 6 3 5 5.927867 -0.927867 0.928
21 8 4 6 6.422311 -0.422311 0.422
22 5 5 5 5.237943 -0.237943 0.238
23 5 5 5 5.237943 -0.237943 0.238
24 5 4 5 5.415024 -0.415024 0.415
25 5 3 4 5.592105 -1.592105 1.592
26 4 5 3 4.902181 -1.902181 1.902
27 6 5 8 5.573705 2.426295 2.426
28 7 3 8 6.26363 1.73637 1.736
29 5 2 6 5.769186 0.230814 0.231
30 8 2 7 6.776473 0.223527 0.224
Kelas A Kelas B Kelas AB Y Pred et e^2 et-1 (et-et-1) (et-et-1)^2
No
( X1 ) ( X2) (Y)
1 6 5 8 5.573705 2.426 5.887
2 5 4 7 5.415024 1.585 2.512 2.426 -0.841 0.708
3 6 2 5 6.104949 -1.105 1.221 1.585 -2.690 7.236
4 7 4 6 6.086549 -0.087 0.007 -1.105 1.018 1.037
5 4 5 6 4.902181 1.098 1.205 -0.087 1.184 1.403
6 4 3 6 5.256343 0.744 0.553 1.098 -0.354 0.125
7 4 3 6 5.256343 0.744 0.553 0.744 0.000 0.000
8 6 3 8 5.927867 2.072 4.294 0.744 1.328 1.765
9 5 5 4 5.237943 -1.238 1.533 2.072 -3.310 10.957
10 5 6 5 5.060862 -0.061 0.004 -1.238 1.177 1.386
11 5 4 6 5.415024 0.585 0.342 -0.061 0.646 0.417
12 3 2 4 5.097662 -1.098 1.205 0.585 -1.683 2.831
13 8 4 3 6.422311 -3.422 11.712 -1.098 -2.325 5.404
14 5 4 5 5.415024 -0.415 0.172 -3.422 3.007 9.044
15 6 4 6 5.750786 0.249 0.062 -0.415 0.664 0.441
16 7 4 8 6.086549 1.913 3.661 0.249 1.664 2.770
17 7 5 4 5.909467 -1.909 3.646 1.913 -3.823 14.615
18 5 6 5 5.060862 -0.061 0.004 -1.909 1.849 3.417
19 4 5 4 4.902181 -0.902 0.814 -0.061 -0.841 0.708
20 6 3 5 5.927867 -0.928 0.861 -0.902 -0.026 0.001
21 8 4 6 6.422311 -0.422 0.178 -0.928 0.506 0.256
22 5 5 5 5.237943 -0.238 0.057 -0.422 0.184 0.034
23 5 5 5 5.237943 -0.238 0.057 -0.238 0.000 0.000
24 5 4 5 5.415024 -0.415 0.172 -0.238 -0.177 0.031
25 5 3 4 5.592105 -1.592 2.535 -0.415 -1.177 1.386
26 4 5 3 4.902181 -1.902 3.618 -1.592 -0.310 0.096
27 6 5 8 5.573705 2.426 5.887 -1.902 4.328 18.736
28 7 3 8 6.26363 1.736 3.015 2.426 -0.690 0.476
29 5 2 6 5.769186 0.231 0.053 1.736 -1.506 2.267
30 8 2 7 6.776473 0.224 0.050 0.231 -0.007 0.000
Jumlah 55.870 Jumlah 87.544

DW 1.567
Nilai DW untuk K=2 Tabel Durbin
dL 1.2837 df=k,n
Du 1.5666 K=2
dL
dU
4-dL
4-dU
Karena nilai DW sebesar 1.56
gejala otokorelasi.
Tabel Durbin

n30
1.284
1.567
2.716
2.433
Karena nilai DW sebesar 1.567 > 1.284 maka di simpulkan bahwa data tidak terdapat
gejala otokorelasi.
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.340554
R Square 0.115977
Adjusted R 0.050494
Standard E 1.438495
Observatio 30

ANOVA
df SS MS F Significance F
Regression 2 7.329744 3.664872 1.771095 0.189347
Residual 27 55.87026 2.069269
Total 29 63.2

Coefficients
Standard Error t Stat P-value Lower 95%Upper 95%Lower 95.0%
Upper 95.0%
Intercept 4.444538 1.555683 2.856969 0.008134 1.25254 7.636535 1.25254 7.636535
X Variable 0.335762 0.205594 1.633129 0.114051 -0.086083 0.757607 -0.086083 0.757607
X Variable -0.177081 0.231644 -0.764454 0.451227 -0.652375 0.298213 -0.652375 0.298213

RESIDUAL OUTPUT

ObservationPredicted Y Residuals
1 5.573705 2.426295
2 5.415024 1.584976
3 6.104949 -1.104949
4 6.086549 -0.086549
5 4.902181 1.097819
6 5.256343 0.743657
7 5.256343 0.743657
8 5.927867 2.072133
9 5.237943 -1.237943
10 5.060862 -0.060862
11 5.415024 0.584976
12 5.097662 -1.097662
13 6.422311 -3.422311
14 5.415024 -0.415024
15 5.750786 0.249214
16 6.086549 1.913451
17 5.909467 -1.909467
18 5.060862 -0.060862
19 4.902181 -0.902181
20 5.927867 -0.927867
21 6.422311 -0.422311
22 5.237943 -0.237943
23 5.237943 -0.237943
24 5.415024 -0.415024
25 5.592105 -1.592105
26 4.902181 -1.902181
27 5.573705 2.426295
28 6.26363 1.73637
29 5.769186 0.230814
30 6.776473 0.223527
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.337737706246
R Square 0.11406675822
Adjusted R 0.048442073644
Standard E 0.267731816969
Observatio 30

ANOVA
df SS MS F Significance F
Regression 2 0.249184966 0.124592 1.738168 0.194946
Residual 27 1.935368797 0.07168
Total 29 2.184553763

Coefficients Standard Error t Stat P-value Lower 95%Upper 95%Lower 95.0%


Upper 95.0%
Intercept 1.27053401791 0.410131113 3.097873 0.004514 0.429014 2.112054 0.429014 2.112054
X Variable 0.345551992794 0.20782269 1.662725 0.107935 -0.080865 0.771969 -0.080865 0.771969
X Variable -0.12381333104 0.152053042 -0.814277 0.42261 -0.4358 0.188174 -0.4358 0.188174

RESIDUAL OUTPUT

Observation Predicted Y Residuals


1 1.690410204069 0.389031338
2 1.655036773178 0.290873376
3 1.803859211783 -0.194421299
4 1.771305425062 0.020454044
5 1.550300927954 0.241458541
6 1.613547950013 0.178211519
7 1.613547950013 0.178211519
8 1.753657226128 0.325784316
9 1.62740862679 -0.241114266
10 1.604834787523 0.004603125
11 1.655036773178 0.136722696
12 1.564340822241 -0.178046461
13 1.817447463884 -0.718835175
14 1.655036773178 -0.045598861
15 1.718038350457 0.073721119
16 1.771305425062 0.308136117
17 1.743677278674 -0.357382918
18 1.604834787523 0.004603125
19 1.550300927954 -0.164006567
20 1.753657226128 -0.144219314
21 1.817447463884 -0.025687995
22 1.62740862679 -0.017970714
23 1.62740862679 -0.017970714
24 1.655036773178 -0.045598861
25 1.690655648848 -0.304361288
26 1.550300927954 -0.451688639
27 1.690410204069 0.389031338
28 1.806924300732 0.272517241
29 1.740857634503 0.050901835
30 1.903268325209 0.042641824
Upper 95.0%
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.367911
R Square 0.135358
Adjusted R 0.035592
Standard E 1.449739
Observatio 30

ANOVA
df SS MS F Significance F
Regression 3 8.55464 2.851547 1.356752 0.27788
Residual 26 54.64536 2.101745
Total 29 63.2

Coefficients
Standard Error t Stat P-value Lower 95%Upper 95%Lower 95.0%
Upper 95.0%
Intercept 5.354928 1.969835 2.718465 0.011522 1.305874 9.403982 1.305874 9.403982
X Variable 0.278811 0.220222 1.266043 0.216724 -0.173862 0.731484 -0.173862 0.731484
X Variable -0.181413 0.233524 -0.776849 0.444259 -0.661427 0.298602 -0.661427 0.298602
X Variable -18.42532 24.13545 -0.763413 0.452089 -68.03645 31.18581 -68.03645 31.18581

>0,05 maka tidak signifikan


jika tidak signifikan maka tidak linier
Jadi Z1 sebesar 0.4520 > 0.05 yang berarti tidak signifikan, jika nilai tidak signifikan
fikan, jika nilai tidak signifikan maka di katakan tidak terjadi linier
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.367964
R Square 0.135397
Adjusted R 0.035636
Standard E 1.449707
Observatio 30

ANOVA
df SS MS F Significance F
Regression 3 8.557121 2.852374 1.357207 0.277743
Residual 26 54.64288 2.101649
Total 29 63.2

Coefficients
Standard Error t Stat P-value Lower 95%Upper 95%Lower 95.0%
Upper 95.0%
Intercept 5.138561 1.811846 2.836091 0.008728 1.414258 8.862864 1.414258 8.862864
X Variable 0.319395 0.208301 1.533335 0.137273 -0.108774 0.747563 -0.108774 0.747563
X Variable -0.185562 0.233713 -0.793974 0.434398 -0.665966 0.294842 -0.665966 0.294842
X Variable 3.333757 4.362396 0.764203 0.451626 -5.633276 12.30079 -5.633276 12.30079

Karena nilai Z2 sebesar 0.4516 > 0.05 maka di katakan Z2 tidak signifikan yang bera
n Z2 tidak signifikan yang berarti tidak linier
Kelas A Kelas B Kelas AB
( X1 ) ( X2) Z2 Z1 (Y) Y Pred LnX1
6 5 -0.152 0.028 8 5.574 1.792
5 4 -0.182 0.034 7 5.415 1.609
6 2 -0.032 0.005 5 6.105 1.792
7 4 -0.208 0.035 6 6.087 1.946
4 5 -0.189 0.039 6 4.902 1.386
4 3 -0.236 0.046 6 5.256 1.386
4 3 -0.236 0.046 6 5.256 1.386
6 3 -0.152 0.026 8 5.928 1.792
5 5 -0.147 0.029 4 5.238 1.609
5 6 -0.084 0.017 5 5.061 1.609
5 4 -0.182 0.034 6 5.415 1.609
3 2 -0.318 0.064 4 5.098 1.099
8 4 -0.266 0.042 3 6.422 2.079
5 4 -0.182 0.034 5 5.415 1.609
6 4 -0.177 0.031 6 5.751 1.792
7 4 -0.208 0.035 8 6.087 1.946
7 5 -0.191 0.033 4 5.909 1.946
5 6 -0.084 0.017 5 5.061 1.609
4 5 -0.189 0.039 4 4.902 1.386
6 3 -0.152 0.026 5 5.928 1.792
8 4 -0.266 0.042 6 6.422 2.079
5 5 -0.147 0.029 5 5.238 1.609
5 5 -0.147 0.029 5 5.238 1.609
5 4 -0.182 0.034 5 5.415 1.609
5 3 -0.169 0.031 4 5.592 1.609
4 5 -0.189 0.039 3 4.902 1.386
6 5 -0.152 0.028 8 5.574 1.792
7 3 -0.172 0.028 8 6.264 1.946
5 2 -0.067 0.012 6 5.769 1.609
8 2 -0.069 0.010 7 6.776 2.079
LnX2 LnY Pred_LnY LnPred_Y Z1 AlnPred_LnY Z2
1.609 2.079 1.690 1.718 0.028 5.422 -0.152
1.386 1.946 1.655 1.689 0.034 5.233 -0.182
0.693 1.609 1.804 1.809 0.005 6.073 -0.032
1.386 1.792 1.771 1.806 0.035 5.879 -0.208
1.609 1.792 1.550 1.590 0.039 4.713 -0.189
1.099 1.792 1.614 1.659 0.046 5.021 -0.236
1.099 1.792 1.614 1.659 0.046 5.021 -0.236
1.099 2.079 1.754 1.780 0.026 5.776 -0.152
1.609 1.386 1.627 1.656 0.029 5.091 -0.147
1.792 1.609 1.605 1.622 0.017 4.977 -0.084 Z1
1.386 1.792 1.655 1.689 0.034 5.233 -0.182 Z2
0.693 1.386 1.564 1.629 0.064 4.780 -0.318
1.386 1.099 1.817 1.860 0.042 6.156 -0.266
1.386 1.609 1.655 1.689 0.034 5.233 -0.182
1.386 1.792 1.718 1.749 0.031 5.574 -0.177
1.386 2.079 1.771 1.806 0.035 5.879 -0.208
1.609 1.386 1.744 1.777 0.033 5.718 -0.191
1.792 1.609 1.605 1.622 0.017 4.977 -0.084
1.609 1.386 1.550 1.590 0.039 4.713 -0.189
1.099 1.609 1.754 1.780 0.026 5.776 -0.152
1.386 1.792 1.817 1.860 0.042 6.156 -0.266
1.609 1.609 1.627 1.656 0.029 5.091 -0.147
1.609 1.609 1.627 1.656 0.029 5.091 -0.147
1.386 1.609 1.655 1.689 0.034 5.233 -0.182
1.099 1.386 1.691 1.721 0.031 5.423 -0.169
1.609 1.099 1.550 1.590 0.039 4.713 -0.189
1.609 2.079 1.690 1.718 0.028 5.422 -0.152
1.099 2.079 1.807 1.835 0.028 6.092 -0.172
0.693 1.792 1.741 1.753 0.012 5.702 -0.067
0.693 1.946 1.903 1.913 0.010 6.708 -0.069
Tidak Linier
Tidak Linier

You might also like