Iniciando la exploración de los datos comparando la información en las tres bases de datos del proyecto:
La base de datos fullclass.csv contiene las siguientes variables extras a class.csv:
Se agrega la variable Teacher, queda la duda sobre las variables FOBAP, RES (qué significan? capaz nos convenga integrar un codebook único como parte del preproceso.).
| ABSENT (N=35) |
MILD (N=113) |
MODERATE (N=67) |
SEVERE (N=8) |
P-value | |
|---|---|---|---|---|---|
| genero | |||||
| Hombre | 10 (28.6%) | 34 (30.1%) | 17 (25.4%) | 1 (12.5%) | 0.22 |
| Mujer | 21 (60.0%) | 79 (69.9%) | 50 (74.6%) | 7 (87.5%) | |
| Otro | 1 (2.9%) | 0 (0%) | 0 (0%) | 0 (0%) | |
| Missing | 3 (8.6%) | 0 (0%) | 0 (0%) | 0 (0%) | |
| edad | |||||
| 18 a 30 años | 6 (17.1%) | 35 (31.0%) | 11 (16.4%) | 1 (12.5%) | 0.162 |
| 31 a 40 años | 10 (28.6%) | 31 (27.4%) | 29 (43.3%) | 3 (37.5%) | |
| 41 a 50 años | 6 (17.1%) | 27 (23.9%) | 9 (13.4%) | 3 (37.5%) | |
| 51 a 60 años | 8 (22.9%) | 13 (11.5%) | 14 (20.9%) | 1 (12.5%) | |
| Mayor de 60 años | 1 (2.9%) | 6 (5.3%) | 4 (6.0%) | 0 (0%) | |
| Missing | 4 (11.4%) | 1 (0.9%) | 0 (0%) | 0 (0%) | |
| grado_academico | |||||
| Preparatoria | 2 (5.7%) | 2 (1.8%) | 2 (3.0%) | 0 (0%) | 0.092 |
| Licenciatura | 24 (68.6%) | 76 (67.3%) | 52 (77.6%) | 3 (37.5%) | |
| Posgrado (maestría, doctorado, especialidad) | 6 (17.1%) | 35 (31.0%) | 13 (19.4%) | 5 (62.5%) | |
| Missing | 3 (8.6%) | 0 (0%) | 0 (0%) | 0 (0%) | |
| habitantes_en_casa | |||||
| 1 | 5 (14.3%) | 9 (8.0%) | 3 (4.5%) | 0 (0%) | 0.469 |
| 2 | 10 (28.6%) | 24 (21.2%) | 14 (20.9%) | 0 (0%) | |
| 3 | 7 (20.0%) | 24 (21.2%) | 16 (23.9%) | 1 (12.5%) | |
| 4 | 6 (17.1%) | 30 (26.5%) | 21 (31.3%) | 3 (37.5%) | |
| Missing | 7 (20.0%) | 26 (23.0%) | 13 (19.4%) | 4 (50.0%) | |
| enfermedades | |||||
| Cáncer; | 1 (2.9%) | 0 (0%) | 0 (0%) | 0 (0%) | 0.805 |
| Diabetes;Cáncer;VIH (SIDA);Obesidad; | 1 (2.9%) | 0 (0%) | 0 (0%) | 0 (0%) | |
| Enfermedad autoinmune (p.ej. Artritis reumatoide, Lupus); | 1 (2.9%) | 1 (0.9%) | 2 (3.0%) | 0 (0%) | |
| Enfermedades cardiacas (p.ej. hipertensión, infarto); | 1 (2.9%) | 4 (3.5%) | 1 (1.5%) | 0 (0%) | |
| Enfermedades cardiacas (p.ej. hipertensión, infarto);Enfermedades pulmonares (p. ej. Asma, EPOC, tuberculosis);Obesidad; | 1 (2.9%) | 0 (0%) | 0 (0%) | 0 (0%) | |
| Enfermedades cardiacas (p.ej. hipertensión, infarto);Obesidad; | 1 (2.9%) | 1 (0.9%) | 0 (0%) | 0 (0%) | |
| Ninguna; | 22 (62.9%) | 75 (66.4%) | 40 (59.7%) | 7 (87.5%) | |
| Obesidad; | 3 (8.6%) | 8 (7.1%) | 7 (10.4%) | 1 (12.5%) | |
| Otra; | 1 (2.9%) | 7 (6.2%) | 4 (6.0%) | 0 (0%) | |
| Diabetes; | 0 (0%) | 4 (3.5%) | 4 (6.0%) | 0 (0%) | |
| Diabetes;Enfermedades cardiacas (p.ej. hipertensión, infarto); | 0 (0%) | 1 (0.9%) | 2 (3.0%) | 0 (0%) | |
| Diabetes;Enfermedades cardiacas (p.ej. hipertensión, infarto);Enfermedades pulmonares (p. ej. Asma, EPOC, tuberculosis);Obesidad; | 0 (0%) | 1 (0.9%) | 0 (0%) | 0 (0%) | |
| Diabetes;Obesidad;Enfermedades cardiacas (p.ej. hipertensión, infarto); | 0 (0%) | 1 (0.9%) | 0 (0%) | 0 (0%) | |
| Enfermedades pulmonares (p. ej. Asma, EPOC, tuberculosis); | 0 (0%) | 1 (0.9%) | 3 (4.5%) | 0 (0%) | |
| Enfermedades pulmonares (p. ej. Asma, EPOC, tuberculosis);Obesidad; | 0 (0%) | 1 (0.9%) | 1 (1.5%) | 0 (0%) | |
| Enfermedades pulmonares (p. ej. Asma, EPOC); | 0 (0%) | 1 (0.9%) | 0 (0%) | 0 (0%) | |
| Obesidad;Diabetes;Enfermedades cardiacas (p.ej. hipertensión, infarto); | 0 (0%) | 1 (0.9%) | 0 (0%) | 0 (0%) | |
| Obesidad;Otra; | 0 (0%) | 1 (0.9%) | 0 (0%) | 0 (0%) | |
| Diabetes;Obesidad; | 0 (0%) | 0 (0%) | 1 (1.5%) | 0 (0%) | |
| Enfermedades cardiacas (p.ej. hipertensión, infarto);Otra; | 0 (0%) | 0 (0%) | 1 (1.5%) | 0 (0%) | |
| Missing | 3 (8.6%) | 5 (4.4%) | 1 (1.5%) | 0 (0%) | |
| modalidad_clases | |||||
| En linea | 0 (0%) | 1 (0.9%) | 0 (0%) | 0 (0%) | 0.727 |
| En línea | 29 (82.9%) | 90 (79.6%) | 59 (88.1%) | 6 (75.0%) | |
| Mixto (presencial y en línea) | 0 (0%) | 12 (10.6%) | 3 (4.5%) | 1 (12.5%) | |
| No aplica | 2 (5.7%) | 7 (6.2%) | 2 (3.0%) | 0 (0%) | |
| Presencial | 1 (2.9%) | 3 (2.7%) | 2 (3.0%) | 0 (0%) | |
| Missing | 3 (8.6%) | 0 (0%) | 1 (1.5%) | 1 (12.5%) | |
| horas_trabajo_diarias | |||||
| No aplica | 1 (2.9%) | 0 (0%) | 2 (3.0%) | 1 (12.5%) | NA |
| 1 a 4 hroas al día | 0 (0%) | 0 (0%) | 0 (0%) | 0 (0%) | |
| 4 a 6 horas al día | 5 (14.3%) | 20 (17.7%) | 16 (23.9%) | 0 (0%) | |
| 6 a 8 horas al día | 14 (40.0%) | 44 (38.9%) | 11 (16.4%) | 4 (50.0%) | |
| Más de 8 horas al día | 9 (25.7%) | 37 (32.7%) | 28 (41.8%) | 3 (37.5%) | |
| Missing | 6 (17.1%) | 12 (10.6%) | 10 (14.9%) | 0 (0%) | |
| estado_residencia | |||||
| Baja California | 9 (25.7%) | 29 (25.7%) | 11 (16.4%) | 0 (0%) | 0.077 |
| Campeche | 0 (0%) | 2 (1.8%) | 1 (1.5%) | 0 (0%) | |
| Chihuahua | 3 (8.6%) | 16 (14.2%) | 6 (9.0%) | 0 (0%) | |
| Coahuila de Zaragoza | 1 (2.9%) | 5 (4.4%) | 8 (11.9%) | 3 (37.5%) | |
| Estado de México | 0 (0%) | 1 (0.9%) | 0 (0%) | 0 (0%) | |
| Hidalgo | 0 (0%) | 5 (4.4%) | 11 (16.4%) | 2 (25.0%) | |
| Nuevo León | 1 (2.9%) | 9 (8.0%) | 3 (4.5%) | 1 (12.5%) | |
| Oaxaca | 0 (0%) | 2 (1.8%) | 0 (0%) | 0 (0%) | |
| Puebla | 0 (0%) | 1 (0.9%) | 0 (0%) | 0 (0%) | |
| San Luis Potosí | 0 (0%) | 0 (0%) | 1 (1.5%) | 1 (12.5%) | |
| Sinaloa | 6 (17.1%) | 7 (6.2%) | 7 (10.4%) | 0 (0%) | |
| Sonora | 9 (25.7%) | 29 (25.7%) | 13 (19.4%) | 1 (12.5%) | |
| Tamaulipas | 1 (2.9%) | 1 (0.9%) | 4 (6.0%) | 0 (0%) | |
| Veracruz | 0 (0%) | 1 (0.9%) | 0 (0%) | 0 (0%) | |
| Yucatán | 0 (0%) | 1 (0.9%) | 0 (0%) | 0 (0%) | |
| Missing | 5 (14.3%) | 4 (3.5%) | 2 (3.0%) | 0 (0%) | |
| nivel_educativo_clases | |||||
| Licenciatura; | 1 (2.9%) | 13 (11.5%) | 11 (16.4%) | 1 (12.5%) | 0.117 |
| Posgrado; | 1 (2.9%) | 0 (0%) | 0 (0%) | 1 (12.5%) | |
| Preparatoria; | 2 (5.7%) | 6 (5.3%) | 8 (11.9%) | 1 (12.5%) | |
| Primaria; | 11 (31.4%) | 31 (27.4%) | 21 (31.3%) | 3 (37.5%) | |
| Primaria;Secundaria; | 7 (20.0%) | 7 (6.2%) | 3 (4.5%) | 0 (0%) | |
| Primaria;Secundaria;Preparatoria; | 1 (2.9%) | 7 (6.2%) | 4 (6.0%) | 0 (0%) | |
| Secundaria; | 3 (8.6%) | 10 (8.8%) | 8 (11.9%) | 0 (0%) | |
| Secundaria;Preparatoria; | 3 (8.6%) | 19 (16.8%) | 4 (6.0%) | 1 (12.5%) | |
| Secundaria;Primaria; | 1 (2.9%) | 0 (0%) | 0 (0%) | 0 (0%) | |
| Licenciatura;Posgrado; | 0 (0%) | 1 (0.9%) | 0 (0%) | 0 (0%) | |
| Licenciatura;Preparatoria; | 0 (0%) | 1 (0.9%) | 0 (0%) | 0 (0%) | |
| Preparatoria;Licenciatura; | 0 (0%) | 1 (0.9%) | 0 (0%) | 0 (0%) | |
| Preparatoria;Secundaria; | 0 (0%) | 3 (2.7%) | 2 (3.0%) | 0 (0%) | |
| Primaria;Licenciatura; | 0 (0%) | 1 (0.9%) | 1 (1.5%) | 0 (0%) | |
| Primaria;Preparatoria; | 0 (0%) | 2 (1.8%) | 0 (0%) | 0 (0%) | |
| Primaria;Secundaria;Licenciatura; | 0 (0%) | 2 (1.8%) | 0 (0%) | 0 (0%) | |
| Primaria;Secundaria;Preparatoria;Licenciatura;Posgrado; | 0 (0%) | 1 (0.9%) | 0 (0%) | 0 (0%) | |
| Secundaria;Licenciatura; | 0 (0%) | 1 (0.9%) | 0 (0%) | 0 (0%) | |
| Secundaria;Preparatoria;Primaria; | 0 (0%) | 1 (0.9%) | 0 (0%) | 0 (0%) | |
| Preparatoria;Primaria; | 0 (0%) | 0 (0%) | 1 (1.5%) | 0 (0%) | |
| Primaria;Posgrado; | 0 (0%) | 0 (0%) | 1 (1.5%) | 0 (0%) | |
| Posgrado;Licenciatura; | 0 (0%) | 0 (0%) | 0 (0%) | 1 (12.5%) | |
| Missing | 5 (14.3%) | 6 (5.3%) | 3 (4.5%) | 0 (0%) | |
| Danger | |||||
| Mean (SD) | 5.20 (3.76) | 12.6 (2.82) | 17.7 (3.37) | 23.0 (1.41) | <0.001 |
| Median [Min, Max] | 6.00 [0, 11.0] | 13.0 [6.00, 19.0] | 18.0 [8.00, 24.0] | 24.0 [21.0, 24.0] | |
| Xeno | |||||
| Mean (SD) | 4.40 (3.81) | 11.0 (3.41) | 16.4 (3.16) | 21.9 (2.47) | <0.001 |
| Median [Min, Max] | 4.00 [0, 12.0] | 11.0 [4.00, 22.0] | 17.0 [10.0, 24.0] | 22.5 [17.0, 24.0] | |
| Socio | |||||
| Mean (SD) | 4.91 (4.03) | 14.9 (5.51) | 22.4 (5.00) | 31.6 (2.83) | <0.001 |
| Median [Min, Max] | 5.00 [0, 14.0] | 14.0 [4.00, 32.0] | 23.0 [11.0, 32.0] | 31.5 [27.0, 36.0] | |
| Con | |||||
| Mean (SD) | 3.29 (2.76) | 10.1 (3.80) | 15.1 (3.61) | 20.5 (3.42) | <0.001 |
| Median [Min, Max] | 3.00 [0, 8.00] | 10.0 [2.00, 23.0] | 15.0 [4.00, 24.0] | 21.0 [15.0, 24.0] | |
| Trauma | |||||
| Mean (SD) | 0.571 (0.884) | 3.42 (3.53) | 9.81 (5.36) | 19.5 (2.88) | <0.001 |
| Median [Min, Max] | 0 [0, 3.00] | 2.00 [0, 16.0] | 10.0 [0, 22.0] | 19.5 [15.0, 24.0] | |
| Comp | |||||
| Mean (SD) | 1.86 (2.40) | 6.61 (3.66) | 11.9 (4.93) | 17.1 (4.36) | <0.001 |
| Median [Min, Max] | 1.00 [0, 8.00] | 6.00 [0, 17.0] | 12.0 [0, 24.0] | 18.0 [8.00, 22.0] | |
| FOBAP | |||||
| Mean (SD) | 1.17 (1.32) | 2.72 (1.73) | 4.57 (1.73) | 6.63 (1.51) | <0.001 |
| Median [Min, Max] | 1.00 [0, 5.00] | 2.00 [0, 8.00] | 4.00 [0, 8.00] | 7.00 [4.00, 8.00] | |
| RES | |||||
| Mean (SD) | 12.8 (7.80) | 16.8 (3.41) | 15.7 (4.02) | 13.9 (4.82) | 0.039 |
| Median [Min, Max] | 16.0 [0, 20.0] | 18.0 [0, 20.0] | 16.0 [3.00, 20.0] | 16.0 [5.00, 19.0] |
All models use the variable Level as dependent variable.
Model 1 adjusts for the following variables:
genero, edad, Danger, Xeno, Socio, Con, Trauma, FOBAP, RESModel 2 adjusts for the variables in Model 1 plus the following:
grado_academico, habitantes_en_casaModel 3 adjusts for the variables in Model 2 plus the following:
modalidad_clases| Dependent variable: | |||
| Level | |||
| Model 1 | Model 2 | Model 3 | |
| (1) | (2) | (3) | |
| generoMujer | -1.114 | -1.019 | -0.700 |
| p = 0.210 | p = 0.328 | p = 0.543 | |
| generoOtro | -7.365 | 7.396 | -3.346 |
| p = 0.000*** | p = 0.000*** | p = 0.000*** | |
| edad.L | -0.935 | ||
| p = 0.400 | |||
| edad.Q | -0.868 | ||
| p = 0.362 | |||
| edad.C | 0.234 | ||
| p = 0.761 | |||
| edad4 | -0.877 | ||
| p = 0.239 | |||
| grado_academico.L | 1.814 | 1.775 | |
| p = 0.517 | p = 0.559 | ||
| grado_academico.Q | -0.316 | 0.077 | |
| p = 0.850 | p = 0.967 | ||
| habitantes_en_casa.L | 1.087 | 0.587 | |
| p = 0.224 | p = 0.544 | ||
| habitantes_en_casa.Q | -1.264 | -0.777 | |
| p = 0.142 | p = 0.417 | ||
| habitantes_en_casa.C | 0.130 | 0.128 | |
| p = 0.866 | p = 0.870 | ||
| modalidad_clasesEn línea | -1.429 | ||
| p = 0.241 | |||
| modalidad_clasesMixto (presencial y en línea) | -1.387 | ||
| p = 0.486 | |||
| modalidad_clasesNo aplica | -2.151 | ||
| p = 0.208 | |||
| modalidad_clasesPresencial | -5.617 | ||
| p = 0.069* | |||
| Danger | 0.594 | 0.662 | 0.654 |
| p = 0.0003*** | p = 0.001*** | p = 0.002*** | |
| Xeno | 0.226 | 0.144 | 0.195 |
| p = 0.081* | p = 0.317 | p = 0.241 | |
| Socio | 0.482 | 0.607 | 0.595 |
| p = 0.00002*** | p = 0.0002*** | p = 0.0002*** | |
| Con | 0.469 | 0.503 | 0.517 |
| p = 0.0002*** | p = 0.001*** | p = 0.002*** | |
| Trauma | 0.643 | 0.841 | 0.861 |
| p = 0.00000*** | p = 0.0001*** | p = 0.00005*** | |
| FOBAP | 0.218 | 0.351 | 0.371 |
| p = 0.330 | p = 0.176 | p = 0.201 | |
| RES | 0.043 | 0.130 | 0.122 |
| p = 0.628 | p = 0.243 | p = 0.277 | |
| Observations | 218 | 173 | 171 |
| Note: | p<0.1; p<0.05; p<0.01 | ||