------------------------------------------------------------------------------------- log: C:\DATA\30ago06.log log type: text opened on: 20 Oct 2004, 13:58:44 . set memory 35m (35840k) . use "E:\Computos\computos2006presid_base.dta", clear . describe Contains data from E:\Computos\computos2006presid_base.dta obs: 130,788 vars: 31 24 Jul 2006 00:05 size: 13,732,740 (62.6% of memory free) (_dta has notes) ------------------------------------------------------------------------------- storage display value variable name type format label variable label ------------------------------------------------------------------------------- index str18 %18s indice edo.dist.seccion.idcasilla.tipo casilla.ext-continua edo str5 %9s EDO id_estado byte %8.0g ID_ESTADO distrito byte %8.0g DISTRITO seccion int %8.0g SECCION id_casilla byte %8.0g ID_CASILLA tipo_casilla str1 %9s TIPO_CASILLA ext_contigua byte %8.0g EXT_CONTIGUA tipo_candidat~a byte %8.0g TIPO_CANDIDATURA tipo_acta byte %8.0g TIPO_ACTA lista_nominal int %8.0g LISTA_NOMINAL v_nulos int %8.0g V_NULOS v_noreg int %8.0g V_NOREG v_validos int %8.0g V_VALIDOS v_total int %8.0g V_TOTAL orden int %8.0g ORDEN pan int %8.0g PAN apm int %8.0g APM pbt int %8.0g PBT panal int %8.0g NA asdc int %8.0g ASDC municipio int %8.0g MUNICIPIO paquete_entre~o byte %8.0g PAQUETE_ENTREGADO casilla_insta~a byte %8.0g CASILLA_INSTALADA fecha_hora str14 %14s FECHA_HORA daytime str14 %14s hours str8 %9s horasdec float %9.0g Horas a partir del 2-jul 7pm rural byte %8.0g casilla no urbana=1 acta_inc byte %8.0g acta inconsistente en PREP=1 merge1 byte %8.0g Merge with rural & actas inconsitentes data ------------------------------------------------------------------------------- Sorted by: index . label var edo "Nombre del estado" . desc edo Contains data from E:\Computos\computos2006presid_base.dta obs: 130,788 vars: 31 24 Jul 2006 00:05 size: 13,732,740 (62.6% of memory free) (_dta has notes) ------------------------------------------------------------------------------- storage display value variable name type format label variable label ------------------------------------------------------------------------------- edo str5 %9s Nombre del estado ------------------------------------------------------------------------------- Sorted by: index . help describe . notes _dta: 1. Indicador rural/urbano tomado de archivo PREP y archivo de actas inconsistentes, IFE 2. Fuente: Archivo de computos distritales, Computos2006-presidente.txt, del IFE . help notes . summarize Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- index | 0 edo | 0 id_estado | 130788 16.54503 8.071968 1 32 distrito | 130788 8.330206 7.817168 1 40 seccion | 130788 1550.18 1340.844 0 6183 -------------+-------------------------------------------------------- id_casilla | 130788 1.276715 1.096708 1 43 tipo_casilla | 0 ext_contigua | 130788 .0081047 .1608879 0 9 tipo_candi~a | 130788 1.011469 .2391937 1 6 tipo_acta | 130488 1.020546 .142452 1 3 -------------+-------------------------------------------------------- lista_nomi~l | 130788 545.7257 143.019 0 750 v_nulos | 130777 6.917149 7.268219 0 951 v_noreg | 130777 2.278604 3.306844 0 379 v_validos | 130777 312.6446 101.3796 0 961 v_total | 130788 319.5348 102.0591 0 982 -------------+-------------------------------------------------------- orden | 130788 222.037 134.276 1 760 pan | 130777 114.7012 73.38175 0 786 apm | 130777 71.12444 39.06332 0 466 pbt | 130777 112.836 72.23151 0 648 panal | 130777 3.072436 4.401513 0 354 -------------+-------------------------------------------------------- asdc | 130777 8.63187 7.068231 0 218 municipio | 130788 50.04783 65.13227 0 570 paquete_en~o | 130488 .9999157 .0091811 0 1 casilla_in~a | 130488 .9999157 .0091811 0 1 fecha_hora | 0 -------------+-------------------------------------------------------- daytime | 0 hours | 0 horasdec | 130788 7.460429 4.869905 .1 31.02 rural | 128471 .3067151 .4611319 0 1 acta_inc | 128471 .0870547 .2819162 0 1 -------------+-------------------------------------------------------- merge1 | 130788 2.964569 .2638331 1 3 . summ v_* Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- v_nulos | 130777 6.917149 7.268219 0 951 v_noreg | 130777 2.278604 3.306844 0 379 v_validos | 130777 312.6446 101.3796 0 961 v_total | 130788 319.5348 102.0591 0 982 . summ *s Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- v_nulos | 130777 6.917149 7.268219 0 951 v_validos | 130777 312.6446 101.3796 0 961 hours | 0 . summ v_total, detail V_TOTAL ------------------------------------------------------------- Percentiles Smallest 1% 60 0 5% 134 0 10% 187 0 Obs 130788 25% 258 0 Sum of Wgt. 130788 50% 326 Mean 319.5348 Largest Std. Dev. 102.0591 75% 387 939 90% 439 955 Variance 10416.05 95% 470 965 Skewness -.105284 99% 535 982 Kurtosis 3.949147 . summ pan, detail PAN ------------------------------------------------------------- Percentiles Smallest 1% 3 0 5% 13 0 10% 27 0 Obs 130777 25% 61 0 Sum of Wgt. 130777 50% 105 Mean 114.7012 Largest Std. Dev. 73.38175 75% 156 599 90% 211 603 Variance 5384.881 95% 250 766 Skewness .9461413 99% 337 786 Kurtosis 4.455286 . summ pbt, detail PBT ------------------------------------------------------------- Percentiles Smallest 1% 6 0 5% 22 0 10% 34 0 Obs 130777 25% 58 0 Sum of Wgt. 130777 50% 97 Mean 112.836 Largest Std. Dev. 72.23151 75% 156 523 90% 216 545 Variance 5217.39 95% 253 546 Skewness .9162528 99% 318 648 Kurtosis 3.593632 . summ apm, detail APM ------------------------------------------------------------- Percentiles Smallest 1% 11 0 5% 23 0 10% 30 0 Obs 130777 25% 44 0 Sum of Wgt. 130777 50% 64 Mean 71.12444 Largest Std. Dev. 39.06332 75% 90 394 90% 122 420 Variance 1525.943 95% 145 423 Skewness 1.369072 99% 199 466 Kurtosis 6.338812 . histogram v_total (bin=51, start=0, width=19.254902) . help hist . histogram v_total, normal (bin=51, start=0, width=19.254902) . histogram pbt, normal (bin=51, start=0, width=12.705882) . histogram asdc, normal (bin=51, start=0, width=4.2745098) . histogram pan, normal (bin=51, start=0, width=15.411765) . histogram pan if rural==1, normal (bin=45, start=0, width=12.911111) . histogram pan if rural==0, normal (bin=49, start=0, width=16.040816) . histogram pan if rural==0, normal freq (bin=49, start=0, width=16.040816) . summ pan pbt apm Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- pan | 130777 114.7012 73.38175 0 786 pbt | 130777 112.836 72.23151 0 648 apm | 130777 71.12444 39.06332 0 466 . summ pan if pan==0 Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- pan | 249 0 0 0 0 . list index if pan==0 +-------------------+ | index | |-------------------| 4310. | BC.7.732.1.B0 | 4811. | BCS.1.118.1.E0 | 9462. | CHIH.7.1253.1.B0 | 11223. | CHIS.1.1474.1.E0 | 11240. | CHIS.1.1479.2.C0 | |-------------------| 11358. | CHIS.1.462.1.B0 | 11379. | CHIS.1.470.1.B0 | 11381. | CHIS.1.470.1.E0 | 11425. | CHIS.1.487.1.C0 | 11426. | CHIS.1.487.1.E0 | |-------------------| 12237. | CHIS.11.64.1.E0 | 12718. | CHIS.2.0.1.B0 | 12729. | CHIS.2.1043.1.B0 | 12734. | CHIS.2.1045.1.B0 | 12735. | CHIS.2.1045.1.C0 | |-------------------| 12736. | CHIS.2.1045.2.C0 | 12737. | CHIS.2.1046.1.B0 | 12761. | CHIS.2.1180.1.E0 | 12806. | CHIS.2.1216.1.B0 | 12813. | CHIS.2.1219.1.B0 | |-------------------| 12818. | CHIS.2.1221.1.B0 | 12819. | CHIS.2.1221.1.C0 | 12830. | CHIS.2.1225.1.E1 | 12953. | CHIS.2.397.1.C0 | 12977. | CHIS.2.557.1.B0 | |-------------------| 12994. | CHIS.2.565.1.B0 | 13014. | CHIS.2.664.2.E0 | 13034. | CHIS.2.685.1.E0 | 13065. | CHIS.2.980.1.E0 | 13069. | CHIS.2.982.1.B0 | |-------------------| 13074. | CHIS.2.984.1.B0 | 13084. | CHIS.2.988.1.E0 | 13085. | CHIS.2.988.2.E0 | 13113. | CHIS.3.39.1.E0 | 13114. | CHIS.3.39.2.E0 | |-------------------| 13118. | CHIS.3.40.1.E1 | 13150. | CHIS.3.723.1.E0 | 13154. | CHIS.3.724.1.C0 | 13164. | CHIS.3.726.1.E0 | 13168. | CHIS.3.728.1.E0 | |-------------------| 13172. | CHIS.3.729.2.E0 | 13175. | CHIS.3.730.1.E0 | 13176. | CHIS.3.730.1.E1 | 13204. | CHIS.3.738.1.E0 | 13205. | CHIS.3.738.2.E0 | |-------------------| 13220. | CHIS.3.743.3.E0 | 13228. | CHIS.3.745.4.E0 | 13230. | CHIS.3.746.1.E0 | 13240. | CHIS.3.751.1.B0 | 13261. | CHIS.3.758.2.E0 | |-------------------| 13335. | CHIS.3.833.1.B0 | 13356. | CHIS.3.840.1.B0 | 13418. | CHIS.3.858.2.E0 | 13422. | CHIS.3.859.3.E0 | 13438. | CHIS.3.864.1.B0 | |-------------------| 13440. | CHIS.3.864.2.E0 | 13441. | CHIS.3.864.3.E0 | 13460. | CHIS.3.870.1.E0 | 13461. | CHIS.3.870.2.E0 | 13462. | CHIS.3.870.3.E0 | |-------------------| 13465. | CHIS.3.871.1.E0 | 13542. | CHIS.3.939.2.E0 | 13555. | CHIS.4.0.1.B0 | 14112. | CHIS.5.1164.1.E0 | 14210. | CHIS.5.1928.1.E0 | |-------------------| 14212. | CHIS.5.1929.1.E0 | 14213. | CHIS.5.1929.2.E0 | 14709. | CHIS.6.814.1.B0 | 15383. | CHIS.8.454.1.E0 | 15439. | CHIS.8.528.1.B0 | |-------------------| 34292. | GRO.1.1387.1.B0 | 34369. | GRO.1.1697.1.E0 | 34440. | GRO.1.2113.1.B0 | 34454. | GRO.1.2126.1.B0 | 34557. | GRO.1.2743.1.B0 | |-------------------| 34704. | GRO.1.543.1.B0 | 34709. | GRO.1.548.1.B0 | 35025. | GRO.2.1853.1.B0 | 35244. | GRO.2.2346.1.B0 | 35248. | GRO.2.2350.1.B0 | |-------------------| 35256. | GRO.2.2359.1.B0 | 35258. | GRO.2.2361.1.B0 | 35262. | GRO.2.2365.1.B0 | 35264. | GRO.2.2367.1.B0 | 35268. | GRO.2.2371.1.B0 | |-------------------| 35299. | GRO.2.2400.1.B0 | 35317. | GRO.2.2416.1.B0 | 35318. | GRO.2.2417.1.B0 | 35547. | GRO.3.1890.1.B0 | 35550. | GRO.3.1893.1.B0 | |-------------------| 35554. | GRO.3.1896.1.B0 | 35596. | GRO.3.1932.1.B0 | 35634. | GRO.3.2284.1.B0 | 35638. | GRO.3.2288.1.B0 | 35701. | GRO.3.2625.1.B0 | |-------------------| 35711. | GRO.3.2633.1.B0 | 35730. | GRO.3.2645.1.B0 | 35734. | GRO.3.2649.1.B0 | 35791. | GRO.3.631.1.B0 | 35798. | GRO.3.638.1.B0 | |-------------------| 35813. | GRO.3.651.1.B0 | 35873. | GRO.3.793.1.B0 | 35876. | GRO.3.794.1.E0 | 35880. | GRO.3.798.1.B0 | 35883. | GRO.3.801.1.B0 | |-------------------| 35889. | GRO.3.806.1.B0 | 35890. | GRO.3.807.1.B0 | 35891. | GRO.3.808.1.B0 | 35892. | GRO.3.809.1.B0 | 35894. | GRO.3.811.1.B0 | |-------------------| 35896. | GRO.3.813.1.B0 | 35899. | GRO.3.815.1.E0 | 35900. | GRO.3.816.1.B0 | 36478. | GRO.5.1743.1.B0 | 36492. | GRO.5.1753.1.B0 | |-------------------| 36493. | GRO.5.1753.1.E0 | 36499. | GRO.5.1756.1.B0 | 36505. | GRO.5.1759.1.E0 | 36510. | GRO.5.1762.1.C0 | 36511. | GRO.5.1762.1.E0 | |-------------------| 36592. | GRO.5.2532.1.B0 | 36645. | GRO.5.2574.1.B0 | 36649. | GRO.5.2578.1.B0 | 36653. | GRO.5.2581.1.B0 | 36676. | GRO.5.2596.1.B0 | |-------------------| 36677. | GRO.5.2597.1.B0 | 36679. | GRO.5.2599.1.B0 | 36685. | GRO.5.2657.1.B0 | 36693. | GRO.5.2664.1.B0 | 36694. | GRO.5.2665.1.B0 | |-------------------| 36695. | GRO.5.2666.1.B0 | 36696. | GRO.5.2667.1.B0 | 36775. | GRO.5.458.1.B0 | 36778. | GRO.5.460.1.B0 | 36780. | GRO.5.462.1.B0 | |-------------------| 36785. | GRO.5.466.1.B0 | 36787. | GRO.5.467.1.C0 | 36815. | GRO.5.574.1.B0 | 36851. | GRO.5.876.1.B0 | 36866. | GRO.6.1032.1.B0 | |-------------------| 37031. | GRO.6.1321.1.B0 | 37148. | GRO.6.1728.1.B0 | 37175. | GRO.6.1796.1.B0 | 37249. | GRO.6.2676.1.B0 | 37250. | GRO.6.2677.1.B0 | |-------------------| 37278. | GRO.6.2785.1.B0 | 37294. | GRO.6.396.1.B0 | 37356. | GRO.6.862.1.C0 | 37630. | GRO.7.1783.1.B0 | 37638. | GRO.7.1977.1.B0 | |-------------------| 37906. | GRO.8.1353.1.B0 | 37975. | GRO.8.1819.1.E0 | 38165. | GRO.8.686.1.B0 | 38180. | GRO.8.698.1.B0 | 38182. | GRO.8.700.1.B0 | |-------------------| 38183. | GRO.8.701.1.B0 | 38201. | GRO.8.715.1.B0 | 38202. | GRO.8.716.1.B0 | 38228. | GRO.8.735.1.B0 | 38246. | GRO.8.749.1.B0 | |-------------------| 38648. | GRO.9.348.1.B0 | 38649. | GRO.9.349.1.B0 | 45080. | HGO.1.412.1.B0 | 45872. | HGO.3.1387.1.B0 | 46125. | HGO.3.682.1.B0 | |-------------------| 67362. | MEX.36.4146.1.E0 | 67658. | MEX.36.5165.1.E0 | 67692. | MEX.36.5930.1.B0 | 71683. | MICH.1.175.1.E0 | 71690. | MICH.1.177.2.E0 | |-------------------| 71692. | MICH.1.178.1.E0 | 71719. | MICH.1.2073.1.B0 | 71742. | MICH.1.429.1.B0 | 72558. | MICH.11.1780.1.B0 | 72717. | MICH.11.2087.1.B0 | |-------------------| 73731. | MICH.2.417.1.E0 | 73881. | MICH.3.1838.1.B0 | 73893. | MICH.3.2016.1.B0 | 79901. | NAY.2.769.2.E0 | 79908. | NAY.2.772.1.E0 | |-------------------| 85023. | NL.9.154.1.E0 | 86498. | OAX.11.2007.1.B0 | 87990. | OAX.5.197.1.B0 | 88017. | OAX.5.2195.1.B0 | 88018. | OAX.5.2196.1.B0 | |-------------------| 88019. | OAX.5.2197.1.B0 | 88133. | OAX.5.383.1.E0 | 88282. | OAX.5.819.1.C0 | 88316. | OAX.6.119.1.E0 | 88317. | OAX.6.119.1.E1 | |-------------------| 88376. | OAX.6.132.1.B0 | 88501. | OAX.6.199.1.B0 | 88530. | OAX.6.2045.1.E0 | 88537. | OAX.6.2048.1.B0 | 88538. | OAX.6.2048.1.C0 | |-------------------| 88540. | OAX.6.2049.1.B0 | 88703. | OAX.6.653.1.B0 | 88732. | OAX.6.774.1.C0 | 88733. | OAX.6.774.1.E0 | 88790. | OAX.7.1142.1.E1 | |-------------------| 88805. | OAX.7.1152.1.B0 | 88821. | OAX.7.1161.1.B0 | 88848. | OAX.7.1188.1.B0 | 88853. | OAX.7.1190.1.E0 | 88855. | OAX.7.1191.1.E0 | |-------------------| 88862. | OAX.7.1341.1.B0 | 89088. | OAX.7.331.1.B0 | 89089. | OAX.7.331.1.C0 | 89150. | OAX.7.839.1.B0 | 89151. | OAX.7.839.1.C0 | |-------------------| 92053. | PUE.14.2021.1.E0 | 98179. | QROO.1.212.1.B0 | 101383. | SIN.5.1263.1.B0 | 109474. | TAB.1.1120.1.B0 | 109585. | TAB.1.679.1.C0 | |-------------------| 109608. | TAB.1.855.1.B0 | 109610. | TAB.1.857.1.B0 | 109623. | TAB.1.866.1.B0 | 109625. | TAB.1.868.1.B0 | 109626. | TAB.1.868.1.C0 | |-------------------| 109627. | TAB.1.869.1.B0 | 109675. | TAB.1.888.1.B0 | 109710. | TAB.1.904.1.E0 | 109719. | TAB.1.910.1.B0 | 110042. | TAB.2.715.1.B0 | |-------------------| 110099. | TAB.2.740.1.B0 | 110510. | TAB.3.651.1.C0 | 110529. | TAB.3.659.2.C0 | 110905. | TAB.4.426.1.C0 | 110913. | TAB.4.429.2.C0 | |-------------------| 110987. | TAB.4.473.1.B0 | 111001. | TAB.5.0.1.B0 | 111025. | TAB.5.1012.1.E0 | 111042. | TAB.5.1020.1.C0 | 111121. | TAB.5.195.1.B0 | |-------------------| 111128. | TAB.5.198.1.C0 | 111182. | TAB.5.227.1.B0 | 111186. | TAB.5.229.1.B0 | 111242. | TAB.5.832.1.C0 | 111262. | TAB.5.841.1.C0 | |-------------------| 111299. | TAB.5.965.1.B0 | 111324. | TAB.5.975.1.C0 | 111649. | TAB.6.459.1.B0 | 111681. | TAB.6.470.1.C0 | 130216. | ZAC.3.847.1.B0 | |-------------------| 130240. | ZAC.3.870.1.B0 | 130245. | ZAC.3.875.1.B0 | 130247. | ZAC.3.89.1.B0 | 130415. | ZAC.4.1145.1.B0 | +-------------------+ . summ pbt if pbt==0 Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- pbt | 104 0 0 0 0 . summ pan if pan==0 Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- pan | 249 0 0 0 0 . list index if pbt==0 +------------------+ | index | |------------------| 1405. | BC.1.511.1.C0 | 4310. | BC.7.732.1.B0 | 8439. | CHIH.5.2269.1.B0 | 8659. | CHIH.5.29.1.B0 | 9594. | CHIH.7.2334.1.B0 | |------------------| 9600. | CHIH.7.2338.1.B0 | 9967. | CHIH.7.357.1.B0 | 10942. | CHIH.9.2326.1.B0 | 10957. | CHIH.9.2391.1.B0 | 11932. | CHIS.11.0.1.B0 | |------------------| 12924. | CHIS.2.386.1.E0 | 12947. | CHIS.2.394.1.E0 | 12953. | CHIS.2.397.1.C0 | 12954. | CHIS.2.397.1.E0 | 13542. | CHIS.3.939.2.E0 | |------------------| 13548. | CHIS.3.941.1.E0 | 16875. | COAH.3.224.1.B0 | 17379. | COAH.4.1037.1.B0 | 19007. | COL.1.101.2.E0 | 32042. | DGO.1.1052.1.B0 | |------------------| 32068. | DGO.1.1111.1.B0 | 32083. | DGO.1.1127.1.B0 | 32157. | DGO.1.1234.1.B0 | 32208. | DGO.1.1276.1.B0 | 32287. | DGO.1.1332.1.B0 | |------------------| 32471. | DGO.1.640.1.B0 | 32478. | DGO.1.644.1.E0 | 32531. | DGO.1.818.1.B0 | 33219. | DGO.3.1189.1.B0 | 33428. | DGO.3.637.1.E0 | |------------------| 33659. | DGO.3.920.1.B0 | 33708. | DGO.3.97.1.E0 | 38648. | GRO.9.348.1.B0 | 38649. | GRO.9.349.1.B0 | 38722. | GTO.1.1901.1.E0 | |------------------| 38971. | GTO.1.2578.1.E0 | 39062. | GTO.1.2942.1.B0 | 39069. | GTO.1.2947.1.B0 | 39334. | GTO.10.2759.1.B0 | 39605. | GTO.11.1934.1.B0 | |------------------| 39609. | GTO.11.1938.1.B0 | 40354. | GTO.12.548.1.B0 | 46125. | HGO.3.682.1.B0 | 50541. | JAL.15.181.1.E0 | 52415. | JAL.19.2632.1.B0 | |------------------| 52956. | JAL.2.2096.1.B0 | 53199. | JAL.3.136.1.B0 | 53238. | JAL.3.1627.1.B0 | 53323. | JAL.3.2145.1.B0 | 53454. | JAL.3.2379.1.B0 | |------------------| 54278. | JAL.5.2218.1.B0 | 81681. | NL.12.14.1.B0 | 81822. | NL.12.18.1.B0 | 82044. | NL.12.59.1.B0 | 85022. | NL.9.154.1.B0 | |------------------| 85023. | NL.9.154.1.E0 | 85035. | NL.9.164.1.E0 | 85411. | NL.9.894.1.B0 | 86023. | OAX.10.1770.1.B0 | 86228. | OAX.10.827.1.E0 | |------------------| 87990. | OAX.5.197.1.B0 | 87998. | OAX.5.2052.1.E0 | 88310. | OAX.6.1163.1.B0 | 88376. | OAX.6.132.1.B0 | 88537. | OAX.6.2048.1.B0 | |------------------| 88538. | OAX.6.2048.1.C0 | 88848. | OAX.7.1188.1.B0 | 88853. | OAX.7.1190.1.E0 | 88855. | OAX.7.1191.1.E0 | 93806. | PUE.4.0.1.B0 | |------------------| 99029. | SIN.1.1739.1.B0 | 99057. | SIN.1.1767.1.B0 | 99058. | SIN.1.1768.1.B0 | 99428. | SIN.1.3440.1.B0 | 99439. | SIN.1.3450.1.E0 | |------------------| 99647. | SIN.1.600.1.B0 | 99654. | SIN.1.608.1.B0 | 101383. | SIN.5.1263.1.B0 | 102208. | SIN.6.3385.1.C0 | 102229. | SIN.6.3407.1.E0 | |------------------| 102266. | SIN.6.648.1.B0 | 103496. | SLP.1.1632.1.B0 | 104187. | SLP.2.62.1.B0 | 104199. | SLP.2.74.1.B0 | 104316. | SLP.3.1697.1.C0 | |------------------| 104322. | SLP.3.1701.1.B0 | 104353. | SLP.3.198.1.B0 | 104671. | SLP.3.770.1.B0 | 105183. | SLP.5.1098.1.B0 | 107931. | SON.4.146.1.B0 | |------------------| 107966. | SON.4.242.1.B0 | 114493. | TAMPS.6.150.1.B0 | 114494. | TAMPS.6.150.1.E0 | 121309. | VER.18.3774.1.B0 | 124474. | VER.5.955.1.C0 | |------------------| 126234. | YUC.1.0.1.B0 | 126235. | YUC.1.100.1.B0 | 126236. | YUC.1.101.1.B0 | 126473. | YUC.1.854.1.B0 | 126588. | YUC.1.962.1.B0 | |------------------| 126636. | YUC.1.99.1.C0 | 127333. | YUC.3.474.8.C0 | 128143. | YUC.5.253.1.C0 | 128259. | YUC.5.815.1.C0 | +------------------+ . summ pan apm pbt if pan==0 Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- pan | 249 0 0 0 0 apm | 249 55.86345 64.71218 0 351 pbt | 249 81.17269 96.6382 0 648 . summ pan apm pbt if pbt==0 Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- pan | 104 42.56731 58.64651 0 341 apm | 104 48.76923 59.5767 0 351 pbt | 104 0 0 0 0 . summ pan apm pbt rural if pbt==0 Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- pan | 104 42.56731 58.64651 0 341 apm | 104 48.76923 59.5767 0 351 pbt | 104 0 0 0 0 rural | 93 .9462366 .2267728 0 1 . summ pan apm pbt rural if pan==0 Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- pan | 249 0 0 0 0 apm | 249 55.86345 64.71218 0 351 pbt | 249 81.17269 96.6382 0 648 rural | 236 .9618644 .1919306 0 1 . summ pan apm pbt if rural Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- pan | 41710 76.67626 60.87305 0 581 apm | 41710 79.6889 48.06143 0 466 pbt | 41710 87.40906 63.94856 0 545 . summ pan apm pbt if rural==0 Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- pan | 89067 132.5083 71.95245 0 786 apm | 89067 67.11371 33.29268 0 391 pbt | 89067 124.7434 72.80873 0 648 . summ pan pbt apm if acta_inc Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- pan | 13490 73.40497 65.4334 0 521 pbt | 13490 84.20838 69.08655 0 546 apm | 13490 73.01905 48.95296 0 466 . summ pan pbt apm rural if acta_inc Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- pan | 13490 73.40497 65.4334 0 521 pbt | 13490 84.20838 69.08655 0 546 apm | 13490 73.01905 48.95296 0 466 rural | 11184 .6561159 .4750242 0 1 . summ pan pbt if rural Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- pan | 41710 76.67626 60.87305 0 581 pbt | 41710 87.40906 63.94856 0 545 . help ttest . ttest pan == pbt Paired t test ------------------------------------------------------------------------------ Variable | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- pan | 130777 114.7012 .2029188 73.38175 114.3035 115.099 pbt | 130777 112.836 .1997381 72.23151 112.4445 113.2275 ---------+-------------------------------------------------------------------- diff | 130777 1.865267 .3098232 112.0417 1.258019 2.472515 ------------------------------------------------------------------------------ Ho: mean(pan - pbt) = mean(diff) = 0 Ha: mean(diff) < 0 Ha: mean(diff) != 0 Ha: mean(diff) > 0 t = 6.0204 t = 6.0204 t = 6.0204 P < t = 1.0000 P > |t| = 0.0000 P > t = 0.0000 . ttest pan == pbt, level(99) Paired t test ------------------------------------------------------------------------------ Variable | Obs Mean Std. Err. Std. Dev. [99% Conf. Interval] ---------+-------------------------------------------------------------------- pan | 130777 114.7012 .2029188 73.38175 114.1785 115.2239 pbt | 130777 112.836 .1997381 72.23151 112.3215 113.3505 ---------+-------------------------------------------------------------------- diff | 130777 1.865267 .3098232 112.0417 1.067204 2.66333 ------------------------------------------------------------------------------ Ho: mean(pan - pbt) = mean(diff) = 0 Ha: mean(diff) < 0 Ha: mean(diff) != 0 Ha: mean(diff) > 0 t = 6.0204 t = 6.0204 t = 6.0204 P < t = 1.0000 P > |t| = 0.0000 P > t = 0.0000 . ttest pan == pbt if edo=="VER" Paired t test ------------------------------------------------------------------------------ Variable | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- pan | 9185 109.6 .5485665 52.57374 108.5247 110.6753 pbt | 9185 112.8464 .5858642 56.14829 111.698 113.9948 ---------+-------------------------------------------------------------------- diff | 9185 -3.24638 .8264361 79.20432 -4.866378 -1.626381 ------------------------------------------------------------------------------ Ho: mean(pan - pbt) = mean(diff) = 0 Ha: mean(diff) < 0 Ha: mean(diff) != 0 Ha: mean(diff) > 0 t = -3.9282 t = -3.9282 t = -3.9282 P < t = 0.0000 P > |t| = 0.0001 P > t = 1.0000 . ttest pan == pbt if edo=="VER" Paired t test ------------------------------------------------------------------------------ Variable | Obs Mean Std. Err. Std. Dev. [95% Conf. Interval] ---------+-------------------------------------------------------------------- pan | 9185 109.6 .5485665 52.57374 108.5247 110.6753 pbt | 9185 112.8464 .5858642 56.14829 111.698 113.9948 ---------+-------------------------------------------------------------------- diff | 9185 -3.24638 .8264361 79.20432 -4.866378 -1.626381 ------------------------------------------------------------------------------ Ho: mean(pan - pbt) = mean(diff) = 0 Ha: mean(diff) < 0 Ha: mean(diff) != 0 Ha: mean(diff) > 0 t = -3.9282 t = -3.9282 t = -3.9282 P < t = 0.0000 P > |t| = 0.0001 P > t = 1.0000 . . graph box pan . graph box pan pbt . graph box pan pbt if edo=="DF" . corr pan apm pbt panal asdc rural (obs=128471) | pan apm pbt panal asdc rural -------------+------------------------------------------------------ pan | 1.0000 apm | -0.0455 1.0000 pbt | -0.1913 -0.1165 1.0000 panal | 0.1050 0.0917 0.0051 1.0000 asdc | 0.3843 -0.1652 0.3519 0.1492 1.0000 rural | -0.3544 0.1595 -0.2381 -0.0869 -0.4607 1.0000 . reg pan apm pbt rural Source | SS df MS Number of obs = 128471 -------------+------------------------------ F( 3,128467) =11132.58 Model | 142973390 3 47657796.5 Prob > F = 0.0000 Residual | 549958136128467 4280.92923 R-squared = 0.2063 -------------+------------------------------ Adj R-squared = 0.2063 Total | 692931525128470 5393.72247 Root MSE = 65.429 ------------------------------------------------------------------------------ pan | Coef. Std. Err. t P>|t| [95% Conf. Interval] -------------+---------------------------------------------------------------- apm | -.0231752 .0047634 -4.87 0.000 -.0325115 -.0138389 pbt | -.2985807 .0026142 -114.22 0.000 -.3037044 -.2934569 rural | -67.25435 .4114394 -163.46 0.000 -68.06076 -66.44794 _cons | 171.3096 .5231579 327.45 0.000 170.2843 172.335 ------------------------------------------------------------------------------ . summ Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- index | 0 edo | 0 id_estado | 130788 16.54503 8.071968 1 32 distrito | 130788 8.330206 7.817168 1 40 seccion | 130788 1550.18 1340.844 0 6183 -------------+-------------------------------------------------------- id_casilla | 130788 1.276715 1.096708 1 43 tipo_casilla | 0 ext_contigua | 130788 .0081047 .1608879 0 9 tipo_candi~a | 130788 1.011469 .2391937 1 6 tipo_acta | 130488 1.020546 .142452 1 3 -------------+-------------------------------------------------------- lista_nomi~l | 130788 545.7257 143.019 0 750 v_nulos | 130777 6.917149 7.268219 0 951 v_noreg | 130777 2.278604 3.306844 0 379 v_validos | 130777 312.6446 101.3796 0 961 v_total | 130788 319.5348 102.0591 0 982 -------------+-------------------------------------------------------- orden | 130788 222.037 134.276 1 760 pan | 130777 114.7012 73.38175 0 786 apm | 130777 71.12444 39.06332 0 466 pbt | 130777 112.836 72.23151 0 648 panal | 130777 3.072436 4.401513 0 354 -------------+-------------------------------------------------------- asdc | 130777 8.63187 7.068231 0 218 municipio | 130788 50.04783 65.13227 0 570 paquete_en~o | 130488 .9999157 .0091811 0 1 casilla_in~a | 130488 .9999157 .0091811 0 1 fecha_hora | 0 -------------+-------------------------------------------------------- daytime | 0 hours | 0 horasdec | 130788 7.460429 4.869905 .1 31.02 rural | 128471 .3067151 .4611319 0 1 acta_inc | 128471 .0870547 .2819162 0 1 -------------+-------------------------------------------------------- merge1 | 130788 2.964569 .2638331 1 3 . log close log: C:\DATA\30ago06.log log type: text closed on: 20 Oct 2004, 14:37:31 -----------------------------------------------------------------------------------