Expansión de la CASEN sobre el CENSO (Región 07)

De ingresos sobre una categoría de respuesta RURAL

DataIntelligence

Abstract

Expandiremos los ingresos promedios comunales obtenidos de la CASEN sobre la pregunta (P15): “Nivel del curso más alto aprobado” en la categoría de respuesta “Profesional” (12), que más alto correlaciona con los ingresos expandidos (obtenidos de la multiplicación del ingreso promedio y los habitantes), ambos a nivel comunal.

Haremos el análisis sobre la región 07.

Ensayaremos diferentes modelos dentro del análisis de regresión cuya variable independiente será: “frecuencia de población que posee la variable Censal respecto a la zona” y la dependiente: “ingreso expandido de la Casen por zona”

Lo anterior para ir combinando a nivel nacional los mejores modelos para construir una tabla de valores predichos.

1 Variable CENSO

Necesitamos calcular las frecuencias a nivel censal de las respuestas correspondientes a la categoría: “Profesional (4 o más años)” del campo P15 a nivel rural del Censo de personas. Recordemos que ésta fué la más alta correlación en relación a los ingresos expandidos (ver punto 3.4 aquí).

1.1 Lectura y filtrado de la tabla censal de personas

Leemos la tabla Censo 2017 de personas que ya tiene integrada la clave zonal:

tabla_con_clave <- readRDS("../censo_personas_con_clave_17")
r3_100 <- tabla_con_clave[c(1:100),]
kbl(r3_100) %>%
  kable_styling(bootstrap_options = c("striped", "hover")) %>%
  kable_paper() %>%
  scroll_box(width = "100%", height = "300px")

REGION	PROVINCIA	COMUNA	DC	AREA	ZC_LOC	ID_ZONA_LOC	NVIV	NHOGAR	PERSONAN	P07	P08	P09	P10	P10COMUNA	P10PAIS	P11	P11COMUNA	P11PAIS	P12	P12COMUNA	P12PAIS	P12A_LLEGADA	P12A_TRAMO	P13	P14	P15	P15A	P16	P16A	P16A_OTRO	P17	P18	P19	P20	P21M	P21A	P10PAIS_GRUPO	P11PAIS_GRUPO	P12PAIS_GRUPO	ESCOLARIDAD	P16A_GRUPO	REGION_15R	PROVINCIA_15R	COMUNA_15R	P10COMUNA_15R	P11COMUNA_15R	P12COMUNA_15R	clave
15	152	15202	1	2	6	13225	1	1	1	1	1	73	1	98	998	3	15101	998	1	98	998	9998	98	2	4	6	2	1	2	98	7	98	98	98	98	9998	998	998	998	4	2	15	152	15202	98	15101	98	15202012006
15	152	15202	1	2	6	13225	3	1	1	1	1	78	1	98	998	2	98	998	1	98	998	9998	98	3	98	98	98	1	2	98	7	98	98	98	98	9998	998	998	998	0	2	15	152	15202	98	98	98	15202012006
15	152	15202	1	2	6	13225	3	1	2	2	2	78	1	98	998	2	98	998	1	98	998	9998	98	3	98	98	98	1	2	98	7	98	1	1	3	1965	998	998	998	0	2	15	152	15202	98	98	98	15202012006
15	152	15202	1	2	6	13225	3	1	3	5	2	52	1	98	998	2	98	998	1	98	998	9998	98	1	2	5	2	1	2	98	7	98	2	1	4	1995	998	998	998	2	2	15	152	15202	98	98	98	15202012006
15	152	15202	1	2	6	13225	3	1	4	11	1	44	1	98	998	2	98	998	1	98	998	9998	98	1	3	5	2	1	2	98	1	Z	98	98	98	9998	998	998	998	3	2	15	152	15202	98	98	98	15202012006
15	152	15202	1	2	6	13225	9	1	1	1	1	39	1	98	998	2	98	998	1	98	998	9998	98	2	8	5	1	1	2	98	8	98	98	98	98	9998	998	998	998	8	2	15	152	15202	98	98	98	15202012006
15	152	15202	1	2	6	13225	9	1	2	2	2	35	1	98	998	2	98	998	1	98	998	9998	98	2	6	5	2	1	2	98	1	Z	2	2	11	2004	998	998	998	6	2	15	152	15202	98	98	98	15202012006
15	152	15202	1	2	6	13225	9	1	3	5	1	13	1	98	998	2	98	998	1	98	998	9998	98	1	7	5	2	1	2	98	98	98	98	98	98	9998	998	998	998	7	2	15	152	15202	98	98	98	15202012006
15	152	15202	1	2	6	13225	9	1	4	5	1	12	1	98	998	2	98	998	1	98	998	9998	98	1	6	5	2	1	2	98	98	98	98	98	98	9998	998	998	998	6	2	15	152	15202	98	98	98	15202012006
15	152	15202	1	2	6	13225	10	1	1	1	2	65	1	98	998	2	98	998	1	98	998	9998	98	2	4	5	2	1	2	98	6	98	3	3	9	1992	998	998	998	4	2	15	152	15202	98	98	98	15202012006
15	152	15202	1	2	6	13225	13	1	1	1	1	50	1	98	998	2	98	998	1	98	998	9998	98	2	5	5	2	1	2	98	1	Z	98	98	98	9998	998	998	998	5	2	15	152	15202	98	98	98	15202012006
15	152	15202	1	2	6	13225	13	1	2	4	2	43	1	98	998	2	98	998	1	98	998	9998	98	2	6	5	2	1	2	98	6	98	2	2	3	2002	998	998	998	6	2	15	152	15202	98	98	98	15202012006
15	152	15202	1	2	6	13225	13	1	3	5	1	15	3	15201	998	2	98	998	1	98	998	9998	98	1	1	7	2	1	2	98	8	98	98	98	98	9998	998	998	998	9	2	15	152	15202	15201	98	98	15202012006
15	152	15202	1	2	6	13225	16	1	1	1	1	75	1	98	998	2	98	998	1	98	998	9998	98	3	98	98	98	1	2	98	7	98	98	98	98	9998	998	998	998	0	2	15	152	15202	98	98	98	15202012006
15	152	15202	1	2	6	13225	16	1	2	16	2	58	4	98	68	6	98	998	5	98	998	9999	1	3	98	98	98	1	2	98	7	98	4	4	99	9999	68	68	68	0	2	15	152	15202	98	98	98	15202012006
15	152	15202	1	2	6	13225	16	1	3	2	2	70	1	98	998	2	98	998	1	98	998	9998	98	3	98	98	98	1	2	98	7	98	5	4	99	9999	998	998	998	0	2	15	152	15202	98	98	98	15202012006
15	152	15202	1	2	6	13225	17	1	1	1	2	43	2	98	998	2	98	998	1	98	998	9998	98	2	8	5	1	1	2	98	1	I	3	3	9	2008	998	998	998	8	2	15	152	15202	98	98	98	15202012006
15	152	15202	1	2	6	13225	17	1	2	4	1	55	2	98	998	2	98	998	1	98	998	9998	98	2	6	5	2	1	2	98	6	98	98	98	98	9998	998	998	998	6	2	15	152	15202	98	98	98	15202012006
15	152	15202	1	2	6	13225	17	1	3	5	2	13	2	98	998	2	98	998	2	15101	998	9998	98	1	7	5	2	1	2	98	98	98	98	98	98	9998	998	998	998	7	2	15	152	15202	98	98	15101	15202012006
15	152	15202	1	2	6	13225	17	1	4	5	1	8	2	98	998	2	98	998	2	15101	998	9998	98	1	2	5	2	1	2	98	98	98	98	98	98	9998	998	998	998	2	2	15	152	15202	98	98	15101	15202012006
15	152	15202	1	2	6	13225	17	1	5	15	2	29	2	98	998	4	98	998	3	98	998	2015	1	2	6	5	2	1	2	98	6	98	5	5	11	2014	998	604	604	6	2	15	152	15202	98	98	98	15202012006
15	152	15202	1	2	6	13225	17	1	6	15	1	4	2	98	998	1	98	998	5	98	998	2015	1	1	0	1	2	1	2	98	98	98	98	98	98	9998	998	998	68	0	2	15	152	15202	98	98	98	15202012006
15	152	15202	1	2	6	13225	17	1	7	15	2	2	2	98	998	1	98	998	3	98	998	2015	1	1	0	1	2	1	2	98	98	98	98	98	98	9998	998	998	604	0	2	15	152	15202	98	98	98	15202012006
15	152	15202	1	2	6	13225	17	1	8	15	1	16	2	98	998	6	98	998	1	98	998	9998	98	2	4	5	2	1	2	98	6	98	98	98	98	9998	998	68	998	4	2	15	152	15202	98	98	98	15202012006
15	152	15202	1	2	6	13225	18	1	1	1	2	74	1	98	998	2	98	998	1	98	998	9998	98	2	2	5	2	1	2	98	6	98	2	2	12	1976	998	998	998	2	2	15	152	15202	98	98	98	15202012006
15	152	15202	1	2	6	13225	19	1	1	1	1	68	1	98	998	2	98	998	1	98	998	9998	98	3	98	98	98	1	2	98	7	98	98	98	98	9998	998	998	998	0	2	15	152	15202	98	98	98	15202012006
15	152	15202	1	2	6	13225	20	1	1	1	1	74	1	98	998	3	15101	998	1	98	998	9998	98	2	2	5	2	1	2	98	1	Z	98	98	98	9998	998	998	998	2	2	15	152	15202	98	15101	98	15202012006
15	152	15202	1	2	6	13225	20	1	2	2	2	65	1	98	998	3	997	998	3	98	998	9999	2	2	2	5	2	1	2	98	6	98	2	2	9	1982	998	998	604	2	2	15	152	15202	98	997	98	15202012006
15	152	15202	1	2	6	13225	25	1	1	1	2	76	1	98	998	2	98	998	1	98	998	9998	98	3	98	98	98	1	2	98	6	98	8	6	3	1981	998	998	998	0	2	15	152	15202	98	98	98	15202012006
15	152	15202	1	2	6	13225	25	1	2	5	2	36	1	98	998	2	98	998	1	98	998	9998	98	2	4	8	1	1	2	98	1	A	0	98	98	9998	998	998	998	12	2	15	152	15202	98	98	98	15202012006
15	152	15202	1	2	6	13225	28	1	1	1	2	31	1	98	998	2	98	998	5	98	998	2007	2	2	5	5	2	1	2	98	1	A	2	2	4	2008	998	998	68	5	2	15	152	15202	98	98	98	15202012006
15	152	15202	1	2	6	13225	28	1	2	4	1	35	1	98	998	2	98	998	5	98	998	2007	2	2	6	5	2	1	2	98	1	F	98	98	98	9998	998	998	68	6	2	15	152	15202	98	98	98	15202012006
15	152	15202	1	2	6	13225	28	1	3	5	1	11	1	98	998	2	98	998	5	98	998	2007	2	1	5	5	2	1	2	98	98	98	98	98	98	9998	998	998	68	5	2	15	152	15202	98	98	98	15202012006
15	152	15202	1	2	6	13225	28	1	4	5	1	8	1	98	998	2	98	998	1	98	998	9998	98	1	2	5	2	1	2	98	98	98	98	98	98	9998	998	998	998	2	2	15	152	15202	98	98	98	15202012006
15	152	15202	1	2	6	13225	28	1	5	15	2	74	1	98	998	2	98	998	1	98	998	9998	98	2	3	5	2	1	2	98	6	98	6	6	99	9999	998	998	998	3	2	15	152	15202	98	98	98	15202012006
15	152	15202	1	2	6	13225	33	1	1	1	1	41	1	98	998	2	98	998	1	98	998	9998	98	2	8	5	1	1	2	98	1	Z	98	98	98	9998	998	998	998	8	2	15	152	15202	98	98	98	15202012006
15	152	15202	1	2	6	13225	33	1	2	2	2	47	1	98	998	2	98	998	1	98	998	9998	98	2	8	5	1	1	2	98	1	A	2	1	4	1996	998	998	998	8	2	15	152	15202	98	98	98	15202012006
15	152	15202	1	2	6	13225	33	1	3	14	1	88	1	98	998	2	98	998	1	98	998	9998	98	3	98	98	98	1	2	98	7	98	98	98	98	9998	998	998	998	0	2	15	152	15202	98	98	98	15202012006
15	152	15202	1	2	6	13225	33	1	4	14	1	65	1	98	998	2	98	998	1	98	998	9998	98	2	2	5	2	1	2	98	7	98	98	98	98	9998	998	998	998	2	2	15	152	15202	98	98	98	15202012006
15	152	15202	1	2	6	13225	36	1	1	1	2	59	1	98	998	2	98	998	1	98	998	9998	98	2	2	5	2	1	2	98	6	98	8	8	2	1998	998	998	998	2	2	15	152	15202	98	98	98	15202012006
15	152	15202	1	2	6	13225	36	1	2	2	1	56	1	98	998	99	99	999	1	98	998	9998	98	2	2	5	2	1	2	98	6	98	98	98	98	9998	998	999	998	2	2	15	152	15202	98	99	98	15202012006
15	152	15202	1	2	6	13225	36	1	3	5	2	36	1	98	998	2	98	998	1	98	998	9998	98	2	8	5	1	1	2	98	6	98	2	2	7	2010	998	998	998	8	2	15	152	15202	98	98	98	15202012006
15	152	15202	1	2	6	13225	36	1	4	12	2	13	1	98	998	2	98	998	1	98	998	9998	98	1	7	5	2	1	2	98	98	98	98	98	98	9998	998	998	998	7	2	15	152	15202	98	98	98	15202012006
15	152	15202	1	2	6	13225	36	1	5	12	2	6	1	98	998	2	98	998	1	98	998	9998	98	1	0	3	1	1	2	98	98	98	98	98	98	9998	998	998	998	0	2	15	152	15202	98	98	98	15202012006
15	152	15202	1	2	6	13225	36	1	6	5	1	24	1	98	998	3	15101	998	1	98	998	9998	98	2	4	7	1	1	2	98	1	Z	98	98	98	9998	998	998	998	12	2	15	152	15202	98	15101	98	15202012006
15	152	15202	1	2	6	13225	36	1	7	11	2	24	1	98	998	3	15101	998	1	98	998	9998	98	2	4	7	1	1	2	98	1	N	2	2	11	2015	998	998	998	12	2	15	152	15202	98	15101	98	15202012006
15	152	15202	1	2	6	13225	36	1	8	12	1	6	1	98	998	2	98	998	2	15101	998	9998	98	1	0	3	1	1	2	98	98	98	98	98	98	9998	998	998	998	0	2	15	152	15202	98	98	15101	15202012006
15	152	15202	1	2	6	13225	36	1	9	12	2	1	1	98	998	1	98	998	2	15101	998	9998	98	3	98	98	98	1	2	98	98	98	98	98	98	9998	998	998	998	0	2	15	152	15202	98	98	15101	15202012006
15	152	15202	1	2	6	13225	38	1	1	1	1	19	1	98	998	3	15101	998	2	15101	998	9998	98	1	1	8	2	1	2	98	1	A	98	98	98	9998	998	998	998	9	2	15	152	15202	98	15101	15101	15202012006
15	152	15202	1	2	6	13225	39	1	1	1	1	21	1	98	998	2	98	998	1	98	998	9998	98	2	1	7	2	1	2	98	1	F	98	98	98	9998	998	998	998	9	2	15	152	15202	98	98	98	15202012006
15	152	15202	1	2	6	13225	39	1	2	4	2	22	1	98	998	2	98	998	1	98	998	9998	98	2	1	8	2	1	2	98	6	98	0	98	98	9998	998	998	998	9	2	15	152	15202	98	98	98	15202012006
15	152	15202	1	2	6	13225	43	1	1	1	2	26	1	98	998	2	98	998	1	98	998	9998	98	2	8	5	1	1	2	98	6	98	2	2	10	2013	998	998	998	8	2	15	152	15202	98	98	98	15202012006
15	152	15202	1	2	6	13225	43	1	2	2	1	24	1	98	998	2	98	998	1	98	998	9998	98	2	8	5	1	1	2	98	1	Z	98	98	98	9998	998	998	998	8	2	15	152	15202	98	98	98	15202012006
15	152	15202	1	2	6	13225	43	1	3	13	2	71	1	98	998	2	98	998	1	98	998	9998	98	2	1	5	2	1	2	98	6	98	3	3	12	1974	998	998	998	1	2	15	152	15202	98	98	98	15202012006
15	152	15202	1	2	6	13225	43	1	4	5	2	6	1	98	998	2	98	998	1	98	998	9998	98	1	0	3	1	1	2	98	98	98	98	98	98	9998	998	998	998	0	2	15	152	15202	98	98	98	15202012006
15	152	15202	1	2	6	13225	43	1	5	5	2	3	1	98	998	1	98	998	1	98	998	9998	98	1	0	1	1	1	2	98	98	98	98	98	98	9998	998	998	998	0	2	15	152	15202	98	98	98	15202012006
15	152	15202	1	2	8	13910	5	1	1	1	1	44	1	98	998	2	98	998	3	98	998	2005	2	2	4	7	1	1	2	98	6	98	98	98	98	9998	998	998	604	12	2	15	152	15202	98	98	98	15202012008
15	152	15202	1	2	8	13910	5	1	2	2	2	42	1	98	998	2	98	998	1	98	998	9998	98	2	3	5	2	1	2	98	1	P	3	3	12	2006	998	998	998	3	2	15	152	15202	98	98	98	15202012008
15	152	15202	1	2	8	13910	5	1	3	5	2	10	1	98	998	2	98	998	1	98	998	9998	98	1	4	5	2	1	2	98	98	98	98	98	98	9998	998	998	998	4	2	15	152	15202	98	98	98	15202012008
15	152	15202	1	2	8	13910	7	1	1	1	2	70	1	98	998	2	98	998	1	98	998	9998	98	2	2	5	2	1	2	98	6	98	7	7	6	1994	998	998	998	2	2	15	152	15202	98	98	98	15202012008
15	152	15202	1	2	8	13910	7	1	2	5	1	44	1	98	998	2	98	998	1	98	998	9998	98	2	5	5	2	1	2	98	7	98	98	98	98	9998	998	998	998	5	2	15	152	15202	98	98	98	15202012008
15	152	15202	1	2	8	13910	8	1	1	1	1	58	1	98	998	2	98	998	3	98	998	2004	2	2	4	5	2	1	2	98	6	98	98	98	98	9998	998	998	604	4	2	15	152	15202	98	98	98	15202012008
15	152	15202	1	2	8	13910	8	1	2	2	2	59	1	98	998	2	98	998	3	98	998	2004	2	2	2	5	2	1	2	98	6	98	3	3	7	1999	998	998	604	2	2	15	152	15202	98	98	98	15202012008
15	152	15202	1	2	8	13910	19	1	1	1	1	58	99	99	999	99	99	999	99	99	999	9999	99	99	99	99	99	99	99	99	99	99	98	98	98	9998	999	999	999	99	99	15	152	15202	99	99	99	15202012008
15	152	15202	1	2	8	13910	21	1	1	1	1	53	1	98	998	2	98	998	1	98	998	9998	98	2	8	5	1	1	2	98	1	H	98	98	98	9998	998	998	998	8	2	15	152	15202	98	98	98	15202012008
15	152	15202	1	2	8	13910	21	1	2	2	2	46	1	98	998	2	98	998	1	98	998	9998	98	2	3	5	2	1	2	98	6	98	3	3	2	1990	998	998	998	3	2	15	152	15202	98	98	98	15202012008
15	152	15202	1	2	8	13910	22	1	1	1	2	73	1	98	998	2	98	998	1	98	998	9998	98	3	98	98	98	1	2	98	6	98	6	5	3	1979	998	998	998	0	2	15	152	15202	98	98	98	15202012008
15	152	15202	1	2	8	13910	30	1	1	1	1	57	1	98	998	2	98	998	2	997	998	9998	98	2	3	5	2	1	2	98	6	98	98	98	98	9998	998	998	998	3	2	15	152	15202	98	98	997	15202012008
15	152	15202	1	2	12	8394	3	1	1	2	2	64	1	98	998	2	98	998	3	98	998	1974	4	3	98	98	98	1	2	98	1	A	12	10	99	9999	998	998	604	0	2	15	152	15202	98	98	98	15202012012
15	152	15202	1	2	12	8394	3	1	2	1	1	74	2	98	998	2	98	998	1	98	998	9998	98	3	98	98	98	1	2	98	99	99	98	98	98	9998	998	998	998	0	2	15	152	15202	98	98	98	15202012012
15	152	15202	1	2	12	8394	3	1	3	5	2	38	1	98	998	2	98	998	1	98	998	9998	98	2	8	5	1	1	2	98	2	A	0	98	98	9998	998	998	998	8	2	15	152	15202	98	98	98	15202012012
15	152	15202	1	2	12	8394	3	1	4	14	1	38	99	99	999	99	99	999	99	99	999	9999	99	99	99	99	99	99	99	99	8	98	98	98	98	9998	999	999	999	99	99	15	152	15202	99	99	99	15202012012
15	152	15202	1	2	12	8394	9	1	1	1	2	79	1	98	998	2	98	998	1	98	998	9998	98	3	98	98	98	1	2	98	8	98	2	2	99	9999	998	998	998	0	2	15	152	15202	98	98	98	15202012012
15	152	15202	1	2	12	8394	19	1	1	1	1	46	99	99	999	99	99	999	99	99	999	9999	99	99	99	99	99	99	99	99	99	99	98	98	98	9998	999	999	999	99	99	15	152	15202	99	99	99	15202012012
15	152	15202	1	2	12	8394	20	1	1	1	2	58	1	98	998	2	98	998	1	98	998	9998	98	2	8	5	1	1	2	98	1	A	3	3	7	1982	998	998	998	8	2	15	152	15202	98	98	98	15202012012
15	152	15202	1	2	12	8394	21	1	1	1	2	45	1	98	998	6	98	998	2	997	998	9998	98	2	4	5	2	1	2	98	1	A	6	6	2	2007	998	68	998	4	2	15	152	15202	98	98	997	15202012012
15	152	15202	1	2	12	8394	21	1	2	5	2	10	1	98	998	6	98	998	2	3201	998	9998	98	1	4	5	2	1	2	98	98	98	98	98	98	9998	998	68	998	4	2	15	152	15202	98	98	3201	15202012012
15	152	15202	1	2	12	8394	24	1	1	1	1	67	1	98	998	2	98	998	1	98	998	9998	98	3	98	98	98	1	2	98	8	98	98	98	98	9998	998	998	998	0	2	15	152	15202	98	98	98	15202012012
15	152	15202	1	2	12	8394	24	1	2	2	2	53	1	98	998	2	98	998	3	98	998	9999	99	3	98	98	98	1	2	98	8	98	0	98	98	9998	998	998	604	0	2	15	152	15202	98	98	98	15202012012
15	152	15202	1	2	12	8394	27	1	1	1	1	48	1	98	998	2	98	998	1	98	998	9998	98	2	4	7	1	1	2	98	8	98	98	98	98	9998	998	998	998	12	2	15	152	15202	98	98	98	15202012012
15	152	15202	1	2	12	8394	31	1	1	1	1	49	1	98	998	4	98	998	3	98	998	2001	2	2	8	5	1	1	2	98	1	A	98	98	98	9998	998	604	604	8	2	15	152	15202	98	98	98	15202012012
15	152	15202	1	2	12	8394	42	1	1	1	1	46	1	98	998	2	98	998	3	98	998	1992	3	2	8	5	1	1	2	98	2	A	98	98	98	9998	998	998	604	8	2	15	152	15202	98	98	98	15202012012
15	152	15202	1	2	12	8394	42	1	2	2	2	24	1	98	998	6	98	998	5	98	998	2013	1	2	7	5	2	1	2	98	6	98	2	2	6	2016	998	68	68	7	2	15	152	15202	98	98	98	15202012012
15	152	15202	1	2	12	8394	42	1	3	6	2	2	1	98	998	1	98	998	1	98	998	9998	98	3	98	98	98	1	2	98	98	98	98	98	98	9998	998	998	998	0	2	15	152	15202	98	98	98	15202012012
15	152	15202	1	2	12	8394	42	1	4	5	1	0	1	98	998	1	98	998	2	15101	998	9998	98	99	99	99	99	1	2	98	98	98	98	98	98	9998	998	998	998	99	2	15	152	15202	98	98	15101	15202012012
15	152	15202	1	2	12	8394	42	1	5	5	2	13	1	98	998	2	98	998	3	98	998	9999	99	1	7	5	2	1	2	98	98	98	98	98	98	9998	998	998	604	7	2	15	152	15202	98	98	98	15202012012
15	152	15202	1	2	12	8394	42	1	6	5	1	6	1	98	998	2	98	998	2	15101	998	9998	98	1	0	3	1	1	2	98	98	98	98	98	98	9998	998	998	998	0	2	15	152	15202	98	98	15101	15202012012
15	152	15202	1	2	15	4094	2	1	1	1	1	41	1	98	998	2	98	998	1	98	998	9998	98	2	4	12	1	1	2	98	1	O	98	98	98	9998	998	998	998	16	2	15	152	15202	98	98	98	15202012015
15	152	15202	1	2	15	4094	8	1	1	17	1	70	2	98	998	2	98	998	1	98	998	9998	98	3	98	98	98	1	2	98	7	98	98	98	98	9998	998	998	998	0	2	15	152	15202	98	98	98	15202012015
15	152	15202	1	2	15	4094	8	1	2	17	1	47	2	98	998	3	15101	998	2	8101	998	9998	98	2	4	8	1	1	2	98	1	Z	98	98	98	9998	998	998	998	12	2	15	152	15202	98	15101	8101	15202012015
15	152	15202	1	2	15	4094	8	1	3	17	1	19	2	98	998	3	15101	998	2	15101	998	9998	98	1	99	7	99	1	2	98	1	I	98	98	98	9998	998	998	998	99	2	15	152	15202	98	15101	15101	15202012015
15	152	15202	1	2	15	4094	8	1	4	17	1	43	2	98	998	3	4302	998	2	8101	998	9998	98	99	4	8	1	1	2	98	1	N	98	98	98	9998	998	998	998	12	2	15	152	15202	98	4302	8101	15202012015
15	152	15202	1	2	15	4094	8	1	5	17	2	35	2	98	998	6	98	998	5	98	998	2016	1	2	8	5	1	1	2	98	1	I	2	2	3	2007	998	68	68	8	2	15	152	15202	98	98	98	15202012015
15	152	15202	1	2	15	4094	8	1	6	17	1	36	3	13123	998	3	13123	998	2	12101	998	9998	98	2	5	12	1	2	98	98	1	J	98	98	98	9998	998	998	998	17	98	15	152	15202	13123	13123	12101	15202012015
15	152	15202	1	2	15	4094	8	1	7	17	2	25	2	98	998	3	15101	998	2	15101	998	9998	98	2	5	12	1	1	2	98	1	Q	1	1	12	2011	998	998	998	17	2	15	152	15202	98	15101	15101	15202012015
15	152	15202	1	2	15	4094	9	1	1	1	1	72	1	98	998	2	98	998	1	98	998	9998	98	2	1	5	2	1	2	98	1	G	98	98	98	9998	998	998	998	1	2	15	152	15202	98	98	98	15202012015
15	152	15202	1	2	15	4094	12	1	1	1	1	21	1	98	998	3	15101	998	2	15101	998	9998	98	2	4	8	1	1	2	98	1	N	98	98	98	9998	998	998	998	12	2	15	152	15202	98	15101	15101	15202012015
15	152	15202	1	2	15	4094	15	1	1	1	1	61	1	98	998	2	98	998	1	98	998	9998	98	2	3	7	2	1	2	98	4	98	98	98	98	9998	998	998	998	11	2	15	152	15202	98	98	98	15202012015
15	152	15202	1	2	15	4094	15	1	2	5	2	31	1	98	998	3	15101	998	1	98	998	9998	98	2	4	12	1	1	2	98	1	P	1	1	10	2007	998	998	998	16	2	15	152	15202	98	15101	98	15202012015
15	152	15202	1	2	15	4094	16	1	1	1	1	34	1	98	998	3	15101	998	1	98	998	9998	98	2	5	12	1	1	2	98	1	O	98	98	98	9998	998	998	998	17	2	15	152	15202	98	15101	98	15202012015

Despleguemos los códigos de regiones de nuestra tabla:

regiones <- unique(tabla_con_clave$REGION)
regiones

##  [1] 15 14 13 12 11 10  9 16  8  7  6  5  4  3  2  1

Hagamos un subset con la region 07 y con la zona = 2:

tabla_con_clave <- filter(tabla_con_clave, tabla_con_clave$REGION == 7) 
tabla_con_clave <- filter(tabla_con_clave, tabla_con_clave$AREA== 2) 

1.2 Cálculo de frecuencias

tabla_con_clave_f <- tabla_con_clave[,-c(1,2,4,5,6,7,8,9,10,11,13,14,15,16,17,18,19,20),drop=FALSE]

names(tabla_con_clave_f)[9] <- "Nivel del curso más alto aprobado"

# Ahora filtramos por Nivel del curso más alto aprobado = 11.
tabla_con_clave_ff <- filter(tabla_con_clave_f, tabla_con_clave_f$`Nivel del curso más alto aprobado` == 12)

# Determinamos las frecuencias por zona:
b <- tabla_con_clave_ff$clave
c <- tabla_con_clave_ff$`Nivel del curso más alto aprobado`
d <- tabla_con_clave_ff$COMUNA
cross_tab =  xtabs( ~ unlist(b) + unlist(c)+ unlist(d))
tabla <- as.data.frame(cross_tab)
d <-tabla[!(tabla$Freq == 0),]
names(d)[1] <- "zona" 
d$anio <- "2017"

Veamos los primeros 100 registros:

r3_100 <- d[c(1:100),]
kbl(r3_100) %>%
  kable_styling(bootstrap_options = c("striped", "hover")) %>%
  kable_paper() %>%
  scroll_box(width = "100%", height = "300px")

	zona	unlist.c.	unlist.d.	Freq	anio
1	7101092003	12	7101	42	2017
2	7101092024	12	7101	6	2017
3	7101092901	12	7101	3	2017
4	7101102004	12	7101	7	2017
5	7101102005	12	7101	35	2017
6	7101102013	12	7101	1	2017
7	7101102017	12	7101	94	2017
8	7101102018	12	7101	10	2017
9	7101112010	12	7101	19	2017
10	7101112015	12	7101	51	2017
11	7101112020	12	7101	61	2017
12	7101112022	12	7101	95	2017
13	7101122001	12	7101	189	2017
14	7101122010	12	7101	60	2017
15	7101122012	12	7101	5	2017
16	7101122014	12	7101	5	2017
17	7101122021	12	7101	9	2017
18	7101122022	12	7101	125	2017
19	7101122901	12	7101	4	2017
20	7101152008	12	7101	51	2017
21	7101152010	12	7101	18	2017
22	7101152016	12	7101	19	2017
23	7101152023	12	7101	16	2017
24	7101162002	12	7101	15	2017
25	7101162007	12	7101	16	2017
26	7101162010	12	7101	67	2017
27	7101162019	12	7101	86	2017
1081	7102022033	12	7102	6	2017
1082	7102022038	12	7102	3	2017
1083	7102022046	12	7102	2	2017
1084	7102022060	12	7102	1	2017
1085	7102032025	12	7102	10	2017
1086	7102032030	12	7102	1	2017
1087	7102032038	12	7102	2	2017
1088	7102032043	12	7102	5	2017
1089	7102032045	12	7102	19	2017
1090	7102032056	12	7102	23	2017
1091	7102032060	12	7102	5	2017
1092	7102042007	12	7102	7	2017
1093	7102042011	12	7102	1	2017
1094	7102042016	12	7102	25	2017
1095	7102042024	12	7102	15	2017
1096	7102042036	12	7102	13	2017
1097	7102042047	12	7102	36	2017
1098	7102042901	12	7102	67	2017
1099	7102052009	12	7102	1	2017
1100	7102052012	12	7102	1	2017
1101	7102052050	12	7102	1	2017
1102	7102062007	12	7102	1	2017
1103	7102062010	12	7102	1	2017
1104	7102062018	12	7102	1	2017
1105	7102062028	12	7102	3	2017
1106	7102062053	12	7102	7	2017
1107	7102062059	12	7102	6	2017
1108	7102062901	12	7102	6	2017
1109	7102072006	12	7102	1	2017
1110	7102072027	12	7102	12	2017
1111	7102072031	12	7102	2	2017
1112	7102072048	12	7102	8	2017
1113	7102072055	12	7102	2	2017
2167	7103012027	12	7103	5	2017
2168	7103012038	12	7103	12	2017
2169	7103012042	12	7103	6	2017
2170	7103012054	12	7103	5	2017
2171	7103022003	12	7103	7	2017
2172	7103022020	12	7103	7	2017
2173	7103022025	12	7103	11	2017
2174	7103022049	12	7103	1	2017
2175	7103022052	12	7103	6	2017
2176	7103032007	12	7103	15	2017
2177	7103032012	12	7103	6	2017
2178	7103032053	12	7103	2	2017
2179	7103042010	12	7103	3	2017
2180	7103042027	12	7103	2	2017
2181	7103042031	12	7103	7	2017
2182	7103042037	12	7103	4	2017
2183	7103042043	12	7103	1	2017
2184	7103042044	12	7103	1	2017
2185	7103042047	12	7103	2	2017
2186	7103042901	12	7103	1	2017
2187	7103052051	12	7103	1	2017
2188	7103052058	12	7103	1	2017
2189	7103062022	12	7103	24	2017
2190	7103062901	12	7103	1	2017
2191	7103072024	12	7103	3	2017
2192	7103072062	12	7103	2	2017
2193	7103072901	12	7103	3	2017
2194	7103082011	12	7103	6	2017
2195	7103082041	12	7103	2	2017
2196	7103082048	12	7103	2	2017
2197	7103082059	12	7103	2	2017
2198	7103092021	12	7103	1	2017
2199	7103092061	12	7103	6	2017
2200	7103102026	12	7103	44	2017
2201	7103102039	12	7103	8	2017
2202	7103102063	12	7103	3	2017
2203	7103102901	12	7103	1	2017
2204	7103112013	12	7103	1	2017
2205	7103112016	12	7103	1	2017
2206	7103112018	12	7103	4	2017

Agregamos un cero a los códigos comunales de cuatro dígitos:

codigos <- d$unlist.d.
rango <- seq(1:nrow(d))
cadena <- paste("0",codigos[rango], sep = "")
cadena <- substr(cadena,(nchar(cadena)[rango])-(4),6)
codigos <- as.data.frame(codigos)
cadena <- as.data.frame(cadena)
comuna_corr <- cbind(d,cadena)
comuna_corr <- comuna_corr[,-c(2,3),drop=FALSE]
names(comuna_corr)[4] <- "código" 
r3_100 <- comuna_corr[c(1:100),]
kbl(r3_100) %>%
  kable_styling(bootstrap_options = c("striped", "hover")) %>%
  kable_paper() %>%
  scroll_box(width = "100%", height = "300px")

	zona	Freq	anio	código
1	7101092003	42	2017	07101
2	7101092024	6	2017	07101
3	7101092901	3	2017	07101
4	7101102004	7	2017	07101
5	7101102005	35	2017	07101
6	7101102013	1	2017	07101
7	7101102017	94	2017	07101
8	7101102018	10	2017	07101
9	7101112010	19	2017	07101
10	7101112015	51	2017	07101
11	7101112020	61	2017	07101
12	7101112022	95	2017	07101
13	7101122001	189	2017	07101
14	7101122010	60	2017	07101
15	7101122012	5	2017	07101
16	7101122014	5	2017	07101
17	7101122021	9	2017	07101
18	7101122022	125	2017	07101
19	7101122901	4	2017	07101
20	7101152008	51	2017	07101
21	7101152010	18	2017	07101
22	7101152016	19	2017	07101
23	7101152023	16	2017	07101
24	7101162002	15	2017	07101
25	7101162007	16	2017	07101
26	7101162010	67	2017	07101
27	7101162019	86	2017	07101
1081	7102022033	6	2017	07102
1082	7102022038	3	2017	07102
1083	7102022046	2	2017	07102
1084	7102022060	1	2017	07102
1085	7102032025	10	2017	07102
1086	7102032030	1	2017	07102
1087	7102032038	2	2017	07102
1088	7102032043	5	2017	07102
1089	7102032045	19	2017	07102
1090	7102032056	23	2017	07102
1091	7102032060	5	2017	07102
1092	7102042007	7	2017	07102
1093	7102042011	1	2017	07102
1094	7102042016	25	2017	07102
1095	7102042024	15	2017	07102
1096	7102042036	13	2017	07102
1097	7102042047	36	2017	07102
1098	7102042901	67	2017	07102
1099	7102052009	1	2017	07102
1100	7102052012	1	2017	07102
1101	7102052050	1	2017	07102
1102	7102062007	1	2017	07102
1103	7102062010	1	2017	07102
1104	7102062018	1	2017	07102
1105	7102062028	3	2017	07102
1106	7102062053	7	2017	07102
1107	7102062059	6	2017	07102
1108	7102062901	6	2017	07102
1109	7102072006	1	2017	07102
1110	7102072027	12	2017	07102
1111	7102072031	2	2017	07102
1112	7102072048	8	2017	07102
1113	7102072055	2	2017	07102
2167	7103012027	5	2017	07103
2168	7103012038	12	2017	07103
2169	7103012042	6	2017	07103
2170	7103012054	5	2017	07103
2171	7103022003	7	2017	07103
2172	7103022020	7	2017	07103
2173	7103022025	11	2017	07103
2174	7103022049	1	2017	07103
2175	7103022052	6	2017	07103
2176	7103032007	15	2017	07103
2177	7103032012	6	2017	07103
2178	7103032053	2	2017	07103
2179	7103042010	3	2017	07103
2180	7103042027	2	2017	07103
2181	7103042031	7	2017	07103
2182	7103042037	4	2017	07103
2183	7103042043	1	2017	07103
2184	7103042044	1	2017	07103
2185	7103042047	2	2017	07103
2186	7103042901	1	2017	07103
2187	7103052051	1	2017	07103
2188	7103052058	1	2017	07103
2189	7103062022	24	2017	07103
2190	7103062901	1	2017	07103
2191	7103072024	3	2017	07103
2192	7103072062	2	2017	07103
2193	7103072901	3	2017	07103
2194	7103082011	6	2017	07103
2195	7103082041	2	2017	07103
2196	7103082048	2	2017	07103
2197	7103082059	2	2017	07103
2198	7103092021	1	2017	07103
2199	7103092061	6	2017	07103
2200	7103102026	44	2017	07103
2201	7103102039	8	2017	07103
2202	7103102063	3	2017	07103
2203	7103102901	1	2017	07103
2204	7103112013	1	2017	07103
2205	7103112016	1	2017	07103
2206	7103112018	4	2017	07103

2 Variable CASEN

2.1 Tabla de ingresos expandidos

Hemos calculado ya éste valor como conclusión del punto 1.1 de aquí

h_y_m_2017_censo <- readRDS("../corre_ing_exp-censo_casen/Ingresos_expandidos_rural_17.rds")
tablamadre <- head(h_y_m_2017_censo,50)
kbl(tablamadre) %>%
  kable_styling(bootstrap_options = c("striped", "hover")) %>%
  kable_paper() %>%
  scroll_box(width = "100%", height = "300px")

código	comuna.x	promedio_i	año	personas	Ingresos_expandidos
01101	Iquique	272529.7	2017	191468	52180713221
01401	Pozo Almonte	243272.4	2017	15711	3822052676
01402	Camiña	226831.0	2017	1250	283538750
01404	Huara	236599.7	2017	2730	645917134
01405	Pica	269198.0	2017	9296	2502464414
02103	Sierra Gorda	322997.9	2017	10186	3290056742
02104	Taltal	288653.8	2017	13317	3844002134
02201	Calama	238080.9	2017	165731	39457387800
02203	San Pedro de Atacama	271472.6	2017	10996	2985112297
02301	Tocopilla	166115.9	2017	25186	4183793832
03101	Copiapó	251396.0	2017	153937	38699138722
03103	Tierra Amarilla	287819.4	2017	14019	4034940816
03202	Diego de Almagro	326439.0	2017	13925	4545663075
03301	Vallenar	217644.6	2017	51917	11299454698
03302	Alto del Carmen	196109.9	2017	5299	1039186477
03303	Freirina	202463.8	2017	7041	1425547554
03304	Huasco	205839.6	2017	10149	2089066548
04101	La Serena	200287.4	2017	221054	44274327972
04102	Coquimbo	206027.8	2017	227730	46918711304
04103	Andacollo	217096.4	2017	11044	2397612293
04104	La Higuera	231674.2	2017	4241	982530309
04105	Paiguano	174868.5	2017	4497	786383423
04106	Vicuña	169077.1	2017	27771	4695441470
04201	Illapel	165639.6	2017	30848	5109649759
04202	Canela	171370.3	2017	9093	1558270441
04203	Los Vilos	173238.5	2017	21382	3704185607
04204	Salamanca	193602.0	2017	29347	5681637894
04301	Ovalle	230819.8	2017	111272	25683781418
04302	Combarbalá	172709.2	2017	13322	2300832587
04303	Monte Patria	189761.6	2017	30751	5835357638
04304	Punitaqui	165862.0	2017	10956	1817183694
04305	Río Hurtado	182027.2	2017	4278	778712384
05101	Valparaíso	251998.5	2017	296655	74756602991
05102	Casablanca	252317.7	2017	26867	6779018483
05105	Puchuncaví	231606.0	2017	18546	4295363979
05107	Quintero	285125.8	2017	31923	9102071069
05301	Los Andes	280548.0	2017	66708	18714795984
05302	Calle Larga	234044.6	2017	14832	3471349123
05303	Rinconada	246136.9	2017	10207	2512319225
05304	San Esteban	211907.3	2017	18855	3995512770
05401	La Ligua	172675.9	2017	35390	6111000517
05402	Cabildo	212985.0	2017	19388	4129354103
05404	Petorca	270139.8	2017	9826	2654393853
05405	Zapallar	235661.4	2017	7339	1729518700
05501	Quillota	212067.6	2017	90517	19195726144
05502	Calera	226906.2	2017	50554	11471016698
05503	Hijuelas	215402.0	2017	17988	3874650405
05504	La Cruz	243333.4	2017	22098	5377180726
05506	Nogales	219800.7	2017	22120	4861992055
05601	San Antonio	230261.5	2017	91350	21034388728

3 Unión Censo-Casen

Integramos a la tabla censal de frecuencias la tabla de ingresos expandidos de la Casen.

comunas_con_ing_exp = merge( x = comuna_corr, y = h_y_m_2017_censo, by = "código", all.x = TRUE)

comunas_con_ing_exp <-comunas_con_ing_exp[!(is.na(comunas_con_ing_exp$Ingresos_expandidos)),]

r3_100 <- comunas_con_ing_exp
kbl(r3_100) %>%
  kable_styling(bootstrap_options = c("striped", "hover")) %>%
  kable_paper() %>%
  scroll_box(width = "100%", height = "300px")

código	zona	Freq	anio	comuna.x	promedio_i	año	personas	Ingresos_expandidos
07101	7101092003	42	2017	Talca	244658.0	2017	220357	53912095394
07101	7101092024	6	2017	Talca	244658.0	2017	220357	53912095394
07101	7101092901	3	2017	Talca	244658.0	2017	220357	53912095394
07101	7101102004	7	2017	Talca	244658.0	2017	220357	53912095394
07101	7101102005	35	2017	Talca	244658.0	2017	220357	53912095394
07101	7101102013	1	2017	Talca	244658.0	2017	220357	53912095394
07101	7101102017	94	2017	Talca	244658.0	2017	220357	53912095394
07101	7101102018	10	2017	Talca	244658.0	2017	220357	53912095394
07101	7101112010	19	2017	Talca	244658.0	2017	220357	53912095394
07101	7101112015	51	2017	Talca	244658.0	2017	220357	53912095394
07101	7101112020	61	2017	Talca	244658.0	2017	220357	53912095394
07101	7101112022	95	2017	Talca	244658.0	2017	220357	53912095394
07101	7101122001	189	2017	Talca	244658.0	2017	220357	53912095394
07101	7101122010	60	2017	Talca	244658.0	2017	220357	53912095394
07101	7101122012	5	2017	Talca	244658.0	2017	220357	53912095394
07101	7101122014	5	2017	Talca	244658.0	2017	220357	53912095394
07101	7101122021	9	2017	Talca	244658.0	2017	220357	53912095394
07101	7101122022	125	2017	Talca	244658.0	2017	220357	53912095394
07101	7101122901	4	2017	Talca	244658.0	2017	220357	53912095394
07101	7101152008	51	2017	Talca	244658.0	2017	220357	53912095394
07101	7101152010	18	2017	Talca	244658.0	2017	220357	53912095394
07101	7101152016	19	2017	Talca	244658.0	2017	220357	53912095394
07101	7101152023	16	2017	Talca	244658.0	2017	220357	53912095394
07101	7101162002	15	2017	Talca	244658.0	2017	220357	53912095394
07101	7101162007	16	2017	Talca	244658.0	2017	220357	53912095394
07101	7101162010	67	2017	Talca	244658.0	2017	220357	53912095394
07101	7101162019	86	2017	Talca	244658.0	2017	220357	53912095394
07102	7102022033	6	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102022038	3	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102022046	2	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102022060	1	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102032025	10	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102032030	1	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102032038	2	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102032043	5	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102032045	19	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102032056	23	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102032060	5	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102042007	7	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102042011	1	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102042016	25	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102042024	15	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102042036	13	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102042047	36	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102042901	67	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102052009	1	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102052012	1	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102052050	1	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102062007	1	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102062010	1	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102062018	1	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102062028	3	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102062053	7	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102062059	6	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102062901	6	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102072006	1	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102072027	12	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102072031	2	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102072048	8	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102072055	2	2017	Constitución	198314.7	2017	46068	9135962663
07103	7103012027	5	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103012038	12	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103012042	6	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103012054	5	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103022003	7	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103022020	7	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103022025	11	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103022049	1	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103022052	6	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103032007	15	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103032012	6	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103032053	2	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103042010	3	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103042027	2	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103042031	7	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103042037	4	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103042043	1	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103042044	1	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103042047	2	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103042901	1	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103052051	1	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103052058	1	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103062022	24	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103062901	1	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103072024	3	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103072062	2	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103072901	3	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103082011	6	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103082041	2	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103082048	2	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103082059	2	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103092021	1	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103092061	6	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103102026	44	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103102039	8	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103102063	3	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103102901	1	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103112013	1	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103112016	1	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103112018	4	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103112036	4	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103112059	1	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103112901	1	2017	Curepto	191743.1	2017	9448	1811588746
07104	7104012008	3	2017	Empedrado	172428.7	2017	4142	714199777
07104	7104012901	2	2017	Empedrado	172428.7	2017	4142	714199777
07104	7104022007	2	2017	Empedrado	172428.7	2017	4142	714199777
07104	7104022012	1	2017	Empedrado	172428.7	2017	4142	714199777
07104	7104022013	1	2017	Empedrado	172428.7	2017	4142	714199777
07104	7104032008	2	2017	Empedrado	172428.7	2017	4142	714199777
07104	7104042011	2	2017	Empedrado	172428.7	2017	4142	714199777
07104	7104042021	3	2017	Empedrado	172428.7	2017	4142	714199777
07105	7105012020	6	2017	Maule	195207.4	2017	49721	9705908393
07105	7105022020	26	2017	Maule	195207.4	2017	49721	9705908393
07105	7105022024	25	2017	Maule	195207.4	2017	49721	9705908393
07105	7105022901	4	2017	Maule	195207.4	2017	49721	9705908393
07105	7105032014	12	2017	Maule	195207.4	2017	49721	9705908393
07105	7105032024	8	2017	Maule	195207.4	2017	49721	9705908393
07105	7105042001	48	2017	Maule	195207.4	2017	49721	9705908393
07105	7105042004	4	2017	Maule	195207.4	2017	49721	9705908393
07105	7105042005	129	2017	Maule	195207.4	2017	49721	9705908393
07105	7105042017	34	2017	Maule	195207.4	2017	49721	9705908393
07105	7105042018	21	2017	Maule	195207.4	2017	49721	9705908393
07105	7105042027	31	2017	Maule	195207.4	2017	49721	9705908393
07105	7105052005	16	2017	Maule	195207.4	2017	49721	9705908393
07105	7105052027	129	2017	Maule	195207.4	2017	49721	9705908393
07105	7105052901	2	2017	Maule	195207.4	2017	49721	9705908393
07105	7105062002	29	2017	Maule	195207.4	2017	49721	9705908393
07105	7105062003	29	2017	Maule	195207.4	2017	49721	9705908393
07105	7105062011	5	2017	Maule	195207.4	2017	49721	9705908393
07105	7105062012	18	2017	Maule	195207.4	2017	49721	9705908393
07105	7105062015	40	2017	Maule	195207.4	2017	49721	9705908393
07105	7105062019	19	2017	Maule	195207.4	2017	49721	9705908393
07105	7105072007	34	2017	Maule	195207.4	2017	49721	9705908393
07105	7105072010	7	2017	Maule	195207.4	2017	49721	9705908393
07105	7105072025	3	2017	Maule	195207.4	2017	49721	9705908393
07105	7105072026	6	2017	Maule	195207.4	2017	49721	9705908393
07105	7105072901	6	2017	Maule	195207.4	2017	49721	9705908393
07105	7105082002	7	2017	Maule	195207.4	2017	49721	9705908393
07105	7105082009	2	2017	Maule	195207.4	2017	49721	9705908393
07105	7105082013	24	2017	Maule	195207.4	2017	49721	9705908393
07105	7105082015	5	2017	Maule	195207.4	2017	49721	9705908393
07105	7105082016	10	2017	Maule	195207.4	2017	49721	9705908393
07105	7105082019	2	2017	Maule	195207.4	2017	49721	9705908393
07105	7105082022	12	2017	Maule	195207.4	2017	49721	9705908393
07105	7105082023	28	2017	Maule	195207.4	2017	49721	9705908393
07105	7105082028	12	2017	Maule	195207.4	2017	49721	9705908393
07105	7105082901	1	2017	Maule	195207.4	2017	49721	9705908393
07106	7106012002	2	2017	Pelarco	187124.6	2017	8422	1575963241
07106	7106012003	2	2017	Pelarco	187124.6	2017	8422	1575963241
07106	7106012004	3	2017	Pelarco	187124.6	2017	8422	1575963241
07106	7106012005	6	2017	Pelarco	187124.6	2017	8422	1575963241
07106	7106012006	3	2017	Pelarco	187124.6	2017	8422	1575963241
07106	7106012013	2	2017	Pelarco	187124.6	2017	8422	1575963241
07106	7106012015	5	2017	Pelarco	187124.6	2017	8422	1575963241
07106	7106012017	19	2017	Pelarco	187124.6	2017	8422	1575963241
07106	7106012018	41	2017	Pelarco	187124.6	2017	8422	1575963241
07106	7106022009	82	2017	Pelarco	187124.6	2017	8422	1575963241
07106	7106022011	30	2017	Pelarco	187124.6	2017	8422	1575963241
07106	7106022019	95	2017	Pelarco	187124.6	2017	8422	1575963241
07106	7106032001	3	2017	Pelarco	187124.6	2017	8422	1575963241
07106	7106032007	7	2017	Pelarco	187124.6	2017	8422	1575963241
07106	7106032008	11	2017	Pelarco	187124.6	2017	8422	1575963241
07106	7106032010	9	2017	Pelarco	187124.6	2017	8422	1575963241
07106	7106032012	3	2017	Pelarco	187124.6	2017	8422	1575963241
07106	7106032016	1	2017	Pelarco	187124.6	2017	8422	1575963241
07106	7106032020	8	2017	Pelarco	187124.6	2017	8422	1575963241
07107	7107012005	3	2017	Pencahue	220957.5	2017	8245	1821794345
07107	7107012011	21	2017	Pencahue	220957.5	2017	8245	1821794345
07107	7107012021	8	2017	Pencahue	220957.5	2017	8245	1821794345
07107	7107012024	2	2017	Pencahue	220957.5	2017	8245	1821794345
07107	7107012033	7	2017	Pencahue	220957.5	2017	8245	1821794345
07107	7107012037	12	2017	Pencahue	220957.5	2017	8245	1821794345
07107	7107012901	3	2017	Pencahue	220957.5	2017	8245	1821794345
07107	7107022005	131	2017	Pencahue	220957.5	2017	8245	1821794345
07107	7107022006	34	2017	Pencahue	220957.5	2017	8245	1821794345
07107	7107022021	2	2017	Pencahue	220957.5	2017	8245	1821794345
07107	7107022038	11	2017	Pencahue	220957.5	2017	8245	1821794345
07107	7107022901	29	2017	Pencahue	220957.5	2017	8245	1821794345
07107	7107032002	7	2017	Pencahue	220957.5	2017	8245	1821794345
07107	7107032006	2	2017	Pencahue	220957.5	2017	8245	1821794345
07107	7107032008	10	2017	Pencahue	220957.5	2017	8245	1821794345
07107	7107032010	6	2017	Pencahue	220957.5	2017	8245	1821794345
07107	7107032014	4	2017	Pencahue	220957.5	2017	8245	1821794345
07107	7107032032	1	2017	Pencahue	220957.5	2017	8245	1821794345
07107	7107042007	3	2017	Pencahue	220957.5	2017	8245	1821794345
07107	7107042043	2	2017	Pencahue	220957.5	2017	8245	1821794345
07107	7107042045	2	2017	Pencahue	220957.5	2017	8245	1821794345
07107	7107042901	2	2017	Pencahue	220957.5	2017	8245	1821794345
07107	7107052001	13	2017	Pencahue	220957.5	2017	8245	1821794345
07107	7107052004	2	2017	Pencahue	220957.5	2017	8245	1821794345
07107	7107052022	1	2017	Pencahue	220957.5	2017	8245	1821794345
07107	7107052039	1	2017	Pencahue	220957.5	2017	8245	1821794345
07107	7107062002	7	2017	Pencahue	220957.5	2017	8245	1821794345
07107	7107062017	1	2017	Pencahue	220957.5	2017	8245	1821794345
07107	7107062023	2	2017	Pencahue	220957.5	2017	8245	1821794345
07107	7107062044	2	2017	Pencahue	220957.5	2017	8245	1821794345
07107	7107072013	3	2017	Pencahue	220957.5	2017	8245	1821794345
07107	7107072018	9	2017	Pencahue	220957.5	2017	8245	1821794345
07107	7107072025	6	2017	Pencahue	220957.5	2017	8245	1821794345
07107	7107072031	2	2017	Pencahue	220957.5	2017	8245	1821794345
07107	7107072047	1	2017	Pencahue	220957.5	2017	8245	1821794345
07108	7108012003	8	2017	Río Claro	196539.7	2017	13906	2733081178
07108	7108012004	6	2017	Río Claro	196539.7	2017	13906	2733081178
07108	7108012007	7	2017	Río Claro	196539.7	2017	13906	2733081178
07108	7108012014	33	2017	Río Claro	196539.7	2017	13906	2733081178
07108	7108012022	6	2017	Río Claro	196539.7	2017	13906	2733081178
07108	7108012028	13	2017	Río Claro	196539.7	2017	13906	2733081178
07108	7108012031	11	2017	Río Claro	196539.7	2017	13906	2733081178
07108	7108012032	15	2017	Río Claro	196539.7	2017	13906	2733081178
07108	7108012033	14	2017	Río Claro	196539.7	2017	13906	2733081178
07108	7108022005	10	2017	Río Claro	196539.7	2017	13906	2733081178
07108	7108022008	10	2017	Río Claro	196539.7	2017	13906	2733081178
07108	7108022011	9	2017	Río Claro	196539.7	2017	13906	2733081178
07108	7108022012	3	2017	Río Claro	196539.7	2017	13906	2733081178
07108	7108022014	1	2017	Río Claro	196539.7	2017	13906	2733081178
07108	7108022017	15	2017	Río Claro	196539.7	2017	13906	2733081178
07108	7108022022	15	2017	Río Claro	196539.7	2017	13906	2733081178
07108	7108022030	4	2017	Río Claro	196539.7	2017	13906	2733081178
07108	7108022034	5	2017	Río Claro	196539.7	2017	13906	2733081178
07108	7108032002	47	2017	Río Claro	196539.7	2017	13906	2733081178
07108	7108032018	19	2017	Río Claro	196539.7	2017	13906	2733081178
07108	7108042001	6	2017	Río Claro	196539.7	2017	13906	2733081178
07108	7108042002	4	2017	Río Claro	196539.7	2017	13906	2733081178
07108	7108042009	2	2017	Río Claro	196539.7	2017	13906	2733081178
07108	7108042023	5	2017	Río Claro	196539.7	2017	13906	2733081178
07108	7108042026	5	2017	Río Claro	196539.7	2017	13906	2733081178
07108	7108042027	2	2017	Río Claro	196539.7	2017	13906	2733081178
07108	7108052024	10	2017	Río Claro	196539.7	2017	13906	2733081178
07108	7108052025	8	2017	Río Claro	196539.7	2017	13906	2733081178
07108	7108052026	13	2017	Río Claro	196539.7	2017	13906	2733081178
07108	7108052029	38	2017	Río Claro	196539.7	2017	13906	2733081178
07108	7108062006	13	2017	Río Claro	196539.7	2017	13906	2733081178
07108	7108062013	7	2017	Río Claro	196539.7	2017	13906	2733081178
07108	7108062019	2	2017	Río Claro	196539.7	2017	13906	2733081178
07108	7108062020	4	2017	Río Claro	196539.7	2017	13906	2733081178
07109	7109012013	6	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109012023	17	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109012024	12	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109012039	4	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109012049	10	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109012051	21	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109022002	56	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109022021	62	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109022053	10	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109022055	3	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109032002	13	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109032037	5	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109032045	10	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109032047	2	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109032054	37	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109042042	12	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109042050	29	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109042054	2	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109052003	21	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109052022	10	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109052044	19	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109062008	7	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109062025	1	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109062043	5	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109072020	3	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109072027	5	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109072032	8	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109072038	1	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109072901	2	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109082010	7	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109082018	1	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109082028	3	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109082031	7	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109082034	43	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109082058	23	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109082059	12	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109082060	25	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109092026	4	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109092901	77	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109102007	14	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109102017	44	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109102041	28	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109112035	32	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109112901	4	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109122006	15	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109122009	23	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109122016	4	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109122049	18	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109122052	14	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109122055	5	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109122056	18	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109122901	3	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109132004	22	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109132011	31	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109132039	83	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109142004	10	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109142007	5	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109142011	39	2017	San Clemente	179181.4	2017	43269	7753001772
07109	7109142036	16	2017	San Clemente	179181.4	2017	43269	7753001772
07110	7110012001	48	2017	San Rafael	195848.9	2017	9191	1800047360
07110	7110012004	3	2017	San Rafael	195848.9	2017	9191	1800047360
07110	7110012007	16	2017	San Rafael	195848.9	2017	9191	1800047360
07110	7110012009	2	2017	San Rafael	195848.9	2017	9191	1800047360
07110	7110012010	7	2017	San Rafael	195848.9	2017	9191	1800047360
07110	7110012013	30	2017	San Rafael	195848.9	2017	9191	1800047360
07110	7110012016	33	2017	San Rafael	195848.9	2017	9191	1800047360
07110	7110022003	10	2017	San Rafael	195848.9	2017	9191	1800047360
07110	7110022005	4	2017	San Rafael	195848.9	2017	9191	1800047360
07110	7110022006	3	2017	San Rafael	195848.9	2017	9191	1800047360
07110	7110022008	1	2017	San Rafael	195848.9	2017	9191	1800047360
07110	7110022011	13	2017	San Rafael	195848.9	2017	9191	1800047360
07110	7110022012	45	2017	San Rafael	195848.9	2017	9191	1800047360
07110	7110022013	8	2017	San Rafael	195848.9	2017	9191	1800047360
07110	7110022014	7	2017	San Rafael	195848.9	2017	9191	1800047360
07110	7110022015	7	2017	San Rafael	195848.9	2017	9191	1800047360
07110	7110022016	3	2017	San Rafael	195848.9	2017	9191	1800047360
07110	7110022017	6	2017	San Rafael	195848.9	2017	9191	1800047360
07110	7110022018	3	2017	San Rafael	195848.9	2017	9191	1800047360
07201	7201062008	4	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201062032	34	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201062037	4	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201062063	1	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201072005	2	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201072038	3	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201072052	7	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201072073	1	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201082011	5	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201082020	5	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201082021	29	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201082901	6	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201092004	3	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201092024	2	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201092049	6	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201092901	3	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201102002	8	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201102004	1	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201102024	3	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201102044	2	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201102062	1	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201102069	2	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201102070	27	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201112010	14	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201112029	5	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201112056	14	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201112073	5	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201122001	2	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201122031	1	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201122035	1	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201122053	4	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201132016	2	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201132017	2	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201132038	1	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201132042	1	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201132074	2	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201142039	1	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201142055	7	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201142072	3	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201152013	1	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201152019	10	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201152050	3	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201152057	1	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201162034	2	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201162051	2	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201162054	12	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201162058	2	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201162061	2	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201162068	18	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201162071	7	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201172003	1	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201172006	8	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201172020	3	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201172065	2	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201172901	1	2017	Cauquenes	152604.5	2017	40441	6171477801
07201	7201182076	3	2017	Cauquenes	152604.5	2017	40441	6171477801
07202	7202012901	5	2017	Chanco	128982.1	2017	8928	1151552040
07202	7202022003	9	2017	Chanco	128982.1	2017	8928	1151552040
07202	7202022026	4	2017	Chanco	128982.1	2017	8928	1151552040
07202	7202022028	2	2017	Chanco	128982.1	2017	8928	1151552040
07202	7202022031	6	2017	Chanco	128982.1	2017	8928	1151552040
07202	7202022032	6	2017	Chanco	128982.1	2017	8928	1151552040
07202	7202022036	2	2017	Chanco	128982.1	2017	8928	1151552040
07202	7202032009	2	2017	Chanco	128982.1	2017	8928	1151552040
07202	7202032013	1	2017	Chanco	128982.1	2017	8928	1151552040
07202	7202032019	6	2017	Chanco	128982.1	2017	8928	1151552040
07202	7202032023	16	2017	Chanco	128982.1	2017	8928	1151552040
07202	7202032027	4	2017	Chanco	128982.1	2017	8928	1151552040
07202	7202042001	1	2017	Chanco	128982.1	2017	8928	1151552040
07202	7202042016	1	2017	Chanco	128982.1	2017	8928	1151552040
07202	7202052008	1	2017	Chanco	128982.1	2017	8928	1151552040
07202	7202052014	2	2017	Chanco	128982.1	2017	8928	1151552040
07202	7202052015	1	2017	Chanco	128982.1	2017	8928	1151552040
07202	7202052025	8	2017	Chanco	128982.1	2017	8928	1151552040
07202	7202062006	7	2017	Chanco	128982.1	2017	8928	1151552040
07202	7202062017	8	2017	Chanco	128982.1	2017	8928	1151552040
07202	7202062020	2	2017	Chanco	128982.1	2017	8928	1151552040
07202	7202062029	1	2017	Chanco	128982.1	2017	8928	1151552040
07203	7203012006	10	2017	Pelluhue	113986.7	2017	7571	862993347
07203	7203012008	1	2017	Pelluhue	113986.7	2017	7571	862993347
07203	7203012011	2	2017	Pelluhue	113986.7	2017	7571	862993347
07203	7203012013	4	2017	Pelluhue	113986.7	2017	7571	862993347
07203	7203012014	2	2017	Pelluhue	113986.7	2017	7571	862993347
07203	7203012017	1	2017	Pelluhue	113986.7	2017	7571	862993347
07203	7203012018	7	2017	Pelluhue	113986.7	2017	7571	862993347
07203	7203012021	3	2017	Pelluhue	113986.7	2017	7571	862993347
07203	7203012022	2	2017	Pelluhue	113986.7	2017	7571	862993347
07203	7203022003	4	2017	Pelluhue	113986.7	2017	7571	862993347
07203	7203022004	2	2017	Pelluhue	113986.7	2017	7571	862993347
07203	7203022012	8	2017	Pelluhue	113986.7	2017	7571	862993347
07203	7203022016	1	2017	Pelluhue	113986.7	2017	7571	862993347
07203	7203022020	50	2017	Pelluhue	113986.7	2017	7571	862993347
07203	7203022024	9	2017	Pelluhue	113986.7	2017	7571	862993347
07203	7203032001	1	2017	Pelluhue	113986.7	2017	7571	862993347
07203	7203032002	23	2017	Pelluhue	113986.7	2017	7571	862993347
07203	7203032005	30	2017	Pelluhue	113986.7	2017	7571	862993347
07203	7203032023	21	2017	Pelluhue	113986.7	2017	7571	862993347
07203	7203032026	1	2017	Pelluhue	113986.7	2017	7571	862993347
07203	7203032027	2	2017	Pelluhue	113986.7	2017	7571	862993347
07301	7301052004	21	2017	Curicó	265301.7	2017	149136	39566034949
07301	7301052032	2	2017	Curicó	265301.7	2017	149136	39566034949
07301	7301062013	53	2017	Curicó	265301.7	2017	149136	39566034949
07301	7301062032	50	2017	Curicó	265301.7	2017	149136	39566034949
07301	7301062033	26	2017	Curicó	265301.7	2017	149136	39566034949
07301	7301062034	10	2017	Curicó	265301.7	2017	149136	39566034949
07301	7301062901	1	2017	Curicó	265301.7	2017	149136	39566034949
07301	7301072001	13	2017	Curicó	265301.7	2017	149136	39566034949
07301	7301072008	14	2017	Curicó	265301.7	2017	149136	39566034949
07301	7301072032	3	2017	Curicó	265301.7	2017	149136	39566034949
07301	7301072901	5	2017	Curicó	265301.7	2017	149136	39566034949
07301	7301082013	25	2017	Curicó	265301.7	2017	149136	39566034949
07301	7301082022	43	2017	Curicó	265301.7	2017	149136	39566034949
07301	7301082028	14	2017	Curicó	265301.7	2017	149136	39566034949
07301	7301082030	1	2017	Curicó	265301.7	2017	149136	39566034949
07301	7301082031	2	2017	Curicó	265301.7	2017	149136	39566034949
07301	7301082901	4	2017	Curicó	265301.7	2017	149136	39566034949
07301	7301092031	37	2017	Curicó	265301.7	2017	149136	39566034949
07301	7301102027	21	2017	Curicó	265301.7	2017	149136	39566034949
07301	7301112009	202	2017	Curicó	265301.7	2017	149136	39566034949
07301	7301112011	23	2017	Curicó	265301.7	2017	149136	39566034949
07301	7301112012	14	2017	Curicó	265301.7	2017	149136	39566034949
07301	7301112014	258	2017	Curicó	265301.7	2017	149136	39566034949
07301	7301112020	116	2017	Curicó	265301.7	2017	149136	39566034949
07301	7301112021	56	2017	Curicó	265301.7	2017	149136	39566034949
07301	7301112023	19	2017	Curicó	265301.7	2017	149136	39566034949
07301	7301112024	12	2017	Curicó	265301.7	2017	149136	39566034949
07301	7301112037	53	2017	Curicó	265301.7	2017	149136	39566034949
07301	7301122016	2	2017	Curicó	265301.7	2017	149136	39566034949
07301	7301122017	8	2017	Curicó	265301.7	2017	149136	39566034949
07301	7301122019	48	2017	Curicó	265301.7	2017	149136	39566034949
07301	7301122023	194	2017	Curicó	265301.7	2017	149136	39566034949
07301	7301122901	2	2017	Curicó	265301.7	2017	149136	39566034949
07301	7301132003	56	2017	Curicó	265301.7	2017	149136	39566034949
07301	7301142025	2	2017	Curicó	265301.7	2017	149136	39566034949
07301	7301142035	7	2017	Curicó	265301.7	2017	149136	39566034949
07301	7301152026	22	2017	Curicó	265301.7	2017	149136	39566034949
07301	7301162005	41	2017	Curicó	265301.7	2017	149136	39566034949
07301	7301162018	2	2017	Curicó	265301.7	2017	149136	39566034949
07301	7301162026	18	2017	Curicó	265301.7	2017	149136	39566034949
07301	7301162035	5	2017	Curicó	265301.7	2017	149136	39566034949
07301	7301172023	19	2017	Curicó	265301.7	2017	149136	39566034949
07302	7302012001	2	2017	Hualañé	167967.3	2017	9657	1622060226
07302	7302012005	2	2017	Hualañé	167967.3	2017	9657	1622060226
07302	7302012007	6	2017	Hualañé	167967.3	2017	9657	1622060226
07302	7302012008	1	2017	Hualañé	167967.3	2017	9657	1622060226
07302	7302012014	11	2017	Hualañé	167967.3	2017	9657	1622060226
07302	7302012018	20	2017	Hualañé	167967.3	2017	9657	1622060226
07302	7302022013	4	2017	Hualañé	167967.3	2017	9657	1622060226
07302	7302022017	5	2017	Hualañé	167967.3	2017	9657	1622060226
07302	7302022019	7	2017	Hualañé	167967.3	2017	9657	1622060226
07302	7302032002	5	2017	Hualañé	167967.3	2017	9657	1622060226
07302	7302032004	5	2017	Hualañé	167967.3	2017	9657	1622060226
07302	7302032011	3	2017	Hualañé	167967.3	2017	9657	1622060226
07302	7302042009	58	2017	Hualañé	167967.3	2017	9657	1622060226
07302	7302042015	23	2017	Hualañé	167967.3	2017	9657	1622060226
07302	7302042016	10	2017	Hualañé	167967.3	2017	9657	1622060226
07302	7302042901	28	2017	Hualañé	167967.3	2017	9657	1622060226
07303	7303012004	4	2017	Licantén	179919.7	2017	6653	1197005482
07303	7303012006	2	2017	Licantén	179919.7	2017	6653	1197005482
07303	7303012007	1	2017	Licantén	179919.7	2017	6653	1197005482
07303	7303012008	7	2017	Licantén	179919.7	2017	6653	1197005482
07303	7303012011	1	2017	Licantén	179919.7	2017	6653	1197005482
07303	7303012016	13	2017	Licantén	179919.7	2017	6653	1197005482
07303	7303012901	1	2017	Licantén	179919.7	2017	6653	1197005482
07303	7303022003	4	2017	Licantén	179919.7	2017	6653	1197005482
07303	7303022012	31	2017	Licantén	179919.7	2017	6653	1197005482
07303	7303022015	1	2017	Licantén	179919.7	2017	6653	1197005482
07303	7303022017	12	2017	Licantén	179919.7	2017	6653	1197005482
07303	7303032901	5	2017	Licantén	179919.7	2017	6653	1197005482
07304	7304022008	16	2017	Molina	227845.0	2017	45976	10475401720
07304	7304022019	3	2017	Molina	227845.0	2017	45976	10475401720
07304	7304022030	3	2017	Molina	227845.0	2017	45976	10475401720
07304	7304022031	10	2017	Molina	227845.0	2017	45976	10475401720
07304	7304022034	3	2017	Molina	227845.0	2017	45976	10475401720
07304	7304022037	5	2017	Molina	227845.0	2017	45976	10475401720
07304	7304022901	1	2017	Molina	227845.0	2017	45976	10475401720
07304	7304032019	67	2017	Molina	227845.0	2017	45976	10475401720
07304	7304032036	2	2017	Molina	227845.0	2017	45976	10475401720
07304	7304042007	1	2017	Molina	227845.0	2017	45976	10475401720
07304	7304042026	5	2017	Molina	227845.0	2017	45976	10475401720
07304	7304042027	2	2017	Molina	227845.0	2017	45976	10475401720
07304	7304042901	1	2017	Molina	227845.0	2017	45976	10475401720
07304	7304052003	8	2017	Molina	227845.0	2017	45976	10475401720
07304	7304052006	9	2017	Molina	227845.0	2017	45976	10475401720
07304	7304052009	4	2017	Molina	227845.0	2017	45976	10475401720
07304	7304052031	2	2017	Molina	227845.0	2017	45976	10475401720
07304	7304052032	58	2017	Molina	227845.0	2017	45976	10475401720
07304	7304052901	1	2017	Molina	227845.0	2017	45976	10475401720
07304	7304062003	15	2017	Molina	227845.0	2017	45976	10475401720
07304	7304062004	8	2017	Molina	227845.0	2017	45976	10475401720
07304	7304062006	13	2017	Molina	227845.0	2017	45976	10475401720
07304	7304062008	15	2017	Molina	227845.0	2017	45976	10475401720
07304	7304062010	7	2017	Molina	227845.0	2017	45976	10475401720
07304	7304062012	16	2017	Molina	227845.0	2017	45976	10475401720
07304	7304062021	5	2017	Molina	227845.0	2017	45976	10475401720
07304	7304062038	2	2017	Molina	227845.0	2017	45976	10475401720
07304	7304062901	2	2017	Molina	227845.0	2017	45976	10475401720
07304	7304072005	25	2017	Molina	227845.0	2017	45976	10475401720
07304	7304072020	5	2017	Molina	227845.0	2017	45976	10475401720
07304	7304072022	5	2017	Molina	227845.0	2017	45976	10475401720
07304	7304072025	4	2017	Molina	227845.0	2017	45976	10475401720
07304	7304072035	25	2017	Molina	227845.0	2017	45976	10475401720
07304	7304072038	14	2017	Molina	227845.0	2017	45976	10475401720
07304	7304072901	2	2017	Molina	227845.0	2017	45976	10475401720
07304	7304082002	3	2017	Molina	227845.0	2017	45976	10475401720
07304	7304082016	8	2017	Molina	227845.0	2017	45976	10475401720
07304	7304082030	1	2017	Molina	227845.0	2017	45976	10475401720
07304	7304092001	4	2017	Molina	227845.0	2017	45976	10475401720
07304	7304092018	3	2017	Molina	227845.0	2017	45976	10475401720
07304	7304092023	1	2017	Molina	227845.0	2017	45976	10475401720
07304	7304102015	10	2017	Molina	227845.0	2017	45976	10475401720
07305	7305012003	50	2017	Rauco	196719.6	2017	10484	2062408371
07305	7305012005	74	2017	Rauco	196719.6	2017	10484	2062408371
07305	7305012008	28	2017	Rauco	196719.6	2017	10484	2062408371
07305	7305012012	43	2017	Rauco	196719.6	2017	10484	2062408371
07305	7305022011	16	2017	Rauco	196719.6	2017	10484	2062408371
07305	7305022013	13	2017	Rauco	196719.6	2017	10484	2062408371
07305	7305022014	8	2017	Rauco	196719.6	2017	10484	2062408371
07305	7305032002	11	2017	Rauco	196719.6	2017	10484	2062408371
07305	7305032009	9	2017	Rauco	196719.6	2017	10484	2062408371
07305	7305032010	27	2017	Rauco	196719.6	2017	10484	2062408371
07305	7305042004	2	2017	Rauco	196719.6	2017	10484	2062408371
07305	7305042901	1	2017	Rauco	196719.6	2017	10484	2062408371
07306	7306012017	47	2017	Romeral	218360.4	2017	15187	3316239205
07306	7306012023	87	2017	Romeral	218360.4	2017	15187	3316239205
07306	7306012024	24	2017	Romeral	218360.4	2017	15187	3316239205
07306	7306012026	161	2017	Romeral	218360.4	2017	15187	3316239205
07306	7306012027	9	2017	Romeral	218360.4	2017	15187	3316239205
07306	7306012029	23	2017	Romeral	218360.4	2017	15187	3316239205
07306	7306012901	5	2017	Romeral	218360.4	2017	15187	3316239205
07306	7306022001	10	2017	Romeral	218360.4	2017	15187	3316239205
07306	7306022004	11	2017	Romeral	218360.4	2017	15187	3316239205
07306	7306022010	24	2017	Romeral	218360.4	2017	15187	3316239205
07306	7306022011	7	2017	Romeral	218360.4	2017	15187	3316239205
07306	7306022012	5	2017	Romeral	218360.4	2017	15187	3316239205
07306	7306022013	27	2017	Romeral	218360.4	2017	15187	3316239205
07306	7306022014	39	2017	Romeral	218360.4	2017	15187	3316239205
07306	7306022016	13	2017	Romeral	218360.4	2017	15187	3316239205
07306	7306022027	7	2017	Romeral	218360.4	2017	15187	3316239205
07306	7306032004	6	2017	Romeral	218360.4	2017	15187	3316239205
07306	7306032005	6	2017	Romeral	218360.4	2017	15187	3316239205
07306	7306032007	4	2017	Romeral	218360.4	2017	15187	3316239205
07306	7306032013	7	2017	Romeral	218360.4	2017	15187	3316239205
07306	7306032015	2	2017	Romeral	218360.4	2017	15187	3316239205
07306	7306032020	8	2017	Romeral	218360.4	2017	15187	3316239205
07306	7306032021	5	2017	Romeral	218360.4	2017	15187	3316239205
07306	7306042021	14	2017	Romeral	218360.4	2017	15187	3316239205
07306	7306042901	4	2017	Romeral	218360.4	2017	15187	3316239205
07306	7306052025	1	2017	Romeral	218360.4	2017	15187	3316239205
07307	7307012017	32	2017	Sagrada Familia	204922.9	2017	18544	3800089672
07307	7307022018	6	2017	Sagrada Familia	204922.9	2017	18544	3800089672
07307	7307022022	21	2017	Sagrada Familia	204922.9	2017	18544	3800089672
07307	7307032007	20	2017	Sagrada Familia	204922.9	2017	18544	3800089672
07307	7307032009	40	2017	Sagrada Familia	204922.9	2017	18544	3800089672
07307	7307032012	72	2017	Sagrada Familia	204922.9	2017	18544	3800089672
07307	7307042001	14	2017	Sagrada Familia	204922.9	2017	18544	3800089672
07307	7307042008	16	2017	Sagrada Familia	204922.9	2017	18544	3800089672
07307	7307042016	24	2017	Sagrada Familia	204922.9	2017	18544	3800089672
07307	7307042021	46	2017	Sagrada Familia	204922.9	2017	18544	3800089672
07307	7307052003	4	2017	Sagrada Familia	204922.9	2017	18544	3800089672
07307	7307052006	5	2017	Sagrada Familia	204922.9	2017	18544	3800089672
07307	7307052901	1	2017	Sagrada Familia	204922.9	2017	18544	3800089672
07307	7307062901	1	2017	Sagrada Familia	204922.9	2017	18544	3800089672
07307	7307072004	2	2017	Sagrada Familia	204922.9	2017	18544	3800089672
07307	7307072023	7	2017	Sagrada Familia	204922.9	2017	18544	3800089672
07307	7307072901	1	2017	Sagrada Familia	204922.9	2017	18544	3800089672
07307	7307082013	21	2017	Sagrada Familia	204922.9	2017	18544	3800089672
07307	7307092002	20	2017	Sagrada Familia	204922.9	2017	18544	3800089672
07307	7307092013	23	2017	Sagrada Familia	204922.9	2017	18544	3800089672
07307	7307092014	95	2017	Sagrada Familia	204922.9	2017	18544	3800089672
07307	7307092019	25	2017	Sagrada Familia	204922.9	2017	18544	3800089672
07308	7308012005	3	2017	Teno	250368.7	2017	28921	7240913928
07308	7308012009	7	2017	Teno	250368.7	2017	28921	7240913928
07308	7308012013	2	2017	Teno	250368.7	2017	28921	7240913928
07308	7308012019	32	2017	Teno	250368.7	2017	28921	7240913928
07308	7308012025	2	2017	Teno	250368.7	2017	28921	7240913928
07308	7308012032	26	2017	Teno	250368.7	2017	28921	7240913928
07308	7308012036	2	2017	Teno	250368.7	2017	28921	7240913928
07308	7308012901	11	2017	Teno	250368.7	2017	28921	7240913928
07308	7308022001	7	2017	Teno	250368.7	2017	28921	7240913928
07308	7308022011	38	2017	Teno	250368.7	2017	28921	7240913928
07308	7308022021	8	2017	Teno	250368.7	2017	28921	7240913928
07308	7308022025	17	2017	Teno	250368.7	2017	28921	7240913928
07308	7308022026	4	2017	Teno	250368.7	2017	28921	7240913928
07308	7308022033	15	2017	Teno	250368.7	2017	28921	7240913928
07308	7308022042	33	2017	Teno	250368.7	2017	28921	7240913928
07308	7308032001	85	2017	Teno	250368.7	2017	28921	7240913928
07308	7308032018	31	2017	Teno	250368.7	2017	28921	7240913928
07308	7308042002	46	2017	Teno	250368.7	2017	28921	7240913928
07308	7308042008	20	2017	Teno	250368.7	2017	28921	7240913928
07308	7308042017	11	2017	Teno	250368.7	2017	28921	7240913928
07308	7308042029	14	2017	Teno	250368.7	2017	28921	7240913928
07308	7308042031	8	2017	Teno	250368.7	2017	28921	7240913928
07308	7308042036	19	2017	Teno	250368.7	2017	28921	7240913928
07308	7308042037	6	2017	Teno	250368.7	2017	28921	7240913928
07308	7308042038	19	2017	Teno	250368.7	2017	28921	7240913928
07308	7308042041	19	2017	Teno	250368.7	2017	28921	7240913928
07308	7308042043	5	2017	Teno	250368.7	2017	28921	7240913928
07308	7308052003	17	2017	Teno	250368.7	2017	28921	7240913928
07308	7308052008	7	2017	Teno	250368.7	2017	28921	7240913928
07308	7308052010	12	2017	Teno	250368.7	2017	28921	7240913928
07308	7308052015	11	2017	Teno	250368.7	2017	28921	7240913928
07308	7308052020	6	2017	Teno	250368.7	2017	28921	7240913928
07308	7308052023	22	2017	Teno	250368.7	2017	28921	7240913928
07308	7308052024	35	2017	Teno	250368.7	2017	28921	7240913928
07308	7308052027	15	2017	Teno	250368.7	2017	28921	7240913928
07308	7308052028	7	2017	Teno	250368.7	2017	28921	7240913928
07308	7308052030	15	2017	Teno	250368.7	2017	28921	7240913928
07308	7308052034	9	2017	Teno	250368.7	2017	28921	7240913928
07308	7308052035	22	2017	Teno	250368.7	2017	28921	7240913928
07308	7308052037	13	2017	Teno	250368.7	2017	28921	7240913928
07308	7308052040	4	2017	Teno	250368.7	2017	28921	7240913928
07308	7308062004	2	2017	Teno	250368.7	2017	28921	7240913928
07308	7308062007	4	2017	Teno	250368.7	2017	28921	7240913928
07308	7308062014	6	2017	Teno	250368.7	2017	28921	7240913928
07308	7308072006	3	2017	Teno	250368.7	2017	28921	7240913928
07308	7308072012	17	2017	Teno	250368.7	2017	28921	7240913928
07308	7308072016	58	2017	Teno	250368.7	2017	28921	7240913928
07308	7308072028	7	2017	Teno	250368.7	2017	28921	7240913928
07309	7309012001	8	2017	Vichuquén	179935.1	2017	4322	777679695
07309	7309012002	20	2017	Vichuquén	179935.1	2017	4322	777679695
07309	7309012005	2	2017	Vichuquén	179935.1	2017	4322	777679695
07309	7309012010	12	2017	Vichuquén	179935.1	2017	4322	777679695
07309	7309012014	2	2017	Vichuquén	179935.1	2017	4322	777679695
07309	7309012018	3	2017	Vichuquén	179935.1	2017	4322	777679695
07309	7309012019	75	2017	Vichuquén	179935.1	2017	4322	777679695
07309	7309022005	2	2017	Vichuquén	179935.1	2017	4322	777679695
07309	7309022008	33	2017	Vichuquén	179935.1	2017	4322	777679695
07309	7309022011	20	2017	Vichuquén	179935.1	2017	4322	777679695
07309	7309032004	7	2017	Vichuquén	179935.1	2017	4322	777679695
07309	7309032008	10	2017	Vichuquén	179935.1	2017	4322	777679695
07309	7309032017	15	2017	Vichuquén	179935.1	2017	4322	777679695
07309	7309032020	8	2017	Vichuquén	179935.1	2017	4322	777679695
07309	7309042003	2	2017	Vichuquén	179935.1	2017	4322	777679695
07309	7309042015	2	2017	Vichuquén	179935.1	2017	4322	777679695
07309	7309042016	4	2017	Vichuquén	179935.1	2017	4322	777679695
07401	7401032003	23	2017	Linares	192783.1	2017	93602	18044885598
07401	7401032004	4	2017	Linares	192783.1	2017	93602	18044885598
07401	7401032026	30	2017	Linares	192783.1	2017	93602	18044885598
07401	7401032047	30	2017	Linares	192783.1	2017	93602	18044885598
07401	7401042015	1	2017	Linares	192783.1	2017	93602	18044885598
07401	7401042017	17	2017	Linares	192783.1	2017	93602	18044885598
07401	7401042025	14	2017	Linares	192783.1	2017	93602	18044885598
07401	7401042039	5	2017	Linares	192783.1	2017	93602	18044885598
07401	7401042046	8	2017	Linares	192783.1	2017	93602	18044885598
07401	7401042901	2	2017	Linares	192783.1	2017	93602	18044885598
07401	7401052021	4	2017	Linares	192783.1	2017	93602	18044885598
07401	7401052035	32	2017	Linares	192783.1	2017	93602	18044885598
07401	7401052038	32	2017	Linares	192783.1	2017	93602	18044885598
07401	7401062016	27	2017	Linares	192783.1	2017	93602	18044885598
07401	7401062025	42	2017	Linares	192783.1	2017	93602	18044885598
07401	7401062043	1	2017	Linares	192783.1	2017	93602	18044885598
07401	7401062051	2	2017	Linares	192783.1	2017	93602	18044885598
07401	7401072019	17	2017	Linares	192783.1	2017	93602	18044885598
07401	7401072020	38	2017	Linares	192783.1	2017	93602	18044885598
07401	7401072022	75	2017	Linares	192783.1	2017	93602	18044885598
07401	7401072047	9	2017	Linares	192783.1	2017	93602	18044885598
07401	7401072901	2	2017	Linares	192783.1	2017	93602	18044885598
07401	7401082005	38	2017	Linares	192783.1	2017	93602	18044885598
07401	7401082009	10	2017	Linares	192783.1	2017	93602	18044885598
07401	7401082013	17	2017	Linares	192783.1	2017	93602	18044885598
07401	7401082019	24	2017	Linares	192783.1	2017	93602	18044885598
07401	7401082022	25	2017	Linares	192783.1	2017	93602	18044885598
07401	7401082025	15	2017	Linares	192783.1	2017	93602	18044885598
07401	7401082026	6	2017	Linares	192783.1	2017	93602	18044885598
07401	7401082029	14	2017	Linares	192783.1	2017	93602	18044885598
07401	7401082042	32	2017	Linares	192783.1	2017	93602	18044885598
07401	7401082043	35	2017	Linares	192783.1	2017	93602	18044885598
07401	7401082044	9	2017	Linares	192783.1	2017	93602	18044885598
07401	7401082047	44	2017	Linares	192783.1	2017	93602	18044885598
07401	7401082048	33	2017	Linares	192783.1	2017	93602	18044885598
07401	7401082049	10	2017	Linares	192783.1	2017	93602	18044885598
07401	7401082050	25	2017	Linares	192783.1	2017	93602	18044885598
07401	7401082053	72	2017	Linares	192783.1	2017	93602	18044885598
07401	7401092008	5	2017	Linares	192783.1	2017	93602	18044885598
07401	7401092011	1	2017	Linares	192783.1	2017	93602	18044885598
07401	7401092012	6	2017	Linares	192783.1	2017	93602	18044885598
07401	7401092027	6	2017	Linares	192783.1	2017	93602	18044885598
07401	7401092031	2	2017	Linares	192783.1	2017	93602	18044885598
07401	7401092036	1	2017	Linares	192783.1	2017	93602	18044885598
07401	7401092037	1	2017	Linares	192783.1	2017	93602	18044885598
07401	7401092040	3	2017	Linares	192783.1	2017	93602	18044885598
07401	7401092055	1	2017	Linares	192783.1	2017	93602	18044885598
07401	7401102007	9	2017	Linares	192783.1	2017	93602	18044885598
07401	7401102014	7	2017	Linares	192783.1	2017	93602	18044885598
07401	7401102045	1	2017	Linares	192783.1	2017	93602	18044885598
07401	7401102054	21	2017	Linares	192783.1	2017	93602	18044885598
07401	7401112023	10	2017	Linares	192783.1	2017	93602	18044885598
07401	7401112024	13	2017	Linares	192783.1	2017	93602	18044885598
07401	7401112034	3	2017	Linares	192783.1	2017	93602	18044885598
07401	7401112035	30	2017	Linares	192783.1	2017	93602	18044885598
07401	7401112041	4	2017	Linares	192783.1	2017	93602	18044885598
07402	7402012002	2	2017	Colbún	161250.1	2017	20765	3348358419
07402	7402012004	2	2017	Colbún	161250.1	2017	20765	3348358419
07402	7402012005	12	2017	Colbún	161250.1	2017	20765	3348358419
07402	7402012010	1	2017	Colbún	161250.1	2017	20765	3348358419
07402	7402012013	1	2017	Colbún	161250.1	2017	20765	3348358419
07402	7402012021	2	2017	Colbún	161250.1	2017	20765	3348358419
07402	7402012029	29	2017	Colbún	161250.1	2017	20765	3348358419
07402	7402012031	48	2017	Colbún	161250.1	2017	20765	3348358419
07402	7402022001	16	2017	Colbún	161250.1	2017	20765	3348358419
07402	7402022019	12	2017	Colbún	161250.1	2017	20765	3348358419
07402	7402022020	83	2017	Colbún	161250.1	2017	20765	3348358419
07402	7402022038	12	2017	Colbún	161250.1	2017	20765	3348358419
07402	7402022040	3	2017	Colbún	161250.1	2017	20765	3348358419
07402	7402032006	9	2017	Colbún	161250.1	2017	20765	3348358419
07402	7402032012	5	2017	Colbún	161250.1	2017	20765	3348358419
07402	7402032016	1	2017	Colbún	161250.1	2017	20765	3348358419
07402	7402032024	12	2017	Colbún	161250.1	2017	20765	3348358419
07402	7402032901	8	2017	Colbún	161250.1	2017	20765	3348358419
07402	7402042007	4	2017	Colbún	161250.1	2017	20765	3348358419
07402	7402052026	6	2017	Colbún	161250.1	2017	20765	3348358419
07402	7402052030	2	2017	Colbún	161250.1	2017	20765	3348358419
07402	7402052901	4	2017	Colbún	161250.1	2017	20765	3348358419
07402	7402062027	27	2017	Colbún	161250.1	2017	20765	3348358419
07402	7402062028	10	2017	Colbún	161250.1	2017	20765	3348358419
07402	7402072003	15	2017	Colbún	161250.1	2017	20765	3348358419
07402	7402072015	25	2017	Colbún	161250.1	2017	20765	3348358419
07402	7402072017	8	2017	Colbún	161250.1	2017	20765	3348358419
07402	7402072023	23	2017	Colbún	161250.1	2017	20765	3348358419
07402	7402072025	41	2017	Colbún	161250.1	2017	20765	3348358419
07402	7402072026	10	2017	Colbún	161250.1	2017	20765	3348358419
07402	7402072032	13	2017	Colbún	161250.1	2017	20765	3348358419
07402	7402082022	22	2017	Colbún	161250.1	2017	20765	3348358419
07402	7402082035	20	2017	Colbún	161250.1	2017	20765	3348358419
07402	7402082036	7	2017	Colbún	161250.1	2017	20765	3348358419
07402	7402082039	12	2017	Colbún	161250.1	2017	20765	3348358419
07402	7402082901	2	2017	Colbún	161250.1	2017	20765	3348358419
07402	7402092008	7	2017	Colbún	161250.1	2017	20765	3348358419
07402	7402092009	9	2017	Colbún	161250.1	2017	20765	3348358419
07402	7402092011	4	2017	Colbún	161250.1	2017	20765	3348358419
07402	7402092014	4	2017	Colbún	161250.1	2017	20765	3348358419
07402	7402092033	3	2017	Colbún	161250.1	2017	20765	3348358419
07402	7402092034	8	2017	Colbún	161250.1	2017	20765	3348358419
07402	7402092037	3	2017	Colbún	161250.1	2017	20765	3348358419
07402	7402092901	1	2017	Colbún	161250.1	2017	20765	3348358419
07403	7403012011	13	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403012021	3	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403012026	1	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403012030	18	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403012037	10	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403012057	3	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403022010	3	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403022014	20	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403022033	3	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403022044	19	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403022052	8	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403032001	3	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403032032	2	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403032039	10	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403042002	13	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403042008	18	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403042035	6	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403042038	5	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403042042	4	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403042043	4	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403042048	18	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403052012	6	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403052014	4	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403052015	4	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403052022	15	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403052024	21	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403052033	19	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403052034	27	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403052038	6	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403052041	3	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403052047	2	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403052050	20	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403052901	1	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403062003	1	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403062020	13	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403062021	7	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403062030	1	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403062036	4	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403062037	2	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403072004	7	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403072005	4	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403072013	11	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403072016	2	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403072019	5	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403072029	4	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403072049	21	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403072054	1	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403082006	1	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403082056	7	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403092009	2	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403092023	1	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403092031	1	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403102004	10	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403102012	7	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403102017	12	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403102018	57	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403102019	4	2017	Longaví	166612.7	2017	30534	5087351933
07403	7403102020	27	2017	Longaví	166612.7	2017	30534	5087351933
07404	7404022001	44	2017	Parral	183123.5	2017	41637	7624714509
07404	7404022029	8	2017	Parral	183123.5	2017	41637	7624714509
07404	7404022901	1	2017	Parral	183123.5	2017	41637	7624714509
07404	7404032060	1	2017	Parral	183123.5	2017	41637	7624714509
07404	7404042024	2	2017	Parral	183123.5	2017	41637	7624714509
07404	7404052024	3	2017	Parral	183123.5	2017	41637	7624714509
07404	7404052072	3	2017	Parral	183123.5	2017	41637	7624714509
07404	7404062005	3	2017	Parral	183123.5	2017	41637	7624714509
07404	7404062015	6	2017	Parral	183123.5	2017	41637	7624714509
07404	7404062018	3	2017	Parral	183123.5	2017	41637	7624714509
07404	7404062020	13	2017	Parral	183123.5	2017	41637	7624714509
07404	7404062028	14	2017	Parral	183123.5	2017	41637	7624714509
07404	7404062032	4	2017	Parral	183123.5	2017	41637	7624714509
07404	7404062048	12	2017	Parral	183123.5	2017	41637	7624714509
07404	7404062071	1	2017	Parral	183123.5	2017	41637	7624714509
07404	7404072003	1	2017	Parral	183123.5	2017	41637	7624714509
07404	7404072007	1	2017	Parral	183123.5	2017	41637	7624714509
07404	7404072014	1	2017	Parral	183123.5	2017	41637	7624714509
07404	7404072052	7	2017	Parral	183123.5	2017	41637	7624714509
07404	7404072054	3	2017	Parral	183123.5	2017	41637	7624714509
07404	7404072062	1	2017	Parral	183123.5	2017	41637	7624714509
07404	7404072070	2	2017	Parral	183123.5	2017	41637	7624714509
07404	7404082019	1	2017	Parral	183123.5	2017	41637	7624714509
07404	7404082022	1	2017	Parral	183123.5	2017	41637	7624714509
07404	7404082027	2	2017	Parral	183123.5	2017	41637	7624714509
07404	7404082033	3	2017	Parral	183123.5	2017	41637	7624714509
07404	7404082042	4	2017	Parral	183123.5	2017	41637	7624714509
07404	7404082045	4	2017	Parral	183123.5	2017	41637	7624714509
07404	7404082046	4	2017	Parral	183123.5	2017	41637	7624714509
07404	7404082051	1	2017	Parral	183123.5	2017	41637	7624714509
07404	7404082057	4	2017	Parral	183123.5	2017	41637	7624714509
07404	7404082064	3	2017	Parral	183123.5	2017	41637	7624714509
07404	7404082067	13	2017	Parral	183123.5	2017	41637	7624714509
07404	7404082068	2	2017	Parral	183123.5	2017	41637	7624714509
07404	7404092013	2	2017	Parral	183123.5	2017	41637	7624714509
07404	7404092035	12	2017	Parral	183123.5	2017	41637	7624714509
07404	7404092041	25	2017	Parral	183123.5	2017	41637	7624714509
07404	7404092044	4	2017	Parral	183123.5	2017	41637	7624714509
07404	7404092049	2	2017	Parral	183123.5	2017	41637	7624714509
07404	7404092053	11	2017	Parral	183123.5	2017	41637	7624714509
07404	7404092055	1	2017	Parral	183123.5	2017	41637	7624714509
07404	7404092056	12	2017	Parral	183123.5	2017	41637	7624714509
07404	7404092059	5	2017	Parral	183123.5	2017	41637	7624714509
07404	7404092066	7	2017	Parral	183123.5	2017	41637	7624714509
07404	7404092067	16	2017	Parral	183123.5	2017	41637	7624714509
07404	7404092074	8	2017	Parral	183123.5	2017	41637	7624714509
07404	7404092075	5	2017	Parral	183123.5	2017	41637	7624714509
07404	7404092077	5	2017	Parral	183123.5	2017	41637	7624714509
07404	7404102023	12	2017	Parral	183123.5	2017	41637	7624714509
07404	7404112002	3	2017	Parral	183123.5	2017	41637	7624714509
07404	7404112038	4	2017	Parral	183123.5	2017	41637	7624714509
07404	7404112901	3	2017	Parral	183123.5	2017	41637	7624714509
07404	7404122010	43	2017	Parral	183123.5	2017	41637	7624714509
07404	7404122011	18	2017	Parral	183123.5	2017	41637	7624714509
07404	7404122016	1	2017	Parral	183123.5	2017	41637	7624714509
07404	7404122031	14	2017	Parral	183123.5	2017	41637	7624714509
07404	7404122037	17	2017	Parral	183123.5	2017	41637	7624714509
07404	7404122043	15	2017	Parral	183123.5	2017	41637	7624714509
07404	7404122056	5	2017	Parral	183123.5	2017	41637	7624714509
07404	7404122058	7	2017	Parral	183123.5	2017	41637	7624714509
07404	7404122065	3	2017	Parral	183123.5	2017	41637	7624714509
07404	7404122901	2	2017	Parral	183123.5	2017	41637	7624714509
07404	7404132039	1	2017	Parral	183123.5	2017	41637	7624714509
07404	7404132063	1	2017	Parral	183123.5	2017	41637	7624714509
07404	7404132076	1	2017	Parral	183123.5	2017	41637	7624714509
07404	7404132901	4	2017	Parral	183123.5	2017	41637	7624714509
07404	7404142073	11	2017	Parral	183123.5	2017	41637	7624714509
07405	7405012011	2	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405012012	2	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405012015	3	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405012018	3	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405012025	17	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405012036	6	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405012045	8	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405022005	6	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405022012	12	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405022013	1	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405022018	5	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405022019	2	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405022030	8	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405022035	5	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405022042	2	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405022046	2	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405032029	13	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405032040	5	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405032041	4	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405032047	5	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405032051	12	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405032901	1	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405042002	2	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405042014	3	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405042017	4	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405042021	2	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405042026	2	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405042041	3	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405042049	1	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405042050	8	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405052003	3	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405052006	2	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405052007	6	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405052009	7	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405052020	3	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405052023	1	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405052037	10	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405052048	1	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405052049	2	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405062001	59	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405062010	7	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405062022	41	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405062031	39	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405062033	11	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405062034	25	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405062039	6	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405062043	4	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405062044	9	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405072013	5	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405072016	4	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405072019	4	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405072024	42	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405072035	5	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405072044	5	2017	Retiro	146406.4	2017	19974	2924321333
07405	7405072045	2	2017	Retiro	146406.4	2017	19974	2924321333
07406	7406022004	3	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406022901	3	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406032020	1	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406042011	5	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406042046	54	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406042901	7	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406052008	9	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406052035	3	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406052037	5	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406052047	2	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406052049	15	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406052050	6	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406062006	7	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406062018	9	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406062034	10	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406062040	61	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406072004	21	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406072015	12	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406072034	6	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406072901	4	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406082001	13	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406082014	1	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406082016	4	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406082053	3	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406092001	34	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406092028	1	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406092030	3	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406092045	9	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406092048	21	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406092053	20	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406092054	1	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406092901	3	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406102009	9	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406102029	16	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406102031	50	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406112002	1	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406112007	14	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406112023	1	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406112039	2	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406112041	3	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406122019	6	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406122032	4	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406122036	2	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406122043	4	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406132012	1	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406132041	1	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406132042	2	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406132044	3	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406142032	1	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406142033	20	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406142051	3	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406142052	2	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406152017	3	2017	San Javier	170552.7	2017	45547	7768163327
07406	7406152027	1	2017	San Javier	170552.7	2017	45547	7768163327
07407	7407012001	1	2017	Villa Alegre	178486.5	2017	16221	2895229121
07407	7407012002	12	2017	Villa Alegre	178486.5	2017	16221	2895229121
07407	7407012003	2	2017	Villa Alegre	178486.5	2017	16221	2895229121
07407	7407012013	1	2017	Villa Alegre	178486.5	2017	16221	2895229121
07407	7407012015	3	2017	Villa Alegre	178486.5	2017	16221	2895229121
07407	7407012030	5	2017	Villa Alegre	178486.5	2017	16221	2895229121
07407	7407022008	2	2017	Villa Alegre	178486.5	2017	16221	2895229121
07407	7407022013	13	2017	Villa Alegre	178486.5	2017	16221	2895229121
07407	7407022014	29	2017	Villa Alegre	178486.5	2017	16221	2895229121
07407	7407022015	13	2017	Villa Alegre	178486.5	2017	16221	2895229121
07407	7407032004	26	2017	Villa Alegre	178486.5	2017	16221	2895229121
07407	7407032012	1	2017	Villa Alegre	178486.5	2017	16221	2895229121
07407	7407032020	20	2017	Villa Alegre	178486.5	2017	16221	2895229121
07407	7407032021	16	2017	Villa Alegre	178486.5	2017	16221	2895229121
07407	7407032023	10	2017	Villa Alegre	178486.5	2017	16221	2895229121
07407	7407032029	16	2017	Villa Alegre	178486.5	2017	16221	2895229121
07407	7407032901	6	2017	Villa Alegre	178486.5	2017	16221	2895229121
07407	7407042008	6	2017	Villa Alegre	178486.5	2017	16221	2895229121
07407	7407042010	25	2017	Villa Alegre	178486.5	2017	16221	2895229121
07407	7407042017	21	2017	Villa Alegre	178486.5	2017	16221	2895229121
07407	7407042022	14	2017	Villa Alegre	178486.5	2017	16221	2895229121
07407	7407042024	4	2017	Villa Alegre	178486.5	2017	16221	2895229121
07407	7407042025	5	2017	Villa Alegre	178486.5	2017	16221	2895229121
07407	7407042026	1	2017	Villa Alegre	178486.5	2017	16221	2895229121
07407	7407042027	1	2017	Villa Alegre	178486.5	2017	16221	2895229121
07407	7407042032	10	2017	Villa Alegre	178486.5	2017	16221	2895229121
07407	7407042901	16	2017	Villa Alegre	178486.5	2017	16221	2895229121
07407	7407052005	5	2017	Villa Alegre	178486.5	2017	16221	2895229121
07407	7407052010	6	2017	Villa Alegre	178486.5	2017	16221	2895229121
07407	7407052022	11	2017	Villa Alegre	178486.5	2017	16221	2895229121
07407	7407052033	4	2017	Villa Alegre	178486.5	2017	16221	2895229121
07407	7407062006	13	2017	Villa Alegre	178486.5	2017	16221	2895229121
07407	7407062016	18	2017	Villa Alegre	178486.5	2017	16221	2895229121
07407	7407062018	5	2017	Villa Alegre	178486.5	2017	16221	2895229121
07407	7407062019	6	2017	Villa Alegre	178486.5	2017	16221	2895229121
07407	7407062028	31	2017	Villa Alegre	178486.5	2017	16221	2895229121
07407	7407062036	2	2017	Villa Alegre	178486.5	2017	16221	2895229121
07407	7407062901	8	2017	Villa Alegre	178486.5	2017	16221	2895229121
07408	7408012008	53	2017	Yerbas Buenas	203001.0	2017	18081	3670461912
07408	7408012030	10	2017	Yerbas Buenas	203001.0	2017	18081	3670461912
07408	7408022006	5	2017	Yerbas Buenas	203001.0	2017	18081	3670461912
07408	7408022010	8	2017	Yerbas Buenas	203001.0	2017	18081	3670461912
07408	7408022013	3	2017	Yerbas Buenas	203001.0	2017	18081	3670461912
07408	7408022023	14	2017	Yerbas Buenas	203001.0	2017	18081	3670461912
07408	7408022029	4	2017	Yerbas Buenas	203001.0	2017	18081	3670461912
07408	7408032001	5	2017	Yerbas Buenas	203001.0	2017	18081	3670461912
07408	7408032011	1	2017	Yerbas Buenas	203001.0	2017	18081	3670461912
07408	7408032014	9	2017	Yerbas Buenas	203001.0	2017	18081	3670461912
07408	7408032018	4	2017	Yerbas Buenas	203001.0	2017	18081	3670461912
07408	7408032022	1	2017	Yerbas Buenas	203001.0	2017	18081	3670461912
07408	7408032025	11	2017	Yerbas Buenas	203001.0	2017	18081	3670461912
07408	7408042003	5	2017	Yerbas Buenas	203001.0	2017	18081	3670461912
07408	7408042005	6	2017	Yerbas Buenas	203001.0	2017	18081	3670461912
07408	7408042009	3	2017	Yerbas Buenas	203001.0	2017	18081	3670461912
07408	7408042016	4	2017	Yerbas Buenas	203001.0	2017	18081	3670461912
07408	7408042024	9	2017	Yerbas Buenas	203001.0	2017	18081	3670461912
07408	7408042027	10	2017	Yerbas Buenas	203001.0	2017	18081	3670461912
07408	7408052002	4	2017	Yerbas Buenas	203001.0	2017	18081	3670461912
07408	7408052003	7	2017	Yerbas Buenas	203001.0	2017	18081	3670461912
07408	7408052012	13	2017	Yerbas Buenas	203001.0	2017	18081	3670461912
07408	7408052015	1	2017	Yerbas Buenas	203001.0	2017	18081	3670461912
07408	7408052017	4	2017	Yerbas Buenas	203001.0	2017	18081	3670461912
07408	7408052019	2	2017	Yerbas Buenas	203001.0	2017	18081	3670461912
07408	7408052027	9	2017	Yerbas Buenas	203001.0	2017	18081	3670461912
07408	7408062019	24	2017	Yerbas Buenas	203001.0	2017	18081	3670461912
07408	7408062026	26	2017	Yerbas Buenas	203001.0	2017	18081	3670461912
07408	7408062028	16	2017	Yerbas Buenas	203001.0	2017	18081	3670461912
07408	7408072002	1	2017	Yerbas Buenas	203001.0	2017	18081	3670461912
07408	7408072020	69	2017	Yerbas Buenas	203001.0	2017	18081	3670461912
07408	7408072021	10	2017	Yerbas Buenas	203001.0	2017	18081	3670461912

4 Proporción poblacional zonal respecto a la comunal

Del censo obtenemos la cantidad de población a nivel de zona y estimamos su proporción a nivel comunal. Ya hemos calculado ésta proporción aquí.

prop_pob <- readRDS("../tabla_de_prop_pob.rds")
names(prop_pob)[1] <- "zona"
names(prop_pob)[3] <- "p_poblacional" 

Veamos los 100 primeros registros:

r3_100 <- prop_pob[c(1:100),]
kbl(r3_100) %>%
  kable_styling(bootstrap_options = c("striped", "hover")) %>%
  kable_paper() %>%
  scroll_box(width = "100%", height = "300px")

zona	Freq	p_poblacional	código
1101011001	2491	0.0130100	01101
1101011002	1475	0.0077036	01101
1101021001	1003	0.0052385	01101
1101021002	54	0.0002820	01101
1101021003	2895	0.0151200	01101
1101021004	2398	0.0125243	01101
1101021005	4525	0.0236332	01101
1101031001	2725	0.0142321	01101
1101031002	3554	0.0185618	01101
1101031003	5246	0.0273988	01101
1101031004	3389	0.0177001	01101
1101041001	1800	0.0094010	01101
1101041002	2538	0.0132555	01101
1101041003	3855	0.0201339	01101
1101041004	5663	0.0295767	01101
1101041005	4162	0.0217373	01101
1101041006	2689	0.0140441	01101
1101051001	3296	0.0172144	01101
1101051002	4465	0.0233198	01101
1101051003	4656	0.0243174	01101
1101051004	2097	0.0109522	01101
1101051005	3569	0.0186402	01101
1101051006	2741	0.0143157	01101
1101061001	1625	0.0084871	01101
1101061002	4767	0.0248971	01101
1101061003	4826	0.0252053	01101
1101061004	4077	0.0212934	01101
1101061005	2166	0.0113126	01101
1101071001	2324	0.0121378	01101
1101071002	2801	0.0146291	01101
1101071003	3829	0.0199981	01101
1101071004	1987	0.0103777	01101
1101081001	5133	0.0268087	01101
1101081002	3233	0.0168853	01101
1101081003	2122	0.0110828	01101
1101081004	2392	0.0124929	01101
1101092001	57	0.0002977	01101
1101092004	247	0.0012900	01101
1101092005	76	0.0003969	01101
1101092006	603	0.0031494	01101
1101092007	84	0.0004387	01101
1101092010	398	0.0020787	01101
1101092012	58	0.0003029	01101
1101092014	23	0.0001201	01101
1101092016	20	0.0001045	01101
1101092017	8	0.0000418	01101
1101092018	74	0.0003865	01101
1101092019	25	0.0001306	01101
1101092021	177	0.0009244	01101
1101092022	23	0.0001201	01101
1101092023	288	0.0015042	01101
1101092024	14	0.0000731	01101
1101092901	30	0.0001567	01101
1101101001	2672	0.0139553	01101
1101101002	4398	0.0229699	01101
1101101003	4524	0.0236280	01101
1101101004	3544	0.0185096	01101
1101101005	4911	0.0256492	01101
1101101006	3688	0.0192617	01101
1101111001	3886	0.0202958	01101
1101111002	2312	0.0120751	01101
1101111003	4874	0.0254560	01101
1101111004	4543	0.0237272	01101
1101111005	4331	0.0226200	01101
1101111006	3253	0.0169898	01101
1101111007	4639	0.0242286	01101
1101111008	4881	0.0254925	01101
1101111009	5006	0.0261454	01101
1101111010	366	0.0019115	01101
1101111011	4351	0.0227244	01101
1101111012	2926	0.0152819	01101
1101111013	3390	0.0177053	01101
1101111014	2940	0.0153550	01101
1101112003	33	0.0001724	01101
1101112013	104	0.0005432	01101
1101112019	34	0.0001776	01101
1101112025	21	0.0001097	01101
1101112901	6	0.0000313	01101
1101991999	1062	0.0055466	01101
1107011001	4104	0.0378685	01107
1107011002	4360	0.0402307	01107
1107011003	8549	0.0788835	01107
1107012003	3	0.0000277	01107
1107012901	17	0.0001569	01107
1107021001	6701	0.0618316	01107
1107021002	3971	0.0366413	01107
1107021003	6349	0.0585836	01107
1107021004	5125	0.0472895	01107
1107021005	4451	0.0410704	01107
1107021006	3864	0.0356540	01107
1107021007	5235	0.0483045	01107
1107021008	4566	0.0421315	01107
1107031001	4195	0.0387082	01107
1107031002	7099	0.0655040	01107
1107031003	4720	0.0435525	01107
1107032005	38	0.0003506	01107
1107032006	2399	0.0221361	01107
1107032008	4	0.0000369	01107
1107041001	3630	0.0334948	01107
1107041002	5358	0.0494394	01107

5 Ingreso medio

Deseamos el valor del ingreso promedio a nivel comunal, pero expandido a nivel zonal. Ésta información está contenida en el campo promedio_i de la tabla obtenida en el punto 3.

r3_100 <- comunas_con_ing_exp[c(1:100),]
kbl(r3_100) %>%
  kable_styling(bootstrap_options = c("striped", "hover")) %>%
  kable_paper() %>%
  scroll_box(width = "100%", height = "300px")

código	zona	Freq	anio	comuna.x	promedio_i	año	personas	Ingresos_expandidos
07101	7101092003	42	2017	Talca	244658.0	2017	220357	53912095394
07101	7101092024	6	2017	Talca	244658.0	2017	220357	53912095394
07101	7101092901	3	2017	Talca	244658.0	2017	220357	53912095394
07101	7101102004	7	2017	Talca	244658.0	2017	220357	53912095394
07101	7101102005	35	2017	Talca	244658.0	2017	220357	53912095394
07101	7101102013	1	2017	Talca	244658.0	2017	220357	53912095394
07101	7101102017	94	2017	Talca	244658.0	2017	220357	53912095394
07101	7101102018	10	2017	Talca	244658.0	2017	220357	53912095394
07101	7101112010	19	2017	Talca	244658.0	2017	220357	53912095394
07101	7101112015	51	2017	Talca	244658.0	2017	220357	53912095394
07101	7101112020	61	2017	Talca	244658.0	2017	220357	53912095394
07101	7101112022	95	2017	Talca	244658.0	2017	220357	53912095394
07101	7101122001	189	2017	Talca	244658.0	2017	220357	53912095394
07101	7101122010	60	2017	Talca	244658.0	2017	220357	53912095394
07101	7101122012	5	2017	Talca	244658.0	2017	220357	53912095394
07101	7101122014	5	2017	Talca	244658.0	2017	220357	53912095394
07101	7101122021	9	2017	Talca	244658.0	2017	220357	53912095394
07101	7101122022	125	2017	Talca	244658.0	2017	220357	53912095394
07101	7101122901	4	2017	Talca	244658.0	2017	220357	53912095394
07101	7101152008	51	2017	Talca	244658.0	2017	220357	53912095394
07101	7101152010	18	2017	Talca	244658.0	2017	220357	53912095394
07101	7101152016	19	2017	Talca	244658.0	2017	220357	53912095394
07101	7101152023	16	2017	Talca	244658.0	2017	220357	53912095394
07101	7101162002	15	2017	Talca	244658.0	2017	220357	53912095394
07101	7101162007	16	2017	Talca	244658.0	2017	220357	53912095394
07101	7101162010	67	2017	Talca	244658.0	2017	220357	53912095394
07101	7101162019	86	2017	Talca	244658.0	2017	220357	53912095394
07102	7102022033	6	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102022038	3	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102022046	2	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102022060	1	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102032025	10	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102032030	1	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102032038	2	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102032043	5	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102032045	19	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102032056	23	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102032060	5	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102042007	7	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102042011	1	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102042016	25	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102042024	15	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102042036	13	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102042047	36	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102042901	67	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102052009	1	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102052012	1	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102052050	1	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102062007	1	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102062010	1	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102062018	1	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102062028	3	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102062053	7	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102062059	6	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102062901	6	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102072006	1	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102072027	12	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102072031	2	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102072048	8	2017	Constitución	198314.7	2017	46068	9135962663
07102	7102072055	2	2017	Constitución	198314.7	2017	46068	9135962663
07103	7103012027	5	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103012038	12	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103012042	6	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103012054	5	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103022003	7	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103022020	7	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103022025	11	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103022049	1	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103022052	6	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103032007	15	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103032012	6	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103032053	2	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103042010	3	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103042027	2	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103042031	7	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103042037	4	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103042043	1	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103042044	1	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103042047	2	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103042901	1	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103052051	1	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103052058	1	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103062022	24	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103062901	1	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103072024	3	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103072062	2	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103072901	3	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103082011	6	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103082041	2	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103082048	2	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103082059	2	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103092021	1	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103092061	6	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103102026	44	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103102039	8	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103102063	3	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103102901	1	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103112013	1	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103112016	1	2017	Curepto	191743.1	2017	9448	1811588746
07103	7103112018	4	2017	Curepto	191743.1	2017	9448	1811588746

6 Ingreso promedio expandido por zona (multi_pob)

En éste momento vamos a construir nuestra variable dependiente de regresión aplicando la siguiente fórmula:

\[ multi\_pob = promedio\_i \cdot personas \cdot p\_poblacional \]

Para ello integramos a la tabla de ingresos expandidos a nivel zonal (punto 3) la tabla de proporciones poblacionales zonales respecto al total comunal (punto 4) :

h_y_m_comuna_corr_01 = merge( x = comunas_con_ing_exp, y = prop_pob, by = "zona", all.x = TRUE)
tablamadre <- head(h_y_m_comuna_corr_01,100)
kbl(tablamadre) %>%
  kable_styling(bootstrap_options = c("striped", "hover")) %>%
  kable_paper() %>%
  scroll_box(width = "100%", height = "300px")

zona	código.x	Freq.x	anio	comuna.x	promedio_i	año	personas	Ingresos_expandidos	Freq.y	p_poblacional	código.y
7101092003	07101	42	2017	Talca	244658.0	2017	220357	53912095394	191	0.0008668	07101
7101092024	07101	6	2017	Talca	244658.0	2017	220357	53912095394	50	0.0002269	07101
7101092901	07101	3	2017	Talca	244658.0	2017	220357	53912095394	38	0.0001724	07101
7101102004	07101	7	2017	Talca	244658.0	2017	220357	53912095394	66	0.0002995	07101
7101102005	07101	35	2017	Talca	244658.0	2017	220357	53912095394	260	0.0011799	07101
7101102013	07101	1	2017	Talca	244658.0	2017	220357	53912095394	8	0.0000363	07101
7101102017	07101	94	2017	Talca	244658.0	2017	220357	53912095394	991	0.0044972	07101
7101102018	07101	10	2017	Talca	244658.0	2017	220357	53912095394	123	0.0005582	07101
7101112010	07101	19	2017	Talca	244658.0	2017	220357	53912095394	74	0.0003358	07101
7101112015	07101	51	2017	Talca	244658.0	2017	220357	53912095394	349	0.0015838	07101
7101112020	07101	61	2017	Talca	244658.0	2017	220357	53912095394	668	0.0030314	07101
7101112022	07101	95	2017	Talca	244658.0	2017	220357	53912095394	287	0.0013024	07101
7101122001	07101	189	2017	Talca	244658.0	2017	220357	53912095394	795	0.0036078	07101
7101122010	07101	60	2017	Talca	244658.0	2017	220357	53912095394	223	0.0010120	07101
7101122012	07101	5	2017	Talca	244658.0	2017	220357	53912095394	27	0.0001225	07101
7101122014	07101	5	2017	Talca	244658.0	2017	220357	53912095394	59	0.0002677	07101
7101122021	07101	9	2017	Talca	244658.0	2017	220357	53912095394	41	0.0001861	07101
7101122022	07101	125	2017	Talca	244658.0	2017	220357	53912095394	435	0.0019741	07101
7101122901	07101	4	2017	Talca	244658.0	2017	220357	53912095394	31	0.0001407	07101
7101152008	07101	51	2017	Talca	244658.0	2017	220357	53912095394	1194	0.0054185	07101
7101152010	07101	18	2017	Talca	244658.0	2017	220357	53912095394	300	0.0013614	07101
7101152016	07101	19	2017	Talca	244658.0	2017	220357	53912095394	308	0.0013977	07101
7101152023	07101	16	2017	Talca	244658.0	2017	220357	53912095394	287	0.0013024	07101
7101162002	07101	15	2017	Talca	244658.0	2017	220357	53912095394	465	0.0021102	07101
7101162007	07101	16	2017	Talca	244658.0	2017	220357	53912095394	601	0.0027274	07101
7101162010	07101	67	2017	Talca	244658.0	2017	220357	53912095394	212	0.0009621	07101
7101162019	07101	86	2017	Talca	244658.0	2017	220357	53912095394	1358	0.0061627	07101
7102022033	07102	6	2017	Constitución	198314.7	2017	46068	9135962663	22	0.0004776	07102
7102022038	07102	3	2017	Constitución	198314.7	2017	46068	9135962663	180	0.0039073	07102
7102022046	07102	2	2017	Constitución	198314.7	2017	46068	9135962663	22	0.0004776	07102
7102022060	07102	1	2017	Constitución	198314.7	2017	46068	9135962663	154	0.0033429	07102
7102032025	07102	10	2017	Constitución	198314.7	2017	46068	9135962663	43	0.0009334	07102
7102032030	07102	1	2017	Constitución	198314.7	2017	46068	9135962663	59	0.0012807	07102
7102032038	07102	2	2017	Constitución	198314.7	2017	46068	9135962663	262	0.0056872	07102
7102032043	07102	5	2017	Constitución	198314.7	2017	46068	9135962663	18	0.0003907	07102
7102032045	07102	19	2017	Constitución	198314.7	2017	46068	9135962663	776	0.0168447	07102
7102032056	07102	23	2017	Constitución	198314.7	2017	46068	9135962663	1833	0.0397890	07102
7102032060	07102	5	2017	Constitución	198314.7	2017	46068	9135962663	148	0.0032126	07102
7102042007	07102	7	2017	Constitución	198314.7	2017	46068	9135962663	353	0.0076626	07102
7102042011	07102	1	2017	Constitución	198314.7	2017	46068	9135962663	62	0.0013458	07102
7102042016	07102	25	2017	Constitución	198314.7	2017	46068	9135962663	178	0.0038639	07102
7102042024	07102	15	2017	Constitución	198314.7	2017	46068	9135962663	382	0.0082921	07102
7102042036	07102	13	2017	Constitución	198314.7	2017	46068	9135962663	181	0.0039290	07102
7102042047	07102	36	2017	Constitución	198314.7	2017	46068	9135962663	328	0.0071199	07102
7102042901	07102	67	2017	Constitución	198314.7	2017	46068	9135962663	350	0.0075975	07102
7102052009	07102	1	2017	Constitución	198314.7	2017	46068	9135962663	106	0.0023009	07102
7102052012	07102	1	2017	Constitución	198314.7	2017	46068	9135962663	128	0.0027785	07102
7102052050	07102	1	2017	Constitución	198314.7	2017	46068	9135962663	45	0.0009768	07102
7102062007	07102	1	2017	Constitución	198314.7	2017	46068	9135962663	29	0.0006295	07102
7102062010	07102	1	2017	Constitución	198314.7	2017	46068	9135962663	37	0.0008032	07102
7102062018	07102	1	2017	Constitución	198314.7	2017	46068	9135962663	77	0.0016714	07102
7102062028	07102	3	2017	Constitución	198314.7	2017	46068	9135962663	269	0.0058392	07102
7102062053	07102	7	2017	Constitución	198314.7	2017	46068	9135962663	378	0.0082053	07102
7102062059	07102	6	2017	Constitución	198314.7	2017	46068	9135962663	903	0.0196015	07102
7102062901	07102	6	2017	Constitución	198314.7	2017	46068	9135962663	78	0.0016931	07102
7102072006	07102	1	2017	Constitución	198314.7	2017	46068	9135962663	15	0.0003256	07102
7102072027	07102	12	2017	Constitución	198314.7	2017	46068	9135962663	462	0.0100287	07102
7102072031	07102	2	2017	Constitución	198314.7	2017	46068	9135962663	62	0.0013458	07102
7102072048	07102	8	2017	Constitución	198314.7	2017	46068	9135962663	124	0.0026917	07102
7102072055	07102	2	2017	Constitución	198314.7	2017	46068	9135962663	98	0.0021273	07102
7103012027	07103	5	2017	Curepto	191743.1	2017	9448	1811588746	158	0.0167231	07103
7103012038	07103	12	2017	Curepto	191743.1	2017	9448	1811588746	143	0.0151355	07103
7103012042	07103	6	2017	Curepto	191743.1	2017	9448	1811588746	147	0.0155588	07103
7103012054	07103	5	2017	Curepto	191743.1	2017	9448	1811588746	61	0.0064564	07103
7103022003	07103	7	2017	Curepto	191743.1	2017	9448	1811588746	328	0.0347163	07103
7103022020	07103	7	2017	Curepto	191743.1	2017	9448	1811588746	167	0.0176757	07103
7103022025	07103	11	2017	Curepto	191743.1	2017	9448	1811588746	252	0.0266723	07103
7103022049	07103	1	2017	Curepto	191743.1	2017	9448	1811588746	43	0.0045512	07103
7103022052	07103	6	2017	Curepto	191743.1	2017	9448	1811588746	181	0.0191575	07103
7103032007	07103	15	2017	Curepto	191743.1	2017	9448	1811588746	242	0.0256139	07103
7103032012	07103	6	2017	Curepto	191743.1	2017	9448	1811588746	202	0.0213802	07103
7103032053	07103	2	2017	Curepto	191743.1	2017	9448	1811588746	40	0.0042337	07103
7103042010	07103	3	2017	Curepto	191743.1	2017	9448	1811588746	32	0.0033870	07103
7103042027	07103	2	2017	Curepto	191743.1	2017	9448	1811588746	110	0.0116427	07103
7103042031	07103	7	2017	Curepto	191743.1	2017	9448	1811588746	184	0.0194750	07103
7103042037	07103	4	2017	Curepto	191743.1	2017	9448	1811588746	27	0.0028577	07103
7103042043	07103	1	2017	Curepto	191743.1	2017	9448	1811588746	17	0.0017993	07103
7103042044	07103	1	2017	Curepto	191743.1	2017	9448	1811588746	13	0.0013760	07103
7103042047	07103	2	2017	Curepto	191743.1	2017	9448	1811588746	36	0.0038103	07103
7103042901	07103	1	2017	Curepto	191743.1	2017	9448	1811588746	19	0.0020110	07103
7103052051	07103	1	2017	Curepto	191743.1	2017	9448	1811588746	20	0.0021169	07103
7103052058	07103	1	2017	Curepto	191743.1	2017	9448	1811588746	40	0.0042337	07103
7103062022	07103	24	2017	Curepto	191743.1	2017	9448	1811588746	448	0.0474174	07103
7103062901	07103	1	2017	Curepto	191743.1	2017	9448	1811588746	11	0.0011643	07103
7103072024	07103	3	2017	Curepto	191743.1	2017	9448	1811588746	35	0.0037045	07103
7103072062	07103	2	2017	Curepto	191743.1	2017	9448	1811588746	69	0.0073031	07103
7103072901	07103	3	2017	Curepto	191743.1	2017	9448	1811588746	108	0.0114310	07103
7103082011	07103	6	2017	Curepto	191743.1	2017	9448	1811588746	125	0.0132303	07103
7103082041	07103	2	2017	Curepto	191743.1	2017	9448	1811588746	119	0.0125953	07103
7103082048	07103	2	2017	Curepto	191743.1	2017	9448	1811588746	33	0.0034928	07103
7103082059	07103	2	2017	Curepto	191743.1	2017	9448	1811588746	43	0.0045512	07103
7103092021	07103	1	2017	Curepto	191743.1	2017	9448	1811588746	95	0.0100550	07103
7103092061	07103	6	2017	Curepto	191743.1	2017	9448	1811588746	237	0.0250847	07103
7103102026	07103	44	2017	Curepto	191743.1	2017	9448	1811588746	967	0.1023497	07103
7103102039	07103	8	2017	Curepto	191743.1	2017	9448	1811588746	330	0.0349280	07103
7103102063	07103	3	2017	Curepto	191743.1	2017	9448	1811588746	31	0.0032811	07103
7103102901	07103	1	2017	Curepto	191743.1	2017	9448	1811588746	28	0.0029636	07103
7103112013	07103	1	2017	Curepto	191743.1	2017	9448	1811588746	76	0.0080440	07103
7103112016	07103	1	2017	Curepto	191743.1	2017	9448	1811588746	49	0.0051863	07103
7103112018	07103	4	2017	Curepto	191743.1	2017	9448	1811588746	80	0.0084674	07103

Hacemos la multiplicación que queda almacenada en la variable multi_pob:

h_y_m_comuna_corr_01$multi_pob <- h_y_m_comuna_corr_01$promedio_i * h_y_m_comuna_corr_01$personas * h_y_m_comuna_corr_01$p_poblacional
tablamadre <- head(h_y_m_comuna_corr_01,100)
kbl(tablamadre) %>%
  kable_styling(bootstrap_options = c("striped", "hover")) %>%
  kable_paper() %>%
  scroll_box(width = "100%", height = "300px")

zona	código.x	Freq.x	anio	comuna.x	promedio_i	año	personas	Ingresos_expandidos	Freq.y	p_poblacional	código.y	multi_pob
7101092003	07101	42	2017	Talca	244658.0	2017	220357	53912095394	191	0.0008668	07101	46729671
7101092024	07101	6	2017	Talca	244658.0	2017	220357	53912095394	50	0.0002269	07101	12232898
7101092901	07101	3	2017	Talca	244658.0	2017	220357	53912095394	38	0.0001724	07101	9297003
7101102004	07101	7	2017	Talca	244658.0	2017	220357	53912095394	66	0.0002995	07101	16147426
7101102005	07101	35	2017	Talca	244658.0	2017	220357	53912095394	260	0.0011799	07101	63611071
7101102013	07101	1	2017	Talca	244658.0	2017	220357	53912095394	8	0.0000363	07101	1957264
7101102017	07101	94	2017	Talca	244658.0	2017	220357	53912095394	991	0.0044972	07101	242456044
7101102018	07101	10	2017	Talca	244658.0	2017	220357	53912095394	123	0.0005582	07101	30092930
7101112010	07101	19	2017	Talca	244658.0	2017	220357	53912095394	74	0.0003358	07101	18104689
7101112015	07101	51	2017	Talca	244658.0	2017	220357	53912095394	349	0.0015838	07101	85385630
7101112020	07101	61	2017	Talca	244658.0	2017	220357	53912095394	668	0.0030314	07101	163431521
7101112022	07101	95	2017	Talca	244658.0	2017	220357	53912095394	287	0.0013024	07101	70216836
7101122001	07101	189	2017	Talca	244658.0	2017	220357	53912095394	795	0.0036078	07101	194503083
7101122010	07101	60	2017	Talca	244658.0	2017	220357	53912095394	223	0.0010120	07101	54558726
7101122012	07101	5	2017	Talca	244658.0	2017	220357	53912095394	27	0.0001225	07101	6605765
7101122014	07101	5	2017	Talca	244658.0	2017	220357	53912095394	59	0.0002677	07101	14434820
7101122021	07101	9	2017	Talca	244658.0	2017	220357	53912095394	41	0.0001861	07101	10030977
7101122022	07101	125	2017	Talca	244658.0	2017	220357	53912095394	435	0.0019741	07101	106426215
7101122901	07101	4	2017	Talca	244658.0	2017	220357	53912095394	31	0.0001407	07101	7584397
7101152008	07101	51	2017	Talca	244658.0	2017	220357	53912095394	1194	0.0054185	07101	292121611
7101152010	07101	18	2017	Talca	244658.0	2017	220357	53912095394	300	0.0013614	07101	73397390
7101152016	07101	19	2017	Talca	244658.0	2017	220357	53912095394	308	0.0013977	07101	75354654
7101152023	07101	16	2017	Talca	244658.0	2017	220357	53912095394	287	0.0013024	07101	70216836
7101162002	07101	15	2017	Talca	244658.0	2017	220357	53912095394	465	0.0021102	07101	113765954
7101162007	07101	16	2017	Talca	244658.0	2017	220357	53912095394	601	0.0027274	07101	147039438
7101162010	07101	67	2017	Talca	244658.0	2017	220357	53912095394	212	0.0009621	07101	51867489
7101162019	07101	86	2017	Talca	244658.0	2017	220357	53912095394	1358	0.0061627	07101	332245518
7102022033	07102	6	2017	Constitución	198314.7	2017	46068	9135962663	22	0.0004776	07102	4362924
7102022038	07102	3	2017	Constitución	198314.7	2017	46068	9135962663	180	0.0039073	07102	35696650
7102022046	07102	2	2017	Constitución	198314.7	2017	46068	9135962663	22	0.0004776	07102	4362924
7102022060	07102	1	2017	Constitución	198314.7	2017	46068	9135962663	154	0.0033429	07102	30540467
7102032025	07102	10	2017	Constitución	198314.7	2017	46068	9135962663	43	0.0009334	07102	8527533
7102032030	07102	1	2017	Constitución	198314.7	2017	46068	9135962663	59	0.0012807	07102	11700569
7102032038	07102	2	2017	Constitución	198314.7	2017	46068	9135962663	262	0.0056872	07102	51958457
7102032043	07102	5	2017	Constitución	198314.7	2017	46068	9135962663	18	0.0003907	07102	3569665
7102032045	07102	19	2017	Constitución	198314.7	2017	46068	9135962663	776	0.0168447	07102	153892225
7102032056	07102	23	2017	Constitución	198314.7	2017	46068	9135962663	1833	0.0397890	07102	363510887
7102032060	07102	5	2017	Constitución	198314.7	2017	46068	9135962663	148	0.0032126	07102	29350579
7102042007	07102	7	2017	Constitución	198314.7	2017	46068	9135962663	353	0.0076626	07102	70005097
7102042011	07102	1	2017	Constitución	198314.7	2017	46068	9135962663	62	0.0013458	07102	12295513
7102042016	07102	25	2017	Constitución	198314.7	2017	46068	9135962663	178	0.0038639	07102	35300021
7102042024	07102	15	2017	Constitución	198314.7	2017	46068	9135962663	382	0.0082921	07102	75756224
7102042036	07102	13	2017	Constitución	198314.7	2017	46068	9135962663	181	0.0039290	07102	35894965
7102042047	07102	36	2017	Constitución	198314.7	2017	46068	9135962663	328	0.0071199	07102	65047229
7102042901	07102	67	2017	Constitución	198314.7	2017	46068	9135962663	350	0.0075975	07102	69410153
7102052009	07102	1	2017	Constitución	198314.7	2017	46068	9135962663	106	0.0023009	07102	21021361
7102052012	07102	1	2017	Constitución	198314.7	2017	46068	9135962663	128	0.0027785	07102	25384285
7102052050	07102	1	2017	Constitución	198314.7	2017	46068	9135962663	45	0.0009768	07102	8924163
7102062007	07102	1	2017	Constitución	198314.7	2017	46068	9135962663	29	0.0006295	07102	5751127
7102062010	07102	1	2017	Constitución	198314.7	2017	46068	9135962663	37	0.0008032	07102	7337645
7102062018	07102	1	2017	Constitución	198314.7	2017	46068	9135962663	77	0.0016714	07102	15270234
7102062028	07102	3	2017	Constitución	198314.7	2017	46068	9135962663	269	0.0058392	07102	53346661
7102062053	07102	7	2017	Constitución	198314.7	2017	46068	9135962663	378	0.0082053	07102	74962965
7102062059	07102	6	2017	Constitución	198314.7	2017	46068	9135962663	903	0.0196015	07102	179078195
7102062901	07102	6	2017	Constitución	198314.7	2017	46068	9135962663	78	0.0016931	07102	15468548
7102072006	07102	1	2017	Constitución	198314.7	2017	46068	9135962663	15	0.0003256	07102	2974721
7102072027	07102	12	2017	Constitución	198314.7	2017	46068	9135962663	462	0.0100287	07102	91621402
7102072031	07102	2	2017	Constitución	198314.7	2017	46068	9135962663	62	0.0013458	07102	12295513
7102072048	07102	8	2017	Constitución	198314.7	2017	46068	9135962663	124	0.0026917	07102	24591026
7102072055	07102	2	2017	Constitución	198314.7	2017	46068	9135962663	98	0.0021273	07102	19434843
7103012027	07103	5	2017	Curepto	191743.1	2017	9448	1811588746	158	0.0167231	07103	30295409
7103012038	07103	12	2017	Curepto	191743.1	2017	9448	1811588746	143	0.0151355	07103	27419262
7103012042	07103	6	2017	Curepto	191743.1	2017	9448	1811588746	147	0.0155588	07103	28186235
7103012054	07103	5	2017	Curepto	191743.1	2017	9448	1811588746	61	0.0064564	07103	11696329
7103022003	07103	7	2017	Curepto	191743.1	2017	9448	1811588746	328	0.0347163	07103	62891735
7103022020	07103	7	2017	Curepto	191743.1	2017	9448	1811588746	167	0.0176757	07103	32021097
7103022025	07103	11	2017	Curepto	191743.1	2017	9448	1811588746	252	0.0266723	07103	48319260
7103022049	07103	1	2017	Curepto	191743.1	2017	9448	1811588746	43	0.0045512	07103	8244953
7103022052	07103	6	2017	Curepto	191743.1	2017	9448	1811588746	181	0.0191575	07103	34705500
7103032007	07103	15	2017	Curepto	191743.1	2017	9448	1811588746	242	0.0256139	07103	46401829
7103032012	07103	6	2017	Curepto	191743.1	2017	9448	1811588746	202	0.0213802	07103	38732105
7103032053	07103	2	2017	Curepto	191743.1	2017	9448	1811588746	40	0.0042337	07103	7669724
7103042010	07103	3	2017	Curepto	191743.1	2017	9448	1811588746	32	0.0033870	07103	6135779
7103042027	07103	2	2017	Curepto	191743.1	2017	9448	1811588746	110	0.0116427	07103	21091740
7103042031	07103	7	2017	Curepto	191743.1	2017	9448	1811588746	184	0.0194750	07103	35280729
7103042037	07103	4	2017	Curepto	191743.1	2017	9448	1811588746	27	0.0028577	07103	5177064
7103042043	07103	1	2017	Curepto	191743.1	2017	9448	1811588746	17	0.0017993	07103	3259633
7103042044	07103	1	2017	Curepto	191743.1	2017	9448	1811588746	13	0.0013760	07103	2492660
7103042047	07103	2	2017	Curepto	191743.1	2017	9448	1811588746	36	0.0038103	07103	6902751
7103042901	07103	1	2017	Curepto	191743.1	2017	9448	1811588746	19	0.0020110	07103	3643119
7103052051	07103	1	2017	Curepto	191743.1	2017	9448	1811588746	20	0.0021169	07103	3834862
7103052058	07103	1	2017	Curepto	191743.1	2017	9448	1811588746	40	0.0042337	07103	7669724
7103062022	07103	24	2017	Curepto	191743.1	2017	9448	1811588746	448	0.0474174	07103	85900906
7103062901	07103	1	2017	Curepto	191743.1	2017	9448	1811588746	11	0.0011643	07103	2109174
7103072024	07103	3	2017	Curepto	191743.1	2017	9448	1811588746	35	0.0037045	07103	6711008
7103072062	07103	2	2017	Curepto	191743.1	2017	9448	1811588746	69	0.0073031	07103	13230273
7103072901	07103	3	2017	Curepto	191743.1	2017	9448	1811588746	108	0.0114310	07103	20708254
7103082011	07103	6	2017	Curepto	191743.1	2017	9448	1811588746	125	0.0132303	07103	23967887
7103082041	07103	2	2017	Curepto	191743.1	2017	9448	1811588746	119	0.0125953	07103	22817428
7103082048	07103	2	2017	Curepto	191743.1	2017	9448	1811588746	33	0.0034928	07103	6327522
7103082059	07103	2	2017	Curepto	191743.1	2017	9448	1811588746	43	0.0045512	07103	8244953
7103092021	07103	1	2017	Curepto	191743.1	2017	9448	1811588746	95	0.0100550	07103	18215594
7103092061	07103	6	2017	Curepto	191743.1	2017	9448	1811588746	237	0.0250847	07103	45443113
7103102026	07103	44	2017	Curepto	191743.1	2017	9448	1811588746	967	0.1023497	07103	185415571
7103102039	07103	8	2017	Curepto	191743.1	2017	9448	1811588746	330	0.0349280	07103	63275221
7103102063	07103	3	2017	Curepto	191743.1	2017	9448	1811588746	31	0.0032811	07103	5944036
7103102901	07103	1	2017	Curepto	191743.1	2017	9448	1811588746	28	0.0029636	07103	5368807
7103112013	07103	1	2017	Curepto	191743.1	2017	9448	1811588746	76	0.0080440	07103	14572475
7103112016	07103	1	2017	Curepto	191743.1	2017	9448	1811588746	49	0.0051863	07103	9395412
7103112018	07103	4	2017	Curepto	191743.1	2017	9448	1811588746	80	0.0084674	07103	15339447

7 Análisis de regresión

Aplicaremos un análisis de regresión donde:

\[ Y(dependiente) = ingreso \ expandido \ por \ zona \ (multi\_pob)\]

\[ X(independiente) = frecuencia \ de \ población \ que \ posee \ la \ variable \ Censal \ respecto \ a \ la \ zona \ (Freq.x) \]

7.1 Diagrama de dispersión loess

scatter.smooth(x=h_y_m_comuna_corr_01$Freq.x, y=h_y_m_comuna_corr_01$multi_pob, main="multi_pob ~ Freq.x",
     xlab = "Freq.x",
     ylab = "multi_pob",
           col = 2) 

7.2 Outliers

Hemos demostrado en el punto 5.7.2 de aquí que la exclusión de ouliers no genera ninguna mejora en el modelo de regresión.

7.3 Modelo lineal

Aplicaremos un análisis de regresión lineal del ingreso expandido por zona sobre las frecuencias de respuestas zonales.

linearMod <- lm( multi_pob~(Freq.x) , data=h_y_m_comuna_corr_01)
summary(linearMod) 

## 
## Call:
## lm(formula = multi_pob ~ (Freq.x), data = h_y_m_comuna_corr_01)
## 
## Residuals:
##        Min         1Q     Median         3Q        Max 
## -324568648  -21938754  -11302715   10717853  294049283 
## 
## Coefficients:
##             Estimate Std. Error t value Pr(>|t|)    
## (Intercept) 23799019    1682997   14.14   <2e-16 ***
## Freq.x       1985330      66300   29.95   <2e-16 ***
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 46460000 on 1051 degrees of freedom
## Multiple R-squared:  0.4604, Adjusted R-squared:  0.4599 
## F-statistic: 896.7 on 1 and 1051 DF,  p-value: < 2.2e-16

7.4 Gráfica de la recta de regresión lineal

ggplot(h_y_m_comuna_corr_01, aes(x = Freq.x , y = multi_pob)) + 
  geom_point() +
  stat_smooth(method = "lm", col = "red")

Si bien obtenemos nuestro modelo lineal da cuenta del 0.8214 de la variabilidad de los datos de respuesta en torno a su media, modelos alternativos pueden ofrecernos una explicación de la variable dependiente aún mayor.

8 Modelos alternativos

8.1 Modelo cuadrático

\[ \hat Y = \beta_0 + \beta_1 X^2 \]

linearMod <- lm( multi_pob~(Freq.x^2) , data=h_y_m_comuna_corr_01)
summary(linearMod) 

## 
## Call:
## lm(formula = multi_pob ~ (Freq.x^2), data = h_y_m_comuna_corr_01)
## 
## Residuals:
##        Min         1Q     Median         3Q        Max 
## -324568648  -21938754  -11302715   10717853  294049283 
## 
## Coefficients:
##             Estimate Std. Error t value Pr(>|t|)    
## (Intercept) 23799019    1682997   14.14   <2e-16 ***
## Freq.x       1985330      66300   29.95   <2e-16 ***
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 46460000 on 1051 degrees of freedom
## Multiple R-squared:  0.4604, Adjusted R-squared:  0.4599 
## F-statistic: 896.7 on 1 and 1051 DF,  p-value: < 2.2e-16

8.2 Modelo cúbico

\[ \hat Y = \beta_0 + \beta_1 X^3 \]

linearMod <- lm( multi_pob~(Freq.x^3) , data=h_y_m_comuna_corr_01)
summary(linearMod) 

## 
## Call:
## lm(formula = multi_pob ~ (Freq.x^3), data = h_y_m_comuna_corr_01)
## 
## Residuals:
##        Min         1Q     Median         3Q        Max 
## -324568648  -21938754  -11302715   10717853  294049283 
## 
## Coefficients:
##             Estimate Std. Error t value Pr(>|t|)    
## (Intercept) 23799019    1682997   14.14   <2e-16 ***
## Freq.x       1985330      66300   29.95   <2e-16 ***
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 46460000 on 1051 degrees of freedom
## Multiple R-squared:  0.4604, Adjusted R-squared:  0.4599 
## F-statistic: 896.7 on 1 and 1051 DF,  p-value: < 2.2e-16

8.3 Modelo logarítmico

\[ \hat Y = \beta_0 + \beta_1 ln X \]

linearMod <- lm( multi_pob~log(Freq.x) , data=h_y_m_comuna_corr_01)
summary(linearMod) 

## 
## Call:
## lm(formula = multi_pob ~ log(Freq.x), data = h_y_m_comuna_corr_01)
## 
## Residuals:
##       Min        1Q    Median        3Q       Max 
## -97141503 -28239414  -4624461  19695053 324859627 
## 
## Coefficients:
##              Estimate Std. Error t value Pr(>|t|)    
## (Intercept) -16616876    2597331  -6.398 2.37e-10 ***
## log(Freq.x)  36148814    1176858  30.716  < 2e-16 ***
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 45910000 on 1051 degrees of freedom
## Multiple R-squared:  0.473,  Adjusted R-squared:  0.4725 
## F-statistic: 943.5 on 1 and 1051 DF,  p-value: < 2.2e-16

8.4 Modelo exponencial

\[ \hat Y = \beta_0 + \beta_1 e^X \]

No es aplicable sin una transformación pues los valores elevados a \(e\) de Freq.x tienden a infinito.

8.5 Modelo con raíz cuadrada

\[ \hat Y = \beta_0 + \beta_1 \sqrt {X} \]

linearMod <- lm( multi_pob~sqrt(Freq.x) , data=h_y_m_comuna_corr_01)
summary(linearMod) 

## 
## Call:
## lm(formula = multi_pob ~ sqrt(Freq.x), data = h_y_m_comuna_corr_01)
## 
## Residuals:
##        Min         1Q     Median         3Q        Max 
## -167723133  -18848974   -2371391   11039476  274308459 
## 
## Coefficients:
##               Estimate Std. Error t value Pr(>|t|)    
## (Intercept)  -20658242    2325412  -8.884   <2e-16 ***
## sqrt(Freq.x)  23350894     636636  36.679   <2e-16 ***
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 41890000 on 1051 degrees of freedom
## Multiple R-squared:  0.5614, Adjusted R-squared:  0.561 
## F-statistic:  1345 on 1 and 1051 DF,  p-value: < 2.2e-16

8.6 Modelo raíz-raíz

\[ \hat Y = {\beta_0}^2 + 2 \beta_0 \beta_1 \sqrt{X}+ \beta_1^2 X \]

linearMod <- lm( sqrt(multi_pob)~sqrt(Freq.x) , data=h_y_m_comuna_corr_01)
summary(linearMod) 

## 
## Call:
## lm(formula = sqrt(multi_pob) ~ sqrt(Freq.x), data = h_y_m_comuna_corr_01)
## 
## Residuals:
##     Min      1Q  Median      3Q     Max 
## -9593.9 -1486.3  -149.1  1253.8 10529.9 
## 
## Coefficients:
##              Estimate Std. Error t value Pr(>|t|)    
## (Intercept)   1896.07     126.28   15.01   <2e-16 ***
## sqrt(Freq.x)  1384.54      34.57   40.05   <2e-16 ***
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 2275 on 1051 degrees of freedom
## Multiple R-squared:  0.6041, Adjusted R-squared:  0.6037 
## F-statistic:  1604 on 1 and 1051 DF,  p-value: < 2.2e-16

8.7 Modelo log-raíz

\[ \hat Y = e^{\beta_0 + \beta_1 \sqrt{X}} \]

linearMod <- lm( log(multi_pob)~sqrt(Freq.x) , data=h_y_m_comuna_corr_01)
summary(linearMod) 

## 
## Call:
## lm(formula = log(multi_pob) ~ sqrt(Freq.x), data = h_y_m_comuna_corr_01)
## 
## Residuals:
##     Min      1Q  Median      3Q     Max 
## -3.3480 -0.5235  0.1032  0.6023  2.1516 
## 
## Coefficients:
##              Estimate Std. Error t value Pr(>|t|)    
## (Intercept)  15.83219    0.04584  345.40   <2e-16 ***
## sqrt(Freq.x)  0.41621    0.01255   33.17   <2e-16 ***
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 0.8257 on 1051 degrees of freedom
## Multiple R-squared:  0.5114, Adjusted R-squared:  0.5109 
## F-statistic:  1100 on 1 and 1051 DF,  p-value: < 2.2e-16

8.8 Modelo raíz-log

\[ \hat Y = {\beta_0}^2 + 2 \beta_0 \beta_1 \ln{X}+ \beta_1^2 ln^2X \]

linearMod <- lm( sqrt(multi_pob)~log(Freq.x) , data=h_y_m_comuna_corr_01)
summary(linearMod) 

## 
## Call:
## lm(formula = sqrt(multi_pob) ~ log(Freq.x), data = h_y_m_comuna_corr_01)
## 
## Residuals:
##     Min      1Q  Median      3Q     Max 
## -6009.1 -1637.8  -116.9  1296.0 10002.6 
## 
## Coefficients:
##             Estimate Std. Error t value Pr(>|t|)    
## (Intercept)  1837.19     131.19   14.00   <2e-16 ***
## log(Freq.x)  2304.64      59.44   38.77   <2e-16 ***
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 2319 on 1051 degrees of freedom
## Multiple R-squared:  0.5885, Adjusted R-squared:  0.5881 
## F-statistic:  1503 on 1 and 1051 DF,  p-value: < 2.2e-16

8.9 Modelo log-log

\[ \hat Y = e^{\beta_0+\beta_1 ln{X}} \]

linearMod <- lm( log(multi_pob)~log(Freq.x) , data=h_y_m_comuna_corr_01)
summary(linearMod) 

## 
## Call:
## lm(formula = log(multi_pob) ~ log(Freq.x), data = h_y_m_comuna_corr_01)
## 
## Residuals:
##      Min       1Q   Median       3Q      Max 
## -2.25031 -0.50538  0.09502  0.54950  1.95084 
## 
## Coefficients:
##             Estimate Std. Error t value Pr(>|t|)    
## (Intercept) 15.71014    0.04317   363.9   <2e-16 ***
## log(Freq.x)  0.74918    0.01956    38.3   <2e-16 ***
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 0.7631 on 1051 degrees of freedom
## Multiple R-squared:  0.5826, Adjusted R-squared:  0.5822 
## F-statistic:  1467 on 1 and 1051 DF,  p-value: < 2.2e-16

9 Modelo elegido: raiz-raiz (raiz-raiz)

Es éste el modelo que nos entrega el mayor coeficiente de determinación de todos (0.6037 ).

9.1 Diagrama de dispersión sobre raiz-raiz

Desplegamos una curva suavizada por loess en el diagrama de dispersión.

scatter.smooth(x=sqrt(h_y_m_comuna_corr_01$Freq.x), y=sqrt(h_y_m_comuna_corr_01$multi_pob), lpars = list(col = "red", lwd = 2, lty = 1), main="multi_pob ~ Freq.x")

9.2 Modelo raiz-raiz

Observemos nuevamente el resultado sobre raiz-raiz.

linearMod <- lm(sqrt( multi_pob)~sqrt(Freq.x) , data=h_y_m_comuna_corr_01)
summary(linearMod) 

## 
## Call:
## lm(formula = sqrt(multi_pob) ~ sqrt(Freq.x), data = h_y_m_comuna_corr_01)
## 
## Residuals:
##     Min      1Q  Median      3Q     Max 
## -9593.9 -1486.3  -149.1  1253.8 10529.9 
## 
## Coefficients:
##              Estimate Std. Error t value Pr(>|t|)    
## (Intercept)   1896.07     126.28   15.01   <2e-16 ***
## sqrt(Freq.x)  1384.54      34.57   40.05   <2e-16 ***
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 2275 on 1051 degrees of freedom
## Multiple R-squared:  0.6041, Adjusted R-squared:  0.6037 
## F-statistic:  1604 on 1 and 1051 DF,  p-value: < 2.2e-16

ggplot(h_y_m_comuna_corr_01, aes(x = sqrt(Freq.x) , y = sqrt(multi_pob))) + 
  geom_point() +
  stat_smooth(method = "lm", col = "red")

9.3 Análisis de residuos

par(mfrow = c (2,2))
plot(linearMod)

9.4 Ecuación del modelo

\[ \hat Y = {1740.6}^2 + 2 \cdot 1740.6 \cdot 1554.5 \sqrt{X}+ 1554.5^2 X \]

10 Aplicación la regresión a los valores de la variable a nivel de zona

Esta nueva variable se llamará: est_ing

h_y_m_comuna_corr_01$est_ing <- 
(1740.6)^2 + 2 * 1740.6 * 1554.5 * sqrt(h_y_m_comuna_corr_01$Freq.x)+  1554.5^2 * (h_y_m_comuna_corr_01$Freq.x) 

r3_100 <- h_y_m_comuna_corr_01[c(1:100),]
kbl(r3_100) %>%
  kable_styling(bootstrap_options = c("striped", "hover")) %>%
  kable_paper() %>%
  scroll_box(width = "100%", height = "300px")

zona	código.x	Freq.x	anio	comuna.x	promedio_i	año	personas	Ingresos_expandidos	Freq.y	p_poblacional	código.y	multi_pob	est_ing
7101092003	07101	42	2017	Talca	244658.0	2017	220357	53912095394	191	0.0008668	07101	46729671	139592132
7101092024	07101	6	2017	Talca	244658.0	2017	220357	53912095394	50	0.0002269	07101	12232898	30783986
7101092901	07101	3	2017	Talca	244658.0	2017	220357	53912095394	38	0.0001724	07101	9297003	19652136
7101102004	07101	7	2017	Talca	244658.0	2017	220357	53912095394	66	0.0002995	07101	16147426	34262531
7101102005	07101	35	2017	Talca	244658.0	2017	220357	53912095394	260	0.0011799	07101	63611071	119621163
7101102013	07101	1	2017	Talca	244658.0	2017	220357	53912095394	8	0.0000363	07101	1957264	10857684
7101102017	07101	94	2017	Talca	244658.0	2017	220357	53912095394	991	0.0044972	07101	242456044	282644577
7101102018	07101	10	2017	Talca	244658.0	2017	220357	53912095394	123	0.0005582	07101	30092930	44307137
7101112010	07101	19	2017	Talca	244658.0	2017	220357	53912095394	74	0.0003358	07101	18104689	72530915
7101112015	07101	51	2017	Talca	244658.0	2017	220357	53912095394	349	0.0015838	07101	85385630	164915692
7101112020	07101	61	2017	Talca	244658.0	2017	220357	53912095394	668	0.0030314	07101	163431521	192699738
7101112022	07101	95	2017	Talca	244658.0	2017	220357	53912095394	287	0.0013024	07101	70216836	285339387
7101122001	07101	189	2017	Talca	244658.0	2017	220357	53912095394	795	0.0036078	07101	194503083	534138740
7101122010	07101	60	2017	Talca	244658.0	2017	220357	53912095394	223	0.0010120	07101	54558726	189935399
7101122012	07101	5	2017	Talca	244658.0	2017	220357	53912095394	27	0.0001225	07101	6605765	27212578
7101122014	07101	5	2017	Talca	244658.0	2017	220357	53912095394	59	0.0002677	07101	14434820	27212578
7101122021	07101	9	2017	Talca	244658.0	2017	220357	53912095394	41	0.0001861	07101	10030977	41012497
7101122022	07101	125	2017	Talca	244658.0	2017	220357	53912095394	435	0.0019741	07101	106426215	365591163
7101122901	07101	4	2017	Talca	244658.0	2017	220357	53912095394	31	0.0001407	07101	7584397	23518620
7101152008	07101	51	2017	Talca	244658.0	2017	220357	53912095394	1194	0.0054185	07101	292121611	164915692
7101152010	07101	18	2017	Talca	244658.0	2017	220357	53912095394	300	0.0013614	07101	73397390	69485311
7101152016	07101	19	2017	Talca	244658.0	2017	220357	53912095394	308	0.0013977	07101	75354654	72530915
7101152023	07101	16	2017	Talca	244658.0	2017	220357	53912095394	287	0.0013024	07101	70216836	63339314
7101162002	07101	15	2017	Talca	244658.0	2017	220357	53912095394	465	0.0021102	07101	113765954	60235490
7101162007	07101	16	2017	Talca	244658.0	2017	220357	53912095394	601	0.0027274	07101	147039438	63339314
7101162010	07101	67	2017	Talca	244658.0	2017	220357	53912095394	212	0.0009621	07101	51867489	209228440
7101162019	07101	86	2017	Talca	244658.0	2017	220357	53912095394	1358	0.0061627	07101	332245518	261030552
7102022033	07102	6	2017	Constitución	198314.7	2017	46068	9135962663	22	0.0004776	07102	4362924	30783986
7102022038	07102	3	2017	Constitución	198314.7	2017	46068	9135962663	180	0.0039073	07102	35696650	19652136
7102022046	07102	2	2017	Constitución	198314.7	2017	46068	9135962663	22	0.0004776	07102	4362924	15515681
7102022060	07102	1	2017	Constitución	198314.7	2017	46068	9135962663	154	0.0033429	07102	30540467	10857684
7102032025	07102	10	2017	Constitución	198314.7	2017	46068	9135962663	43	0.0009334	07102	8527533	44307137
7102032030	07102	1	2017	Constitución	198314.7	2017	46068	9135962663	59	0.0012807	07102	11700569	10857684
7102032038	07102	2	2017	Constitución	198314.7	2017	46068	9135962663	262	0.0056872	07102	51958457	15515681
7102032043	07102	5	2017	Constitución	198314.7	2017	46068	9135962663	18	0.0003907	07102	3569665	27212578
7102032045	07102	19	2017	Constitución	198314.7	2017	46068	9135962663	776	0.0168447	07102	153892225	72530915
7102032056	07102	23	2017	Constitución	198314.7	2017	46068	9135962663	1833	0.0397890	07102	363510887	84561268
7102032060	07102	5	2017	Constitución	198314.7	2017	46068	9135962663	148	0.0032126	07102	29350579	27212578
7102042007	07102	7	2017	Constitución	198314.7	2017	46068	9135962663	353	0.0076626	07102	70005097	34262531
7102042011	07102	1	2017	Constitución	198314.7	2017	46068	9135962663	62	0.0013458	07102	12295513	10857684
7102042016	07102	25	2017	Constitución	198314.7	2017	46068	9135962663	178	0.0038639	07102	35300021	90499072
7102042024	07102	15	2017	Constitución	198314.7	2017	46068	9135962663	382	0.0082921	07102	75756224	60235490
7102042036	07102	13	2017	Constitución	198314.7	2017	46068	9135962663	181	0.0039290	07102	35894965	53955334
7102042047	07102	36	2017	Constitución	198314.7	2017	46068	9135962663	328	0.0071199	07102	65047229	122491770
7102042901	07102	67	2017	Constitución	198314.7	2017	46068	9135962663	350	0.0075975	07102	69410153	209228440
7102052009	07102	1	2017	Constitución	198314.7	2017	46068	9135962663	106	0.0023009	07102	21021361	10857684
7102052012	07102	1	2017	Constitución	198314.7	2017	46068	9135962663	128	0.0027785	07102	25384285	10857684
7102052050	07102	1	2017	Constitución	198314.7	2017	46068	9135962663	45	0.0009768	07102	8924163	10857684
7102062007	07102	1	2017	Constitución	198314.7	2017	46068	9135962663	29	0.0006295	07102	5751127	10857684
7102062010	07102	1	2017	Constitución	198314.7	2017	46068	9135962663	37	0.0008032	07102	7337645	10857684
7102062018	07102	1	2017	Constitución	198314.7	2017	46068	9135962663	77	0.0016714	07102	15270234	10857684
7102062028	07102	3	2017	Constitución	198314.7	2017	46068	9135962663	269	0.0058392	07102	53346661	19652136
7102062053	07102	7	2017	Constitución	198314.7	2017	46068	9135962663	378	0.0082053	07102	74962965	34262531
7102062059	07102	6	2017	Constitución	198314.7	2017	46068	9135962663	903	0.0196015	07102	179078195	30783986
7102062901	07102	6	2017	Constitución	198314.7	2017	46068	9135962663	78	0.0016931	07102	15468548	30783986
7102072006	07102	1	2017	Constitución	198314.7	2017	46068	9135962663	15	0.0003256	07102	2974721	10857684
7102072027	07102	12	2017	Constitución	198314.7	2017	46068	9135962663	462	0.0100287	07102	91621402	50773405
7102072031	07102	2	2017	Constitución	198314.7	2017	46068	9135962663	62	0.0013458	07102	12295513	15515681
7102072048	07102	8	2017	Constitución	198314.7	2017	46068	9135962663	124	0.0026917	07102	24591026	37667556
7102072055	07102	2	2017	Constitución	198314.7	2017	46068	9135962663	98	0.0021273	07102	19434843	15515681
7103012027	07103	5	2017	Curepto	191743.1	2017	9448	1811588746	158	0.0167231	07103	30295409	27212578
7103012038	07103	12	2017	Curepto	191743.1	2017	9448	1811588746	143	0.0151355	07103	27419262	50773405
7103012042	07103	6	2017	Curepto	191743.1	2017	9448	1811588746	147	0.0155588	07103	28186235	30783986
7103012054	07103	5	2017	Curepto	191743.1	2017	9448	1811588746	61	0.0064564	07103	11696329	27212578
7103022003	07103	7	2017	Curepto	191743.1	2017	9448	1811588746	328	0.0347163	07103	62891735	34262531
7103022020	07103	7	2017	Curepto	191743.1	2017	9448	1811588746	167	0.0176757	07103	32021097	34262531
7103022025	07103	11	2017	Curepto	191743.1	2017	9448	1811588746	252	0.0266723	07103	48319260	47558860
7103022049	07103	1	2017	Curepto	191743.1	2017	9448	1811588746	43	0.0045512	07103	8244953	10857684
7103022052	07103	6	2017	Curepto	191743.1	2017	9448	1811588746	181	0.0191575	07103	34705500	30783986
7103032007	07103	15	2017	Curepto	191743.1	2017	9448	1811588746	242	0.0256139	07103	46401829	60235490
7103032012	07103	6	2017	Curepto	191743.1	2017	9448	1811588746	202	0.0213802	07103	38732105	30783986
7103032053	07103	2	2017	Curepto	191743.1	2017	9448	1811588746	40	0.0042337	07103	7669724	15515681
7103042010	07103	3	2017	Curepto	191743.1	2017	9448	1811588746	32	0.0033870	07103	6135779	19652136
7103042027	07103	2	2017	Curepto	191743.1	2017	9448	1811588746	110	0.0116427	07103	21091740	15515681
7103042031	07103	7	2017	Curepto	191743.1	2017	9448	1811588746	184	0.0194750	07103	35280729	34262531
7103042037	07103	4	2017	Curepto	191743.1	2017	9448	1811588746	27	0.0028577	07103	5177064	23518620
7103042043	07103	1	2017	Curepto	191743.1	2017	9448	1811588746	17	0.0017993	07103	3259633	10857684
7103042044	07103	1	2017	Curepto	191743.1	2017	9448	1811588746	13	0.0013760	07103	2492660	10857684
7103042047	07103	2	2017	Curepto	191743.1	2017	9448	1811588746	36	0.0038103	07103	6902751	15515681
7103042901	07103	1	2017	Curepto	191743.1	2017	9448	1811588746	19	0.0020110	07103	3643119	10857684
7103052051	07103	1	2017	Curepto	191743.1	2017	9448	1811588746	20	0.0021169	07103	3834862	10857684
7103052058	07103	1	2017	Curepto	191743.1	2017	9448	1811588746	40	0.0042337	07103	7669724	10857684
7103062022	07103	24	2017	Curepto	191743.1	2017	9448	1811588746	448	0.0474174	07103	85900906	87535926
7103062901	07103	1	2017	Curepto	191743.1	2017	9448	1811588746	11	0.0011643	07103	2109174	10857684
7103072024	07103	3	2017	Curepto	191743.1	2017	9448	1811588746	35	0.0037045	07103	6711008	19652136
7103072062	07103	2	2017	Curepto	191743.1	2017	9448	1811588746	69	0.0073031	07103	13230273	15515681
7103072901	07103	3	2017	Curepto	191743.1	2017	9448	1811588746	108	0.0114310	07103	20708254	19652136
7103082011	07103	6	2017	Curepto	191743.1	2017	9448	1811588746	125	0.0132303	07103	23967887	30783986
7103082041	07103	2	2017	Curepto	191743.1	2017	9448	1811588746	119	0.0125953	07103	22817428	15515681
7103082048	07103	2	2017	Curepto	191743.1	2017	9448	1811588746	33	0.0034928	07103	6327522	15515681
7103082059	07103	2	2017	Curepto	191743.1	2017	9448	1811588746	43	0.0045512	07103	8244953	15515681
7103092021	07103	1	2017	Curepto	191743.1	2017	9448	1811588746	95	0.0100550	07103	18215594	10857684
7103092061	07103	6	2017	Curepto	191743.1	2017	9448	1811588746	237	0.0250847	07103	45443113	30783986
7103102026	07103	44	2017	Curepto	191743.1	2017	9448	1811588746	967	0.1023497	07103	185415571	145250378
7103102039	07103	8	2017	Curepto	191743.1	2017	9448	1811588746	330	0.0349280	07103	63275221	37667556
7103102063	07103	3	2017	Curepto	191743.1	2017	9448	1811588746	31	0.0032811	07103	5944036	19652136
7103102901	07103	1	2017	Curepto	191743.1	2017	9448	1811588746	28	0.0029636	07103	5368807	10857684
7103112013	07103	1	2017	Curepto	191743.1	2017	9448	1811588746	76	0.0080440	07103	14572475	10857684
7103112016	07103	1	2017	Curepto	191743.1	2017	9448	1811588746	49	0.0051863	07103	9395412	10857684
7103112018	07103	4	2017	Curepto	191743.1	2017	9448	1811588746	80	0.0084674	07103	15339447	23518620

11 División del valor estimado entre la población total de la zona para obtener el ingreso medio por zona

\[ Ingreso \_ Medio\_zona = est\_ing / (personas * p\_poblacional) \]

h_y_m_comuna_corr_01$ing_medio_zona <- h_y_m_comuna_corr_01$est_ing  /( h_y_m_comuna_corr_01$personas  * h_y_m_comuna_corr_01$p_poblacional)

r3_100 <- h_y_m_comuna_corr_01[c(1:100),]
kbl(r3_100) %>%
  kable_styling(bootstrap_options = c("striped", "hover")) %>%
  kable_paper() %>%
  scroll_box(width = "100%", height = "300px")

zona	código.x	Freq.x	anio	comuna.x	promedio_i	año	personas	Ingresos_expandidos	Freq.y	p_poblacional	código.y	multi_pob	est_ing	ing_medio_zona
7101092003	07101	42	2017	Talca	244658.0	2017	220357	53912095394	191	0.0008668	07101	46729671	139592132	730848.86
7101092024	07101	6	2017	Talca	244658.0	2017	220357	53912095394	50	0.0002269	07101	12232898	30783986	615679.72
7101092901	07101	3	2017	Talca	244658.0	2017	220357	53912095394	38	0.0001724	07101	9297003	19652136	517161.47
7101102004	07101	7	2017	Talca	244658.0	2017	220357	53912095394	66	0.0002995	07101	16147426	34262531	519129.25
7101102005	07101	35	2017	Talca	244658.0	2017	220357	53912095394	260	0.0011799	07101	63611071	119621163	460081.40
7101102013	07101	1	2017	Talca	244658.0	2017	220357	53912095394	8	0.0000363	07101	1957264	10857684	1357210.50
7101102017	07101	94	2017	Talca	244658.0	2017	220357	53912095394	991	0.0044972	07101	242456044	282644577	285211.48
7101102018	07101	10	2017	Talca	244658.0	2017	220357	53912095394	123	0.0005582	07101	30092930	44307137	360220.62
7101112010	07101	19	2017	Talca	244658.0	2017	220357	53912095394	74	0.0003358	07101	18104689	72530915	980147.51
7101112015	07101	51	2017	Talca	244658.0	2017	220357	53912095394	349	0.0015838	07101	85385630	164915692	472537.80
7101112020	07101	61	2017	Talca	244658.0	2017	220357	53912095394	668	0.0030314	07101	163431521	192699738	288472.66
7101112022	07101	95	2017	Talca	244658.0	2017	220357	53912095394	287	0.0013024	07101	70216836	285339387	994213.89
7101122001	07101	189	2017	Talca	244658.0	2017	220357	53912095394	795	0.0036078	07101	194503083	534138740	671872.63
7101122010	07101	60	2017	Talca	244658.0	2017	220357	53912095394	223	0.0010120	07101	54558726	189935399	851728.25
7101122012	07101	5	2017	Talca	244658.0	2017	220357	53912095394	27	0.0001225	07101	6605765	27212578	1007873.27
7101122014	07101	5	2017	Talca	244658.0	2017	220357	53912095394	59	0.0002677	07101	14434820	27212578	461230.14
7101122021	07101	9	2017	Talca	244658.0	2017	220357	53912095394	41	0.0001861	07101	10030977	41012497	1000304.80
7101122022	07101	125	2017	Talca	244658.0	2017	220357	53912095394	435	0.0019741	07101	106426215	365591163	840439.45
7101122901	07101	4	2017	Talca	244658.0	2017	220357	53912095394	31	0.0001407	07101	7584397	23518620	758665.17
7101152008	07101	51	2017	Talca	244658.0	2017	220357	53912095394	1194	0.0054185	07101	292121611	164915692	138120.35
7101152010	07101	18	2017	Talca	244658.0	2017	220357	53912095394	300	0.0013614	07101	73397390	69485311	231617.70
7101152016	07101	19	2017	Talca	244658.0	2017	220357	53912095394	308	0.0013977	07101	75354654	72530915	235489.99
7101152023	07101	16	2017	Talca	244658.0	2017	220357	53912095394	287	0.0013024	07101	70216836	63339314	220694.47
7101162002	07101	15	2017	Talca	244658.0	2017	220357	53912095394	465	0.0021102	07101	113765954	60235490	129538.69
7101162007	07101	16	2017	Talca	244658.0	2017	220357	53912095394	601	0.0027274	07101	147039438	63339314	105389.87
7101162010	07101	67	2017	Talca	244658.0	2017	220357	53912095394	212	0.0009621	07101	51867489	209228440	986926.60
7101162019	07101	86	2017	Talca	244658.0	2017	220357	53912095394	1358	0.0061627	07101	332245518	261030552	192216.90
7102022033	07102	6	2017	Constitución	198314.7	2017	46068	9135962663	22	0.0004776	07102	4362924	30783986	1399272.08
7102022038	07102	3	2017	Constitución	198314.7	2017	46068	9135962663	180	0.0039073	07102	35696650	19652136	109178.53
7102022046	07102	2	2017	Constitución	198314.7	2017	46068	9135962663	22	0.0004776	07102	4362924	15515681	705258.25
7102022060	07102	1	2017	Constitución	198314.7	2017	46068	9135962663	154	0.0033429	07102	30540467	10857684	70504.44
7102032025	07102	10	2017	Constitución	198314.7	2017	46068	9135962663	43	0.0009334	07102	8527533	44307137	1030398.53
7102032030	07102	1	2017	Constitución	198314.7	2017	46068	9135962663	59	0.0012807	07102	11700569	10857684	184028.54
7102032038	07102	2	2017	Constitución	198314.7	2017	46068	9135962663	262	0.0056872	07102	51958457	15515681	59220.16
7102032043	07102	5	2017	Constitución	198314.7	2017	46068	9135962663	18	0.0003907	07102	3569665	27212578	1511809.90
7102032045	07102	19	2017	Constitución	198314.7	2017	46068	9135962663	776	0.0168447	07102	153892225	72530915	93467.67
7102032056	07102	23	2017	Constitución	198314.7	2017	46068	9135962663	1833	0.0397890	07102	363510887	84561268	46132.72
7102032060	07102	5	2017	Constitución	198314.7	2017	46068	9135962663	148	0.0032126	07102	29350579	27212578	183868.77
7102042007	07102	7	2017	Constitución	198314.7	2017	46068	9135962663	353	0.0076626	07102	70005097	34262531	97060.99
7102042011	07102	1	2017	Constitución	198314.7	2017	46068	9135962663	62	0.0013458	07102	12295513	10857684	175123.94
7102042016	07102	25	2017	Constitución	198314.7	2017	46068	9135962663	178	0.0038639	07102	35300021	90499072	508421.75
7102042024	07102	15	2017	Constitución	198314.7	2017	46068	9135962663	382	0.0082921	07102	75756224	60235490	157684.53
7102042036	07102	13	2017	Constitución	198314.7	2017	46068	9135962663	181	0.0039290	07102	35894965	53955334	298095.77
7102042047	07102	36	2017	Constitución	198314.7	2017	46068	9135962663	328	0.0071199	07102	65047229	122491770	373450.52
7102042901	07102	67	2017	Constitución	198314.7	2017	46068	9135962663	350	0.0075975	07102	69410153	209228440	597795.54
7102052009	07102	1	2017	Constitución	198314.7	2017	46068	9135962663	106	0.0023009	07102	21021361	10857684	102430.98
7102052012	07102	1	2017	Constitución	198314.7	2017	46068	9135962663	128	0.0027785	07102	25384285	10857684	84825.66
7102052050	07102	1	2017	Constitución	198314.7	2017	46068	9135962663	45	0.0009768	07102	8924163	10857684	241281.87
7102062007	07102	1	2017	Constitución	198314.7	2017	46068	9135962663	29	0.0006295	07102	5751127	10857684	374402.90
7102062010	07102	1	2017	Constitución	198314.7	2017	46068	9135962663	37	0.0008032	07102	7337645	10857684	293450.92
7102062018	07102	1	2017	Constitución	198314.7	2017	46068	9135962663	77	0.0016714	07102	15270234	10857684	141008.88
7102062028	07102	3	2017	Constitución	198314.7	2017	46068	9135962663	269	0.0058392	07102	53346661	19652136	73056.27
7102062053	07102	7	2017	Constitución	198314.7	2017	46068	9135962663	378	0.0082053	07102	74962965	34262531	90641.62
7102062059	07102	6	2017	Constitución	198314.7	2017	46068	9135962663	903	0.0196015	07102	179078195	30783986	34090.79
7102062901	07102	6	2017	Constitución	198314.7	2017	46068	9135962663	78	0.0016931	07102	15468548	30783986	394666.48
7102072006	07102	1	2017	Constitución	198314.7	2017	46068	9135962663	15	0.0003256	07102	2974721	10857684	723845.60
7102072027	07102	12	2017	Constitución	198314.7	2017	46068	9135962663	462	0.0100287	07102	91621402	50773405	109899.15
7102072031	07102	2	2017	Constitución	198314.7	2017	46068	9135962663	62	0.0013458	07102	12295513	15515681	250252.93
7102072048	07102	8	2017	Constitución	198314.7	2017	46068	9135962663	124	0.0026917	07102	24591026	37667556	303770.61
7102072055	07102	2	2017	Constitución	198314.7	2017	46068	9135962663	98	0.0021273	07102	19434843	15515681	158323.28
7103012027	07103	5	2017	Curepto	191743.1	2017	9448	1811588746	158	0.0167231	07103	30295409	27212578	172231.51
7103012038	07103	12	2017	Curepto	191743.1	2017	9448	1811588746	143	0.0151355	07103	27419262	50773405	355058.78
7103012042	07103	6	2017	Curepto	191743.1	2017	9448	1811588746	147	0.0155588	07103	28186235	30783986	209414.87
7103012054	07103	5	2017	Curepto	191743.1	2017	9448	1811588746	61	0.0064564	07103	11696329	27212578	446107.84
7103022003	07103	7	2017	Curepto	191743.1	2017	9448	1811588746	328	0.0347163	07103	62891735	34262531	104458.93
7103022020	07103	7	2017	Curepto	191743.1	2017	9448	1811588746	167	0.0176757	07103	32021097	34262531	205164.85
7103022025	07103	11	2017	Curepto	191743.1	2017	9448	1811588746	252	0.0266723	07103	48319260	47558860	188725.64
7103022049	07103	1	2017	Curepto	191743.1	2017	9448	1811588746	43	0.0045512	07103	8244953	10857684	252504.28
7103022052	07103	6	2017	Curepto	191743.1	2017	9448	1811588746	181	0.0191575	07103	34705500	30783986	170077.27
7103032007	07103	15	2017	Curepto	191743.1	2017	9448	1811588746	242	0.0256139	07103	46401829	60235490	248906.98
7103032012	07103	6	2017	Curepto	191743.1	2017	9448	1811588746	202	0.0213802	07103	38732105	30783986	152395.97
7103032053	07103	2	2017	Curepto	191743.1	2017	9448	1811588746	40	0.0042337	07103	7669724	15515681	387892.04
7103042010	07103	3	2017	Curepto	191743.1	2017	9448	1811588746	32	0.0033870	07103	6135779	19652136	614129.25
7103042027	07103	2	2017	Curepto	191743.1	2017	9448	1811588746	110	0.0116427	07103	21091740	15515681	141051.65
7103042031	07103	7	2017	Curepto	191743.1	2017	9448	1811588746	184	0.0194750	07103	35280729	34262531	186209.41
7103042037	07103	4	2017	Curepto	191743.1	2017	9448	1811588746	27	0.0028577	07103	5177064	23518620	871060.01
7103042043	07103	1	2017	Curepto	191743.1	2017	9448	1811588746	17	0.0017993	07103	3259633	10857684	638687.29
7103042044	07103	1	2017	Curepto	191743.1	2017	9448	1811588746	13	0.0013760	07103	2492660	10857684	835206.46
7103042047	07103	2	2017	Curepto	191743.1	2017	9448	1811588746	36	0.0038103	07103	6902751	15515681	430991.15
7103042901	07103	1	2017	Curepto	191743.1	2017	9448	1811588746	19	0.0020110	07103	3643119	10857684	571457.05
7103052051	07103	1	2017	Curepto	191743.1	2017	9448	1811588746	20	0.0021169	07103	3834862	10857684	542884.20
7103052058	07103	1	2017	Curepto	191743.1	2017	9448	1811588746	40	0.0042337	07103	7669724	10857684	271442.10
7103062022	07103	24	2017	Curepto	191743.1	2017	9448	1811588746	448	0.0474174	07103	85900906	87535926	195392.69
7103062901	07103	1	2017	Curepto	191743.1	2017	9448	1811588746	11	0.0011643	07103	2109174	10857684	987062.18
7103072024	07103	3	2017	Curepto	191743.1	2017	9448	1811588746	35	0.0037045	07103	6711008	19652136	561489.60
7103072062	07103	2	2017	Curepto	191743.1	2017	9448	1811588746	69	0.0073031	07103	13230273	15515681	224864.95
7103072901	07103	3	2017	Curepto	191743.1	2017	9448	1811588746	108	0.0114310	07103	20708254	19652136	181964.22
7103082011	07103	6	2017	Curepto	191743.1	2017	9448	1811588746	125	0.0132303	07103	23967887	30783986	246271.89
7103082041	07103	2	2017	Curepto	191743.1	2017	9448	1811588746	119	0.0125953	07103	22817428	15515681	130383.88
7103082048	07103	2	2017	Curepto	191743.1	2017	9448	1811588746	33	0.0034928	07103	6327522	15515681	470172.17
7103082059	07103	2	2017	Curepto	191743.1	2017	9448	1811588746	43	0.0045512	07103	8244953	15515681	360829.80
7103092021	07103	1	2017	Curepto	191743.1	2017	9448	1811588746	95	0.0100550	07103	18215594	10857684	114291.41
7103092061	07103	6	2017	Curepto	191743.1	2017	9448	1811588746	237	0.0250847	07103	45443113	30783986	129890.24
7103102026	07103	44	2017	Curepto	191743.1	2017	9448	1811588746	967	0.1023497	07103	185415571	145250378	150207.22
7103102039	07103	8	2017	Curepto	191743.1	2017	9448	1811588746	330	0.0349280	07103	63275221	37667556	114144.11
7103102063	07103	3	2017	Curepto	191743.1	2017	9448	1811588746	31	0.0032811	07103	5944036	19652136	633939.87
7103102901	07103	1	2017	Curepto	191743.1	2017	9448	1811588746	28	0.0029636	07103	5368807	10857684	387774.43
7103112013	07103	1	2017	Curepto	191743.1	2017	9448	1811588746	76	0.0080440	07103	14572475	10857684	142864.26
7103112016	07103	1	2017	Curepto	191743.1	2017	9448	1811588746	49	0.0051863	07103	9395412	10857684	221585.39
7103112018	07103	4	2017	Curepto	191743.1	2017	9448	1811588746	80	0.0084674	07103	15339447	23518620	293982.75

Guardamos:

saveRDS(h_y_m_comuna_corr_01, "P15/region_07_P15_r.rds")

12 Referencias

https://rpubs.com/osoramirez/316691

https://dataintelligencechile.shinyapps.io/casenfinal

Manual_de_usuario_Censo_2017_16R.pdf

http://www.censo2017.cl/microdatos/

Censo de Población y Vivienda

https://www.ine.cl/estadisticas/sociales/censos-de-poblacion-y-vivienda/poblacion-y-vivienda

http://r-statistics.co/Linear-Regression.html