Base Generacion y AtraccionVIAJES GENERADOS VIAJES ATRAIDOS VIAJES GENERADOS/HAB VIAJES ATRAIDOS/HABZATLOCALIDADNOMLOCALIDADAUTOSESTRATOHABITANTESINDICE DE MOTORIZACINUSO EMPLEO (HAB)% EMPLEOUSO_ESTUDIO (HAB)% ESTUDIOEMPLEO+ESTUDIO% EMPLEO+ESTUDIOINGRESO PER CAPITAAUTOSTRANS_PUBTOTALAUTOSTRANS_PUBTOTALAUTOSTRANS_PUBTOTALAUTOSTRANS_PUBTOTAL

11Usaquen3,454241,6410.08313,7510.6127,6291.641,3811.0117,5796,43624,36730,8038,20822,26130,4690.1550.5850.7400.19712179150.53458855850.7317103521Usaquen1,177321,9850.05415,7590.7027,2981.643,0571.175,6242,72711,92914,65611,91730,37742,2950.1240.5430.6670.5420682871.38171799151.923786278531Usaquen6,328369,2230.09116,4230.7317,6111.034,0340.9145,08911,90936,42248,3306,69616,61723,3120.1720.5260.6980.09672362270.24004263370.336766256441Usaquen5,469434,1150.16012,2330.558,5260.520,7590.5159,12910,56918,33728,9066,21713,27919,4960.3100.5380.8470.18224831540.3892358970.571484212451Usaquen20,459483,6470.24526,1551.1717,1761.043,3311.1259,29341,47135,63077,10119,89528,44748,3420.4960.4260.9220.23783978590.3400884380.577928223961Usaquen8,578533,4130.25716,5970.746,0740.322,6710.6243,78416,94610,45727,4037,61421,80629,4200.5070.3130.8200.22787661360.65260244770.880479061471Usaquen20,812484,6290.24667,0362.9920,2651.287,3012.2275,11243,01735,30378,31946,96594,346141,3110.5080.4170.9250.55494821211.11482156731.669769779481Usaquen16,900546,0340.36747,5252.1211,1860.658,7111.5339,22737,6728,88946,56129,86061,42591,2850.8180.1931.0110.6486439421.33432213171.982966073792Chapinero18,485647,7970.38773,1903.266,7480.479,9372.0360,91944,2058,90853,11343,26481,418124,6820.9250.1861.1110.90515783071.70341990482.6085777355102Chapinero19,961543,0730.46379,7173.5626,5061.5106,2232.7570,76940,7336,36947,10252,846109,194162,0410.9460.1481.0941.22690289672.535093763.7619966567112Chapinero6,122434,3560.17861,1282.7330,4001.791,5292.3168,92612,40912,83925,24830,815114,992145,8080.3610.3740.7350.89693917683.34705839824.2439975751122Chapinero3,384420,5700.16540,5471.8121,0721.261,6181.5156,8208,2329,47317,70524,61381,014105,6270.4000.4610.8611.19654856613.93842691875.1349754848132Chapinero4,019427,6410.14539,7111.7756,5583.296,2692.4238,9537,99516,27324,26729,578118,320147,8980.2890.5890.8781.07008727164.28058054615.3506678177143Santa Fe20544,5200.04522,4501.0012,6280.735,0780.9225,0004852,4162,90112,84341,86854,7110.1070.5340.6422.84127415479.262754179612.1040283343153Santa Fe1,326321,9220.06041,9411.8725,6631.567,6041.781,9322,75113,77316,52419,10676,97496,0800.1250.6280.7540.87154098083.51126437794.3828053587163Santa Fe1,776329,7170.060183,9378.2074,7084.3258,6456.5129,4294,81012,60317,41383,352401,858485,2100.1620.4240.5862.804850307813.522769320516.3276196283173Santa Fe957230,2300.03226,6841.1916,2920.942,9761.170,6471,38716,10717,4948,50252,62161,1220.0460.5330.5790.28122931951.74066630852.021895628183Santa Fe617261,5700.0104,6560.2120,9201.225,5760.658,59279739,22940,0265,10218,17123,2730.0130.6370.6500.08286303080.29512636930.37798940011917La Candelaria248211,4020.0226,2050.2817,5341.023,7390.6108,0533055,1965,5016,27119,26325,5340.0270.4560.4820.55001750551.68940995322.23942745872017La Candelaria402217,9190.02225,9681.1622,5931.348,5611.248,3371,1058,5309,63511,18845,94957,1380.0620.4760.5380.62437640932.56424892013.1886253294214San Cristobal1,114318,2910.0612,6730.122,2950.14,9670.175,7872,45012,11114,5615553,7934,3480.1340.6620.7960.03033583740.20735065820.2376864955224San Cristobal1,158250,3100.0235,9540.279,6650.615,6190.461,6832,24936,08538,3341,47610,54612,0220.0450.7170.7620.02934706970.20961366660.2389607364234San Cristobal1,148313,9350.0824,0810.184,1370.28,2180.288,2314,63310,26314,8963,5305,2438,7730.3320.7361.0690.25331676840.37622088010.6295376485244San Cristobal2,855259,3160.04816,1250.7224,6991.440,8241.084,9717,21850,42857,6466,47535,08941,5640.1220.8500.9720.10915859940.5915608620.7007194614254San Cristobal2,7362149,5660.0189,3660.4227,1161.636,4810.954,4403,46197,043100,5042,14814,38716,5350.0230.6490.6720.01435915920.09619163710.1105507963264San Cristobal1,4372114,4190.0139,1790.4128,2651.637,4430.945,1502,40172,56174,96356610,97311,5390.0210.6340.6550.004942980.09590583650.1008488165275Usme0110,7480.0008710.043,4050.24,2760.134,67106,6236,62301,9531,9530.0000.6160.61600.18168527870.1816852787285Usme1,151250,8680.0234,0360.186,4430.410,4780.374,1961,76339,08540,84803,0703,0700.0350.7680.80300.06034884120.0603488412295Usme195129,9290.0072,2890.108,1810.510,4700.339,46028417,04517,328562,7402,7960.0090.5690.5790.0018857450.09155147570.0934372207305Usme983274,7310.0138,4460.3823,1311.331,5770.853,2721,49947,73949,2381,19017,55118,7410.0200.6390.6590.01591812030.23485554290.2507736631315Usme510245,8070.0114,8300.2215,4550.920,2860.544,54467326,90427,5773898,3728,7610.0150.5870.6020.00848823520.18276822410.1912564593326Tunjuelito2,507360,2680.04211,6670.5214,6410.826,3080.765,6384,53341,13145,6642,42114,45816,8780.0750.6820.7580.04016279090.23988816310.280050954336Tunjuelito1,645325,1570.0655,4700.2414,6250.820,0950.5120,1913,73218,94422,67694317,74218,6850.1480.7530.9010.03748633390.70525348730.7427398212346Tunjuelito2,448283,6480.0299,8270.4420,8591.230,6860.864,6703,83856,80660,6434,45119,14923,6000.0460.6790.7250.05320949990.22892594820.2821354481356Tunjuelito3,193350,5120.06317,2830.7712,5810.729,8640.7131,4705,55037,29242,8414,01831,40635,4230.1100.7380.8480.07953567580.62174205270.7012777285367Bosa2,773338,4980.0726,3110.286,0780.312,3890.3100,1694,94226,86331,8052,61011,18413,7940.1280.6980.8260.0677972310.290508340.358305571377Bosa3,1582159,2660.02022,5631.0147,1642.769,7271.755,0474,764102,020106,7845,64842,27747,9240.0300.6410.6700.03545968410.26544556990.300905254387Bosa630268,2190.0094,8950.2213,9540.818,8490.542,02595935,37536,3342433,3093,5520.0140.5190.5330.00356144790.04850806820.052069516398Ciudad Kennedy6,320373,3780.08621,4720.9611,5430.733,0150.8107,18014,78945,52860,3177,41227,05434,4660.2020.6200.8220.10101429130.36869004930.4697043406408Ciudad Kennedy2,368332,1430.07410,0960.459,0650.519,1620.578,6865,41520,42325,8393,85616,01219,8690.1680.6350.8040.11997498370.49815252190.6181275056418Ciudad Kennedy1,438414,7770.0977,8780.352,8270.210,7060.3154,8393,87310,15914,0312,8339,87312,7060.2620.6870.9500.19170562920.66815609520.8598617244428Ciudad Kennedy7,160364,7200.11114,1340.638,6910.522,8250.6134,21519,03039,59558,6256,68320,00426,6870.2940.6120.9060.10325637570.30909169320.4123480688438Ciudad Kennedy7,0933118,2920.06032,7071.4637,4802.170,1881.898,06517,64772,83990,48611,31866,11277,4300.1490.6160.7650.09567826260.55888853940.654566802448Ciudad Kennedy4,614393,3050.04915,8770.7116,9591.032,8370.882,33910,55864,27074,8283,44826,86030,3070.1130.6890.8020.03695091860.2878698790.3248207976458Ciudad Kennedy1,2522116,1130.01121,3060.9527,3731.648,6791.257,3982,03779,39281,4295,80633,51739,3230.0180.6840.7010.05000250530.28866263120.3386651366468Ciudad Kennedy3,9862147,7080.02713,2860.5924,2041.437,4900.965,2626,333107,544113,8782,87819,90122,7790.0430.7280.7710.01948620270.13473091690.1542171196479Fontibon1,792416,5510.10810,9570.499050.111,8620.3214,2113,66212,31915,9814,20116,60220,8030.2210.7440.9660.25382523591.00304824511.256873481499Fontibon12,054458,1060.20718,8300.846,5900.425,4200.6226,26826,04329,11255,1556,98521,66128,6460.4480.5010.9490.12021649710.3727885790.4930050761509Fontibon6,8543104,2530.06621,3360.9518,9701.140,3061.087,83512,57560,23372,8087,37226,66234,0340.1210.5780.6980.07071451340.25574062230.3264551357519Fontibon6,4142104,2310.06235,8831.6036,4312.172,3151.880,0559,44060,56170,00111,39150,21461,6050.0910.5810.6720.1092852830.4817585840.591043867539Fontibon1,481233,9610.0445,0210.223,2470.28,2680.271,1434,31925,21829,5381,3666,1447,5090.1270.7430.8700.04021163170.180902830.22111446165410Engativa5,440387,4740.06224,4701.0924,4281.448,8971.295,56214,20063,22877,42910,35447,11457,4680.1620.7230.8850.11836428790.53860546040.65696974845510Engativa12,2453139,4390.08830,7931.3734,4522.065,2461.6101,69827,24789,525116,77213,32851,43264,7590.1950.6420.8370.09558047370.36884688510.46442735885610Engativa2,395411,0550.21711,4650.5116,5160.927,9810.7258,5225,3297,15812,4878,15524,47432,6290.4820.6471.1300.7376653082.2138349292.9515002375710Engativa8,4363142,6410.05925,2481.1333,7431.958,9911.599,11422,006103,043125,04911,28436,19447,4780.1540.7220.8770.07910715320.25374283030.33284998355810Engativa6,4443106,5840.06024,6551.1014,5210.839,1761.089,63312,40287,47499,8766,38833,43339,8210.1160.8210.9370.05993827350.31367726660.37361554025910Engativa6,818356,0730.12213,8680.627,5110.421,3790.5135,1859,70735,48745,1946,18612,08118,2670.1730.6330.8060.11031315460.21545812390.32577127856010Engativa5,095388,4900.05810,4860.4711,8890.722,3750.692,14512,19166,03878,2303,72016,08419,8040.1380.7460.8840.04204073860.18175966220.22380040076110Engativa6,2842152,1700.04119,7480.8826,7491.546,4971.297,06511,579108,342119,9216,92626,47433,4000.0760.7120.7880.04551457540.17397436210.21948893746210Engativa2,287350,6390.0455,8350.269,0080.514,8430.494,9834,08634,12538,2102,1146,1148,2280.0810.6740.7550.04174354690.12074372270.16248726966311Suba23,833484,7800.28130,4281.3610,2100.640,6381.0278,38345,78830,84476,63219,58537,27956,8640.5400.3640.9040.23101417550.43971193430.67072610976411Suba9,957365,7500.15112,8000.579,7600.622,5610.6172,50218,35233,04451,3954,41511,78016,1950.2790.5030.7820.06714521230.17916359590.24630880826511Suba6,058343,4920.1399,4620.429,7590.619,2200.5180,89711,87123,21035,0813,1656,88810,0530.2730.5340.8070.07277286380.15837198220.2311448466611Suba4,865427,2180.1797,0530.3113,0480.720,1010.5181,52210,63714,24824,8853,8878,28512,1720.3910.5230.9140.14280070830.30440679420.44720750246711Suba14,553541,7590.34920,8420.937,0590.427,9010.7377,88034,35114,62048,97116,71026,17342,8830.8230.3501.1730.40016884690.62675819931.02692704626811Suba4,3032139,9710.03122,3121.0029,4451.751,7571.375,7587,46599,536107,0014,27533,66337,9390.0530.7110.7640.03054395640.24050136790.27104532436911Suba4,455375,0620.05912,5260.5621,8441.334,3700.995,3619,92143,54253,4636,31218,10024,4120.1320.5800.7120.08409487760.24113209310.32522697067011Suba1,876266,6080.0288,6700.3912,5200.721,1900.559,4832,91840,50643,4241,51511,39512,9090.0440.6080.6520.02273820550.17106841270.19380661827112Barrios Unidos7,613450,6600.15023,1961.037,7140.430,9110.8245,18414,11825,53039,6477,44027,79835,2380.2790.5040.7830.14685456520.54871451330.69556907857212Barrios Unidos7,388338,3020.19318,0610.815,8110.323,8720.6216,41417,26616,11333,37910,61622,15332,7690.4510.4210.8710.27716695330.57836319660.85553014997312Barrios Unidos4,754350,7410.09437,3911.6720,3441.257,7361.4135,2739,37128,86838,24020,26463,68983,9540.1850.5690.7540.39936977091.25517750281.65454727387412Barrios Unidos3,272373,2180.04522,9251.0217,2771.040,2021.088,0237,54050,14157,6807,89432,55940,4530.1030.6850.7880.10781910660.44467904550.55249815217512Barrios Unidos3,505423,7770.14712,5700.5612,1860.724,7560.6235,0009,90416,67526,5795,32928,46133,7900.4170.7011.1180.22412109821.19698719321.42110829147613Teusaquillo4,571432,5780.14038,7501.7323,6701.462,4201.6156,2929,96816,04326,01118,71763,42582,1430.3060.4920.7980.57454090911.94686836982.52140927897713Teusaquillo4,587430,5010.15022,0540.9824,7411.446,7951.2172,2666,26013,67719,93715,38551,66067,0440.2050.4480.6540.50439144341.69370272392.19809416737813Teusaquillo4,037426,2910.15423,6091.0514,3790.837,9881.0182,5208,62013,41522,03613,66041,58955,2490.3280.5100.8380.51956228891.58186165022.10142393917913Teusaquillo5,473426,3270.20812,4460.5617,2771.029,7230.7265,49112,28410,42222,7068,04929,37237,4210.4670.3960.8620.30572255541.11564636561.42136892098013Teusaquillo6,527426,6660.24535,2151.577,5890.442,8041.1246,21018,23811,98730,22520,50444,81065,3140.6840.4501.1330.76891919721.68040966142.44932885878113Teusaquillo4,610423,9530.19212,2470.552,8540.215,1000.4202,1927,96510,66918,6345,15015,62320,7730.3330.4450.7780.21502018220.65221410520.86723428748213Teusaquillo104720.1435,8210.268570.06,6790.2112,50043591021,8209,27011,0900.5970.8251.42225.2798825033128.7445334852154.02441598848314Los Martires1,177330,1390.03926,9601.2012,5740.739,5341.091,6672,55815,94318,50012,02238,99451,0160.0850.5290.6140.39889315341.29379921181.69269236528414Los Martires2,901316,8050.17348,5892.176,8150.455,4051.4159,49410,4737,98918,46217,81272,36890,1800.6230.4751.0991.0599219524.30635036275.36627231478514Los Martires1,767320,3180.08719,1730.867,4550.426,6290.775,1103,5688,85012,4199,41326,98736,4000.1760.4360.6110.46326699221.32820753811.79147453028614Los Martires1,683325,6730.0669,0380.407,3210.416,3590.489,5512,82018,52121,3415,42210,69516,1170.1100.7210.8310.21117466810.41659711420.62777178238714Los Martires5,799336,8650.15731,6621.4115,2520.946,9131.2138,35213,64125,69939,34012,97248,93261,9040.3700.6971.0670.35188752141.32731993981.67920746128815Antonio Nario1,859225,9120.0727,0490.318,2700.515,3190.469,5813,21211,79715,0102,29010,15812,4480.1240.4550.5790.08837703730.39202647140.48040350878915Antonio Nario3,698431,4330.1186,6550.306,4830.413,1380.3125,1296,23317,33523,5681,1958,3619,5550.1980.5510.7500.03800229920.26598826680.3039905669015Antonio Nario1,778318,7970.0955,6100.257,5560.413,1650.3112,3153,9468,24412,1902,60613,42916,0350.2100.4390.6490.13865118420.71439638140.85304756569115Antonio Nario2,779334,1940.08117,9190.8012,3120.730,2310.883,6823,97718,02021,9973,30234,63137,9330.1160.5270.6430.09655976021.01278064211.10934040239215Antonio Nario5,442347,6800.11414,4090.6414,7330.829,1420.7108,29211,84929,21441,0635,22324,96830,1910.2490.6130.8610.10954366140.52366503380.63320869519316Puente Aranda11933,1970.03724,6461.105,5750.330,2210.865,9432321,3511,5837,87634,85442,7300.0720.4230.4952.463469046410.901511351713.36498039819416Puente Aranda3,456410,2740.3368,8130.398940.19,7070.2182,8897,3883,61411,0034,18910,70914,8980.7190.3521.0710.40775363511.04230114341.45005477859516Puente Aranda17233,5130.04929,2161.302,8810.232,0960.870,0172421,4491,6918,37237,93746,3090.0690.4120.4812.382995162110.798809346213.18180450849616Puente Aranda4,104339,0990.10510,0910.456,1980.416,2890.4184,6848,70027,38036,0804,56211,03515,5960.2230.7000.9230.1166667980.2822212320.398888039716Puente Aranda8,170368,5650.11913,6210.617,2990.420,9210.5137,26217,72249,66367,3854,16510,36514,5300.2580.7240.9830.0607487770.15117037350.21191915049816Puente Aranda58836,9880.08433,5521.501,4320.134,9830.978,5054194,0104,4299,52345,28354,8060.0600.5740.6341.36278074486.48000371497.84278445979916Puente Aranda7,2273110,9120.06555,4292.4721,9911.377,4201.9100,43613,36271,98485,34614,46073,26787,7260.1200.6490.7690.1303696260.66058832820.790957954210016Puente Aranda5,860364,4560.0917,9390.357,1300.415,0690.499,54417,71944,27961,9992,83911,00413,8430.2750.6870.9620.04404819130.17072259810.214770789310116Puente Aranda3,947378,1860.05021,0290.9417,2771.038,3061.093,0877,24560,01967,2645,64634,67740,3240.0930.7680.8600.07221726680.44352018630.515737453110218Rafael Uribe4,933365,4620.07515,4160.6926,0071.541,4241.095,29010,40043,58953,9896,02236,64242,6640.1590.6660.8250.09199409490.55974208580.651736180610318Rafael Uribe2,981361,5640.04813,4110.6018,7741.132,1850.8105,0095,91338,97644,8896,36631,11437,4800.0960.6330.7290.10340239630.50539406930.608796465610418Rafael Uribe2,633369,8340.03811,5560.5226,6881.538,2441.071,2824,83854,33359,1713,17233,63836,8100.0690.7780.8470.04542813090.48168587750.527114008310518Rafael Uribe2,2922133,7090.01713,9230.6222,5421.336,4660.952,0886,33494,324100,6583,81520,17023,9850.0470.7050.7530.02853071020.15084994060.179380650910619Ciudad Bolivar1,6402155,9400.01116,3880.7337,9272.254,3151.447,9562,61897,02299,6391,17121,24422,4150.0170.6220.6390.00751051610.13623320530.143743721310719Ciudad Bolivar1,027274,1370.0146,7950.3014,6920.821,4870.555,6012,21356,07758,29096812,06513,0330.0300.7560.7860.01305387090.16274621870.175800089610819Ciudad Bolivar4,0692132,3520.03122,2410.9926,5381.548,7801.269,24111,92994,718106,6467,26031,58838,8490.0900.7160.8060.05485585140.23866969640.2935255478TOTALES5,994,73310.6952,242,3391001,744,1461003,986,4841001,047,8113,706,5284,754,3391,002,9303,626,5434,629,473

est motorizacionindice de motorizacion

Media0.10090Error tpico0.00877Mediana0.06874ModaERROR:#N/ADesviacin estndar0.09027Varianza de la muestra0.00815Curtosis3.11311Coeficiente de asimetra1.68905Rango0.46341Mnimo0.00000Mximo0.46341Suma10.69550Cuenta106.00000

estadistica ingresosestadistica ingresos

Media130484.830198113Error tpico8316.0927238154Mediana99329.005ModaERROR:#N/ADesviacin estndar85619.414902556Varianza de la muestra7330684208.25603Curtosis6.2782463205Coeficiente de asimetra2.0506047206Rango536097.738Mnimo34671.493Mximo570769.231Suma13831392.001Cuenta106Nivel de confianza(95,0%)16489.275200966

SOCIOECONMICAS

PIBPOBLACIONPIB perAutosAutos per$ ctesCapitaCpita1985122,3374,200,22629.13274,0000.0651986128,2414,351,88029.47289,0000.0661987137,4454,508,81830.48307,0000.0681988143,9454,671,21930.82327,0000.0701989146,5914,839,26230.29343,0000.0711990154,2215,013,15430.76357,0000.0711991152,5445,164,63629.54372,0000.0721992161,7465,319,36830.41392,0000.0741993180,8375,484,24432.97442,0000.0811994205,6045,593,92936.75489,0000.0871995208,1965,678,34236.66498,0000.088

regresionResumen

Estadsticas de la regresinCoeficiente de correlacin mltiple0.9862673135Coeficiente de determinacin R^20.9727232136R^2 ajustado0.9719209552Error tpico4800.6919842857Observaciones106ANLISIS DE VARIANZAGrados de libertadSuma de cuadradosPromedio de los cuadradosFValor crtico de FRegresin383830862365.901827943620788.63391212.48114740450Residuos1022350757639.8544423046643.5279847Total10586181620005.7563

CoeficientesError tpicoEstadstico tProbabilidadInferior 95%Superior 95%Inferior 95,0%Superior 95,0%Intercepcin-607.47653523511475.7100252089-0.41165034110.6814594566-3534.54029362522319.587223155-3534.54029362522319.587223155habitantes0.72378630670.015764563645.912232453600.69251737050.75505524290.69251737050.7550552429autos-1.080206060.186335842-5.79709222060.0000000759-1.4498023091-0.710609811-1.4498023091-0.710609811ingresos-0.00225496020.0103422765-0.21803325850.8278388026-0.0227688160.0182588955-0.0227688160.0182588955Anlisis de los residuales

ObservacinPronstico para YResiduos125535.5773075626-1168.4605075626213863.4980054953-1934.5706054953342332.7376610289-5911.0439610288417818.2977808376518.6387191624537251.0696861845-1621.0414861844613760.8765792595-3303.8465792595737544.1117443493-2241.2573443494813691.3833564148-4802.0694564148913205.8502400583-4298.1693400583107719.4941939379-1350.95149393791117265.1731052766-4426.21660527661210272.020809345-799.1847093451314518.86002097911753.8257790209141934.7598622102480.81743778971513642.8132853226130.43191467741618691.1648621266-6088.13596212661720079.9989281695-3973.45462816951843157.7393138415-3928.4396138415197133.8078752042-1937.50197520422011819.1727421583-3288.92884215822111256.9034407877854.55945921232234415.77008609141668.9459139086238039.94026318912222.66443681092439048.486577759811379.380922240225104567.431748816-7524.43954881612680553.3455235298-7991.8645235298277093.9070793945-470.62357939452834798.87151369514286.61338630492920754.7225748477-3710.13167484773052299.5750075447-4560.16060754473131895.1869457895-4991.43904578953240157.455769225973.1845307753315553.03081905253391.21468094753457146.0477062003-340.43820620033532206.79541982675085.16838017333624035.5195400572827.16765994337111131.391897039-9111.47029703863847993.3733433874-12618.82414338743945434.462334287393.66806571274019921.397414091501.946085909418184.92181138141973.78038861864238199.17134577861395.78735422144377128.0471564509-4288.56885645094461756.22825003562513.83304996444581951.5159794162-2559.117179416246101849.0817330995695.0152669012478953.04576375423366.08723624584827917.69368317051194.24161682954967248.1145592753-7015.20215927545067724.0494733253-7162.68197332535122213.31773764023005.04456235985256612.91404685176615.39385314835386860.33835370032664.1740462997544223.72002660772933.82637339235593297.97083097629745.04296902385669373.509977362518100.32012263755732307.41228508493179.81361491515857728.9851533838309.21594661759102524.3828059745818.1018940266033359.4694302354765.37346976466134383.4831729693-3539.02257296936235836.311597506-2792.8106975066323920.0628306715-710.52893067156413428.4310210578819.49367894226513044.20873549851575.88686450156695882.61938455883653.69861544126748694.5735654271-5152.69746542716845441.7835567319-4936.17935673186927282.9834573948-1753.36165739487018646.8591662169-2533.39016621697130678.4008647807-1809.98196478077248653.5569611511487.2074388497312286.10825193594388.57914806417417682.4088085297-1639.45460852977516125.8740587271-2448.85815872717613649.1367951504-233.91579515047711937.1485094026-1515.31690940267811087.7274839454899.13701605467911293.926752825-624.85835282580-820.1565000328879.58390003288119728.3753121848-3785.8225121848828062.591210747-73.8886107478312020.6799739777-3170.38177397788415953.97976440692566.70033559318519498.94804866086199.94255133928615982.1978883787-4185.04518837878717866.5853050255-531.60940502558810823.5830515494-2579.71265154948920951.0876146669-2930.66931466699027779.64988992431434.2889100757911429.1652576322-78.1257576322922683.3603538045931.0713461955931591.761445733-143.1554457339422842.71908754594537.36551245419539883.47751065559779.5748893445963638.4382603125371.07863968759771635.3607052572348.38949474289839490.87083555234788.55756444779951509.36383455158509.681565448510041228.88781776152359.655882238510140495.307223832-1519.01112383210246932.41723972887400.648060271210393575.6344854031748.7750145968104110379.427451118-13357.884151117910551817.26114492824259.685055071810690635.92574433644081.6368556636

regresion empleo estdioResumen

Estadsticas de la regresinCoeficiente de correlacin mltiple0.9868872191Coeficiente de determinacin R^20.9739463833R^2 ajustado0.9729145568Error tpico4714.9886326811Observaciones106ANLISIS DE VARIANZAGrados de libertadSuma de cuadradosPromedio de los cuadradosFValor crtico de FRegresin483936277107.318820984069276.8297943.90527096540Residuos1012245342898.4375122231117.806312Total10586181620005.7563

CoeficientesError tpicoEstadstico tProbabilidadInferior 95%Superior 95%Inferior 95,0%Superior 95,0%Intercepcin-175.91004600771462.852721589-0.12025137150.9045229123-3077.81626491212725.9961728968-3077.81626491212725.9961728968Variable X 10.73134132960.015867094346.091698689500.69986528360.76281737570.69986528360.7628173757Variable X 2-1.08669248450.1830335606-5.93712148160.0000000412-1.4497818236-0.7236031455-1.4497818236-0.7236031455Variable X 30.0016194220.01031229260.157038020.8755283823-0.0188373920.022076236-0.0188373920.022076236Variable X 4-0.03547013850.0162889414-2.17755946620.0317669951-0.0677830157-0.0031572613-0.0677830157-0.0031572613Anlisis de los residuales

ObservacinPronstico para YResiduos125247.1042906116-879.9874906116213219.2882417145-1290.3608417145342601.1792752563-6179.4855752563418352.3404114877-15.4039114877537649.546598205-2019.518398205614529.6138224874-4072.5838224874736449.3673695989-1146.512969599813592.9321516581-4703.6182516581912441.5671187872-3533.8862187872106790.6482326174-422.10553261741115324.5335852503-2485.5770852503129259.0140578898213.82204211031312644.30966314383628.3761368562142026.6451919483388.93210805171512150.90164543781622.34355456221610663.00010130061940.02879869941719483.0953332081-3376.55103320811843370.3025748699-4141.0028748699197226.5251724795-2030.21927247952010848.3377289045-2318.09382890452111936.8654651383174.59743486172234904.88933035671179.8266696433238619.6809338631642.9237661372438790.835992444911637.031507555125105028.144005664-7985.15180566412680686.8342073274-8125.3532073274277589.3254907908-966.04199079092835523.07968586623562.40521413382921192.6571367209-4148.06623672093052375.7109162423-4636.29651624233132122.562353382-5218.8144533823240349.2616317011781.37866829893315916.88301279623027.36248720383457355.8147273442-550.20522734423532449.36236118084842.60143881923624688.62466725712174.062532742937110485.784742885-8465.8631428853848430.505296424-13055.9560964243945623.6054396818-95.47503968184020205.6341822192217.7093177808418938.96361955691219.73858044314238783.6612606303811.29743936974376297.6763963865-3458.19809638654462017.07377415282252.98752584724581747.9253705998-2355.526570599846102293.7981532035250.2988467974479907.20389683982411.92910316024828685.0638026986426.87149730144967333.5176724968-7100.60527249685066646.6320989948-6085.26459899485122874.2275917122344.1347082885256305.90856839626922.39933160385386345.68803221183178.8243677882544732.40323351472425.14316648535593044.04578359819998.96801640195669526.226947165617947.60315283445732883.81368849182603.41221150825858359.40665068337678.794449316759102791.6583326955550.82636730516034000.306413601124.5364863996134938.1133783652-4093.65277836526236568.1304756543-3524.62957565446324660.0392049252-1450.50530492526414024.3625489383223.56215106176514171.2499421863448.84565781376695801.44825421113734.86974578896748814.6870526475-5272.81095264756845843.2614084278-5337.65720842786927901.4380770302-2371.81627703027019311.5991685295-3198.13016852957129938.6932123474-1070.27431234747248532.12517267011608.63922732997312906.9459413053767.7414586957416721.9445874994-678.99038749947515765.7296552097-2088.71375520977613612.8594012999-197.63840129997712506.4637072783-2084.63210727837811114.08454849872.779951517912124.3192415683-1455.250841568380-189.1398735935248.56727359358119332.8980616017-3390.3452616017827255.0279090086733.67469099148311940.7785007357-3090.48030073578416335.2860822032185.3940177978519043.42353859226655.46706140788616323.6957707554-4526.54307075548718530.4270502699-1195.45115026998811353.803626654-3109.9332266548920874.8806348285-2854.46233482859027922.03051888851291.9082811115911067.6514992385283.3880007615923534.3899580780.04174193931181.5615596995267.04444030059423680.83849533023699.24610466989540569.80723077229093.2451692278963182.2748626076827.24203739249770501.03036917981482.71983082029840222.58284726634056.84555273379951507.96099048128511.084409518810041022.90656552292565.637134477110140637.9133063444-1661.617206344410246794.16881253527538.896487464810393910.8649173617413.5445826383104110237.72166622-13216.178366220310552255.5508288273821.39537117310690579.07155824284138.4910417572

Hoja3HABITANTESautosingresoempleo+estuioviaje publico41641.2153,454117,57941,38124,36721985.151,17775,62443,05711,92969223.1946,328145,08934,03436,42234115.1515,469159,12920,75918,33783647.3120,459259,29343,33135,63033413.2558,578243,78422,67110,45784628.8320,812275,11287,30135,30346034.4616,900339,22758,7118,88947797.03218,485360,91979,9378,90843073.04219,961570,769106,2236,36934356.2486,122168,92691,52912,83920570.0883,384156,82061,6189,47327641.0764,019238,95396,26916,2734520.032205225,00035,0782,41621922.0451,32681,93267,60413,77329717.1451,776129,429258,64512,60330230.1495770,64742,97616,10761570.01261758,59225,57639,22911402.112248108,05323,7395,19617919.16540248,33748,5618,53018291.0561,11475,7874,96712,11150309.661,15861,68315,61936,08513935.071,14888,2318,21810,26359315.622,85584,97140,82450,428149565.7352,73654,44036,48197,043114419.3181,43745,15037,44372,56110748.43034,6714,2766,62350867.6761,15174,19610,47839,08529929.07319539,46010,47017,04574731.10498353,27231,57747,73945807.07251044,54420,28626,90460268.4962,50765,63826,30841,13125157.081,645120,19120,09518,94483648.3282,44864,67030,68656,80650512.3743,193131,47029,86437,29238498.2082,773100,16912,38926,863159266.3543,15855,04769,727102,02068218.863042,02518,84935,37573378.2286,320107,18033,01545,52832143.062,36878,68619,16220,42314777.011,438154,83910,70610,15964720.2667,160134,21522,82539,595118292.3097,09398,06570,18872,83993305.1124,61482,33932,83764,270116112.6121,25257,39848,67979,392147708.4043,98665,26237,490107,54416551.0971,792214,21111,86212,31958105.53612,054226,26825,42029,112104253.0096,85487,83540,30660,233104230.626,41480,05572,31560,56133961.0791,48171,1438,26825,21887474.325,44095,56248,89763,228139439.42412,245101,69865,24689,52511055.122,395258,52227,9817,158142641.3998,43699,11458,991103,043106584.0966,44489,63339,17687,47456073.0666,818135,18521,37935,48788490.3845,09592,14522,37566,038152169.7846,28497,06546,497108,34250638.52,28794,98314,84334,12584780.323,833278,38340,63830,84465749.6329,957172,50222,56133,04443492.46,058180,89719,22023,21027218.1084,865181,52220,10114,24841758.53514,553377,88027,90114,620139971.4384,30375,75851,75799,53675062.1324,45595,36134,37043,54266608.2951,87659,48321,19040,50650660.0717,613245,18430,91125,53038302.0727,388216,41423,87216,11350741.0734,754135,27357,73628,86873218.163,27288,02340,20250,14123777.233,505235,00024,75616,67532578.084,571156,29262,42016,04330501.1564,587172,26646,79513,67726291.2234,037182,52037,98813,41526327.2775,473265,49129,72310,42226666.0686,527246,21042,80411,98723953.0854,610202,19215,10010,66972.00210112,5006,6795930139.1361,17791,66739,53415,94316805.042,901159,49455,4057,98920318.21,76775,11026,6298,85025673.1921,68389,55116,35918,52136865.2245,799138,35246,91325,69925912.1541,85969,58115,31911,79731433.0853,698125,12913,13817,33518797.0361,778112,31513,1658,24434194.0412,77983,68230,23118,02047680.1395,442108,29229,14229,2143197.13811965,94330,2211,35110274.113,456182,8899,7073,6143513.11217270,01732,0961,44939099.2564,104184,68416,28927,38068564.618,170137,26220,92149,6636988.06358878,50534,9834,010110911.6267,227100,43677,42071,98464456.0955,86099,54415,06944,27978186.3683,94793,08738,30660,01965461.684,93395,29041,42443,58961564.0222,981105,00932,18538,97669834.022,63371,28238,24454,333133708.752,29252,08836,46694,324155939.8171,64047,95654,31597,02274136.631,02755,60121,48756,077132351.8154,06969,24148,78094,7185994733.2873,986,484