Europe

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

SUMMARY OUTPUT

Regression Statistics
Multiple R 0.731106465328015
R Square 0.534516663644424
Adjusted R Square 0.452372545464028
Standard Error 58.4262570358971 sai số chuẩn 116.85251
Observations 21

ANOVA
df SS MS F Significance F
Regression 3 66638.03186313 22212.677 6.5070595 0.003940222
Residual 17 58031.66769082 3413.6275
Total 20 124669.699554

Coefficients Standard Error t Stat P-value Lower 95%


Intercept -114.835150264663 78.28996449028 -1.466793 0.1606877 -280.0125369
GNP per head 0.00229771185295111 0.00095192961 2.4137413 0.0273548 0.000289316
Unemployment rate 4.21952457323109 4.84000589643 0.8718015 0.3954627 -5.991995264
%age spend on education 21.4226983037986 12.73611957498 1.6820428 0.1108365 -5.448165177
phương trình hồi quy= -114,83 + 0.002*GNP per head+4,219*Unemployment rate+ 21,42*%ag

RESIDUAL OUTPUT

Observation Predicted
Residuals Sales/Capita
= Predicted Sales/Capita - Computer Sales (ở bảng data)
1 141.105011011314 -29.0573919637
2 153.936169926388 6.244782454565
3 32.1578881740811 -11.8947302793
4 54.767288455875 46.0856527206
5 229.790903573369 -59.7181763006
6 179.819714617707 192.0670778351 Finland bỏ đi (quan sát ngoại lai lớn hơn 2 lần
7 151.740630374153 -55.9587240737
8 124.24022741289 -41.5214395341
9 83.2552007781005 -10.6659150638
10 60.6308801232729 -15.7308801233
11 142.785115882451 -11.6714795188
12 119.958849005467 -54.4546045233
13 132.531069108837 -1.10682668459
14 97.7164232545092 -22.7953706229
15 90.8053302087436 -22.7118722648
16 6.76514638293487 25.49776441519
17 120.26738267287 -14.3343469586
18 168.363823385881 -17.6438233859
19 193.926492416372 35.79089888798
20 23.5560006075128 14.4255297355
21 112.931370653125 49.15387524851
Upper 95% Lower 95.0% Upper 95.0%
50.342236 -280.01253693 50.34223640494
0.0043061 0.00028931593 0.004306107773
14.431044 -5.9919952639 14.43104441032
48.293562 -5.4481651767 48.29356178425
oyment rate+ 21,42*%age spend on education

át ngoại lai lớn hơn 2 lần sai số chuẩn)


Computer
Country Pop (millions) Sales
1 Austria 8.4 941.2
2 Belgium 10.5 1681.9
3 Bulgaria 7.6 154
4 Czech Rep. 10.2 1028.7
5 Denmark 5.5 935.4
6 Finland 5.3 1971
7 France 61.9 5928.9
8 Germany 82.5 6824.3
9 Greece 11.2 813
10 Hungary 10 449
11 Ireland 4.4 576.9
12 Italy 58.9 3858.2
13 Netherlands 16.5 2168.5
14 Poland 38 2847
15 Portugal 10.7 728.6
16 Romania 21.3 687.2
17 Spain 44.8 4745.8
18 Switzerland 7.5 1130.4
19 Sweden 9.2 2113.4
20 Turkey 75.8 2879
21 UK 61 9887.2
Source Economist Pocket World in Figures 2011
GNP per Unemployment %age spend on
Sales/Capita head rate education
$112.05 $49,600 4.2 5.8
$160.18 $47,090 8.1 5.9
$20.26 $6,550 13.5 3.5
$100.85 $20,670 6.6 4.4
$170.07 $62,120 5.2 8.4
$371.89 $51,320 9.9 6.3
$95.78 $44,510 10 5.7
$82.72 $44,450 9.1 4.6
$72.59 $31,670 9.9 3.9
$44.90 $15,410 7.3 5.1
$131.11 $60,460 6.3 4.3
$65.50 $38,490 9.3 5
$131.42 $52,960 4.4 5
$74.92 $13,850 14.4 5.6
$68.09 $22,920 6.3 5.9
$32.26 $9,300 7 3.3
$105.93 $35,220 14.2 4.4
$150.72 $64,430 3.6 5.6
$229.72 $51,950 6.3 7.6
$37.98 $9,940 8.6 3.7
$162.09 $43,540 5.9 4.8
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.860805636504695
R Square 0.740986343838254
Adjusted R Square 0.692421283307926
Standard Error 29.9835812953123 sai ssó chuẩn nhỏ đi thì sịuw phù hợp của mô hình tăng lên
Observations 20

ANOVA
df SS MS F Significance F
Regression 3 41150.44477078 13716.81 15.2576 5.93265E-05
Residual 16 14384.24235668 899.0151
Total 19 55534.68712746

Coefficients Standard Error t Stat P-value Lower 95%


Intercept -32.2087611352601 41.89082135252 -0.768874 0.453169 -121.01333531
GNP per head 0.00167841641197646 0.000496537103 3.380244 0.003816 0.00062580478
Unemployment rate -0.527867145804316 2.575579640676 -0.204951 0.840195 -5.9878520746
%age spend on education 15.2276446070204 6.596202921354 2.308547 0.034658 1.2443190793

RESIDUAL OUTPUT

Observation Predicted Sales/Capita Residuals


1 137.143989607112 -25.0963705595
2 132.395247005117 27.78570537584
3 24.9554160193988 -4.69225812466
4 66.0018192088745 34.8511219676
5 197.221771917506 -27.1490446448
6 124.016456163785 -28.2345498633
7 107.640422542568 -24.9216346638
8 75.108615855951 -2.51933014167
9 67.4631931047295 -22.5631931047
10 131.421603924457 -0.30796756082
11 103.622545140835 -38.1183006587
12 130.495779636576 0.928462787667
13 68.7108290703458 6.210223561233
14 92.7780831900934 -24.6846252462
15 29.956668678658 2.306242119464
16 86.4109876950191 19.52204801927
17 159.306096362802 -8.5860963628
18 167.389507461704 62.32788384264
19 36.2773255918442 1.704204751164
20 110.847767395647 51.23747850599
ô hình tăng lên

Upper 95% Lower 95.0% Upper 95.0%


56.595813 -121.01333531 56.595813039
0.00273103 0.0006258048 0.002731028
4.93211778 -5.9878520746 4.932117783
29.2109701 1.2443190793 29.210970135
Computer
Country Pop (millions) Sales
1 Austria 8.4 941.2
2 Belgium 10.5 1681.9
3 Bulgaria 7.6 154
4 Czech Rep. 10.2 1028.7
5 Denmark 5.5 935.4
7 France 61.9 5928.9
8 Germany 82.5 6824.3
9 Greece 11.2 813
10 Hungary 10 449
11 Ireland 4.4 576.9
12 Italy 58.9 3858.2
13 Netherlands 16.5 2168.5
14 Poland 38 2847
15 Portugal 10.7 728.6
16 Romania 21.3 687.2
17 Spain 44.8 4745.8
18 Switzerland 7.5 1130.4
19 Sweden 9.2 2113.4
20 Turkey 75.8 2879
21 UK 61 9887.2
2007 Source Economist Pocket world in Figures
GNP per Unemployment %age spend on
Sales/Capita head rate education
$112.05 49600 4.2 5.8
$160.18 47090 8.1 5.9
$20.26 6550 13.5 3.5
$100.85 20670 6.6 4.4
$170.07 62120 5.2 8.4
$95.78 44510 10 5.7
$82.72 44450 9.1 4.6
$72.59 31670 9.9 3.9
$44.90 15410 7.3 5.1
$131.11 60460 6.3 4.3
$65.50 38490 9.3 5
$131.42 52960 4.4 5
$74.92 13850 14.4 5.6
$68.09 22920 6.3 5.9
$32.26 9300 7 3.3
$105.93 35220 14.2 4.4
$150.72 64430 3.6 5.6
$229.72 51950 6.3 7.6
$37.98 9940 8.6 3.7
$162.09 43540 5.9 4.8
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.860410573329042
R Square 0.740306354696411
Adjusted R Square 0.709754161131283
Standard Error 29.1265043448139
Observations 20

ANOVA
df SS MS F Significance F
Regression 2 41112.681787 20556.34 24.23087 1.054196E-05
Residual 17 14422.005341 848.3533
Total 19 55534.687127

Coefficients Standard Error t Stat P-value Lower 95%


Intercept -38.4802612075854 27.79129164 -1.384616 0.184076 -97.11476124
GNP per head 0.00172316828236258 0.0004332016 3.977751 0.000973 0.0008091927
%age spend on education 15.3097398354649 6.3958258117 2.393708 0.028487 1.8157269048

RESIDUAL OUTPUT

Observation Predicted Sales/Capita Residuals abs resid


1 135.785376643295 -23.7377576 23.73776
2 132.991198238111 27.189754143 27.18975
3 26.3905804660167 -6.127422571 6.127423
4 64.5004824648947 36.352458712 36.35246
5 197.164767110683 -27.09203984 27.09204
6 125.483476102523 -29.7015698 29.70157
7 108.53937218657 -25.82058431 25.82058
8 75.8004636531507 -3.211177939 3.211178
9 66.153435184493 -21.25343518 21.25344
10 131.534374436555 -0.420738073 0.420738
11 104.393185157875 -38.88894068 38.88894
12 129.327430203661 2.0968122206 2.096812
13 71.1201625817398 3.8008900498 3.80089
14 91.3422208534079 -23.24876291 23.24876
15 28.0673452754208 4.1955655227 4.195566
16 89.5725809732703 16.360454741 16.36045
17 158.278014303639 -7.558014304 7.558014
18 167.392353810684 62.325037494 62.32504
19 35.2940689103188 2.6874614327 2.687461
20 110.033237016713 52.052008885 52.05201
Upper 95%Lower 95.0%
Upper 95.0%
20.1542388 -97.11476 20.15424
0.00263714 0.000809 0.002637
28.8037528 1.815727 28.80375

skewness 0.831785
kurtosis 0.179802

SUMMARY OUTPUT

Regression Statistics
Multiple R 0.403163
R Square 0.16254 p-value>.05 so no significant heteroscedacity
Adjusted R 0.116014
Standard E 16.49376
Observatio 20

ANOVA
df SS MS F Significance F
Regression 1 950.4042 950.4042 3.493565 0.077968
Residual 18 4896.796 272.0442
Total 19 5847.2

Coefficients
Standard Error t Stat P-value Lower 95%Upper 95%Lower 95.0%
Intercept 5.127997 9.114044 0.562648 0.580615 -14.0199 24.27589 -14.0199
Predicted S 0.152043 0.081345 1.869108 0.077968 -0.018857 0.322943 -0.018857
Upper 95.0%
24.27589
0.322943
Computer
Country Pop (millions) Sales
1 Austria 8.4 941.2
2 Belgium 10.5 1681.9
3 Bulgaria 7.6 154
4 Czech Rep. 10.2 1028.7
5 Denmark 5.5 935.4
7 France 61.9 5928.9
8 Germany 82.5 6824.3
9 Greece 11.2 813
10 Hungary 10 449
11 Ireland 4.4 576.9
12 Italy 58.9 3858.2
13 Netherlands 16.5 2168.5
14 Poland 38 2847
15 Portugal 10.7 728.6
16 Romania 21.3 687.2
17 Spain 44.8 4745.8
18 Switzerland 7.5 1130.4
19 Sweden 9.2 2113.4
20 Turkey 75.8 2879
21 UK 61 9887.2
2007 Source Economist Pocket world in Figures
GNP per %age spend on
Sales/Capita head education
$112.05 49600 5.8
$160.18 47090 5.9
$20.26 6550 3.5
$100.85 20670 4.4
$170.07 62120 8.4
$95.78 44510 5.7
$82.72 44450 4.6
$72.59 31670 3.9
$44.90 15410 5.1
$131.11 60460 4.3
$65.50 38490 5
$131.42 52960 5
$74.92 13850 5.6
$68.09 22920 5.9
$32.26 9300 3.3
$105.93 35220 4.4
$150.72 64430 5.6
$229.72 51950 7.6
$37.98 9940 3.7
$162.09 43540 4.8

You might also like