Uji AsumsiKlasik_desya(TugasEkonometrika)
Uji AsumsiKlasik_desya(TugasEkonometrika)
Uji AsumsiKlasik_desya(TugasEkonometrika)
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)|
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
RESIDUAL 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
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