econometrie

8
Anul Luna arfa livrata lunar y Consum combustibil x1` Pierderi materiale x2 noiembrie 131750 1523 124 decembrie 225245 2525 236 2000 ianuarie 76316 1114 124 februarie 104875 1369 147 martie 159366 1945 165 aprilie 160124 1865 167 mai 168745 1647 172 iunie 240814 2444 258 iulie 213702 2268 240 august 207965 2097 225 septembrie 181546 1952 182 octombrie 117786 1464 123 noiembrie 133079 1884 178 decembrie 226416 2927 245 2001 ianuarie 78116 1580 110 februarie 106994 1884 117 martie 161203 2355 185 aprilie 164045 2208 206 mai 170614 1999 217 iunie 243398 2630 260 iulie 214011 2325 233 august 208844 2545 206 septembrie 183939 2355 183 octombrie 118968 1884 165 SUMMARY OUTPUT Regression Statistics Multiple 0.9849119 R Square 0.9700515 Adjusted 0.9594815 Standard 10055.218 Observati 24 ANOVA df SS MS F Regressio 6 55673948349.1464 9278991391.5244 91.7736091448277 Residual 17 1718825870.81196 101107404.165409 Total 23 57392774219.9583 Coefficients Standard Error t Stat P-value Intercept -313557.9 277324.492258511 -1.1306533024375 0.273900799039708 X Variabl 63.994061 10.9873206078561 5.82435545153633 2.031108756688E-05 X Variabl 294.44334 140.369872649789 2.09762493486268 0.0511946102371875 X Variabl 233.12344 85.8842336757109 2.71439158361986 0.0147256583607409 X Variabl 107.08462 61.2568997920304 1.74812337272163 0.0984774147368975 X Variabl -119.8913 55.0806670150084 -2.17664884952759 0.0438918167530167 1999

description

laborator

Transcript of econometrie

Page 1: econometrie

Anul Luna Marfa livrata lunar y Consum combustibil x1` Pierderi materiale x2noiembrie 131750 1523 124decembrie 225245 2525 236

20

00

ianuarie 76316 1114 124februarie 104875 1369 147martie 159366 1945 165aprilie 160124 1865 167mai 168745 1647 172iunie 240814 2444 258iulie 213702 2268 240august 207965 2097 225septembrie 181546 1952 182octombrie 117786 1464 123noiembrie 133079 1884 178decembrie 226416 2927 245

20

01

ianuarie 78116 1580 110februarie 106994 1884 117martie 161203 2355 185aprilie 164045 2208 206mai 170614 1999 217iunie 243398 2630 260iulie 214011 2325 233august 208844 2545 206septembrie 183939 2355 183octombrie 118968 1884 165

SUMMARY OUTPUT

Regression StatisticsMultiple R 0.9849119R Square 0.9700515Adjusted R 0.9594815Standard E 10055.218Observatio 24

ANOVAdf SS MS F

Regression 6 55673948349.1464 9278991391.5244 91.7736091448277Residual 17 1718825870.81196 101107404.165409Total 23 57392774219.9583

Coefficients Standard Error t Stat P-valueIntercept -313557.85 277324.492258511 -1.1306533024375 0.273900799039708X Variable 63.994061 10.9873206078561 5.82435545153633 2.031108756688E-05X Variable 294.44334 140.369872649789 2.09762493486268 0.0511946102371875X Variable 233.12344 85.8842336757109 2.71439158361986 0.0147256583607409X Variable 107.08462 61.2568997920304 1.74812337272163 0.0984774147368975X Variable -119.89127 55.0806670150084 -2.17664884952759 0.0438918167530167

19

99

Page 2: econometrie

X Variable 807.23072 530.357926604489 1.5220489314125 0.146380246896553

RESIDUAL OUTPUT

ObservationPredicted Y Residuals1 127023.85 4726.146599985912 222930.4 2314.60040405483 75843.974 472.0256835232294 100790.91 4084.088569422445 163729.7 -4363.699620083796 169167.74 -9043.739125462727 165201.65 3543.354468182438 239954.11 859.8867238226239 226012.3 -12310.3014020878

10 210229.91 -2264.9077932833511 170045.22 11500.782312042912 95987.348 21798.652391534513 143163.1 -10084.097364913614 225485.93 930.0656074165615 95619.561 -17503.561496125916 106531.94 462.05884415590817 168504 -7301.0043872955418 166355.43 -2310.4313024696319 175901.61 -5287.6130545847720 233887.06 9510.9421859033821 209758.15 4252.8539916327322 207904.95 939.05352497697523 171969.36 11969.642804988724 125862.8 -6894.798565337

Anul Luna Marfa livrata lunar y Consum combustibil x1` Retur marfa x3noiembrie 131750 1523 1510decembrie 225245 2525 1532

20

00

ianuarie 76316 1114 1480februarie 104875 1369 1500martie 159366 1945 1580aprilie 160124 1865 1600mai 168745 1647 1630iunie 240814 2444 1650iulie 213702 2268 1640august 207965 2097 1635septembrie 181546 1952 1580octombrie 117786 1464 1490noiembrie 133079 1884 1510decembrie 226416 2927 1536

20

01

ianuarie 78116 1580 1485

19

99

Page 3: econometrie

20

01

februarie 106994 1884 1487martie 161203 2355 1530aprilie 164045 2208 1550mai 170614 1999 1620iunie 243398 2630 1640iulie 214011 2325 1638august 208844 2545 1636septembrie 183939 2355 1580octombrie 118968 1884 1550

SUMMARY OUTPUT

Regression StatisticsMultiple R 0.9970623R Square 0.9941333Adjusted R 0.9459555Standard E 14215.507Observatio 24

ANOVAdf SS MS F

Regression 3 719102938060.915 239700979353.638 1186.16497846206Residual 21 4243693464.08536 202080641.146922Total 24 723346631525

Coefficients Standard Error t Stat P-valueIntercept 0 #N/A #N/A #N/AX Variable 98.55437 7.32833477074168 13.4483990506037 8.662348530704E-12X Variable 233.21459 34.4258166369579 6.7744099400083 1.061768766767E-06X Variable -201.94696 27.3402761032583 -7.38642734789136 2.88828604874E-07

RESIDUAL OUTPUT

ObservationPredicted Y Residuals1 121178.42 10571.57573455112 209308.76 15936.2386656783 62766.166 13549.83402074034 89330.671 15544.32909689845 173842.77 -14476.76913147546 177892.8 -17768.80206186197 163606.33 5138.665883870628 236923.06 3890.942000238289 222495.96 -8793.96391067753

10 208112.14 -147.13894068758211 176148.23 5397.7745710471612 105852.7 11933.302589537113 129695.66 3383.34108624543

Page 4: econometrie

14 218558.7 7857.3026796599715 111878.05 -33762.045176411616 123523.94 -16529.935389701317 178961.54 -17758.536579995718 165099.4 -1054.396761319619 159412.93 11201.073779184520 223639.72 19758.284705639621 204827.13 9183.8729980830122 219782.3 -10938.303438868723 186583.33 -2644.327038751124 129330.79 -10362.7884613027

Page 5: econometrie

Retur marfa x3 Capacitate incarcare x4Fond salariix5IPC x61510 530 1887 153.71532 550 1965 154.81480 400 1942 156.81500 400 1958 155.71580 420 1913 149.01600 430 1877 148.91630 480 1876 144.01650 500 1925 140.91640 490 1899 144.51635 470 1881 145.41580 450 1905 144.91490 430 1911 142.91510 560 2021 141.31536 580 2120 140.71485 450 1932 139.91487 450 2025 140.01530 470 2030 140.31550 480 2050 137.51620 520 2057 137.41640 550 2070 135.71638 550 2012 131.81636 510 2043 132.41580 490 2050 131.21550 480 2069 130.8

Significance F5.29028428E-12

t teo 2.109816

Lower 95% Upper 95% Lower 95.0%Upper 95.0%-898661.3815647 271545.675526927 -898661.382 ###40.81284071444 87.1752806458448 40.81284071 87.18

-1.711196300499 590.597886247892 -1.7111963 590.651.92354860817 414.323333501814 51.92354861 414.3

-22.15614198546 236.325378519292 -22.156142 236.3-236.1013187354 -3.68122224350378 -236.101319 -3.681

Page 6: econometrie

-311.7266897186 1926.18812062761 -311.72669 1926

Fond salariix5188719651942195819131877187619251899188119051911202121201932

Page 7: econometrie

202520302050205720702012204320502069

Significance F1.09750802E-22

t teo 2.085963Lower 95% Upper 95% Lower 95.0%Upper 95.0% t fisher 3.098391

#N/A #N/A #N/A #N/A t chow 3.00691783.31426398134 113.794476765357 83.31426398 113.8161.6221897872 304.806999049401 161.6221898 304.8-258.804179602 -145.089746614009 -258.80418 -145