6301645
9940929
735860
326189
5393929
229413
6587137
349567
246012
47.37
52.63
89.02
10.98
Los siguientes análisis demuestran la calidad y la normalidad de los datos usando un muestreo de 10 mil de casi 17 millones de observaciones registrados en la base de datos. El análisis para la calidad de datos usa un poder computacional significante cuál no está disponible en una computadora personal. Por lo tanto un muestreo seleccionado al azar es usado para simular la calidad y la normalidad de datos.
| NamesCat | Count | Miss | Card | Mode | ModeFrec | ModePerc | Mode2 | Mode2Frec | Mode2Perc | |
|---|---|---|---|---|---|---|---|---|---|---|
| 3 | ORIGEN | 10000 | 0 | 2 | NO USMER | 7707 | 77.07% | USMER | 2293 | 22.93% |
| 4 | SECTOR | 10000 | 0 | 12 | SSA | 5430 | 54.3% | IMSS | 3480 | 34.8% |
| 5 | ENTIDAD_UM | 10000 | 0 | 32 | CIUDAD DE MÉXICO | 3715 | 37.15% | MÉXICO | 682 | 6.82% |
| 6 | SEXO | 10000 | 0 | 2 | MUJER | 5349 | 53.49% | HOMBRE | 4651 | 46.51% |
| 7 | ENTIDAD_NAC | 10000 | 0 | 33 | CIUDAD DE MÉXICO | 3139 | 31.39% | MÉXICO | 1109 | 11.09% |
| 8 | ENTIDAD_RES | 10000 | 0 | 32 | CIUDAD DE MÉXICO | 3249 | 32.49% | MÉXICO | 1131 | 11.31% |
| 9 | TIPO_PACIENTE | 10000 | 0 | 2 | AMBULATORIO | 9265 | 92.65% | HOSPITALIZADO | 735 | 7.35% |
| 10 | FECHA_INGRESO | 10000 | 0 | 834 | 2022-01-11 | 74 | 0.74% | 2022-01-14 | 74 | 0.74% |
| 11 | FECHA_SINTOMAS | 10000 | 0 | 853 | 2022-01-10 | 81 | 0.81% | 2022-01-17 | 66 | 0.66% |
| 12 | FECHA_DEF | 10000 | 0 | 210 | 9999-99-99 | 9741 | 97.41% | 2020-06-15 | 4 | 0.04% |
| 13 | INTUBADO | 10000 | 0 | 4 | NO APLICA | 9265 | 92.65% | NO | 649 | 6.49% |
| 14 | NEUMONIA | 10000 | 0 | 3 | NO | 9431 | 94.31% | SI | 466 | 4.66% |
| 15 | NACIONALIDAD | 10000 | 0 | 2 | MEXICANA | 9920 | 99.2% | EXTRANJERA | 80 | 0.8% |
| 16 | EMBARAZO | 10000 | 0 | 4 | NO | 5212 | 52.12% | NO APLICA | 4651 | 46.51% |
| 17 | HABLA_LENGUA_INDIG | 10000 | 0 | 3 | NO | 9248 | 92.48% | NO ESPECIFICADO | 703 | 7.03% |
| 18 | INDIGENA | 10000 | 0 | 3 | NO | 9228 | 92.28% | NO ESPECIFICADO | 696 | 6.96% |
| 19 | DIABETES | 10000 | 0 | 3 | NO | 9157 | 91.57% | SI | 801 | 8.01% |
| 20 | EPOC | 10000 | 0 | 3 | NO | 9891 | 98.91% | SI | 67 | 0.67% |
| 21 | ASMA | 10000 | 0 | 3 | NO | 9780 | 97.8% | SI | 179 | 1.79% |
| 22 | INMUSUPR | 10000 | 0 | 3 | NO | 9904 | 99.04% | SI | 55 | 0.55% |
| 23 | HIPERTENSION | 10000 | 0 | 3 | NO | 8853 | 88.53% | SI | 1107 | 11.07% |
| 24 | OTRA_COM | 10000 | 0 | 3 | NO | 9711 | 97.11% | SE IGNORA | 156 | 1.56% |
| 25 | CARDIOVASCULAR | 10000 | 0 | 3 | NO | 9863 | 98.63% | SI | 97 | 0.97% |
| 26 | OBESIDAD | 10000 | 0 | 3 | NO | 9065 | 90.65% | SI | 895 | 8.95% |
| 27 | RENAL_CRONICA | 10000 | 0 | 3 | NO | 9859 | 98.59% | SI | 101 | 1.01% |
| 28 | TABAQUISMO | 10000 | 0 | 3 | NO | 9364 | 93.64% | SI | 596 | 5.96% |
| 29 | OTRO_CASO | 10000 | 0 | 3 | NO | 6307 | 63.07% | SI | 3353 | 33.53% |
| 30 | TOMA_MUESTRA_LAB | 10000 | 0 | 2 | NO | 6519 | 65.19% | SI | 3481 | 34.81% |
| 31 | RESULTADO_LAB | 10000 | 0 | 5 | NO APLICA | 6519 | 65.19% | NO POSITIVO | 1943 | 19.43% |
| 32 | TOMA_MUESTRA_ANTIGENO | 10000 | 0 | 2 | SI | 6649 | 66.49% | NO | 3351 | 33.51% |
| 33 | RESULTADO_ANTIGENO | 10000 | 0 | 3 | NEGATIVO | 4437 | 44.37% | NO APLICA | 3351 | 33.51% |
| 34 | CLASIFICACION_FINAL | 10000 | 0 | 7 | NEGATIVO | 5844 | 58.44% | PRUEBA | 3516 | 35.16% |
| 35 | MIGRANTE | 10000 | 0 | 3 | NO ESPECIFICADO | 9924 | 99.24% | 2 | 61 | 0.61% |
| 36 | PAIS_NACIONALIDAD | 10000 | 0 | 22 | MEXICANA | 9920 | 99.2% | Estados Unidos de América | 36 | 0.36% |
| 37 | PAIS_ORIGEN | 10000 | 0 | 10 | NO APLICA | 9987 | 99.87% | Ecuador | 2 | 0.02% |
| 38 | UCI | 10000 | 0 | 4 | NO APLICA | 9265 | 92.65% | NO | 685 | 6.85% |
| Count | Miss | Card | Min | Qrt1 | Median | Qrt3 | Max | Mean | Sdev | |
|---|---|---|---|---|---|---|---|---|---|---|
| MUNICIPIO_RES | 10000 | 0 | 185 | 1 | 7 | 15 | 38 | 999 | 35.62 | 80.46 |
| EDAD | 10000 | 0 | 102 | 0 | 26 | 37 | 50 | 121 | 38.81 | 17.09 |
| VARIABLE | N | HOMBRE, N = 4,6511 | MUJER, N = 5,3491 | p-value2 |
|---|---|---|---|---|
| EDAD | 10,000 | 36 (26, 50) | 38 (27, 50) | 0.015 |
| ORIGEN | 10,000 | 0.3 | ||
| NO USMER | 3,606 (78%) | 4,101 (77%) | ||
| USMER | 1,045 (22%) | 1,248 (23%) | ||
| SECTOR | 10,000 | |||
| CRUZ ROJA | 1 (<0.1%) | 1 (<0.1%) | ||
| ESTATAL | 52 (1.1%) | 69 (1.3%) | ||
| IMSS | 1,612 (35%) | 1,868 (35%) | ||
| IMSS-BIENESTAR | 18 (0.4%) | 18 (0.3%) | ||
| ISSSTE | 103 (2.2%) | 140 (2.6%) | ||
| MUNICIPAL | 0 (0%) | 4 (<0.1%) | ||
| PEMEX | 21 (0.5%) | 19 (0.4%) | ||
| PRIVADA | 304 (6.5%) | 290 (5.4%) | ||
| SEDENA | 19 (0.4%) | 14 (0.3%) | ||
| SEMAR | 6 (0.1%) | 9 (0.2%) | ||
| SSA | 2,513 (54%) | 2,917 (55%) | ||
| UNIVERSITARIO | 2 (<0.1%) | 0 (0%) | ||
| TIPO_PACIENTE | 10,000 | <0.001 | ||
| AMBULATORIO | 4,242 (91%) | 5,023 (94%) | ||
| HOSPITALIZADO | 409 (8.8%) | 326 (6.1%) | ||
| INTUBADO | 10,000 | <0.001 | ||
| NO | 361 (7.8%) | 288 (5.4%) | ||
| NO APLICA | 4,242 (91%) | 5,023 (94%) | ||
| NO ESPECIFICADO | 3 (<0.1%) | 5 (<0.1%) | ||
| SI | 45 (1.0%) | 33 (0.6%) | ||
| NEUMONIA | 10,000 | <0.001 | ||
| NO | 4,342 (93%) | 5,089 (95%) | ||
| NO ESPECIFICADO | 45 (1.0%) | 58 (1.1%) | ||
| SI | 264 (5.7%) | 202 (3.8%) | ||
| NACIONALIDAD | 10,000 | 0.9 | ||
| EXTRANJERA | 38 (0.8%) | 42 (0.8%) | ||
| MEXICANA | 4,613 (99%) | 5,307 (99%) | ||
| EMBARAZO | 10,000 | <0.001 | ||
| NO | 0 (0%) | 5,212 (97%) | ||
| NO APLICA | 4,651 (100%) | 0 (0%) | ||
| SE IGNORA | 0 (0%) | 39 (0.7%) | ||
| SI | 0 (0%) | 98 (1.8%) | ||
| HABLA_LENGUA_INDIG | 10,000 | 0.5 | ||
| NO | 4,307 (93%) | 4,941 (92%) | ||
| NO ESPECIFICADO | 318 (6.8%) | 385 (7.2%) | ||
| SI | 26 (0.6%) | 23 (0.4%) | ||
| INDIGENA | 10,000 | 0.6 | ||
| NO | 4,300 (92%) | 4,928 (92%) | ||
| NO ESPECIFICADO | 313 (6.7%) | 383 (7.2%) | ||
| SI | 38 (0.8%) | 38 (0.7%) | ||
| DIABETES | 10,000 | <0.001 | ||
| NO | 4,255 (91%) | 4,902 (92%) | ||
| SE IGNORA | 33 (0.7%) | 9 (0.2%) | ||
| SI | 363 (7.8%) | 438 (8.2%) | ||
| EPOC | 10,000 | <0.001 | ||
| NO | 4,588 (99%) | 5,303 (99%) | ||
| SE IGNORA | 32 (0.7%) | 10 (0.2%) | ||
| SI | 31 (0.7%) | 36 (0.7%) | ||
| ASMA | 10,000 | <0.001 | ||
| NO | 4,558 (98%) | 5,222 (98%) | ||
| SE IGNORA | 33 (0.7%) | 8 (0.1%) | ||
| SI | 60 (1.3%) | 119 (2.2%) | ||
| INMUSUPR | 10,000 | <0.001 | ||
| NO | 4,598 (99%) | 5,306 (99%) | ||
| SE IGNORA | 33 (0.7%) | 8 (0.1%) | ||
| SI | 20 (0.4%) | 35 (0.7%) | ||
| HIPERTENSION | 10,000 | <0.001 | ||
| NO | 4,119 (89%) | 4,734 (89%) | ||
| SE IGNORA | 32 (0.7%) | 8 (0.1%) | ||
| SI | 500 (11%) | 607 (11%) | ||
| CARDIOVASCULAR | 10,000 | <0.001 | ||
| NO | 4,579 (98%) | 5,284 (99%) | ||
| SE IGNORA | 32 (0.7%) | 8 (0.1%) | ||
| SI | 40 (0.9%) | 57 (1.1%) | ||
| OBESIDAD | 10,000 | <0.001 | ||
| NO | 4,263 (92%) | 4,802 (90%) | ||
| SE IGNORA | 31 (0.7%) | 9 (0.2%) | ||
| SI | 357 (7.7%) | 538 (10%) | ||
| RENAL_CRONICA | 10,000 | <0.001 | ||
| NO | 4,573 (98%) | 5,286 (99%) | ||
| SE IGNORA | 31 (0.7%) | 9 (0.2%) | ||
| SI | 47 (1.0%) | 54 (1.0%) | ||
| TABAQUISMO | 10,000 | <0.001 | ||
| NO | 4,234 (91%) | 5,130 (96%) | ||
| SE IGNORA | 31 (0.7%) | 9 (0.2%) | ||
| SI | 386 (8.3%) | 210 (3.9%) | ||
| OTRO_CASO | 10,000 | <0.001 | ||
| NO | 3,019 (65%) | 3,288 (61%) | ||
| NO ESPECIFICADO | 179 (3.8%) | 161 (3.0%) | ||
| SI | 1,453 (31%) | 1,900 (36%) | ||
| TOMA_MUESTRA_LAB | 10,000 | <0.001 | ||
| NO | 2,953 (63%) | 3,566 (67%) | ||
| SI | 1,698 (37%) | 1,783 (33%) | ||
| RESULTADO_LAB | 10,000 | |||
| NO ADECUADO | 72 (1.5%) | 84 (1.6%) | ||
| NO APLICA | 2,953 (63%) | 3,566 (67%) | ||
| NO POSITIVO | 918 (20%) | 1,025 (19%) | ||
| PENDIENTE | 7 (0.2%) | 1 (<0.1%) | ||
| POSITIVO | 701 (15%) | 673 (13%) | ||
| TOMA_MUESTRA_ANTIGENO | 10,000 | <0.001 | ||
| NO | 1,649 (35%) | 1,702 (32%) | ||
| SI | 3,002 (65%) | 3,647 (68%) | ||
| RESULTADO_ANTIGENO | 10,000 | <0.001 | ||
| NEGATIVO | 1,987 (43%) | 2,450 (46%) | ||
| NO APLICA | 1,649 (35%) | 1,702 (32%) | ||
| POSITIVO | 1,015 (22%) | 1,197 (22%) | ||
| MIGRANTE | 10,000 | 0.3 | ||
| 1 | 10 (0.2%) | 5 (<0.1%) | ||
| 2 | 27 (0.6%) | 34 (0.6%) | ||
| NO ESPECIFICADO | 4,614 (99%) | 5,310 (99%) | ||
| UCI | 10,000 | <0.001 | ||
| NO | 380 (8.2%) | 305 (5.7%) | ||
| NO APLICA | 4,242 (91%) | 5,023 (94%) | ||
| NO ESPECIFICADO | 3 (<0.1%) | 5 (<0.1%) | ||
| SI | 26 (0.6%) | 16 (0.3%) | ||
| CLASIFICACION_FINAL | 10,000 | |||
| CLINICA | 98 (2.1%) | 116 (2.2%) | ||
| COMITE | 9 (0.2%) | 2 (<0.1%) | ||
| INVALIDO | 3 (<0.1%) | 5 (<0.1%) | ||
| NEGATIVO | 2,663 (57%) | 3,181 (59%) | ||
| NO REALIZADO | 23 (0.5%) | 26 (0.5%) | ||
| PRUEBA | 1,684 (36%) | 1,832 (34%) | ||
| SOSPECHOSO | 171 (3.7%) | 187 (3.5%) | ||
|
1
Median (IQR); n (%)
2
Wilcoxon rank sum test; Pearson's Chi-squared test; Fisher's exact test
|
||||