ECONOMETRIA

Télécharger au format xlsx, pdf ou txt
Télécharger au format xlsx, pdf ou txt
Vous êtes sur la page 1sur 4

obs Y X Y*X X^2 x y y^2

1 2.5 1 2.5 1 -4.5 -2.55 6.5025


2 3.5 2 7 4 -3.5 -1.55 2.4025
3 3.2 3 9.6 9 -2.5 -1.85 3.4225
4 5 4 20 16 -1.5 -0.05 0.0025
5 4.8 5 24 25 -0.5 -0.25 0.0625
6 6.2 6 37.2 36 0.5 1.15 1.3225
7 6 7 42 49 1.5 0.95 0.9025
8 5.5 8 44 64 2.5 0.45 0.2025
9 6.3 9 56.7 81 3.5 1.25 1.5625
10 7.5 10 75 100 4.5 2.45 6.0025
SUMA 50.5 55 318 385 0 0 22.385
PROMEDIO 5.05 5.5
RXY 0.9366

β1 2.3667 Sigma2 0.2851 Sigma 0.534


β2 0.4879 Var(β1) 0.1331 Cov(β1, β2) #VALUE!
Var(β2) 0.0035 R^2 0.8772
se(β1) 0.3648 IC(β1)
se(β2) 0.0588 IC(β2)

obs Y X X^2 log(X) log^2(X) Y*log(X)


2006 2.5 1 1 0 0 0
2007 3.5 2 4 0.3010 0.0906 0.0906
2008 3.2 3 9 0.4771 0.2276 0.2276
2009 5 4 16 0.6021 0.3625 0.3625
2010 4.8 5 25 0.6990 0.4886 0.4886
2011 6.2 6 36 0.7782 0.6055 0.6055
2012 6 7 49 0.8451 0.7142 0.7142
2013 5.5 8 64 0.9031 0.8156 0.8156
2014 6.3 9 81 0.9542 0.9106 0.9106
2015 7.5 10 100 1 1 1
SUMA 50.5 55 385 6.5598 5.2152 5.2152

obs Y X y^2 x^2 x*y Y^ STC


2006 2.5 1 6.5025 20.25 11.475 2.8545 4.8200
2007 3.5 2 2.4025 12.25 5.425 3.3424 2.9158
2008 3.2 3 3.4225 6.25 4.625 3.8303 1.4877
2009 5 4 0.0025 2.25 0.075 4.3182 0.5356
2010 4.8 5 0.0625 0.25 0.125 4.8061 0.0595
2011 6.2 6 1.3225 0.25 0.575 5.2939 0.0595
2012 6 7 0.9025 2.25 1.425 5.7818 0.5356
2013 5.5 8 0.2025 6.25 1.125 6.2697 1.4877
2014 6.3 9 1.5625 12.25 4.375 6.7576 2.9158
2015 7.5 10 6.0025 20.25 11.025 7.2455 4.8200
SUMA 50.5 55 22.385 82.5 40.25 50.5 19.6371
PROMEDIO 5.05 5.5
RXY 0.0000

β1 2.3667
β2 0.4879
x^2 x*y Y^ ui STC SEC SRC
20.25 11.475 2.85454545 -0.3545 6.5025 4.82002066 0.12570248
12.25 5.425 3.34242424 0.1576 2.4025 2.91581497 0.02483012
6.25 4.625 3.83030303 -0.6303 3.4225 1.4876607 0.39728191
2.25 0.075 4.31818182 0.6818 0.0025 0.53555785 0.46487603
0.25 0.125 4.80606061 -0.0061 0.0625 0.05950643 3.67309E-05
0.25 0.575 5.29393939 0.9061 1.3225 0.05950643 0.82094582
2.25 1.425 5.78181818 0.2182 0.9025 0.53555785 0.04760331
6.25 1.125 6.26969697 -0.7697 0.2025 1.4876607 0.12570248
12.25 4.375 6.75757576 -0.4576 1.5625 2.91581497 0.20937557
20.25 11.025 7.24545455 0.2545 6.0025 4.82002066 0.06479339
82.5 40.25 50.5 0 22.385 19.6371212 2.28114784

SRC
0.1257
0.0248
0.3973
0.4649
0.0000
0.8209
0.0476
0.5924
0.2094
0.0648
2.7479

Vous aimerez peut-être aussi