Proiect Econometrie1.xlsx

Ani

Tări

Greutatea Pasagerii Transport

Belgium Bulgaria

237,852 27,235

821 1

372 1

Denmark Germany Estonia Ireland Greece Spain

92,244 303,742 43,578 47,483 168,501 427,672

41,353 30,780 13,654 2,755 66,533 23,486

30,366 21,636 11,353 2,753 32,744 14,229

France Croatia

298,203 18,603

26,638 23,523

24,892 10,134

Italy Cyprus Latvia Lithuania

443,141 7,186 71,836 41,105

72,225 76 862 280

35,933 3,653 61 2,842

3,460

9,669

306

Netherland 571,636 Poland 68,744 Portugal 80,156 Romania 43,753

1,819 2,224 551 1

11,020 2,753 10,246 11,135

Slovenia 18,012 Finland 105,537 Sweden 167,530 United Ki 503,171 European E 3,997,867

27 18,471 29,244 28,135 399,954

1,954 5,745 1,043 1,797 19,655

723 6,103 108 2,150 844 2 41,647 30,087 14,164 2,751 65,680 24,522 26,133 27,271 70,268 68 661 286 9,910 1,910

267 46 217 19,655 351 3 30,295 20,885 11,594 2,750 32,060 14,911 24,612 10,188 34,716 3,394 75 2,940 295 11,035

Malta

2014

Iceland Norway Montenegr Turkey Belgium Bulgaria Denmark Germany Estonia Ireland Greece Spain France Croatia Italy Cyprus Latvia Lithuania Malta Netherland

6,674 200,812 1,241 378,688 241,459 27,166 95,098 295,918 34,965 50,666 167,036 447,048 297,880 18,930 458,020 10,268 67,811 43,128 3,705 594,272

SUMMARY OUTPUT Regression Statistics Multiple R 0.967434 R Square 0.935928 Adjusted R 0.934326 Standard E 191439.8 Observatio 83 ANOVA df Regression Residual Total

2 80 82

Coefficients Intercept 86516.57 821 9.934362 372 -7.49305

RESIDUAL OUTPUT Observation Predicted 237852 1 86519.01 2 269798.2 3 230176.6 4 137091.7 5 93257.37 6 502127 7 213216.4 8 164631.1 9 244268 10 534778 11 59899.47 12 94622.91 13 68002.94 14 180279 15 22013.75 16 87982.22 17 15216.6 18 3091.38

2015

2016

Poland 69,530 Portugal 86,769 Romania 44,533 Slovenia 19,931 Finland 99,962 Sweden 169,685 United Ki 496,708 European E 4,041,230 Iceland 7,137 Norway 193,605 Montenegr 1,487 Turkey 411,783 Belgium 252,666 Bulgaria 28,685 Denmark 95,899

2,421 583 1 34 18,884 29,500 27,805 402,882 737 6,714 99 2,233 1,082 3 41,913

2,750 10,004 11,517 1,945 5,991 972 1,892 18,065 341 50 286 18,065 330 4 30,332

Germany 297,137 Estonia 33,596 Ireland 50,758 Greece 175,100 Spain 451,255 France 292,160 Croatia 18,551 Italy 461,990 Cyprus 10,259 Latvia 60,962 Lithuania 46,236 Malta 3,788 Netherland 588,772 Poland 72,926 Portugal 91,344 Romania 46,295 Slovenia 21,171 Finland 105,887 Sweden 171,324 United Ki 484,048 European E 4,068,398 Iceland 7,446 Norway 200,143 Montenegr 1,617 Turkey 425,853

30,849 14,333 2,717 65,248 26,323 24,514 29,661 67,273 59 723 303 10,690 1,906 2,602 679 50,300 28 19,222 29,800 26,887 403,627 544 6,266 110 1,250

20,636 11,953 2,712 31,806 18,852 22,161 10,132 35,175 3,536 82 2,755 438 11,303 2,712 9,549 60,345 1,973 6,139 952 1,875 16,742 217 42 170 16,742

84

84

84

19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63

72143.38 226966.6 369221.8 352554.8 3912528 91698.47 146801.3 85963.49 -39400.5 92271.11 86513.96 273250.9 228919.3 140352.4 93240.11 498778.2 218398.1 161712.3 281097.3 524455.5 61760.69 92521.2 67328.23 182755.6 22805.38 89961.77 17347.82 229.0343 72280.35 229226.2 372297 348564.6 3953530 91283.06 152841.2 85357.06 -26662 94792.84 86516.4 275616.2 238355.1 139341.3 93187.08 496389.8 206759.8

64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83

163994 305260.1 491262.8 60607.27 93084.68 68883.33 189432.9 20757.51 92044.62 21710.86 134046.8 72010.94 231475 375427.2 339572.3 3970844 90294.87 148450.6 86335.53 -26514.1

821 Residual Plot

Standard Error t Stat 28043.06 3.085133 0.29702 33.44673 1.856071 -4.03705

Residuals -59284 -177554 73565.44 -93513.7 -45774.4 -333626 214455.6 133571.9 -225665 -91637 -52713.5 -22786.9 -26897.9 -176819 549622.3 -19238.2 64939.4 40661.62

P-value Lower 95%Upper 95% Lower 95.0% Upper 95.0% 0.002794 30709.1 142324 30709.1 142324 8.69E-49 9.343272 10.52545 9.343272 10.52545 0.000123 -11.1867 -3.79935 -11.1867 -3.79935

1000000

0

-500000

SS MS F Significance F 4.28E+13 2.14E+13 584.2988 1.85E-48 2.93E+12 3.66E+10 4.58E+13

372 Residua

500000 Residuals

Residuals

1000000

0

500000 100,000 200,000 300,000 40 0 -500000

821 0 10,00020,000 30,000 372

-54131.4 -121430 -201692 150616.2 85338.72 -85024.5 54010.7 -84722.5 418088.5 149187.9 -59348 -178153 66998.67 -105387 -42574.1 -331742 228649.9 136167.7 -262167 -66435.5 -51492.7 -24710.2 -24200.2 -179051 571466.6 -20431.8 69421.18 44303.97 -52349.4 -129264 -202612 148143.4 87699.96 -84146.1 40763.78 -83870.1 438445 157873.2 -57831.4 -179717 58781.92 -105745 -42429.1 -321290 244495.2

128166 -286709 -29272.8 -50348.3 -32122.7 -22647.3 -185645 568014.5 -19118.6 69633.14 -87751.8 -50839.9 -125588 -204103 144475.7 97553.55 -82848.9 51692.43 -84718.5 452367.1

821 Residual Plot 372 Residual Plot 1000000 0

500000 100,000 200,000 300,000 400,000 500,000 0 -500000

82120,00030,00040,00050,00060,00070,000 0 10,000 372