DATOS HIPOTETICOS DE Y, X2 y X3Y X2 X31 2 42 0 23 4 124 6 05 8 16

DATOS HIPOTETICOS DE Y, X2 y X3Y X2 X31 2 42 0 23 4 04 6 125 8 16

y X2 X370 80 81065 100 100990 120 127395 140 1425

110 160 1633115 180 1876120 200 2052140 220 2201 Resumen155 240 2435 Estadísticas de la regresión150 260 2686 Coeficiente de correlación múltiple 0.98158

Coeficiente de determinación R^2 0.96350R^2 ajustado 0.95308Error típico 6.80804Observaciones 10ANÁLISIS DE VARIANZA

Regresión 2 8565.55407 4282.77704Residuos 7 324.44593 46.34942Total 9 8890

Coeficientes Error típico Estadístico tIntercepción 24.77473 6.75250 3.66897Variable X 1 0.94154 0.82290 1.14417Variable X 2 -0.04243 0.08066 -0.52606

Datos hipoteticos sobre consumo, ingreso y riqueza

Grados de libertad

Suma de cuadrados

Promedio de los cuadrados

F Valor crítico de F92.40196 0.00001

Probabilidad Inferior 95% Superior 95% Inferior 95.0% Superior 95.0%0.00798 8.80761 40.74186 8.80761 40.741860.29016 -1.00431 2.88738 -1.00431 2.887380.61509 -0.23318 0.14831 -0.23318 0.14831

Año IPC LnIPC PBI LnPBI Ln(PBI/IPC) M LnM Ln(M/IPC)1975 53.8 4.0 1638.3 7.4 3.4 98185.0 11.5 7.509335271976 56.9 4.0 1825.3 7.5 3.5 124228.0 11.7 7.688578521977 60.6 4.1 2030.9 7.6 3.5 151907.0 11.9 7.826728881978 65.2 4.2 2294.7 7.7 3.6 176002.0 12.1 7.900791171979 72.6 4.3 2563.3 7.8 3.6 212007.0 12.3 7.979409651980 82.4 4.4 2789.5 7.9 3.5 249750.0 12.4 8.016630261981 90.9 4.5 3128.4 8.0 3.5 265067.0 12.5 7.97797791982 96.5 4.6 3225.0 8.1 3.5 247642.0 12.4 7.850196431983 99.6 4.6 3536.7 8.2 3.6 268901.0 12.5 7.90093641984 103.9 4.6 3933.2 8.3 3.6 332418.0 12.7 8.070719591985 107.6 4.7 4220.3 8.3 3.7 338088.0 12.7 8.052640851986 109.6 4.7 4462.8 8.4 3.7 368425.0 12.8 8.120155071987 113.6 4.7 4739.5 8.5 3.7 409765.0 12.9 8.19065561988 118.3 4.8 5103.8 8.5 3.8 447189.0 13.0 8.237512831989 124.0 4.8 5484.4 8.6 3.8 477665.0 13.1 8.256383361990 130.7 4.9 5803.1 8.7 3.8 498438.0 13.1 8.246329871991 136.2 4.9 5995.9 8.7 3.8 491020.0 13.1 8.190115751992 140.3 4.9 6337.7 8.8 3.8 536528.0 13.2 8.249091041993 144.5 5.0 6657.4 8.8 3.8 589394.0 13.3 8.313570661994 148.2 5.0 7072.2 8.9 3.9 668690.0 13.4 8.414513141995 152.4 5.0 7397.7 8.9 3.9 749374.0 13.5 8.500484831996 156.9 5.1 7816.9 9.0 3.9 803113.0 13.6 8.540642051997 160.5 5.1 8304.3 9.0 3.9 876470.0 13.7 8.605363811998 163.0 5.1 8747.0 9.1 4.0 917103.0 13.7 8.635224871999 166.6 5.1 9268.4 9.1 4.0 1029980.0 13.8 8.729454212000 172.2 5.1 9817.0 9.2 4.0 1224408.0 14.0 8.869311432001 177.1 5.2 10128.0 9.2 4.0 1145900.0 14.0 8.774986372002 179.9 5.2 10469.6 9.3 4.1 1164720.0 14.0 8.775590132003 184.0 5.2 10960.8 9.3 4.1 1260717.0 14.0 8.832255412004 188.9 5.2 11712.5 9.4 4.1 1472926.0 14.2 8.961543682005 195.3 5.3 12455.8 9.4 4.2 1677371.0 14.3 9.05820141

19751977

19791981

19831985

19871989

19911993

19951997

19992001

20032005

2

4

6

8

10

12

14

16

LnPBI LnIPC LnM

19751977

19791981

19831985

19871989

19911993

19951997

19992001

20032005

0

200000

400000

600000

800000

1000000

1200000

1400000

1600000

1800000M

19751977

19791981

19831985

19871989

19911993

19951997

19992001

20032005

2

4

6

8

10

12

14

16

LnPBI LnIPC LnM

19751977

19791981

19831985

19871989

19911993

19951997

19992001

20032005

0

2000

4000

6000

8000

10000

12000

14000PBI

19751977

19791981

19831985

19871989

19911993

19951997

19992001

20032005

0

50

100

150

200

250IPC

19751977

19791981

19831985

19871989

19911993

19951997

19992001

20032005

0

2000

4000

6000

8000

10000

12000

14000PBI

19751977

19791981

19831985

19871989

19911993

19951997

19992001

20032005

0

50

100

150

200

250IPC

A;o IPC PBI M1970 38.8 1039.7 39,8661971 40.5 1128.6 45,5791972 41.8 1240.4 55,7971973 44.4 1385.5 70,4991974 49.3 1501 103,8111975 53.8 1635.2 98,1851976 56.9 1823.9 124,2281977 60.6 2031.4 151,9071978 65.2 2295.9 176,0021979 72.6 2566.4 212,0071980 82.4 2795 249,7501981 90.9 3131.3 265,0671982 96.5 3259.2 247,6421983 99.6 3534.9 268,9011984 103.9 3932.7 332,4181985 107.6 4213 338,0881986 109.6 4452.9 368,4251987 113.6 4742.5 409,7651988 118.3 5108.3 447,1891989 124 5489.1 477,3651990 130.7 5803.2 498,3371991 136.2 5986.2 490,9811992 140.3 6318.9 536,4581993 144.5 6642.3 589,4411994 148.2 7054.3 668,5901995 152.4 7400.5 749,5741996 156.9 7813.2 803,3271997 160.5 8300.8 876,3661998 163 8759.9 917,178

LnCt= B1 + B2LnYdt +B3LnWt + B4It +ut

Resumen

Estadísticas de la regresiónCoeficiente de correlación múltiple 0.999779804244809Coeficiente de determinación R^2 0.999559656975788 90%R^2 ajustado 0.999533236394335Error típico 0.0119337581808344Observaciones 54

ANÁLISIS DE VARIANZAGrados de libertad Suma de cuadrados

Regresión 3 16.1637479445253Residuos 50 0.00712072921593154Total 53 16.1708686737412

Coeficientes Error típicoIntercepción -0.467711074101168 0.0427780344408678Variable X 1 0.804872934923197 0.0174978568535024Variable X 2 0.201269964626241 0.0175925951541514Variable X 3 -0.002689055382212 0.000761929809597902

Promedio de los cuadrados F Valor crítico de F5.38791598150843 37832.61389475 7.1209832748E-84

0.000142414584318631

Estadístico t Probabilidad Inferior 95% Superior 95%-10.933440028613 7.33116767E-15 -0.5536332849751 -0.38178886322720345.9983723527885 1.37625134E-42 0.7697274550979 0.84001841474853411.4406068497942 1.43363887E-15 0.1659341973239 0.236605731928612

-3.52926916408643 0.000904672121 -0.0042194364441 -0.001158674320363

Inferior 95.0% Superior 95.0%-0.55363328497513 -0.38178886322720.76972745509786 0.84001841474853

0.165934197323871 0.23660573192861-0.00421943644406 -0.00115867432036

Año C Yd W I LnC LnYd1947 976.4 1035.2 5166.815 -10.35094 6.88387234 6.9423499241948 998.1 1090.0 5280.757 -4.719804 6.90585347 6.9939329751949 1025.3 1095.6 5607.351 1.044063 6.93274053 6.9990574371950 1090.9 1192.7 5759.515 0.407346 6.99475832 7.0839749241951 1107.1 1227.0 6086.056 -5.283152 7.00949926 7.1123274451952 1142.4 1266.8 6243.864 -0.277011 7.04088659 7.1442493151953 1197.2 1327.5 6355.613 0.561137 7.08774078 7.1910527531954 1221.9 1344.0 6797.027 -0.138476 7.1081623 7.2034055211955 1310.4 1433.8 7172.242 0.261997 7.17808771 7.2680835411956 1348.8 1502.3 7375.180 -0.736124 7.20697059 7.3147525461957 1381.8 1539.5 7315.286 -0.260683 7.23114228 7.3392129671958 1393.0 1553.7 7869.975 -0.57463 7.23921497 7.3483944621959 1470.7 1623.8 8188.054 2.295943 7.29349376 7.392524361960 1510.8 1664.8 8351.757 1.511181 7.32039459 7.4174602751961 1541.2 1720.0 8971.872 1.296432 7.34031661 7.450079571962 1617.3 1803.5 9091.545 1.395922 7.38851337 7.49748451963 1684.0 1871.5 9436.097 2.057616 7.42892719 7.5344955271964 1784.8 2006.9 10003.400 2.026599 7.48706164 7.6043465221965 1897.6 2131.0 10562.810 2.111669 7.54834521 7.6643466321966 2006.1 2244.6 10522.040 2.020251 7.60394782 7.7162826111967 2066.2 2340.5 11312.070 1.212616 7.63346645 7.7581198611968 2184.2 2448.2 12145.410 1.054986 7.68900491 7.803108341969 2264.8 2524.3 11672.250 1.732154 7.72524173 7.8337190761970 2317.5 2630.0 11650.040 1.166228 7.7482443 7.8747391251971 2405.2 2745.3 12312.920 -0.712241 7.78538834 7.9176456381972 2550.5 2874.3 13499.920 -0.155737 7.8440447 7.9635644451973 2675.9 3072.3 13080.960 1.413839 7.89204105 8.0301817461974 2653.7 3051.9 11868.790 -1.042571 7.88371017 8.0235196261975 2710.9 3108.5 12634.360 -3.533585 7.90503596 8.0418955741976 2868.9 3243.5 13456.780 -0.656766 7.96168396 8.0844082731977 2992.1 3360.7 13786.310 -1.190427 8.00373076 8.1199045651978 3124.7 3527.5 14450.500 0.113048 8.04709356 8.1683446841979 3203.2 3628.6 15340.000 1.70421 8.07190559 8.1966021781980 3193.0 3658.0 15964.950 2.298496 8.06871619 8.2046718291981 3236.0 3741.1 15964.990 4.703847 8.08209328 8.2271349651982 3275.5 3791.7 16312.510 4.449027 8.09422581 8.2405697461983 3454.3 3906.9 16944.850 4.690972 8.14737511 8.27049951984 3640.6 4207.6 17526.750 5.848332 8.19990378 8.3446476931985 3820.9 4347.8 19068.350 4.330504 8.24824128 8.3774252491986 3981.2 4486.6 20530.040 3.768031 8.28933856 8.4088504561987 4113.4 4582.5 21235.690 2.819469 8.32200522 8.429999981988 4279.5 4784.1 22331.990 3.287061 8.36159146 8.4730531981989 4393.7 4906.5 23659.800 4.317956 8.38792698 8.4983161361990 4474.5 5014.2 23105.130 3.595025 8.40614989 8.5200291661991 4466.6 5033.0 24050.210 1.802757 8.40438277 8.5237715071992 4594.5 5189.3 24418.200 1.007439 8.43261521 8.554354092

1993 4748.9 5261.3 25092.330 0.624790 8.46566829 8.5681334231994 4928.1 5397.2 25218.600 2.206002 8.5027088 8.593635581995 5075.6 5539.1 27439.730 3.333143 8.53220002 8.6195873121996 5237.5 5677.7 29448.190 3.083201 8.56359956 8.64430151997 5423.9 5854.5 32664.070 3.120000 8.59857039 8.6749658751998 5683.7 6168.6 35587.020 3.583909 8.64535771 8.7272271871999 5968.4 6320.0 39591.260 3.245271 8.69423416 8.7514744872000 6257.8 6539.2 38167.720 3.575970 8.74158396 8.785570113

LnW I8.55001172 -10.350948.57182474 -4.7198048.63183369 1.044063 I = tasa de interes real8.65860855 0.4073468.71375553 -5.283152

8.7393545 -0.2770118.75709364 0.5611378.82424059 -0.1384768.87797358 0.2619978.90587559 -0.7361248.89772141 -0.2606838.97081016 -0.574639.01043154 2.2959439.03022721 1.5111819.10184963 1.2964329.11510014 1.3959229.15229772 2.0576169.21068031 2.0265999.26509462 2.1116699.26122738 2.0202519.33362558 1.212616

9.4047066 1.0549869.36496951 1.7321549.36306489 1.166228

9.4184044 -0.7122419.51043904 -0.1557379.47891302 1.4138399.38166754 -1.0425719.44417537 -3.5335859.50723835 -0.6567669.53143135 -1.190427

9.5784843 0.1130489.63821907 1.704219.67815097 2.2984969.67815348 4.7038479.69968758 4.4490279.73771923 4.6909729.77148356 5.8483329.85578517 4.3305049.92964446 3.7680319.96343854 2.81946910.0137755 3.28706110.0715327 4.31795610.0478099 3.595025

10.087899 1.80275710.103084 1.007439

10.1303175 0.62479010.1353371 2.20600210.2197472 3.33314310.2903877 3.083201

10.394031 3.12000010.4797362 3.58390910.5863637 3.24527110.5497454 3.575970