Resultados IDX 13: Salud mental

Resultados para toda Antioquia

Resumen: Este informe presenta el análisis y los resultados del Índice de Salud Mental para los municipios de Antioquia. Se describe la metodología utilizada, se muestran estadísticas descriptivas de las variables involucradas, se explica la construcción del índice mediante análisis de componentes principales (PCA) y se presentan los resultados numéricos y espaciales. Además, se facilita la descarga de la base de datos y los gráficos generados, así como el acceso al código fuente empleado en el estudio. ## Descarga de datos

Puedes descargar la base de datos asociada a este índice aquí: Descargar base de datos IDX 13

Estadísticas descriptivas

Code 
library(readxl)
library(knitr)
Warning: package 'knitr' was built under R version 4.5.2
Code 
library(magrittr)
ruta_excel <- "all/01_TablasDescriptivas/idx13_saludmental_summary_labels.xlsx"
tabla_resumen <- read_xlsx(ruta_excel)
tabla_resumen %>%
  dplyr::select(Etiqueta, N, Media, SD, Min, Max) %>%
  dplyr::mutate(Media = round(Media, 3), SD = round(SD, 3), Min = round(Min, 3), Max = round(Max, 3)) %>%
  kable(caption = "Resumen de variables numéricas válidas")
Resumen de variables numéricas válidas
Etiqueta N Media SD Min Max
Intento de suicidio x100k 125 -63.528 33.383 -189.484 -10.429
Intento suicidio H x100k 125 -47.570 28.645 -169.858 0.000
Intento suicidio M x100k 125 -85.711 47.277 -256.988 0.000
Intento suicidio 15–29 x100k 125 -174.359 95.020 -494.077 -42.058
Intento suicidio 30–59 x100k 125 -49.482 30.905 -174.135 0.000
Intento suicidio 15–64 x100k 125 -83.610 42.074 -227.883 -19.050
Suicidios x100k 125 -10.506 7.753 -38.600 0.000
Suicidios H x100k 125 -16.355 13.560 -66.704 0.000
Suicidios M x100k 125 -4.635 9.519 -82.001 0.000
Suicidios 15–29 x100k 125 -18.099 22.689 -149.701 0.000
Suicidios 30–59 x100k 125 -11.824 14.782 -93.052 0.000
Suicidios 15–64 x100k 125 -13.875 11.575 -54.925 0.000

Construcción del índice

Code 
knitr::include_graphics("all/02_Imagenes/idx13_saludmental_results.png")

Resultados completos en PNG

Resultados numéricos

Code 
ruta_excel <- "all/idx13_saludmental_loadings_y_tops.xlsx"
loadings <- read_xlsx(ruta_excel, sheet = "loadings")
variance <- read_xlsx(ruta_excel, sheet = "variance")
top_PC1 <- read_xlsx(ruta_excel, sheet = "top_PC1")
top_PC2 <- read_xlsx(ruta_excel, sheet = "top_PC2")
kable(loadings, caption = "Cargas por variable y componente (loadings)")
Cargas por variable y componente (loadings)
variable component loading peso_relativo peso_relativo_pct
Intento suicidio 15–29 x100k PC1 -0.4084046 0.1385949 13.9
Intento suicidio 15–64 x100k PC1 -0.4312564 0.1463498 14.6
Intento suicidio 30–59 x100k PC1 -0.3287873 0.1115762 11.2
Intento suicidio H x100k PC1 -0.3664478 0.1243566 12.4
Intento suicidio M x100k PC1 -0.4006679 0.1359694 13.6
Intento de suicidio x100k PC1 -0.4232308 0.1436263 14.4
Suicidios 15–29 x100k PC1 -0.0552508 0.0187497 1.9
Suicidios 15–64 x100k PC1 -0.1119877 0.0380038 3.8
Suicidios 30–59 x100k PC1 -0.1061031 0.0360068 3.6
Suicidios H x100k PC1 -0.1289025 0.0437440 4.4
Suicidios M x100k PC1 -0.0455930 0.0154723 1.5
Suicidios x100k PC1 -0.1401184 0.0475502 4.8
Intento suicidio 15–29 x100k PC2 -0.1422905 0.0489680 4.9
Intento suicidio 15–64 x100k PC2 -0.1233776 0.0424593 4.2
Intento suicidio 30–59 x100k PC2 0.0625257 0.0215176 2.2
Intento suicidio H x100k PC2 -0.1309893 0.0450788 4.5
Intento suicidio M x100k PC2 -0.0972587 0.0334707 3.3
Intento de suicidio x100k PC2 -0.1464609 0.0504032 5.0
Suicidios 15–29 x100k PC2 0.3294958 0.1133930 11.3
Suicidios 15–64 x100k PC2 0.4957886 0.1706211 17.1
Suicidios 30–59 x100k PC2 0.3489080 0.1200735 12.0
Suicidios H x100k PC2 0.4511848 0.1552711 15.5
Suicidios M x100k PC2 0.1069322 0.0367997 3.7
Suicidios x100k PC2 0.4705749 0.1619441 16.2
Intento suicidio 15–29 x100k PC3 0.0085402 0.0038558 0.4
Intento suicidio 15–64 x100k PC3 0.0238285 0.0107583 1.1
Intento suicidio 30–59 x100k PC3 -0.0397495 0.0179465 1.8
Intento suicidio H x100k PC3 0.0292142 0.0131900 1.3
Intento suicidio M x100k PC3 -0.0364923 0.0164760 1.6
Intento de suicidio x100k PC3 0.0158195 0.0071424 0.7
Suicidios 15–29 x100k PC3 0.4162016 0.1879114 18.8
Suicidios 15–64 x100k PC3 -0.0318083 0.0143612 1.4
Suicidios 30–59 x100k PC3 -0.4353115 0.1965393 19.7
Suicidios H x100k PC3 -0.2724990 0.1230309 12.3
Suicidios M x100k PC3 0.7242471 0.3269913 32.7
Suicidios x100k PC3 0.1811703 0.0817968 8.2
Intento suicidio 15–29 x100k PC4 0.0891692 0.0340480 3.4
Intento suicidio 15–64 x100k PC4 0.0096792 0.0036959 0.4
Intento suicidio 30–59 x100k PC4 -0.1877750 0.0716992 7.2
Intento suicidio H x100k PC4 -0.2319815 0.0885788 8.9
Intento suicidio M x100k PC4 0.1594932 0.0609002 6.1
Intento de suicidio x100k PC4 0.0082535 0.0031515 0.3
Suicidios 15–29 x100k PC4 -0.5769074 0.2202837 22.0
Suicidios 15–64 x100k PC4 -0.0401180 0.0153185 1.5
Suicidios 30–59 x100k PC4 0.4719928 0.1802236 18.0
Suicidios H x100k PC4 -0.1648275 0.0629370 6.3
Suicidios M x100k PC4 0.5163671 0.1971673 19.7
Suicidios x100k PC4 0.1623645 0.0619965 6.2
Intento suicidio 15–29 x100k PC5 -0.2946096 0.1391784 13.9
Intento suicidio 15–64 x100k PC5 -0.0847895 0.0400560 4.0
Intento suicidio 30–59 x100k PC5 0.8984702 0.4244521 42.4
Intento suicidio H x100k PC5 -0.0466513 0.0220388 2.2
Intento suicidio M x100k PC5 -0.0919040 0.0434170 4.3
Intento de suicidio x100k PC5 -0.1287201 0.0608095 6.1
Suicidios 15–29 x100k PC5 -0.1713256 0.0809370 8.1
Suicidios 15–64 x100k PC5 -0.0664316 0.0313834 3.1
Suicidios 30–59 x100k PC5 0.0336680 0.0159053 1.6
Suicidios H x100k PC5 -0.1386247 0.0654886 6.5
Suicidios M x100k PC5 0.1277237 0.0603388 6.0
Suicidios x100k PC5 -0.0338582 0.0159952 1.6
Intento suicidio 15–29 x100k PC6 -0.0438054 0.0204405 2.0
Intento suicidio 15–64 x100k PC6 -0.0169424 0.0079057 0.8
Intento suicidio 30–59 x100k PC6 -0.0979168 0.0456901 4.6
Intento suicidio H x100k PC6 0.7668101 0.3578103 35.8
Intento suicidio M x100k PC6 -0.5559430 0.2594152 25.9
Intento de suicidio x100k PC6 -0.0433147 0.0202116 2.0
Suicidios 15–29 x100k PC6 -0.1397585 0.0652143 6.5
Suicidios 15–64 x100k PC6 0.0653304 0.0304846 3.0
Suicidios 30–59 x100k PC6 0.2123643 0.0990938 9.9
Suicidios H x100k PC6 -0.0737292 0.0344037 3.4
Suicidios M x100k PC6 0.1220611 0.0569564 5.7
Suicidios x100k PC6 -0.0050873 0.0023738 0.2
Intento suicidio 15–29 x100k PC7 0.0791146 0.0312160 3.1
Intento suicidio 15–64 x100k PC7 0.0436983 0.0172419 1.7
Intento suicidio 30–59 x100k PC7 0.0106107 0.0041866 0.4
Intento suicidio H x100k PC7 -0.0846080 0.0333835 3.3
Intento suicidio M x100k PC7 0.0618789 0.0244154 2.4
Intento de suicidio x100k PC7 -0.0517710 0.0204271 2.0
Suicidios 15–29 x100k PC7 0.3238519 0.1277814 12.8
Suicidios 15–64 x100k PC7 0.4772517 0.1883080 18.8
Suicidios 30–59 x100k PC7 0.3644315 0.1437928 14.4
Suicidios H x100k PC7 -0.5438502 0.2145856 21.5
Suicidios M x100k PC7 -0.0285957 0.0112829 1.1
Suicidios x100k PC7 -0.4647587 0.1833786 18.3
Intento suicidio 15–29 x100k PC8 0.7122872 0.3111417 31.1
Intento suicidio 15–64 x100k PC8 0.1687527 0.0737147 7.4
Intento suicidio 30–59 x100k PC8 0.1572044 0.0686701 6.9
Intento suicidio H x100k PC8 -0.3183762 0.1390733 13.9
Intento suicidio M x100k PC8 -0.5395109 0.2356695 23.6
Intento de suicidio x100k PC8 -0.1919588 0.0838516 8.4
Suicidios 15–29 x100k PC8 0.0132397 0.0057834 0.6
Suicidios 15–64 x100k PC8 -0.0797590 0.0348404 3.5
Suicidios 30–59 x100k PC8 -0.0074707 0.0032634 0.3
Suicidios H x100k PC8 0.0238565 0.0104210 1.0
Suicidios M x100k PC8 -0.0330541 0.0144387 1.4
Suicidios x100k PC8 0.0437993 0.0191324 1.9
Intento suicidio 15–29 x100k PC9 -0.3831458 0.1621540 16.2
Intento suicidio 15–64 x100k PC9 0.4598127 0.1946007 19.5
Intento suicidio 30–59 x100k PC9 -0.0561492 0.0237633 2.4
Intento suicidio H x100k PC9 -0.3043663 0.1288131 12.9
Intento suicidio M x100k PC9 -0.4228917 0.1789751 17.9
Intento de suicidio x100k PC9 0.6024227 0.2549557 25.5
Suicidios 15–29 x100k PC9 -0.0179372 0.0075913 0.8
Suicidios 15–64 x100k PC9 0.0539409 0.0228287 2.3
Suicidios 30–59 x100k PC9 0.0201440 0.0085253 0.9
Suicidios H x100k PC9 -0.0142257 0.0060205 0.6
Suicidios M x100k PC9 -0.0126571 0.0053567 0.5
Suicidios x100k PC9 -0.0151592 0.0064156 0.6
Intento suicidio 15–29 x100k PC10 -0.0269906 0.0134677 1.3
Intento suicidio 15–64 x100k PC10 -0.1155308 0.0576472 5.8
Intento suicidio 30–59 x100k PC10 0.0160573 0.0080122 0.8
Intento suicidio H x100k PC10 -0.0009020 0.0004501 0.0
Intento suicidio M x100k PC10 -0.0065207 0.0032537 0.3
Intento de suicidio x100k PC10 0.1261216 0.0629318 6.3
Suicidios 15–29 x100k PC10 0.4740677 0.2365490 23.7
Suicidios 15–64 x100k PC10 -0.6879862 0.3432895 34.3
Suicidios 30–59 x100k PC10 0.5208672 0.2599009 26.0
Suicidios H x100k PC10 0.0065072 0.0032469 0.3
Suicidios M x100k PC10 0.0163695 0.0081680 0.8
Suicidios x100k PC10 -0.0061787 0.0030830 0.3
Intento suicidio 15–29 x100k PC11 -0.2340436 0.1109469 11.1
Intento suicidio 15–64 x100k PC11 0.7317038 0.3468597 34.7
Intento suicidio 30–59 x100k PC11 -0.0768663 0.0364380 3.6
Intento suicidio H x100k PC11 0.0462902 0.0219436 2.2
Intento suicidio M x100k PC11 0.1086257 0.0514934 5.1
Intento de suicidio x100k PC11 -0.6018275 0.2852926 28.5
Suicidios 15–29 x100k PC11 0.0577197 0.0273617 2.7
Suicidios 15–64 x100k PC11 -0.1399385 0.0663370 6.6
Suicidios 30–59 x100k PC11 0.0625343 0.0296440 3.0
Suicidios H x100k PC11 0.0219477 0.0104042 1.0
Suicidios M x100k PC11 -0.0074068 0.0035112 0.4
Suicidios x100k PC11 0.0206052 0.0097678 1.0
Intento suicidio 15–29 x100k PC12 0.0174231 0.0096794 1.0
Intento suicidio 15–64 x100k PC12 0.0102723 0.0057068 0.6
Intento suicidio 30–59 x100k PC12 0.0129945 0.0072191 0.7
Intento suicidio H x100k PC12 -0.0202623 0.0112567 1.1
Intento suicidio M x100k PC12 -0.0116942 0.0064967 0.6
Intento de suicidio x100k PC12 -0.0108151 0.0060083 0.6
Suicidios 15–29 x100k PC12 -0.0005210 0.0002895 0.0
Suicidios 15–64 x100k PC12 0.0200452 0.0111361 1.1
Suicidios 30–59 x100k PC12 0.0038516 0.0021398 0.2
Suicidios H x100k PC12 0.5972195 0.3317843 33.2
Suicidios M x100k PC12 0.4021348 0.2234053 22.3
Suicidios x100k PC12 -0.6927895 0.3848781 38.5
Code 
kable(variance, caption = "Varianza explicada por componente")
Varianza explicada por componente
component percent
PC1 0.4121346
PC2 0.2990735
PC3 0.1065687
PC4 0.0825453
PC5 0.0422048
PC6 0.0289843
PC7 0.0150697
PC8 0.0065950
PC9 0.0044501
PC10 0.0012494
PC11 0.0010778
PC12 0.0000467
Code 
kable(top_PC1, caption = "Top variables en PC1")
Top variables en PC1
variable loading sign
Intento suicidio 15–64 x100k -0.4312564 -
Intento de suicidio x100k -0.4232308 -
Intento suicidio 15–29 x100k -0.4084046 -
Intento suicidio M x100k -0.4006679 -
Intento suicidio H x100k -0.3664478 -
Intento suicidio 30–59 x100k -0.3287873 -
Suicidios x100k -0.1401184 -
Suicidios H x100k -0.1289025 -
Suicidios 15–64 x100k -0.1119877 -
Suicidios 30–59 x100k -0.1061031 -
Code 
kable(top_PC2, caption = "Top variables en PC2")
Top variables en PC2
variable loading sign
Suicidios 15–64 x100k 0.4957886 +
Suicidios x100k 0.4705749 +
Suicidios H x100k 0.4511848 +
Suicidios 30–59 x100k 0.3489080 +
Suicidios 15–29 x100k 0.3294958 +
Intento de suicidio x100k -0.1464609 -
Intento suicidio 15–29 x100k -0.1422905 -
Intento suicidio H x100k -0.1309893 -
Intento suicidio 15–64 x100k -0.1233776 -
Suicidios M x100k 0.1069322 +

Distribución espacial

Code 
knitr::include_graphics("all/02_Imagenes/idx13_saludmental_map_pcall.png")

Mapa combinado de componentes principales

Descarga de gráficos y acceso a código fuente

Descargar Radar PC1 Descargar Radar PC2 Descargar Radar PC3 Descargar Mapa PC1 Descargar Mapa PC2 Descargar Mapa Todos los PCs Descargar Resultados Completos Descargar Excel de Loadings y Tops Descargar Tabla Descriptiva

Ver código fuente en GitHub Repositorio principal