Mich-acordeon-perfecto.xlsx

DW corregido Indicadores económicos de coyuntura > Oferta y demanda global de bienes y servicios, base 2013 > Series Originales > A precio Unidad de medida:Millones de pesos a precios de 2013.

Periodicidad: Trimesinversion 1997/01 1997/02 1997/03 1997/04 1998/01 1998/02 1998/03 1998/04 1999/01 1999/02 1999/03 1999/04 2000/01 2000/02 2000/03 2000/04 2001/01 2001/02 2001/03 2001/04 2002/01 2002/02 2002/03 2002/04 2003/01 2003/02 2003/03 2003/04 2004/01 2004/02 2004/03 2004/04 2005/01 2005/02 2005/03 2005/04 2006/01

tasa 1991848.725 24.216667 2072015.272 22.703333 2301964.762 21.09 2316884.965 21.166667 2368174.314 20.816667 2260212.182 20.833333 2513002.684 30.07 2450289.249 36.846667 2535906.207 31.056667 2395245.483 23.34 2610863.689 23.59 2583020.593 20.52 2681753.714 17.556667 2560297.247 16.533333 2778376.738 16.456667 2634550.653 18.38 2523247.662 18.146667 2322266.32 14.143333 2566704.845 7.93 2467866.913 10.08 2341839.106 8.7033333 2371656.425 7.8 2499618.974 8.4733333 2442261.647 8.8233333 2460228.729 9.7566667 2379630.488 7.21 2466516.613 5.58 2450595.114 6.11 2580765.018 6.0566667 2556435.842 7.09 2610939.336 7.8433333 2700899.988 8.78 2680262.621 9.5333333 2723325.163 10.146667 2766145.765 9.8366667 2927996.026 9.01 2927578.28 7.9566667

2006/02 2006/03 2006/04 2007/01 2007/02 2007/03 2007/04 2008/01 2008/02 2008/03 2008/04 2009/01 2009/02 2009/03 2009/04 2010/01 2010/02 2010/03 2010/04 2011/01 2011/02 2011/03 2011/04 2012/01 2012/02 2012/03 2012/04 2013/01 2013/02 2013/03 2013/04 2014/01 2014/02 2014/03 2014/04 2015/01 2015/02 2015/03 2015/04 2016/01r/ 2016/02 2016/03 2016/04 2017/01 2017/02

2960383.583 7.6633333 3064764.473 7.5166667 3178539.568 7.6233333 3044760.996 7.6733333 3080037.3 7.7533333 3233092.761 7.78 3478904.947 7.93 3295109.851 7.9533333 3478572.872 8.0066667 3451517.842 8.6466667 3453148.939 8.8033333 2952023.131 7.9366667 2958142.086 5.7766667 3026830.477 4.9533333 3145264.039 5.05 3057152.799 5.04 3120014.805 5.0266667 3122127.235 4.9933333 3352429.885 4.94 3147467.223 4.89 3325754.714 4.8833333 3450025.243 4.8366667 3721348.797 4.81 3441812.756 4.7966667 3520178.043 4.7733333 3624173.044 4.8033333 3730758.84 4.8533333 3356467.689 4.7233333 3450701.27 4.3233333 3414595.877 4.2466667 3615449.265 3.85 3344810.928 3.8033333 3477406.7 3.69 3567822.519 3.3066667 3871476.973 3.3033333 3508441.895 3.3166667 3680940.69 3.31 3862905.878 3.3433333 3923481.676 3.4 3630770.764 3.8266667 3760319.817 4.1566667 3784599.68 4.69 3953494.267 5.6 3653859.942 6.5433333 3650173.673 7.0966667

2017/03 2017/04 2018/01 2018/02 2018/03p/

3749720.64 7.3866667 3836751.181 7.4566667 3693674.262 7.8 3771204.878 7.9233333 3760367.504 8.1533333

Cifras preliminares: p/ A partir de 2018/03Cifras revisadas: r/ A partir de 2016/01 Fuente: INEGI. Sistema de Cuentas Nacionales de México. Fecha de consulta: 07/03/2019 17:37:40

ido e 2013 > Series Originales > A precios constantes > Demanda > Valores absolutos p Producto Interno Bruto, a precios de mercado

10862932 11460068.1 11408200.9 11887380.1 11827638 12034464.2 11972371.6 12139816.6 12100154.5 12315219.1 12325229.1 12554685.8 12725022 12994568.9 13008792.3 13003302.2 12796119.5 12967530.2 12857408.6 12901429.2 12415541.5 13112362.8 12889950.1 13084104.3 12803326.7 13182931.6 12954912.3 13305703.4 13252637.3 13732337.6 13438257.2 13872028.2 13354792.4 14104834.7 13782142.6 14306520.4 14107961.1

710318.176 885463.025 743181.756 784271.135 641245.819 967842.991 732313.173 860803.218 661611.762 973390.533 798143.329 915910.959 726957.095 1028068.45 735155.64 722177.165 597286.421 979122.784 713178.171 654719.414 770693.727 878272.119 733435.141 790613.688 697732.524 839718.411 764398.534 905452.929 792135.077 863270.842 915971.009 833833.41 891004.374 904385.924 1036962.53 925898.316

6.14797737 5.56921136 6.74880883 6.34639683 6.60233568 15.8276084 16.2897684 5.86700324 2.10858204 7.63396388 4.39305518 3.52848067 4.53098511 5.15390472 7.12965005 5.58145913 1.73764058 -1.7388748 4.65877607 1.8122946 1.8500985 3.14098193 3.03066783 3.72472899 0.54000318 0.65099313 2.29531784 1.87965807 2.94945192 2.99636263 3.41802442 3.53101983 3.62934828 2.90005228 2.2853124 1.79711716

4033789.8 3573699.55 4088337.06 3701011.37 3948679.3 3745193.11 3955086.77 3800953.52 4043132.39 3906116.86 4128730.32 4142201.98 4295301.06 4125252.8 4110039.14 3906609.69 4219657.64 3992353.79 4111657.27 3595675.55 4624666.63 3925882.64 4272085.96 3858577.71 4430132.02 3942601.53 4449274.6 4156395.44 4672373.67 4050353.32 4685167.98 3871391.22 4975033.94 4139586.83 4884568.21 4327525.93

14700503.8 14435867.2 14800896.8 14393731.5 14993341.6 14783297.4 15204933.4 14563429.2 15386331.9 14979493.1 15125056.5 13752157.5 14012946.5 14231940.4 14882949.1 14371712.2 14998393.2 14921449.7 15499623.7 14902786.2 15413082.4 15526005.7 16139460.1 15619690 16027316 15952743.5 16639145.1 15720266.2 16362706.7 16186052.6 16839722.8 16135622.7 16736982.8 16645034.5 17416978.9 16696943.7 17239319.5 17309689.9 17889470.6 17199206.2 17810988.7 17668867 18476232.8 17793290.3 18149091.7

958989.205 1040943.25 1083359.93 871800.749 998532.739 1127472.09 1268650.24 916809.379 1225921.12 1073444.39 1093571.25 591330.363 940036.357 1004541.62 1076017.41 906940.861 1030038.78 989176.552 1218035.07 855629.505 1174036.6 1176423.6 1362791.5 897769.233 1167235.08 1217656.85 1253148.04 805991.133 1156103.17 1055576.42 1281112.71 873164.009 1190777.57 1190546.3 1432389.36 861765.527 1282447.73 1346486.74 1282664.81 948542.171 1278198.59 1213914.21 1366210.24 951113.698 1152267.88

2.22387914 2.27774535 2.48467845 2.46175741 2.50757567 2.47955155 2.61132129 2.53210941 2.56949126 3.17303074 2.89217114 1.91840168 0.35088517 1.004203 1.66372898 1.58764428 1.5811473 1.5569291 1.52638359 1.51284411 1.54035918 1.49825008 1.50348637 1.5083833 1.4941651 1.54011658 1.56960753 1.40542579 1.09429832 1.29108557 0.9468309 1.17133937 1.08990899 0.78405427 1.04278094 1.05839306 1.04261126 1.08050216 1.114381 1.50230836 1.54062418 1.84835803 2.39375281 2.71497848 2.62341632

5055810.7 4386091.3 4932035.72 4275323.4 5153285.92 4533327.41 5098556.87 4168807.67 5430264.91 4460861.32 4884553.8 3412142.6 4611493.1 4652202.63 5153499.36 4197210.36 5173390.63 4668026.29 5298801.47 4306704.14 5225019.18 4989086.25 5525342.41 4586193.47 5349152.4 4995912.66 5733294.56 4345167.63 5615785.74 4999936.96 5774374.04 4623402.29 5706109.7 5203050.69 6037854.15 4790090.89 5824707.85 5524291.21 6055964.24 4969341.63 6053012.95 5492655.39 6397180.5 5162294.69 5984979.36

17935776.2 18749848.4 18008915.8 18618588.2 18389170.2

1254334.91 1273311.68 1070737.65 1246080.63 1182240.63

2.5351384 2.40688431 2.70236321 2.59098193 2.73666697

5528425.59 6488327.71 5190866.99 6307066.74 5660855.5

0.6836347954

Resumen Estadísticas de la regresión

Coeficiente de correlación múltiple Coeficiente de determinación R^2 R^2 ajustado Error típico Observaciones

0.8443995156 0.713010542 0.7060951333 112683.961885455 86

ANÁLISIS DE VARIANZA Grados de libertad

Regresión Residuos Total

2 83 85

2618377831546.78 1.30919E+12 103.104615 1053907047094.83 12697675266 3672284878641.61

-152895.191946325 1750.944349892 0.239273426

93434.610995374 -1.636387098 0.10554517 5064.7486114117 0.345711996 0.73043388 0.018115757 13.20802805 4.1788E-22

Coeficientes

Intercepción Variable X 1 Variable X 2

Suma de cuadrados Promedio de los cuadradosF

Error típico

Estadístico t Probabilidad

Análisis de los residuales Observación

Pronóstico para Y

1 2 3 4 5 6 7 8 9 10

823048.280298398 711947.523021975 837152.011706672 743770.666655062 803479.155157597 770943.255323153 821974.447503885 766844.775481577 818210.957069191 795101.417534848

Residuos

Ut-1

-112730.103865206 173515.502455604 -112730.1039 -93970.2557756945 173515.5025 40500.4683508065 -93970.25578 -162233.335761122 40500.46835 196899.736093206 -162233.3358 -89661.2741992894 196899.7361 93958.4421275615 -89661.2742 -156599.195024451 93958.44213 178289.115781295 -156599.195

ut-ut-1

286245.606 -267485.76 134470.724 -202733.8 359133.072 -286561.01 183619.716 -250557.64 334888.311

11 12 13 14 15 16 17 18 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

842692.251283381 844401.839062875 882789.711196893 843192.379778144 843011.574548301 791625.517376639 859799.260589292 799324.305262769 839072.38817899 710627.642955443 956904.056650735 791963.880850903 874607.982255457 776881.708219447 908063.188327531 791604.436961761 915716.957604752 844910.961160343 970243.989857434 821493.186717592 974125.771832029 779608.468939763 1043853.00957762 842675.762218672 1019853.63205978 885713.416602708 1060719.84484828 900568.105707354 1031560.4244981 874386.48471762 1084539.81044262 936151.146101625 1071626.25729483 849023.284697941 1150921.93394019 920026.178130672 1020912.76022467 666898.872262108 951126.941567358 962011.573071908 1083113.35355202 854165.587438371 1087728.20999845 966765.547566659 1117639.80178543

-44548.9221087964 178289.1158 71509.1203487442 -44548.92211 -155832.615758504 71509.12035 184876.073626802 -155832.6158 -107855.93435229 184876.0736 -69448.3519896477 -107855.9344 -262512.83972352 -69448.35199 179798.479218744 -262512.8397 -125894.216721727 179798.4792 -55908.2290784107 -125894.2167 -186210.329721579 -55908.22908 86308.2383045558 -186210.3297 -141172.841103428 86308.2383 13731.9794404476 -141172.8411 -210330.664094494 13731.97944 48113.9742662511 -210330.6641 -151318.423663502 48113.97427 60541.9674921029 -151318.4237 -178108.912892199 60541.96749 41777.6555044536 -178108.9129 -58154.7625788118 41777.6555 54224.941390121 -58154.76258 -152848.635081263 54224.94139 61710.1621884607 -152848.6351 17108.8998605285 61710.16219 40184.8992547554 17108.89986 -101730.640289576 40184.89925 140375.142247174 -101730.6403 51799.5100784602 140375.1422 -2585.7359320659 51799.51008 -86007.0709600374 -2585.735932 191320.945513739 -86007.07096 197023.981556204 191320.9455 67786.0946721657 197023.9816 74999.1892778946 67786.09467 153418.210264114 74999.18928 72658.4850684813 153418.2103 -75568.5096328117 72658.48507 -11090.5847204267 -75568.50963 42530.0442255857 -11090.58472 -7095.9483816044 42530.04423 52775.2738066523 -7095.948382 -57689.4332243069 52775.27381 22411.0045977536 -57689.43322 100395.269728153 22411.0046

-222838.04 116058.042 -227341.74 340708.689 -292732.01 38407.5824 -193064.49 442311.319 -305692.7 69985.9876 -130302.1 272518.568 -227481.08 154904.821 -224062.64 258444.638 -199432.4 211860.391 -238650.88 219886.568 -99932.418 112379.704 -207073.58 214558.797 -44601.262 23075.9994 -141915.54 242105.783 -88575.632 -54385.246 -83421.335 277328.016 5703.03604 -129237.89 7213.09461 78419.021 -80759.725 -148226.99 64477.9249 53620.6289 -49625.993 59871.2222 -110464.71 80100.4378 77984.2651

56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86

880233.567136005 1100010.13239274 1043483.92095498 1171804.93627495 947100.127197544 1129631.02838147 1045190.60390403 1221678.13448505 889248.77648801 1192729.15637386 1045717.47206815 1230416.9150754 955413.064849185 1214333.59380086 1093429.408648 1293628.70768131 995099.452847049 1242628.16380498 1170812.79128751 1298087.33857906 1038766.66338498 1298127.50087142 1164587.65263962 1381971.42987992 1087058.52125906 1283744.77927071 1174349.02500468 1403803.52930669 1093873.02345344 1360754.94098595 1206388.84973793

-24604.0626333613 100395.2697 74026.47060923 -24604.06263 132939.678616286 74026.47061 190986.559630175 132939.6786 -49330.8946161896 190986.5596 37604.0553935545 -49330.89462 172466.243926933 37604.05539 31469.9081155062 172466.2439 -83257.6437275886 31469.90812 -36625.9881825859 -83257.64373 9858.9482571444 -36625.98818 50695.7962059965 9858.948257 -82249.0553769225 50695.79621 -23556.0281884209 -82249.05538 97116.8925033966 -23556.02819 138760.647547845 97116.8925 -133333.926148 138760.6475 39819.5691626503 -133333.9261 175673.951254959 39819.56916 -15422.5321033997 175673.9513 -90224.4921807445 -15422.5321 -19928.9122331222 -90224.49218 49326.5586578208 -19928.91223 -15761.190756619 49326.55866 -135944.823562288 -15761.19076 -131476.900110208 -135944.8236 79985.882909403 -131476.9001 -130491.850809528 79985.88291 -23135.3700456554 -130491.8508 -114674.31133231 -23135.37005 -24148.220890047 -114674.3113

-124999.33 98630.5332 58913.208 58046.881 -240317.45 86934.95 134862.189 -140996.34 -114727.55 46631.6555 46484.9364 40836.8479 -132944.85 58693.0272 120672.921 41643.755 -272094.57 173153.495 135854.382 -191096.48 -74801.96 70295.5799 69255.4709 -65087.749 -120183.63 4467.92345 211462.783 -210477.73 107356.481 -91538.941 90526.0904

dw=

Valor crítico de F

3.172756E-23

Inferior 95%

Superior 95% Inferior 95.0% Superior 95.0%

-338732.8753 32942.4914 -338732.88 32942.4914 -8322.636935 11824.525635 -8322.6369 11824.5256 0.203241914 0.2753049379 0.20324191 0.27530494

ut-ut-1)^2

Ut^2

81936547138 71548630857 18082375647 41100995330 128976563300 82117212620 33716200224 62779129535 112150180714

12708076317 30107629592 8830408971 1640287937 26319655232 38769506074 8039144091 8828188847 24523307882 31787008806

49656791131 13469469219 51684264976 116082411023 85692028495 1475142383 37273896424 195639302864 93448024351 4898038466 16978637432 74266369919 51747641489 23995503428 50204068228 66793631097 39773281344 44884825341 56954242708 48350102961 9986488184 12629197864 42879466073 46035477486 1989272601 532501748 20140020364 58615209938 7845642614 2957754984 6959119138 76910828721 32524620.102 16702431406 52028733.791 6149542852 6522133214 21971241958 4157402801 2875171849 2462739142 3584563246 12202451499 6416080139 6081545608

1984606461 5113554293 24283804134 34179162600 11632902575 4823073594 68912991020 32327493129 15849353804 3125730079 34674286895 7449111999 19929771065 188567259.35 44238988258 2314954520 22897265340 3665329828 31722784852 1745372499 3381976411 2940344269 23362705246 3808144117 292714454.44 1614826128 10349123174 19705180561 2683189244 6686030.3104 7397216255 36603704192 38818449308 4594954631 5624878392 23537147241 5279255452 5710599648 123001069.44 1808804662 50352483.434 2785229525 3328070706 502253127.08 10079210184

15624833091 9727982088 3470766078 3369440395 57752478815 7557685533 18187809896 19879966712 13162411152 2174511299 2160849316 1667648150 17674333562 3444871441 14561953788 1734202334 74035457035 29982132938 18456413134 36517865952 5595333231 4941468560 4796320248 4236415124 14444105594 19962339.974 44716508602 44300876391 11525413962 8379377772 8194973051 2.634661E+12

2.4998985634

605359898.07 5479918351 17672958151 36475865959 2433537164 1414064982 29744605294 990355116.8 6931835239 1341463010 97198860.737 2570063753 6764907110 554886464 9431690810 19254517308 17777935862 1585598088 30861337150 237854496.48 8140458989 397161542.8 2433109389 248415134.07 18480995053 17286175263 6397741465 17028123128 535245347.15 13150197680 583136572.15 1.053907E+12

Indicadores económicos de coyuntura > Oferta y demanda global de bienes y servicios, base 2013 > Series Originales > A precio Unidad de medida:Millones de pesos a precios de 2013.

Periodicidad: Trimesinversion 1997/01 1997/02 1997/03 1997/04 1998/01 1998/02 1998/03 1998/04 1999/01 1999/02 1999/03 1999/04 2000/01 2000/02 2000/03 2000/04 2001/01 2001/02 2001/03 2001/04 2002/01 2002/02 2002/03 2002/04 2003/01 2003/02 2003/03 2003/04 2004/01 2004/02 2004/03 2004/04 2005/01 2005/02 2005/03 2005/04 2006/01 2006/02

tasa 1991848.725 24.216667 2072015.272 22.703333 2301964.762 21.09 2316884.965 21.166667 2368174.314 20.816667 2260212.182 20.833333 2513002.684 30.07 2450289.249 36.846667 2535906.207 31.056667 2395245.483 23.34 2610863.689 23.59 2583020.593 20.52 2681753.714 17.556667 2560297.247 16.533333 2778376.738 16.456667 2634550.653 18.38 2523247.662 18.146667 2322266.32 14.143333 2566704.845 7.93 2467866.913 10.08 2341839.106 8.7033333 2371656.425 7.8 2499618.974 8.4733333 2442261.647 8.8233333 2460228.729 9.7566667 2379630.488 7.21 2466516.613 5.58 2450595.114 6.11 2580765.018 6.0566667 2556435.842 7.09 2610939.336 7.8433333 2700899.988 8.78 2680262.621 9.5333333 2723325.163 10.146667 2766145.765 9.8366667 2927996.026 9.01 2927578.28 7.9566667 2960383.583 7.6633333

2006/03 2006/04 2007/01 2007/02 2007/03 2007/04 2008/01 2008/02 2008/03 2008/04 2009/01 2009/02 2009/03 2009/04 2010/01 2010/02 2010/03 2010/04 2011/01 2011/02 2011/03 2011/04 2012/01 2012/02 2012/03 2012/04 2013/01 2013/02 2013/03 2013/04 2014/01 2014/02 2014/03 2014/04 2015/01 2015/02 2015/03 2015/04 2016/01r/ 2016/02 2016/03 2016/04 2017/01 2017/02 2017/03

3064764.473 7.5166667 3178539.568 7.6233333 3044760.996 7.6733333 3080037.3 7.7533333 3233092.761 7.78 3478904.947 7.93 3295109.851 7.9533333 3478572.872 8.0066667 3451517.842 8.6466667 3453148.939 8.8033333 2952023.131 7.9366667 2958142.086 5.7766667 3026830.477 4.9533333 3145264.039 5.05 3057152.799 5.04 3120014.805 5.0266667 3122127.235 4.9933333 3352429.885 4.94 3147467.223 4.89 3325754.714 4.8833333 3450025.243 4.8366667 3721348.797 4.81 3441812.756 4.7966667 3520178.043 4.7733333 3624173.044 4.8033333 3730758.84 4.8533333 3356467.689 4.7233333 3450701.27 4.3233333 3414595.877 4.2466667 3615449.265 3.85 3344810.928 3.8033333 3477406.7 3.69 3567822.519 3.3066667 3871476.973 3.3033333 3508441.895 3.3166667 3680940.69 3.31 3862905.878 3.3433333 3923481.676 3.4 3630770.764 3.8266667 3760319.817 4.1566667 3784599.68 4.69 3953494.267 5.6 3653859.942 6.5433333 3650173.673 7.0966667 3749720.64 7.3866667

2017/04 2018/01 2018/02 2018/03p/

3836751.181 7.4566667 3693674.262 7.8 3771204.878 7.9233333 3760367.504 8.1533333

Cifras preliminares: p/ A partir de 2018/03Cifras revisadas: r/ A partir de 2016/01 Fuente: INEGI. Sistema de Cuentas Nacionales de México. Fecha de consulta: 07/03/2019 17:37:40

e 2013 > Series Originales > A precios constantes > Demanda > Valores absolutos p

0.6836348

Producto Interno Bruto, a precios de mercado

10862932 11460068.1 11408200.9 11887380.1 11827638 12034464.2 11972371.6 12139816.6 12100154.5 12315219.1 12325229.1 12554685.8 12725022 12994568.9 13008792.3 13003302.2 12796119.5 12967530.2 12857408.6 12901429.2 12415541.5 13112362.8 12889950.1 13084104.3 12803326.7 13182931.6 12954912.3 13305703.4 13252637.3 13732337.6 13438257.2 13872028.2 13354792.4 14104834.7 13782142.6 14306520.4 14107961.1 14700503.8

Resumen 710318.176 885463.025 743181.756 784271.135 641245.819 967842.991 732313.173 860803.218 661611.762 973390.533 798143.329 915910.959 726957.095 1028068.45 735155.64 722177.165 597286.421 979122.784 713178.171 654719.414 770693.727 878272.119 733435.141 790613.688 697732.524 839718.411 764398.534 905452.929 792135.077 863270.842 915971.009 833833.41 891004.374 904385.924 1036962.53 925898.316 958989.205

6.14797737 5.56921136 6.74880883 6.34639683 6.60233568 15.8276084 16.2897684 5.86700324 2.10858204 7.63396388 4.39305518 3.52848067 4.53098511 5.15390472 7.12965005 5.58145913 1.73764058 -1.7388748 4.65877607 1.8122946 1.8500985 3.14098193 3.03066783 3.72472899 0.54000318 0.65099313 2.29531784 1.87965807 2.94945192 2.99636263 3.41802442 3.53101983 3.62934828 2.90005228 2.2853124 1.79711716 2.22387914

4033789.8 3573699.55 4088337.06 3701011.37 3948679.3 3745193.11 3955086.77 3800953.52 4043132.39 3906116.86 4128730.32 4142201.98 4295301.06 4125252.8 4110039.14 3906609.69 4219657.64 3992353.79 4111657.27 3595675.55 4624666.63 3925882.64 4272085.96 3858577.71 4430132.02 3942601.53 4449274.6 4156395.44 4672373.67 4050353.32 4685167.98 3871391.22 4975033.94 4139586.83 4884568.21 4327525.93 5055810.7

Estadísticas de la regresión

Coeficiente d Coeficiente R^2 ajustado Error típico Observacione ANÁLISIS DE VARIANZA Grados de libertad

Regresión Residuos Total

Intercepción Variable X 1 Variable X 2

Análisis de los residuales Observación

1 2 3 4 5 6 7 8 9 10 11 12 13

14435867.2 14800896.8 14393731.5 14993341.6 14783297.4 15204933.4 14563429.2 15386331.9 14979493.1 15125056.5 13752157.5 14012946.5 14231940.4 14882949.1 14371712.2 14998393.2 14921449.7 15499623.7 14902786.2 15413082.4 15526005.7 16139460.1 15619690 16027316 15952743.5 16639145.1 15720266.2 16362706.7 16186052.6 16839722.8 16135622.7 16736982.8 16645034.5 17416978.9 16696943.7 17239319.5 17309689.9 17889470.6 17199206.2 17810988.7 17668867 18476232.8 17793290.3 18149091.7 17935776.2

1040943.25 1083359.93 871800.749 998532.739 1127472.09 1268650.24 916809.379 1225921.12 1073444.39 1093571.25 591330.363 940036.357 1004541.62 1076017.41 906940.861 1030038.78 989176.552 1218035.07 855629.505 1174036.6 1176423.6 1362791.5 897769.233 1167235.08 1217656.85 1253148.04 805991.133 1156103.17 1055576.42 1281112.71 873164.009 1190777.57 1190546.3 1432389.36 861765.527 1282447.73 1346486.74 1282664.81 948542.171 1278198.59 1213914.21 1366210.24 951113.698 1152267.88 1254334.91

2.27774535 2.48467845 2.46175741 2.50757567 2.47955155 2.61132129 2.53210941 2.56949126 3.17303074 2.89217114 1.91840168 0.35088517 1.004203 1.66372898 1.58764428 1.5811473 1.5569291 1.52638359 1.51284411 1.54035918 1.49825008 1.50348637 1.5083833 1.4941651 1.54011658 1.56960753 1.40542579 1.09429832 1.29108557 0.9468309 1.17133937 1.08990899 0.78405427 1.04278094 1.05839306 1.04261126 1.08050216 1.114381 1.50230836 1.54062418 1.84835803 2.39375281 2.71497848 2.62341632 2.5351384

4386091.3 4932035.72 4275323.4 5153285.92 4533327.41 5098556.87 4168807.67 5430264.91 4460861.32 4884553.8 3412142.6 4611493.1 4652202.63 5153499.36 4197210.36 5173390.63 4668026.29 5298801.47 4306704.14 5225019.18 4989086.25 5525342.41 4586193.47 5349152.4 4995912.66 5733294.56 4345167.63 5615785.74 4999936.96 5774374.04 4623402.29 5706109.7 5203050.69 6037854.15 4790090.89 5824707.85 5524291.21 6055964.24 4969341.63 6053012.95 5492655.39 6397180.5 5162294.69 5984979.36 5528425.59

14 15 16 17 18 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

18749848.4 18008915.8 18618588.2 18389170.2

1273311.68 1070737.65 1246080.63 1182240.63

2.40688431 6488327.71 2.70236321 5190866.99 2.59098193 6307066.74 2.73666697 5660855.5

59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86

stadísticas de la regresión

0.84439952 0.71301054 0.70609513 112683.962 86

NÁLISIS DE VARIANZA Grados de libertad Suma de Promedio cuadradosde los cuadrados F

Valor crítico de F

2 2.6184E+12 1.3092E+12 103.104615 3.1728E-23 83 1.0539E+12 1.2698E+10 85 3.6723E+12 Coeficientes Error típico Estadístico t Probabilidad Inferior 95% Superior 95% Inferior 95.0% Superior 95.0%

-152895.19 93434.611 -1.6363871 0.10554517 -338732.88 32942.4914 -338732.8753 32942.4914 1750.94435 5064.74861 0.345712 0.73043388 -8322.6369 11824.5256 -8322.636935 11824.525635 0.23927343 0.01811576 13.208028 4.1788E-22 0.20324191 0.27530494 0.203241914 0.2753049379

nálisis de los residuales Pronóstico para YResiduos

823048.28 711947.523 837152.012 743770.667 803479.155 770943.255 821974.448 766844.775 818210.957 795101.418 842692.251 844401.839 882789.711

-112730.1 173515.502 -93970.256 40500.4684 -162233.34 196899.736 -89661.274 93958.4421 -156599.2 178289.116 -44548.922 71509.1203 -155832.62

ut

-112730.1 173515.502 -93970.256 40500.4684 -162233.34 196899.736 -89661.274 93958.4421 -156599.2 178289.116 -44548.922 71509.1203 -155832.62

ut-1

-112730.1 173515.502 -93970.256 40500.4684 -162233.34 196899.736 -89661.274 93958.4421 -156599.2 178289.116 -44548.922 71509.1203

ut-2

PIB

ut-3

-112730.1 173515.502 -93970.256 40500.4684 -162233.34 196899.736 -89661.274 93958.4421 -156599.2 178289.116 -44548.922

4033789.8038 3573699.5545 4088337.0603 3701011.3736 3948679.3024 3745193.1073 3955086.7703 3800953.5223 4043132.3925 3906116.8609 4128730.3179 4142201.9754 4295301.0606

-112730.1039 173515.50246 -93970.25578 40500.468351 -162233.3358 196899.73609 -89661.2742 93958.442128 -156599.195 178289.11578

843192.38 843011.575 791625.517 859799.261 799324.305 839072.388 710627.643 956904.057 791963.881 874607.982 776881.708 908063.188 791604.437 915716.958 844910.961 970243.99 821493.187 974125.772 779608.469 1043853.01 842675.762 1019853.63 885713.417 1060719.84 900568.106 1031560.42 874386.485 1084539.81 936151.146 1071626.26 849023.285 1150921.93 920026.178 1020912.76 666898.872 951126.942 962011.573 1083113.35 854165.587 1087728.21 966765.548 1117639.8 880233.567 1100010.13 1043483.92

184876.074 -107855.93 -69448.352 -262512.84 179798.479 -125894.22 -55908.229 -186210.33 86308.2383 -141172.84 13731.9794 -210330.66 48113.9743 -151318.42 60541.9675 -178108.91 41777.6555 -58154.763 54224.9414 -152848.64 61710.1622 17108.8999 40184.8993 -101730.64 140375.142 51799.5101 -2585.7359 -86007.071 191320.946 197023.982 67786.0947 74999.1893 153418.21 72658.4851 -75568.51 -11090.585 42530.0442 -7095.9484 52775.2738 -57689.433 22411.0046 100395.27 -24604.063 74026.4706 132939.679

184876.074 -107855.93 -69448.352 -262512.84 179798.479 -125894.22 -55908.229 -186210.33 86308.2383 -141172.84 13731.9794 -210330.66 48113.9743 -151318.42 60541.9675 -178108.91 41777.6555 -58154.763 54224.9414 -152848.64 61710.1622 17108.8999 40184.8993 -101730.64 140375.142 51799.5101 -2585.7359 -86007.071 191320.946 197023.982 67786.0947 74999.1893 153418.21 72658.4851 -75568.51 -11090.585 42530.0442 -7095.9484 52775.2738 -57689.433 22411.0046 100395.27 -24604.063 74026.4706 132939.679

-155832.62 184876.074 -107855.93 -69448.352 -262512.84 179798.479 -125894.22 -55908.229 -186210.33 86308.2383 -141172.84 13731.9794 -210330.66 48113.9743 -151318.42 60541.9675 -178108.91 41777.6555 -58154.763 54224.9414 -152848.64 61710.1622 17108.8999 40184.8993 -101730.64 140375.142 51799.5101 -2585.7359 -86007.071 191320.946 197023.982 67786.0947 74999.1893 153418.21 72658.4851 -75568.51 -11090.585 42530.0442 -7095.9484 52775.2738 -57689.433 22411.0046 100395.27 -24604.063 74026.4706

71509.1203 -155832.62 184876.074 -107855.93 -69448.352 -262512.84 179798.479 -125894.22 -55908.229 -186210.33 86308.2383 -141172.84 13731.9794 -210330.66 48113.9743 -151318.42 60541.9675 -178108.91 41777.6555 -58154.763 54224.9414 -152848.64 61710.1622 17108.8999 40184.8993 -101730.64 140375.142 51799.5101 -2585.7359 -86007.071 191320.946 197023.982 67786.0947 74999.1893 153418.21 72658.4851 -75568.51 -11090.585 42530.0442 -7095.9484 52775.2738 -57689.433 22411.0046 100395.27 -24604.063

4125252.8038 4110039.1405 3906609.6922 4219657.6426 3992353.7949 4111657.2744 3595675.5516 4624666.6323 3925882.6358 4272085.9591 3858577.7055 4430132.0151 3942601.5335 4449274.5963 4156395.4392 4672373.6707 4050353.3165 4685167.9775 3871391.2249 4975033.9379 4139586.8346 4884568.2065 4327525.9348 5055810.7038 4386091.3013 4932035.7158 4275323.3974 5153285.9193 4533327.4134 5098556.8749 4168807.6723 5430264.913 4460861.3158 4884553.7974 3412142.5992 4611493.1009 4652202.6294 5153499.3643 4197210.361 5173390.6345 4668026.2915 5298801.4689 4306704.1358 5225019.1848 4989086.2536

-44548.92211 71509.120349 -155832.6158 184876.07363 -107855.9344 -69448.35199 -262512.8397 179798.47922 -125894.2167 -55908.22908 -186210.3297 86308.238305 -141172.8411 13731.97944 -210330.6641 48113.974266 -151318.4237 60541.967492 -178108.9129 41777.655504 -58154.76258 54224.94139 -152848.6351 61710.162188 17108.899861 40184.899255 -101730.6403 140375.14225 51799.510078 -2585.735932 -86007.07096 191320.94551 197023.98156 67786.094672 74999.189278 153418.21026 72658.485068 -75568.50963 -11090.58472 42530.044226 -7095.948382 52775.273807 -57689.43322 22411.004598 100395.26973

1171804.94 947100.127 1129631.03 1045190.6 1221678.13 889248.776 1192729.16 1045717.47 1230416.92 955413.065 1214333.59 1093429.41 1293628.71 995099.453 1242628.16 1170812.79 1298087.34 1038766.66 1298127.5 1164587.65 1381971.43 1087058.52 1283744.78 1174349.03 1403803.53 1093873.02 1360754.94 1206388.85

190986.56 -49330.895 37604.0554 172466.244 31469.9081 -83257.644 -36625.988 9858.94826 50695.7962 -82249.055 -23556.028 97116.8925 138760.648 -133333.93 39819.5692 175673.951 -15422.532 -90224.492 -19928.912 49326.5587 -15761.191 -135944.82 -131476.9 79985.8829 -130491.85 -23135.37 -114674.31 -24148.221

190986.56 -49330.895 37604.0554 172466.244 31469.9081 -83257.644 -36625.988 9858.94826 50695.7962 -82249.055 -23556.028 97116.8925 138760.648 -133333.93 39819.5692 175673.951 -15422.532 -90224.492 -19928.912 49326.5587 -15761.191 -135944.82 -131476.9 79985.8829 -130491.85 -23135.37 -114674.31 -24148.221

132939.679 190986.56 -49330.895 37604.0554 172466.244 31469.9081 -83257.644 -36625.988 9858.94826 50695.7962 -82249.055 -23556.028 97116.8925 138760.648 -133333.93 39819.5692 175673.951 -15422.532 -90224.492 -19928.912 49326.5587 -15761.191 -135944.82 -131476.9 79985.8829 -130491.85 -23135.37 -114674.31

74026.4706 132939.679 190986.56 -49330.895 37604.0554 172466.244 31469.9081 -83257.644 -36625.988 9858.94826 50695.7962 -82249.055 -23556.028 97116.8925 138760.648 -133333.93 39819.5692 175673.951 -15422.532 -90224.492 -19928.912 49326.5587 -15761.191 -135944.82 -131476.9 79985.8829 -130491.85 -23135.37

5525342.4064 4586193.4708 5349152.3983 4995912.6575 5733294.5579 4345167.6334 5615785.7372 4999936.9557 5774374.0375 4623402.2949 5706109.6952 5203050.6945 6037854.151 4790090.8878 5824707.8454 5524291.2108 6055964.2406 4969341.6315 6053012.9483 5492655.3886 6397180.4961 5162294.6926 5984979.3574 5528425.588 6488327.7132 5190866.9872 6307066.7443 5660855.5029

-24604.06263 74026.470609 132939.67862 190986.55963 -49330.89462 37604.055394 172466.24393 31469.908116 -83257.64373 -36625.98818 9858.9482571 50695.796206 -82249.05538 -23556.02819 97116.892503 138760.64755 -133333.9261 39819.569163 175673.95125 -15422.5321 -90224.49218 -19928.91223 49326.558658 -15761.19076 -135944.8236 -131476.9001 79985.882909 -130491.8508

erior 95.0%

Resumen Estadísticas de la regresión

Coeficiente d 0.36329621 Coeficiente 0.13198413 R^2 ajustado 0.0874705 Error típico 105609.76 Observacione 83

Estadistico de prueba 10.9546831

ANÁLISIS DE VARIANZA Grados de libertad Suma de Promedio cuadradosde los cuadrados F

Regresión Residuos

Valor crítico de F

4 1.3228E+11 3.307E+10 2.96502716 0.02461892 78 8.6997E+11 1.1153E+10

Total

82 1.0022E+12 Coeficientes Error típico Estadístico t Probabilidad Inferior 95% Superior 95%

Intercepción Variable X 1 Variable X 2 Variable X 3 Variable X 4

-71252.268 -0.1513122 0.220796 0.01495949 -0.1404238

78857.8795 0.1122312 0.11043799 0.01639112 0.11221955

-0.9035529 -1.348219 1.99927577 0.91265849 -1.2513313

0.36901462 0.18149017 0.04906129 0.36423449 0.21455366

-228246.25 -0.3747474 0.00093085 -0.0176727 -0.3638358

85741.7103 0.07212293 0.44066116 0.04759169 0.08298813

Inferior 95.0% Superior 95.0%

-228246.25 -0.3747474 0.00093085 -0.0176727 -0.3638358

85741.7103 0.07212293 0.44066116 0.04759169 0.08298813

Indicadores económicos de coyuntura > Oferta y demanda global de bienes y servicios, base 2013 > Series Originales > A precio Unidad de medida:Millones de pesos a precios de 2013.

Periodicidad: Trimesinversion 1997/01 1997/02 1997/03 1997/04 1998/01 1998/02 1998/03 1998/04 1999/01 1999/02 1999/03 1999/04 2000/01 2000/02 2000/03 2000/04 2001/01 2001/02 2001/03 2001/04 2002/01 2002/02 2002/03 2002/04 2003/01 2003/02 2003/03 2003/04 2004/01 2004/02 2004/03 2004/04 2005/01 2005/02 2005/03 2005/04 2006/01 2006/02

tasa 1991848.725 24.216667 2072015.272 22.703333 2301964.762 21.09 2316884.965 21.166667 2368174.314 20.816667 2260212.182 20.833333 2513002.684 30.07 2450289.249 36.846667 2535906.207 31.056667 2395245.483 23.34 2610863.689 23.59 2583020.593 20.52 2681753.714 17.556667 2560297.247 16.533333 2778376.738 16.456667 2634550.653 18.38 2523247.662 18.146667 2322266.32 14.143333 2566704.845 7.93 2467866.913 10.08 2341839.106 8.7033333 2371656.425 7.8 2499618.974 8.4733333 2442261.647 8.8233333 2460228.729 9.7566667 2379630.488 7.21 2466516.613 5.58 2450595.114 6.11 2580765.018 6.0566667 2556435.842 7.09 2610939.336 7.8433333 2700899.988 8.78 2680262.621 9.5333333 2723325.163 10.146667 2766145.765 9.8366667 2927996.026 9.01 2927578.28 7.9566667 2960383.583 7.6633333

2006/03 2006/04 2007/01 2007/02 2007/03 2007/04 2008/01 2008/02 2008/03 2008/04 2009/01 2009/02 2009/03 2009/04 2010/01 2010/02 2010/03 2010/04 2011/01 2011/02 2011/03 2011/04 2012/01 2012/02 2012/03 2012/04 2013/01 2013/02 2013/03 2013/04 2014/01 2014/02 2014/03 2014/04 2015/01 2015/02 2015/03 2015/04 2016/01r/ 2016/02 2016/03 2016/04 2017/01 2017/02 2017/03

3064764.473 7.5166667 3178539.568 7.6233333 3044760.996 7.6733333 3080037.3 7.7533333 3233092.761 7.78 3478904.947 7.93 3295109.851 7.9533333 3478572.872 8.0066667 3451517.842 8.6466667 3453148.939 8.8033333 2952023.131 7.9366667 2958142.086 5.7766667 3026830.477 4.9533333 3145264.039 5.05 3057152.799 5.04 3120014.805 5.0266667 3122127.235 4.9933333 3352429.885 4.94 3147467.223 4.89 3325754.714 4.8833333 3450025.243 4.8366667 3721348.797 4.81 3441812.756 4.7966667 3520178.043 4.7733333 3624173.044 4.8033333 3730758.84 4.8533333 3356467.689 4.7233333 3450701.27 4.3233333 3414595.877 4.2466667 3615449.265 3.85 3344810.928 3.8033333 3477406.7 3.69 3567822.519 3.3066667 3871476.973 3.3033333 3508441.895 3.3166667 3680940.69 3.31 3862905.878 3.3433333 3923481.676 3.4 3630770.764 3.8266667 3760319.817 4.1566667 3784599.68 4.69 3953494.267 5.6 3653859.942 6.5433333 3650173.673 7.0966667 3749720.64 7.3866667

2017/04 2018/01 2018/02 2018/03p/

3836751.181 7.4566667 3693674.262 7.8 3771204.878 7.9233333 3760367.504 8.1533333

Cifras preliminares: p/ A partir de 2018/03Cifras revisadas: r/ A partir de 2016/01 Fuente: INEGI. Sistema de Cuentas Nacionales de México. Fecha de consulta: 07/03/2019 17:37:40

e 2013 > Series Originales > A precios constantes > Demanda > Valores absolutos p

0.6836348

Producto Interno Bruto, a precios de mercado

10862932 11460068.1 11408200.9 11887380.1 11827638 12034464.2 11972371.6 12139816.6 12100154.5 12315219.1 12325229.1 12554685.8 12725022 12994568.9 13008792.3 13003302.2 12796119.5 12967530.2 12857408.6 12901429.2 12415541.5 13112362.8 12889950.1 13084104.3 12803326.7 13182931.6 12954912.3 13305703.4 13252637.3 13732337.6 13438257.2 13872028.2 13354792.4 14104834.7 13782142.6 14306520.4 14107961.1 14700503.8

Resumen 710318.176 885463.025 743181.756 784271.135 641245.819 967842.991 732313.173 860803.218 661611.762 973390.533 798143.329 915910.959 726957.095 1028068.45 735155.64 722177.165 597286.421 979122.784 713178.171 654719.414 770693.727 878272.119 733435.141 790613.688 697732.524 839718.411 764398.534 905452.929 792135.077 863270.842 915971.009 833833.41 891004.374 904385.924 1036962.53 925898.316 958989.205

6.14797737 5.56921136 6.74880883 6.34639683 6.60233568 15.8276084 16.2897684 5.86700324 2.10858204 7.63396388 4.39305518 3.52848067 4.53098511 5.15390472 7.12965005 5.58145913 1.73764058 -1.7388748 4.65877607 1.8122946 1.8500985 3.14098193 3.03066783 3.72472899 0.54000318 0.65099313 2.29531784 1.87965807 2.94945192 2.99636263 3.41802442 3.53101983 3.62934828 2.90005228 2.2853124 1.79711716 2.22387914

4033789.8 3573699.55 4088337.06 3701011.37 3948679.3 3745193.11 3955086.77 3800953.52 4043132.39 3906116.86 4128730.32 4142201.98 4295301.06 4125252.8 4110039.14 3906609.69 4219657.64 3992353.79 4111657.27 3595675.55 4624666.63 3925882.64 4272085.96 3858577.71 4430132.02 3942601.53 4449274.6 4156395.44 4672373.67 4050353.32 4685167.98 3871391.22 4975033.94 4139586.83 4884568.21 4327525.93 5055810.7

Estadísticas de la regresión

Coeficiente d Coeficiente R^2 ajustado Error típico Observacione ANÁLISIS DE VARIANZA Grados de libertad

Regresión Residuos Total

Intercepción Variable X 1 Variable X 2

Análisis de los residuales Observación

1 2 3 4 5 6 7 8 9 10 11 12 13

14435867.2 14800896.8 14393731.5 14993341.6 14783297.4 15204933.4 14563429.2 15386331.9 14979493.1 15125056.5 13752157.5 14012946.5 14231940.4 14882949.1 14371712.2 14998393.2 14921449.7 15499623.7 14902786.2 15413082.4 15526005.7 16139460.1 15619690 16027316 15952743.5 16639145.1 15720266.2 16362706.7 16186052.6 16839722.8 16135622.7 16736982.8 16645034.5 17416978.9 16696943.7 17239319.5 17309689.9 17889470.6 17199206.2 17810988.7 17668867 18476232.8 17793290.3 18149091.7 17935776.2

1040943.25 1083359.93 871800.749 998532.739 1127472.09 1268650.24 916809.379 1225921.12 1073444.39 1093571.25 591330.363 940036.357 1004541.62 1076017.41 906940.861 1030038.78 989176.552 1218035.07 855629.505 1174036.6 1176423.6 1362791.5 897769.233 1167235.08 1217656.85 1253148.04 805991.133 1156103.17 1055576.42 1281112.71 873164.009 1190777.57 1190546.3 1432389.36 861765.527 1282447.73 1346486.74 1282664.81 948542.171 1278198.59 1213914.21 1366210.24 951113.698 1152267.88 1254334.91

2.27774535 2.48467845 2.46175741 2.50757567 2.47955155 2.61132129 2.53210941 2.56949126 3.17303074 2.89217114 1.91840168 0.35088517 1.004203 1.66372898 1.58764428 1.5811473 1.5569291 1.52638359 1.51284411 1.54035918 1.49825008 1.50348637 1.5083833 1.4941651 1.54011658 1.56960753 1.40542579 1.09429832 1.29108557 0.9468309 1.17133937 1.08990899 0.78405427 1.04278094 1.05839306 1.04261126 1.08050216 1.114381 1.50230836 1.54062418 1.84835803 2.39375281 2.71497848 2.62341632 2.5351384

4386091.3 4932035.72 4275323.4 5153285.92 4533327.41 5098556.87 4168807.67 5430264.91 4460861.32 4884553.8 3412142.6 4611493.1 4652202.63 5153499.36 4197210.36 5173390.63 4668026.29 5298801.47 4306704.14 5225019.18 4989086.25 5525342.41 4586193.47 5349152.4 4995912.66 5733294.56 4345167.63 5615785.74 4999936.96 5774374.04 4623402.29 5706109.7 5203050.69 6037854.15 4790090.89 5824707.85 5524291.21 6055964.24 4969341.63 6053012.95 5492655.39 6397180.5 5162294.69 5984979.36 5528425.59

14 15 16 17 18 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

18749848.4 18008915.8 18618588.2 18389170.2

1273311.68 1070737.65 1246080.63 1182240.63

2.40688431 6488327.71 2.70236321 5190866.99 2.59098193 6307066.74 2.73666697 5660855.5

59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86

stadísticas de la regresión

0.84439952 0.71301054 0.70609513 112683.962 86

NÁLISIS DE VARIANZA Grados de libertad Suma de Promedio cuadradosde los cuadrados F

Valor crítico de F

2 2.6184E+12 1.3092E+12 103.104615 3.1728E-23 83 1.0539E+12 1.2698E+10 85 3.6723E+12 Coeficientes Error típico Estadístico t Probabilidad Inferior 95% Superior 95% Inferior 95.0% Superior 95.0%

-152895.19 93434.611 -1.6363871 0.10554517 -338732.88 32942.4914 -338732.8753 32942.4914 1750.94435 5064.74861 0.345712 0.73043388 -8322.6369 11824.5256 -8322.636935 11824.525635 0.23927343 0.01811576 13.208028 4.1788E-22 0.20324191 0.27530494 0.203241914 0.2753049379

nálisis de los residuales Pronóstico para YResiduos

823048.28 711947.523 837152.012 743770.667 803479.155 770943.255 821974.448 766844.775 818210.957 795101.418 842692.251 844401.839 882789.711

-112730.1 173515.502 -93970.256 40500.4684 -162233.34 196899.736 -89661.274 93958.4421 -156599.2 178289.116 -44548.922 71509.1203 -155832.62

ut

x1

x2

x1^2

x2^2

-112730.1 173515.502 -93970.256 40500.4684 -162233.34 196899.736 -89661.274 93958.4421 -156599.2 178289.116 -44548.922 71509.1203 -155832.62

6.14797737 5.56921136 6.74880883 6.34639683 6.60233568 15.8276084 16.2897684 5.86700324 2.10858204 7.63396388 4.39305518 3.52848067 4.53098511

4033789.8 3573699.55 4088337.06 3701011.37 3948679.3 3745193.11 3955086.77 3800953.52 4043132.39 3906116.86 4128730.32 4142201.98 4295301.06

37.797625762 31.016115194 45.546420649 40.276752735 43.590836378 250.51318859 265.35655352 34.421727008 4.4461182101 58.277404453 19.298933786 12.450175805 20.529826057

1.627146E+13 1.277133E+13 1.67145E+13 1.369749E+13 1.559207E+13 1.402647E+13 1.564271E+13 1.444725E+13 1.634692E+13 1.525775E+13 1.704641E+13 1.715784E+13 1.844961E+13

843192.38 843011.575 791625.517 859799.261 799324.305 839072.388 710627.643 956904.057 791963.881 874607.982 776881.708 908063.188 791604.437 915716.958 844910.961 970243.99 821493.187 974125.772 779608.469 1043853.01 842675.762 1019853.63 885713.417 1060719.84 900568.106 1031560.42 874386.485 1084539.81 936151.146 1071626.26 849023.285 1150921.93 920026.178 1020912.76 666898.872 951126.942 962011.573 1083113.35 854165.587 1087728.21 966765.548 1117639.8 880233.567 1100010.13 1043483.92

184876.074 -107855.93 -69448.352 -262512.84 179798.479 -125894.22 -55908.229 -186210.33 86308.2383 -141172.84 13731.9794 -210330.66 48113.9743 -151318.42 60541.9675 -178108.91 41777.6555 -58154.763 54224.9414 -152848.64 61710.1622 17108.8999 40184.8993 -101730.64 140375.142 51799.5101 -2585.7359 -86007.071 191320.946 197023.982 67786.0947 74999.1893 153418.21 72658.4851 -75568.51 -11090.585 42530.0442 -7095.9484 52775.2738 -57689.433 22411.0046 100395.27 -24604.063 74026.4706 132939.679

184876.074 -107855.93 -69448.352 -262512.84 179798.479 -125894.22 -55908.229 -186210.33 86308.2383 -141172.84 13731.9794 -210330.66 48113.9743 -151318.42 60541.9675 -178108.91 41777.6555 -58154.763 54224.9414 -152848.64 61710.1622 17108.8999 40184.8993 -101730.64 140375.142 51799.5101 -2585.7359 -86007.071 191320.946 197023.982 67786.0947 74999.1893 153418.21 72658.4851 -75568.51 -11090.585 42530.0442 -7095.9484 52775.2738 -57689.433 22411.0046 100395.27 -24604.063 74026.4706 132939.679

5.15390472 7.12965005 5.58145913 1.73764058 -1.7388748 4.65877607 1.8122946 1.8500985 3.14098193 3.03066783 3.72472899 0.54000318 0.65099313 2.29531784 1.87965807 2.94945192 2.99636263 3.41802442 3.53101983 3.62934828 2.90005228 2.2853124 1.79711716 2.22387914 2.27774535 2.48467845 2.46175741 2.50757567 2.47955155 2.61132129 2.53210941 2.56949126 3.17303074 2.89217114 1.91840168 0.35088517 1.004203 1.66372898 1.58764428 1.5811473 1.5569291 1.52638359 1.51284411 1.54035918 1.49825008

4125252.8 4110039.14 3906609.69 4219657.64 3992353.79 4111657.27 3595675.55 4624666.63 3925882.64 4272085.96 3858577.71 4430132.02 3942601.53 4449274.6 4156395.44 4672373.67 4050353.32 4685167.98 3871391.22 4975033.94 4139586.83 4884568.21 4327525.93 5055810.7 4386091.3 4932035.72 4275323.4 5153285.92 4533327.41 5098556.87 4168807.67 5430264.91 4460861.32 4884553.8 3412142.6 4611493.1 4652202.63 5153499.36 4197210.36 5173390.63 4668026.29 5298801.47 4306704.14 5225019.18 4989086.25

26.562733824 50.831909843 31.15268599 3.019394784 3.0236855335 21.704194494 3.2844117019 3.4228644502 9.86576748 9.1849475183 13.873606039 0.291603434 0.4237920491 5.2684839945 3.5331144482 8.6992666436 8.9781890345 11.682890946 12.468101038 13.172168966 8.4103032041 5.2226527473 3.2296300874 4.9456384501 5.1881238854 6.1736270229 6.0602495447 6.2879357409 6.1481759043 6.8189988893 6.4115780433 6.6022853386 10.068124066 8.364653879 3.6802650234 0.1231204053 1.0084236624 2.7679941194 2.5206143702 2.5000267776 2.4240282074 2.3298468588 2.2886973035 2.3727064153 2.2447533097

1.701771E+13 1.689242E+13 1.52616E+13 1.780551E+13 1.593889E+13 1.690573E+13 1.292888E+13 2.138754E+13 1.541255E+13 1.825072E+13 1.488862E+13 1.962607E+13 1.554411E+13 1.979604E+13 1.727562E+13 2.183108E+13 1.640536E+13 2.19508E+13 1.498767E+13 2.475096E+13 1.713618E+13 2.385901E+13 1.872748E+13 2.556122E+13 1.92378E+13 2.432498E+13 1.827839E+13 2.655636E+13 2.055106E+13 2.599528E+13 1.737896E+13 2.948778E+13 1.989928E+13 2.385887E+13 1.164272E+13 2.126587E+13 2.164299E+13 2.655856E+13 1.761657E+13 2.676397E+13 2.179047E+13 2.80773E+13 1.85477E+13 2.730083E+13 2.489098E+13

1171804.94 947100.127 1129631.03 1045190.6 1221678.13 889248.776 1192729.16 1045717.47 1230416.92 955413.065 1214333.59 1093429.41 1293628.71 995099.453 1242628.16 1170812.79 1298087.34 1038766.66 1298127.5 1164587.65 1381971.43 1087058.52 1283744.78 1174349.03 1403803.53 1093873.02 1360754.94 1206388.85

190986.56 -49330.895 37604.0554 172466.244 31469.9081 -83257.644 -36625.988 9858.94826 50695.7962 -82249.055 -23556.028 97116.8925 138760.648 -133333.93 39819.5692 175673.951 -15422.532 -90224.492 -19928.912 49326.5587 -15761.191 -135944.82 -131476.9 79985.8829 -130491.85 -23135.37 -114674.31 -24148.221

190986.56 -49330.895 37604.0554 172466.244 31469.9081 -83257.644 -36625.988 9858.94826 50695.7962 -82249.055 -23556.028 97116.8925 138760.648 -133333.93 39819.5692 175673.951 -15422.532 -90224.492 -19928.912 49326.5587 -15761.191 -135944.82 -131476.9 79985.8829 -130491.85 -23135.37 -114674.31 -24148.221

1.50348637 1.5083833 1.4941651 1.54011658 1.56960753 1.40542579 1.09429832 1.29108557 0.9468309 1.17133937 1.08990899 0.78405427 1.04278094 1.05839306 1.04261126 1.08050216 1.114381 1.50230836 1.54062418 1.84835803 2.39375281 2.71497848 2.62341632 2.5351384 2.40688431 2.70236321 2.59098193 2.73666697

5525342.41 4586193.47 5349152.4 4995912.66 5733294.56 4345167.63 5615785.74 4999936.96 5774374.04 4623402.29 5706109.7 5203050.69 6037854.15 4790090.89 5824707.85 5524291.21 6055964.24 4969341.63 6053012.95 5492655.39 6397180.5 5162294.69 5984979.36 5528425.59 6488327.71 5190866.99 6307066.74 5660855.5

2.2604712737 2.2752201822 2.2325293404 2.3719590697 2.463667807 1.9752216597 1.1974888053 1.6669019437 0.8964887574 1.3720359222 1.1879016171 0.6147411009 1.0873920956 1.1201958678 1.0870382435 1.167484919 1.2418450148 2.2569304155 2.3735228731 3.4164274212 5.7300525135 7.3711081422 6.8823131993 6.4269267175 5.7930920883 7.3027669135 6.7131873578 7.4893461111

3.052941E+13 2.103317E+13 2.861343E+13 2.495914E+13 3.287067E+13 1.888048E+13 3.153705E+13 2.499937E+13 3.33434E+13 2.137585E+13 3.255969E+13 2.707174E+13 3.645568E+13 2.294497E+13 3.392722E+13 3.051779E+13 3.66747E+13 2.469436E+13 3.663897E+13 3.016926E+13 4.092392E+13 2.664929E+13 3.581998E+13 3.056349E+13 4.20984E+13 2.69451E+13 3.977909E+13 3.204529E+13

erior 95.0%

x1x2

24799648.435 19902688.163 27591405.26 23488086.852 26070506.231 59277449.995 64427447.369 22300206.627 8525276.3391 29819155.01 18137740.096 14615679.582 19461945.144

Resumen Estadísticas de la regresión

Coeficiente d 0.33757727 Coeficiente 0.11395841 R^2 ajustado 0.05858081 Error típico 108039.661 Observacione 86

r^2 n*R^2

0.11395841 9.80042348

ANÁLISIS DE VARIANZA Grados de libertad Suma de Promedio cuadradosde los cuadrados F

Regresión Residuos

Valor crítico de F

5 1.201E+11 2.402E+10 2.05784314 0.07937003 80 9.3381E+11 1.1673E+10

21261159.881 29303140.765 21804582.324 7332248.3519 -6942203.3646 19155290.529 6516423.3703 8556088.7875 12331126.415 12947273.499 14372156.235 2392285.3743 2566606.4938 10212499.363 7812602.2162 13780941.506 12136327.332 16014018.566 13669959.184 18056130.885 12005018.222 11162764.271 7777071.1186 11243511.984 9990399.072 12254522.881 10524809.053 12922254.392 11240619.028 13313970.125 10555877.118 13953018.237 14154450.074 14126965.504 6545860.1103 1618104.5587 4671755.8306 8574026.2416 6663677.0353 8179892.6227 7267785.9503 8088003.6 6515371.9887 8048406.2872 7474898.8911

Total

85 1.0539E+12 Coeficientes Error típico Estadístico t Probabilidad Inferior 95%

Intercepción Variable X 1 Variable X 2 Variable X 3 Variable X 4 Variable X 5

-535435.45 186564.365 0.15851121 -238.35554 -6.8475E-09 -0.046145

567699.933 70192.9551 0.22096514 887.154028 2.1542E-08 0.0158345

-0.9431663 2.65787877 0.71735845 -0.2686744 -0.3178653 -2.9142068

0.34843551 0.00949236 0.47524236 0.78887193 0.75141538 0.00462247

-1665194.3 46875.9329 -0.2812234 -2003.8483 -4.9718E-08 -0.0776566

8307277.0139 6917737.6457 7992516.818 7694287.8994 8999022.3259 6106810.6671 6145344.8776 6455346.444 5467355.7798 5415573.1363 6219140.2825 4079474.1228 6296159.2467 5069798.9487 6072905.9971 5969008.589 6748651.4908 7465483.4882 9325418.128 10152393.715 15313268.786 14015518.993 15701092.534 14015324.011 15616654.18 14027607.969 16341495.961 15491876.283

or crítico de F

Superior 95%Inferior 95.0% Superior 95.0%

594323.425 326252.798 0.59824585 1527.13724 3.6023E-08 -0.0146333

-1665194.3 46875.9329 -0.2812234 -2003.8483 -4.9718E-08 -0.0776566

594323.425 326252.798 0.59824585 1527.13724 3.6023E-08 -0.0146333

LN(y) LN(x1) LN(x2) LNx3 LNx4 6.91046161 5.59471138 6.94793707 2.0898868 3.07375756 7.22748456 6.97821374 8.16394095 3.07657466 2.19589035 5.15971026 5.29330482 6.3403593 1.39475844 0.52117192 6.04570412 5.37063803 6.95368421 1.92454058 2.00390948 6.52206044 6.54391185 7.73368357 2.71164374 1.91294412 6.57392874 5.28826703 6.61606519 2.02669983 2.80432961 6.90975927 6.60258789 8.2905435 2.8557228 2.38499423 7.7329644 6.72743172 7.9956436 3.04495092 3.82783673 13.4422187 7.47760424 12.0434302 7.62536139 10.1690664 6.50269409 5.70044357 6.95559261 2.62691245 2.46580877 9.99314936 7.1808312 9.36836924 4.93801442 6.06421535 7.01909449 6.34212142 7.60240134 2.71151087 2.98224168 6.06500075 5.9348942 7.38274645 1.6540288 1.21817152 8.61217532 7.64969262 9.09672365 3.81165003 4.49737337 8.62353413 7.06731985 8.82600055 3.5821569 4.28190239 8.84888387 6.9255952 8.54675199 3.60089488 4.20472247 7.28284434 5.80814249 7.84619882 2.49526944 3.17329251 7.33863274 5.60211882 7.068172 2.41332113 3.73542901 11.1769723 7.24494155 10.4166105 6.01986248 7.20061667 8.48808997 6.88038408 8.37701116 3.57358083 4.75577745 8.06900397 6.88550967 8.30622522 3.44345834 4.509991 7.80398044 6.13772705 7.85941315 2.91787883 3.84200818 6.51872389 6.07073773 7.21450441 2.32209356 1.93989208 7.38574878 6.02344759 7.63819824 2.49039158 3.0956681 7.10561302 6.80903931 7.89989532 2.9370963 2.83673654 6.99940787 7.03174126 8.05959233 3.32694068 2.31668522 6.28867978 5.86078622 7.30921237 2.41090124 1.75319188 7.18230424 6.67708346 7.84267147 3.08717133 3.06553815 5.33396922 5.04985601 6.33150185 0.68208623 1.16844925 7.97482874 7.07072411 8.63834831 3.53628173 4.06900966 8.02228029 6.82110747 8.14902387 3.02771532 3.21044035 7.08495038 5.41164605 6.54391185 1.94890566 3.38848357

LN(y) 03 Baja Califor 5.15971026 5.33396922 29 Tlaxcala 6.06500075 13 Hidalgo 6.28867978 27 Tabasco 05 Coahuila de 6.52206044 23 Quintana R 6.51872389 04 Campeche 6.04570412 02 Baja Califor 7.22748456 6.99940787 26 Sonora 6.90975927 07 Chiapas 10 Durango 6.50269409 6.57392874 06 Colima

7.33863274 18 Nayarit 08 Chihuahua 7.7329644 22 Querétaro 7.80398044 30 Veracruz de 7.97482874 16 Michoacán 8.84888387 8.62353413 15 México 8.61217532 14 Jalisco 8.06900397 21 Puebla 8.48808997 20 Oaxaca 11 Guanajuato 9.99314936 19 Nuevo León 11.1769723 09 Ciudad de 13.4422187

LN(x1) LN(x2) LNx3 LNx4 5.29330482 6.3403593 1.39475844 0.52117192 5.04985601 6.33150185 0.68208623 1.16844925 5.9348942 7.38274645 1.6540288 1.21817152 5.86078622 7.30921237 2.41090124 1.75319188 6.54391185 7.73368357 2.71164374 1.91294412 6.07073773 7.21450441 2.32209356 1.93989208 5.37063803 6.95368421 1.92454058 2.00390948 6.97821374 8.16394095 3.07657466 2.19589035 7.03174126 8.05959233 3.32694068 2.31668522 6.60258789 8.2905435 2.8557228 2.38499423 5.70044357 6.95559261 2.62691245 2.46580877 5.28826703 6.61606519 2.02669983 2.80432961

5.60211882 6.72743172 6.13772705 7.07072411 6.9255952 7.06731985 7.64969262 6.88550967 6.88038408 7.1808312 7.24494155 7.47760424

7.068172 7.9956436 7.85941315 8.63834831 8.54675199 8.82600055 9.09672365 8.30622522 8.37701116 9.36836924 10.4166105 12.0434302

2.41332113 3.04495092 2.91787883 3.53628173 3.60089488 3.5821569 3.81165003 3.44345834 3.57358083 4.93801442 6.01986248 7.62536139

3.73542901 3.82783673 3.84200818 4.06900966 4.20472247 4.28190239 4.49737337 4.509991 4.75577745 6.06421535 7.20061667 10.1690664

Resumen Estadísticas de la regresión Coeficiente d 0.98531729 Coeficiente 0.97085016 R^2 ajustado 0.95419312 Error típico 0.13323801 Observacione 12 ANÁLISIS DE VARIANZA Grados de libertad Suma de cuadrados

Regresión Residuos Total

Intercepción Variable X 1 Variable X 2 Variable X 3 Variable X 4

4 4.13876166 7 0.12426657 11 4.26302823 Coeficientes 1.95577609 0.45967608 0.07628389 -0.0003322 0.57538387

Error típico 0.69192825 0.26057833 0.21120282 0.16575998 0.11021737

Resumen lamda

3.23381948 Estadísticas de la regresión Coeficiente d Coeficiente R^2 ajustado Error típico Observacione

Promedio de los cuadradosF

Valor crítico de F

ANÁLISIS DE VARIANZA Grados de libertad

1.03469042 58.2846451 1.8599E-05 0.01775237

Estadístico t Probabilidad Inferior 95% Superior 95%Inferior 95.0% Superior 95.0% 2.82655911 0.02553187 0.31962578 3.59192641 0.31962578 3.59192641 1.76406102 0.12108218 -0.1564938 1.07584592 -0.1564938 1.07584592 0.36118785 0.72861405 -0.4231314 0.57569919 -0.4231314 0.57569919 -0.0020043 0.99845674 -0.3922923 0.39162783 -0.3922923 0.39162783 5.2204464 0.0012252 0.31476121 0.83600654 0.31476121 0.83600654

Regresión Residuos Total

Intercepción Variable X 1 Variable X 2 Variable X 3 Variable X 4

tadísticas de la regresión 0.99402852 0.9880927 0.98128853 0.23959956 12

NÁLISIS DE VARIANZA Grados de libertad Suma de cuadrados Promedio de los cuadradosF

Valor crítico de F

4 33.3468319 8.33670797 7 0.40185565 0.05740795 11 33.7486875 Coeficientes 4.17923195 -0.3513898 0.39711367 0.79432578 0.10180201

Error típico 1.89087641 0.32611547 0.46610838 0.50771532 0.28430569

145.2187 8.2133E-07

Estadístico t Probabilidad Inferior 95% Superior 95%Inferior 95.0% Superior 95.0% 2.21020894 0.06277788 -0.2919803 8.65044417 -0.2919803 8.65044417 -1.0775011 0.31698206 -1.1225303 0.41975076 -1.1225303 0.41975076 0.85197711 0.42241444 -0.7050575 1.49928486 -0.7050575 1.49928486 1.56451016 0.16167564 -0.4062302 1.99488175 -0.4062302 1.99488175 0.35807234 0.73084354 -0.5704741 0.77407815 -0.5704741 0.77407815

perior 95.0%

LN(y) LN(x1) LN(x2) LNx3 LNx4 6.91046161 5.59471138 6.94793707 2.0898868 3.07375756 7.22748456 6.97821374 8.16394095 3.07657466 2.19589035 5.15971026 5.29330482 6.3403593 1.39475844 0.52117192 6.04570412 5.37063803 6.95368421 1.92454058 2.00390948 6.52206044 6.54391185 7.73368357 2.71164374 1.91294412 6.57392874 5.28826703 6.61606519 2.02669983 2.80432961 6.90975927 6.60258789 8.2905435 2.8557228 2.38499423 7.7329644 6.72743172 7.9956436 3.04495092 3.82783673 13.4422187 7.47760424 12.0434302 7.62536139 10.1690664 6.50269409 5.70044357 6.95559261 2.62691245 2.46580877 9.99314936 7.1808312 9.36836924 4.93801442 6.06421535 7.01909449 6.34212142 7.60240134 2.71151087 2.98224168 6.06500075 5.9348942 7.38274645 1.6540288 1.21817152 8.61217532 7.64969262 9.09672365 3.81165003 4.49737337 8.62353413 7.06731985 8.82600055 3.5821569 4.28190239 8.84888387 6.9255952 8.54675199 3.60089488 4.20472247 7.28284434 5.80814249 7.84619882 2.49526944 3.17329251 7.33863274 5.60211882 7.068172 2.41332113 3.73542901 11.1769723 7.24494155 10.4166105 6.01986248 7.20061667 8.48808997 6.88038408 8.37701116 3.57358083 4.75577745 8.06900397 6.88550967 8.30622522 3.44345834 4.509991 7.80398044 6.13772705 7.85941315 2.91787883 3.84200818 6.51872389 6.07073773 7.21450441 2.32209356 1.93989208 7.38574878 6.02344759 7.63819824 2.49039158 3.0956681 7.10561302 6.80903931 7.89989532 2.9370963 2.83673654 6.99940787 7.03174126 8.05959233 3.32694068 2.31668522 6.28867978 5.86078622 7.30921237 2.41090124 1.75319188 7.18230424 6.67708346 7.84267147 3.08717133 3.06553815 5.33396922 5.04985601 6.33150185 0.68208623 1.16844925 7.97482874 7.07072411 8.63834831 3.53628173 4.06900966 8.02228029 6.82110747 8.14902387 3.02771532 3.21044035 7.08495038 5.41164605 6.54391185 1.94890566 3.38848357

Resumen Estadísticas de la regresión Coeficiente d 0.99308177 Coeficiente 0.9862114 R^2 ajustado 0.98416865 Error típico 0.20526143 Observacione 32 ANÁLISIS DE VARIANZA Grados de libertad Regresión 4 Residuos 27 Total 31

Intercepción Variable X 1 Variable X 2 Variable X 3 Variable X 4

Coeficientes 2.15957673 0.00986211 0.38491585 0.12602472 0.56206928

Análisis de los residuales Observación Pronóstico para Y 1 6.88016561 2 6.9927939 3 5.12099345 4 6.25800149 5 6.61787218 6 6.59000038 7 7.11627745 8 7.8388219 9 13.5457328 10 6.61012426 11 9.86724976 12 7.16635206 13 5.95298876 14 8.74468953 15 8.48470906 16 8.33480515 17 7.33505945

18 19 20 21 22 23 24 25 26 27 28 29 30 31 32

7.33918492 11.0464426 8.57531217 8.39356842 7.77252003 6.37941906 7.21287507 7.23211237 7.05260375 6.32005661 7.35630016 5.38918356 8.28707045 7.54959258 6.8819752

Suma de cuadrados Promedio de los cuadradosF Valor crítico de F 81.3632754 20.3408189 482.784939 1.0947E-24 1.13757092 0.04213226 82.5008464 Error típico 0.6934502 0.10839501 0.1454567 0.14403281 0.0596801

Residuos 0.030296 0.23469066 0.0387168 -0.2122974 -0.0958117 -0.0160716 -0.2065182 -0.1058575 -0.1035141 -0.1074302 0.1258996 -0.1472576 0.11201199 -0.1325142 0.13882507 0.51407872 -0.0522151

Estadístico t Probabilidad Inferior 95% Superior 95%Inferior 95.0% Superior 95.0% 3.11424918 0.00433418 0.73673444 3.58241901 0.73673444 3.58241901 0.09098305 0.9281777 -0.2125461 0.23227031 -0.2125461 0.23227031 2.64625725 0.01340953 0.08646335 0.68336835 0.08646335 0.68336835 0.87497228 0.38930624 -0.1695062 0.42155563 -0.1695062 0.42155563 9.4180355 5.0574E-10 0.43961584 0.68452273 0.43961584 0.68452273

RESIDUOS^2 0.00091785 0.0550797 0.00149899 0.04507017 0.00917989 0.0002583 0.04264976 0.01120581 0.01071516 0.01154124 0.01585071 0.02168479 0.01254669 0.01756002 0.0192724 0.26427693 0.00272642

-0.0005522 0.13052975 -0.0872222 -0.3245645 0.03146041 0.13930483 0.17287371 -0.1264994 -0.0531959 -0.0313768 -0.1739959 -0.0552143 -0.3122417 0.4726877 0.20297518

3.049E-07 0.01703801 0.00760771 0.10534208 0.00098976 0.01940584 0.02988532 0.01600209 0.0028298 0.0009845 0.03027458 0.00304862 0.09749488 0.22343366 0.04119892 1.13757092

SUMA R^2 1.13757092 0.03554909

pi x1* x2* x3* 0.02581916 5.59471138 6.94793707 2.0898868 1.54939837 6.97821374 8.16394095 3.07657466 0.04216679 5.29330482 6.3403593 1.39475844 1.26782907 5.37063803 6.95368421 1.92454058 0.25823131 6.54391185 7.73368357 2.71164374 0.00726594 5.28826703 6.61606519 2.02669983 1.19974264 6.60258789 8.2905435 2.8557228 0.31522075 6.72743172 7.9956436 3.04495092 0.30141875 7.47760424 12.0434302 7.62536139 0.32465644 5.70044357 6.95559261 2.62691245 0.44588224 7.1808312 9.36836924 4.93801442 0.60999569 6.34212142 7.60240134 2.71151087 0.3529397 5.9348942 7.38274645 1.6540288 0.49396524 7.64969262 9.09672365 3.81165003 0.54213479 7.06731985 8.82600055 3.5821569 7.43414034 6.9255952 8.54675199 3.60089488 0.07669446 5.80814249 7.84619882 2.49526944 8.5769E-06 5.60211882 7.068172 2.41332113 0.4792813 7.24494155 10.4166105 6.01986248 0.2140058 6.88038408 8.37701116 3.57358083 2.96328481 6.88550967 8.30622522 3.44345834 0.02784199 6.13772705 7.85941315 2.91787883 0.54588838 6.07073773 7.21450441 2.32209356 0.84067744 6.02344759 7.63819824 2.49039158 0.45014051 6.80903931 7.89989532 2.9370963 0.07960264 7.03174126 8.05959233 3.32694068 0.02769424 5.86078622 7.30921237 2.41090124 0.85162745 6.67708346 7.84267147 3.08717133 0.08575811 5.04985601 6.33150185 0.68208623 2.7425422 7.07072411 8.63834831 3.53628173 6.28521446 6.82110747 8.14902387 3.02771532 1.15893044 5.41164605 6.54391185 1.94890566

x4* 3.07375756 2.19589035 0.52117192 2.00390948 1.91294412 2.80432961 2.38499423 3.82783673 10.1690664 2.46580877 6.06421535 2.98224168 1.21817152 4.49737337 4.28190239 4.20472247 3.17329251 3.73542901 7.20061667 4.75577745 4.509991 3.84200818 1.93989208 3.0956681 2.83673654 2.31668522 1.75319188 3.06553815 1.16844925 4.06900966 3.21044035 3.38848357

Resumen Estadísticas de la regresión Coeficiente d 0.37015171 Coeficiente 0.13701229 R^2 ajustado 0.00916225 Error típico 1.69314702 Observacione 32

Theta

6.14437916

ANÁLISIS DE VARIANZA Grados de libertad Suma de cuadrados Promedio de los cuadradosF Valor crítico de F Regresión 4 12.2887583 3.07218958 1.07166407 0.38981291 Residuos 27 77.4021643 2.86674683 Total 31 89.6909226

Intercepción Variable X 1 Variable X 2 Variable X 3 Variable X 4

Coeficientes -6.8182553 1.55309111 -0.0418489 -0.9856999 0.35734318

Error típico 5.72008641 0.89412167 1.19983368 1.18808837 0.49228527

Estadístico t Probabilidad Inferior 95% -1.1919847 0.24363914 -18.554903 1.73700198 0.09378426 -0.281495 -0.0348789 0.9724329 -2.5037042 -0.829652 0.41401097 -3.4234559 0.72588639 0.47415413 -0.6527428

or crítico de F

Superior 95%Inferior 95.0% Superior 95.0% 4.91839259 -18.554903 4.91839259 3.38767724 -0.281495 3.38767724 2.4200065 -2.5037042 2.4200065 1.45205608 -3.4234559 1.45205608 1.36742911 -0.6527428 1.36742911

Entidad Aguascalientes Baja California Baja California Sur Campeche Coahuila de Zaragoza Colima Chiapas Chihuahua Ciudad de México Durango Guanajuato Guerrero Hidalgo Jalisco México Michoacán de Ocampo Morelos Nayarit Nuevo León Oaxaca Puebla Querétaro Quintana Roo San Luis Potosí Sinaloa Sonora Tabasco Tamaulipas Tlaxcala Veracruz de Ignacio de la Llave Yucatán Zacatecas

POBREZA (y)

PROM ESC (X1) 28.2 22.1 22.1 43.8

9.7 9.7 9.8 9.1

ESP VIDA (X2) 75.9 74.2 76.2 75.4

24.8 33.6 77.1 30.8 27.9 36 42.4 64.4 50.6 31.8 47.9

9.8 9.5 7.2 9.4 11.1 9.1 8.3 7.6 8.7 9.2 9.5

76 76.1 73 73.5 76.2 76 75.6 73.1 74.6 75.7 75.4

55.3 49.5 37.5 14.2 70.4 59.4 31.1 28.8 45.5 30.8 27.9 50.9 32.2 53.9

7.9 9.2 9.1 10.2 7.5 8.5 9.5 9.6 8.8 9.5 10 9.3 9.4 9.2

74.9 75.9 75.4 76.7 73.2 75 75.5 75.8 74.9 75.8 75.5 74.9 76 75.4

62.2 41.9 49

8.2 8.8 8.6

74.2 75.6 75.5

POBREZA= porcentaje de la población en situación de pobreza 2016, porcentaje PROM ESC= años promedio de escolaridad 2015, promedio ESP VIDA= esperanza de vida al nacer 2016, años HOMICIDIOS= tasa de homicidios 2016, homicidios por cada 100 habitantes DESEMPLEO= tasa de desocupación 2016, porcentaje SV= satisfacción con la vida 2014, calificación promedio

DESEMPLEO (x4)

SV (X5)

4 2.6 4.6 3.7

7.7 8.3 8.3 7.8

Resumen

4.4 4.1 3.1 3.2 5 4.5 4 2 3.1 3.7 5.2

8 7.8 7.9 8.3 8.4 8.2 7.9 7.7 8 7.8 7.9

Coeficiente 0.71131577 R^2 ajustado 0.680385317 Error típico 0.466623513 Observacione 32

2.7 2.6 4 4.3 2 3 4.5 3.2 2.4 3.7 5 7.4 4.6 4.1

7.6 7.7 7.9 8.3 7.5 7.6 8.3 8 8 7.9 8 7.9 8.3 7.8

Coeficientes -34.06271208 0.426898379 0.152547087 1.316776674

3.6 2 2.8

7.7 8 8.1

Estadísticas de la regresión Coeficiente d 0.843395382

0.95 FIV

ANÁLISIS DE VARIANZA Grados de libertad Suma de cuadrados Promedio de los cuadrados Regresión 3 15.0220999 5.00736664 Residuos 28 6.09665007 0.2177375 Total 31 21.11875

Intercepción Variable X 1 Variable X 2 Variable X 3

Error típico 7.34310696 0.1002309 0.08442455 0.37168393

Estadístico t -4.6387329 4.25914928 1.80690441 3.54273231

ESP VIDA (X2) 75.9 74.2 76.2 75.4 3.4639925

F Valor crítico de F 22.997263 1.0342E-07

ProbabilidadInferior 95% Superior 95%Inferior 95.0% Superior 95.0% 7.444E-05 -49.104385 -19.021039 -49.104385 -19.021039 0.000209 0.22158468 0.63221208 0.22158468 0.63221208 0.0815354 -0.0203888 0.32548293 -0.0203888 0.32548293 0.0014104 0.55541665 2.07813669 0.55541665 2.07813669

76 76.1 73 73.5 76.2 76 75.6 73.1 74.6 75.7 75.4 74.9 75.9 75.4 76.7 73.2 75 75.5 75.8 74.9 75.8 75.5 74.9 76 75.4 74.2 75.6 75.5

PROM ESC (X1)

DESEMPLEO (x4)

SV (X5)

9.7 9.7 9.8 9.1

4 2.6 4.6 3.7

7.7 8.3 8.3 7.8

9.8 9.5 7.2 9.4 11.1 9.1 8.3 7.6 8.7 9.2 9.5

4.4 4.1 3.1 3.2 5 4.5 4 2 3.1 3.7 5.2

8 7.8 7.9 8.3 8.4 8.2 7.9 7.7 8 7.8 7.9

7.9 9.2 9.1 10.2 7.5 8.5 9.5 9.6 8.8 9.5 10 9.3 9.4 9.2

2.7 2.6 4 4.3 2 3 4.5 3.2 2.4 3.7 5 7.4 4.6 4.1

7.6 7.7 7.9 8.3 7.5 7.6 8.3 8 8 7.9 8 7.9 8.3 7.8

8.2 8.8 8.6

3.6 2 2.8

7.7 8 8.1

Resumen Estadísticas de la regresión Coeficiente d 0.7335529 Coeficiente 0.5380998 R^2 ajustado 0.4886105 Error típico 0.6853691 Observacione 32 ANÁLISIS DE VARIANZA Grados de libertad Regresión 3 Residuos 28 Total 31

Coeficientes Intercepción 72.443155 Variable X 1 0.920959 Variable X 2 0.0568452 Variable X 3 -0.72997

DESEMPLEO (x4) 4 2.6 4.6 3.7

FIV

2.16497005

Suma de cuadrados Promedio de los cuadradosF Valor crítico de F 15.322225 5.10740832 10.8730538 6.5756E-05 13.1524625 0.4697308 28.4746875

Error típico 4.27695209 0.21623075 0.13059052 0.642335

Estadístico t Probabilidad Inferior 95% Superior 95%Inferior 95.0% Superior 95.0% 16.9380329 3.0141E-16 63.6822158 81.2040942 63.6822158 81.2040942 4.25914928 0.000209 0.47803042 1.36388763 0.47803042 1.36388763 0.43529383 0.66668625 -0.2106573 0.3243478 -0.2106573 0.3243478 -1.1364316 0.26540913 -2.0457334 0.58579382 -2.0457334 0.58579382

4.4 4.1 3.1 3.2 5 4.5 4 2 3.1 3.7 5.2 2.7 2.6 4 4.3 2 3 4.5 3.2 2.4 3.7 5 7.4 4.6 4.1 3.6 2 2.8

PROM ESC (X1) ESP VIDA (X2) 9.7 75.9 9.7 74.2 9.8 76.2 9.1 75.4

SV (X5) 7.7 8.3 8.3 7.8

9.8 9.5 7.2 9.4 11.1 9.1 8.3 7.6 8.7 9.2 9.5

76 76.1 73 73.5 76.2 76 75.6 73.1 74.6 75.7 75.4

8 7.8 7.9 8.3 8.4 8.2 7.9 7.7 8 7.8 7.9

7.9 9.2 9.1 10.2 7.5 8.5 9.5 9.6 8.8 9.5 10 9.3 9.4 9.2

74.9 75.9 75.4 76.7 73.2 75 75.5 75.8 74.9 75.8 75.5 74.9 76 75.4

7.6 7.7 7.9 8.3 7.5 7.6 8.3 8 8 7.9 8 7.9 8.3 7.8

8.2 8.8 8.6

74.2 75.6 75.5

7.7 8 8.1

Resumen Estadísticas de la regresión Coeficiente d 0.56147562 Coeficiente 0.31525487 R^2 ajustado 0.24188932 Error típico 0.98848329 Observacione 32

FIV

ANÁLISIS DE VARIANZA Grados de libertad Suma de Promedio cuadradosde los cuadrados Regresión 3 12.59591 4.19863657 Residuos 28 27.358778 0.97709921 Total 31 39.954688

Intercepción Variable X 1 Variable X 2 Variable X 3

Coeficientes Error típico -10.632592 20.588554 0.68455657 0.378856 0.11824527 0.2716447 -0.0961948 0.9473666

Estadístico t -0.5164322 1.80690441 0.43529383 -0.1015392

SV (X5) PROM ESC (X1) ESP VIDA (X2) 7.7 9.7 75.9 8.3 9.7 74.2 8.3 9.8 76.2 7.8 9.1 75.4 1.46039738

F Valor crítico de F 4.29704225 0.01295031

Probabilidad Inferior 95% Superior 95%Inferior 95.0% Superior 95.0% 0.60960753 -52.806334 31.5411495 -52.806334 31.5411495 0.08153536 -0.0914948 1.4606079 -0.0914948 1.4606079 0.66668625 -0.4381937 0.67468426 -0.4381937 0.67468426 0.91984612 -2.0367873 1.84439769 -2.0367873 1.84439769

8 7.8 7.9 8.3 8.4 8.2 7.9 7.7 8 7.8 7.9

9.8 9.5 7.2 9.4 11.1 9.1 8.3 7.6 8.7 9.2 9.5

76 76.1 73 73.5 76.2 76 75.6 73.1 74.6 75.7 75.4

7.6 7.7 7.9 8.3 7.5 7.6 8.3 8 8 7.9 8 7.9 8.3 7.8

7.9 9.2 9.1 10.2 7.5 8.5 9.5 9.6 8.8 9.5 10 9.3 9.4 9.2

74.9 75.9 75.4 76.7 73.2 75 75.5 75.8 74.9 75.8 75.5 74.9 76 75.4

7.7 8 8.1

8.2 8.8 8.6

74.2 75.6 75.5

DESEMPLEO (x4) 4 2.6 4.6 3.7

Resumen Estadísticas de la regresión Coeficiente d 0.63885733

4.4 4.1 3.1 3.2 5 4.5 4 2 3.1 3.7 5.2

Coeficiente 0.40813869 R^2 ajustado 0.34472498 Error típico 0.19714797 Observacione 32

2.7 2.6 4 4.3 2 3 4.5 3.2 2.4 3.7 5 7.4 4.6 4.1

Coeficientes 10.3764277 0.23505175 -0.0604005 -0.0038265

3.6 2 2.8

1.68958501 FIV

ANÁLISIS DE VARIANZA Grados de libertad Suma de cuadrados Promedio de los cuadradosF Valor crítico de F Regresión 3 0.75046501 0.250155 6.43612675 0.00187524 Residuos 28 1.08828499 0.03886732 Total 31 1.83875

Intercepción Variable X 1 Variable X 2 Variable X 3

Error típico 3.62998592 0.06634759 0.05314925 0.03768461

Estadístico t Probabilidad Inferior 95% 2.85853111 0.00794644 2.94073858 3.54273231 0.00141041 0.09914487 -1.1364316 0.26540913 -0.1692718 -0.1015392 0.91984612 -0.0810199

or crítico de F

Superior 95%Inferior 95.0% Superior 95.0% 17.8121167 2.94073858 17.8121167 0.37095863 0.09914487 0.37095863 0.04847082 -0.1692718 0.04847082 0.07336696 -0.0810199 0.07336696