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

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 09.

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 09 y con la zona = 2:

tabla_con_clave <- filter(tabla_con_clave, tabla_con_clave$REGION == 9) 
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	9101072007	12	9101	21	2017
2	9101072009	12	9101	5	2017
3	9101072010	12	9101	13	2017
4	9101072042	12	9101	17	2017
5	9101072060	12	9101	17	2017
6	9101082007	12	9101	30	2017
7	9101102004	12	9101	445	2017
8	9101102006	12	9101	188	2017
9	9101102018	12	9101	1	2017
10	9101102028	12	9101	152	2017
11	9101102029	12	9101	28	2017
12	9101102034	12	9101	2	2017
13	9101102052	12	9101	1	2017
14	9101102057	12	9101	158	2017
15	9101112003	12	9101	4	2017
16	9101112013	12	9101	5	2017
17	9101112014	12	9101	1	2017
18	9101112019	12	9101	3	2017
19	9101112021	12	9101	13	2017
20	9101112029	12	9101	14	2017
21	9101112031	12	9101	4	2017
22	9101112038	12	9101	3	2017
23	9101112041	12	9101	3	2017
24	9101112045	12	9101	14	2017
25	9101112047	12	9101	2	2017
26	9101112048	12	9101	3	2017
27	9101112052	12	9101	8	2017
28	9101112054	12	9101	30	2017
29	9101112059	12	9101	4	2017
30	9101112062	12	9101	41	2017
31	9101112065	12	9101	1	2017
32	9101112067	12	9101	16	2017
33	9101112068	12	9101	6	2017
34	9101112069	12	9101	2	2017
35	9101112070	12	9101	1	2017
36	9101112071	12	9101	11	2017
37	9101112072	12	9101	3	2017
38	9101112073	12	9101	6	2017
39	9101122051	12	9101	75	2017
40	9101122060	12	9101	24	2017
41	9101122061	12	9101	6	2017
42	9101132015	12	9101	9	2017
43	9101132032	12	9101	2	2017
44	9101132033	12	9101	1	2017
45	9101132036	12	9101	2	2017
46	9101142008	12	9101	21	2017
47	9101142012	12	9101	41	2017
48	9101142022	12	9101	7	2017
49	9101142024	12	9101	1	2017
50	9101142037	12	9101	5	2017
51	9101142040	12	9101	25	2017
52	9101142042	12	9101	18	2017
53	9101142046	12	9101	7	2017
54	9101142054	12	9101	127	2017
55	9101142062	12	9101	29	2017
56	9101142064	12	9101	4	2017
57	9101142066	12	9101	1	2017
58	9101152002	12	9101	33	2017
59	9101152011	12	9101	8	2017
60	9101152015	12	9101	2	2017
61	9101152016	12	9101	7	2017
62	9101152017	12	9101	14	2017
63	9101152020	12	9101	7	2017
64	9101152023	12	9101	2	2017
65	9101152027	12	9101	11	2017
66	9101152035	12	9101	2	2017
67	9101152043	12	9101	2	2017
1380	9102012028	12	9102	3	2017
1381	9102022011	12	9102	11	2017
1382	9102022031	12	9102	4	2017
1383	9102022054	12	9102	5	2017
1384	9102022901	12	9102	4	2017
1385	9102032009	12	9102	2	2017
1386	9102032035	12	9102	1	2017
1387	9102032037	12	9102	2	2017
1388	9102032042	12	9102	4	2017
1389	9102032901	12	9102	1	2017
1390	9102042004	12	9102	11	2017
1391	9102042010	12	9102	12	2017
1392	9102042015	12	9102	19	2017
1393	9102042029	12	9102	15	2017
1394	9102042041	12	9102	3	2017
1395	9102042045	12	9102	8	2017
1396	9102052018	12	9102	11	2017
1397	9102052034	12	9102	3	2017
1398	9102052039	12	9102	1	2017
1399	9102052040	12	9102	26	2017
1400	9102052043	12	9102	6	2017
1401	9102052047	12	9102	4	2017
1402	9102052055	12	9102	16	2017
1403	9102062014	12	9102	5	2017
1404	9102062032	12	9102	6	2017
1405	9102062044	12	9102	5	2017
1406	9102062052	12	9102	1	2017
1407	9102072002	12	9102	1	2017
1408	9102072003	12	9102	4	2017
1409	9102072008	12	9102	5	2017
1410	9102082024	12	9102	12	2017
1411	9102082027	12	9102	5	2017
1412	9102082036	12	9102	1	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	9101072007	21	2017	09101
2	9101072009	5	2017	09101
3	9101072010	13	2017	09101
4	9101072042	17	2017	09101
5	9101072060	17	2017	09101
6	9101082007	30	2017	09101
7	9101102004	445	2017	09101
8	9101102006	188	2017	09101
9	9101102018	1	2017	09101
10	9101102028	152	2017	09101
11	9101102029	28	2017	09101
12	9101102034	2	2017	09101
13	9101102052	1	2017	09101
14	9101102057	158	2017	09101
15	9101112003	4	2017	09101
16	9101112013	5	2017	09101
17	9101112014	1	2017	09101
18	9101112019	3	2017	09101
19	9101112021	13	2017	09101
20	9101112029	14	2017	09101
21	9101112031	4	2017	09101
22	9101112038	3	2017	09101
23	9101112041	3	2017	09101
24	9101112045	14	2017	09101
25	9101112047	2	2017	09101
26	9101112048	3	2017	09101
27	9101112052	8	2017	09101
28	9101112054	30	2017	09101
29	9101112059	4	2017	09101
30	9101112062	41	2017	09101
31	9101112065	1	2017	09101
32	9101112067	16	2017	09101
33	9101112068	6	2017	09101
34	9101112069	2	2017	09101
35	9101112070	1	2017	09101
36	9101112071	11	2017	09101
37	9101112072	3	2017	09101
38	9101112073	6	2017	09101
39	9101122051	75	2017	09101
40	9101122060	24	2017	09101
41	9101122061	6	2017	09101
42	9101132015	9	2017	09101
43	9101132032	2	2017	09101
44	9101132033	1	2017	09101
45	9101132036	2	2017	09101
46	9101142008	21	2017	09101
47	9101142012	41	2017	09101
48	9101142022	7	2017	09101
49	9101142024	1	2017	09101
50	9101142037	5	2017	09101
51	9101142040	25	2017	09101
52	9101142042	18	2017	09101
53	9101142046	7	2017	09101
54	9101142054	127	2017	09101
55	9101142062	29	2017	09101
56	9101142064	4	2017	09101
57	9101142066	1	2017	09101
58	9101152002	33	2017	09101
59	9101152011	8	2017	09101
60	9101152015	2	2017	09101
61	9101152016	7	2017	09101
62	9101152017	14	2017	09101
63	9101152020	7	2017	09101
64	9101152023	2	2017	09101
65	9101152027	11	2017	09101
66	9101152035	2	2017	09101
67	9101152043	2	2017	09101
1380	9102012028	3	2017	09102
1381	9102022011	11	2017	09102
1382	9102022031	4	2017	09102
1383	9102022054	5	2017	09102
1384	9102022901	4	2017	09102
1385	9102032009	2	2017	09102
1386	9102032035	1	2017	09102
1387	9102032037	2	2017	09102
1388	9102032042	4	2017	09102
1389	9102032901	1	2017	09102
1390	9102042004	11	2017	09102
1391	9102042010	12	2017	09102
1392	9102042015	19	2017	09102
1393	9102042029	15	2017	09102
1394	9102042041	3	2017	09102
1395	9102042045	8	2017	09102
1396	9102052018	11	2017	09102
1397	9102052034	3	2017	09102
1398	9102052039	1	2017	09102
1399	9102052040	26	2017	09102
1400	9102052043	6	2017	09102
1401	9102052047	4	2017	09102
1402	9102052055	16	2017	09102
1403	9102062014	5	2017	09102
1404	9102062032	6	2017	09102
1405	9102062044	5	2017	09102
1406	9102062052	1	2017	09102
1407	9102072002	1	2017	09102
1408	9102072003	4	2017	09102
1409	9102072008	5	2017	09102
1410	9102082024	12	2017	09102
1411	9102082027	5	2017	09102
1412	9102082036	1	2017	09102

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
09101	9101072007	21	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101072009	5	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101072010	13	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101072042	17	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101072060	17	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101082007	30	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101102004	445	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101102006	188	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101102018	1	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101102028	152	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101102029	28	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101102034	2	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101102052	1	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101102057	158	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112003	4	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112013	5	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112014	1	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112019	3	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112021	13	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112029	14	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112031	4	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112038	3	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112041	3	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112045	14	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112047	2	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112048	3	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112052	8	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112054	30	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112059	4	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112062	41	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112065	1	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112067	16	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112068	6	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112069	2	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112070	1	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112071	11	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112072	3	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112073	6	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101122051	75	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101122060	24	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101122061	6	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101132015	9	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101132032	2	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101132033	1	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101132036	2	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101142008	21	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101142012	41	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101142022	7	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101142024	1	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101142037	5	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101142040	25	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101142042	18	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101142046	7	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101142054	127	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101142062	29	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101142064	4	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101142066	1	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101152002	33	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101152011	8	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101152015	2	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101152016	7	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101152017	14	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101152020	7	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101152023	2	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101152027	11	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101152035	2	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101152043	2	2017	Temuco	173314.1	2017	282415	48946498862
09102	9102012028	3	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102022011	11	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102022031	4	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102022054	5	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102022901	4	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102032009	2	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102032035	1	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102032037	2	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102032042	4	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102032901	1	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102042004	11	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102042010	12	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102042015	19	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102042029	15	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102042041	3	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102042045	8	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102052018	11	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102052034	3	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102052039	1	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102052040	26	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102052043	6	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102052047	4	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102052055	16	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102062014	5	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102062032	6	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102062044	5	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102062052	1	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102072002	1	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102072003	4	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102072008	5	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102082024	12	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102082027	5	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102082036	1	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102092021	1	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102092024	3	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102092036	3	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102092053	3	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102102026	1	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102102049	1	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102112006	1	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102112019	1	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102112022	2	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102112033	3	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102122016	1	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102122018	3	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102122019	3	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102122024	2	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102122046	4	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102122057	2	2017	Carahue	127924.5	2017	24533	3138372109
09103	9103012016	2	2017	Cunco	156882.5	2017	17526	2749522512
09103	9103012020	5	2017	Cunco	156882.5	2017	17526	2749522512
09103	9103012031	1	2017	Cunco	156882.5	2017	17526	2749522512
09103	9103012045	23	2017	Cunco	156882.5	2017	17526	2749522512
09103	9103022001	28	2017	Cunco	156882.5	2017	17526	2749522512
09103	9103022024	2	2017	Cunco	156882.5	2017	17526	2749522512
09103	9103022025	2	2017	Cunco	156882.5	2017	17526	2749522512
09103	9103022031	7	2017	Cunco	156882.5	2017	17526	2749522512
09103	9103022041	1	2017	Cunco	156882.5	2017	17526	2749522512
09103	9103022042	6	2017	Cunco	156882.5	2017	17526	2749522512
09103	9103032005	12	2017	Cunco	156882.5	2017	17526	2749522512
09103	9103032014	2	2017	Cunco	156882.5	2017	17526	2749522512
09103	9103032015	3	2017	Cunco	156882.5	2017	17526	2749522512
09103	9103032024	1	2017	Cunco	156882.5	2017	17526	2749522512
09103	9103032047	7	2017	Cunco	156882.5	2017	17526	2749522512
09103	9103032901	14	2017	Cunco	156882.5	2017	17526	2749522512
09103	9103042013	1	2017	Cunco	156882.5	2017	17526	2749522512
09103	9103042019	4	2017	Cunco	156882.5	2017	17526	2749522512
09103	9103042027	12	2017	Cunco	156882.5	2017	17526	2749522512
09103	9103052009	3	2017	Cunco	156882.5	2017	17526	2749522512
09103	9103052028	2	2017	Cunco	156882.5	2017	17526	2749522512
09103	9103052032	1	2017	Cunco	156882.5	2017	17526	2749522512
09103	9103052043	2	2017	Cunco	156882.5	2017	17526	2749522512
09103	9103062019	2	2017	Cunco	156882.5	2017	17526	2749522512
09103	9103062022	23	2017	Cunco	156882.5	2017	17526	2749522512
09103	9103062036	11	2017	Cunco	156882.5	2017	17526	2749522512
09103	9103062040	2	2017	Cunco	156882.5	2017	17526	2749522512
09103	9103062901	1	2017	Cunco	156882.5	2017	17526	2749522512
09103	9103072004	3	2017	Cunco	156882.5	2017	17526	2749522512
09103	9103072037	8	2017	Cunco	156882.5	2017	17526	2749522512
09103	9103072901	1	2017	Cunco	156882.5	2017	17526	2749522512
09103	9103082006	1	2017	Cunco	156882.5	2017	17526	2749522512
09103	9103082017	5	2017	Cunco	156882.5	2017	17526	2749522512
09103	9103082023	1	2017	Cunco	156882.5	2017	17526	2749522512
09103	9103082036	11	2017	Cunco	156882.5	2017	17526	2749522512
09103	9103082046	4	2017	Cunco	156882.5	2017	17526	2749522512
09103	9103082901	1	2017	Cunco	156882.5	2017	17526	2749522512
09103	9103092020	36	2017	Cunco	156882.5	2017	17526	2749522512
09103	9103092029	5	2017	Cunco	156882.5	2017	17526	2749522512
09103	9103092034	26	2017	Cunco	156882.5	2017	17526	2749522512
09103	9103102007	18	2017	Cunco	156882.5	2017	17526	2749522512
09103	9103102030	6	2017	Cunco	156882.5	2017	17526	2749522512
09103	9103102039	6	2017	Cunco	156882.5	2017	17526	2749522512
09103	9103102901	6	2017	Cunco	156882.5	2017	17526	2749522512
09103	9103112020	42	2017	Cunco	156882.5	2017	17526	2749522512
09103	9103122003	7	2017	Cunco	156882.5	2017	17526	2749522512
09103	9103122020	3	2017	Cunco	156882.5	2017	17526	2749522512
09104	9104012001	9	2017	Curarrehue	135420.9	2017	7489	1014167156
09104	9104012002	52	2017	Curarrehue	135420.9	2017	7489	1014167156
09104	9104012003	14	2017	Curarrehue	135420.9	2017	7489	1014167156
09104	9104012008	7	2017	Curarrehue	135420.9	2017	7489	1014167156
09104	9104012009	22	2017	Curarrehue	135420.9	2017	7489	1014167156
09104	9104012012	9	2017	Curarrehue	135420.9	2017	7489	1014167156
09104	9104022004	4	2017	Curarrehue	135420.9	2017	7489	1014167156
09104	9104022005	7	2017	Curarrehue	135420.9	2017	7489	1014167156
09104	9104022006	12	2017	Curarrehue	135420.9	2017	7489	1014167156
09104	9104022007	2	2017	Curarrehue	135420.9	2017	7489	1014167156
09104	9104022008	10	2017	Curarrehue	135420.9	2017	7489	1014167156
09104	9104022010	10	2017	Curarrehue	135420.9	2017	7489	1014167156
09104	9104022011	17	2017	Curarrehue	135420.9	2017	7489	1014167156
09105	9105012001	1	2017	Freire	197426.1	2017	24606	4857867695
09105	9105012005	4	2017	Freire	197426.1	2017	24606	4857867695
09105	9105012012	61	2017	Freire	197426.1	2017	24606	4857867695
09105	9105022005	6	2017	Freire	197426.1	2017	24606	4857867695
09105	9105022008	55	2017	Freire	197426.1	2017	24606	4857867695
09105	9105022015	11	2017	Freire	197426.1	2017	24606	4857867695
09105	9105022033	17	2017	Freire	197426.1	2017	24606	4857867695
09105	9105022044	1	2017	Freire	197426.1	2017	24606	4857867695
09105	9105032001	3	2017	Freire	197426.1	2017	24606	4857867695
09105	9105032034	1	2017	Freire	197426.1	2017	24606	4857867695
09105	9105032039	1	2017	Freire	197426.1	2017	24606	4857867695
09105	9105032044	5	2017	Freire	197426.1	2017	24606	4857867695
09105	9105042001	39	2017	Freire	197426.1	2017	24606	4857867695
09105	9105042021	10	2017	Freire	197426.1	2017	24606	4857867695
09105	9105042027	15	2017	Freire	197426.1	2017	24606	4857867695
09105	9105042034	41	2017	Freire	197426.1	2017	24606	4857867695
09105	9105052002	37	2017	Freire	197426.1	2017	24606	4857867695
09105	9105052007	2	2017	Freire	197426.1	2017	24606	4857867695
09105	9105052010	38	2017	Freire	197426.1	2017	24606	4857867695
09105	9105052011	1	2017	Freire	197426.1	2017	24606	4857867695
09105	9105052013	3	2017	Freire	197426.1	2017	24606	4857867695
09105	9105052018	1	2017	Freire	197426.1	2017	24606	4857867695
09105	9105052029	24	2017	Freire	197426.1	2017	24606	4857867695
09105	9105052032	2	2017	Freire	197426.1	2017	24606	4857867695
09105	9105052036	5	2017	Freire	197426.1	2017	24606	4857867695
09105	9105052038	1	2017	Freire	197426.1	2017	24606	4857867695
09105	9105062004	29	2017	Freire	197426.1	2017	24606	4857867695
09105	9105062017	16	2017	Freire	197426.1	2017	24606	4857867695
09105	9105062023	3	2017	Freire	197426.1	2017	24606	4857867695
09105	9105062031	10	2017	Freire	197426.1	2017	24606	4857867695
09105	9105062035	3	2017	Freire	197426.1	2017	24606	4857867695
09105	9105062040	2	2017	Freire	197426.1	2017	24606	4857867695
09105	9105062041	3	2017	Freire	197426.1	2017	24606	4857867695
09105	9105062043	15	2017	Freire	197426.1	2017	24606	4857867695
09105	9105062901	5	2017	Freire	197426.1	2017	24606	4857867695
09105	9105072009	11	2017	Freire	197426.1	2017	24606	4857867695
09105	9105072019	4	2017	Freire	197426.1	2017	24606	4857867695
09105	9105072026	8	2017	Freire	197426.1	2017	24606	4857867695
09105	9105082003	16	2017	Freire	197426.1	2017	24606	4857867695
09105	9105082014	18	2017	Freire	197426.1	2017	24606	4857867695
09105	9105082016	9	2017	Freire	197426.1	2017	24606	4857867695
09105	9105082022	20	2017	Freire	197426.1	2017	24606	4857867695
09105	9105082023	3	2017	Freire	197426.1	2017	24606	4857867695
09105	9105092006	24	2017	Freire	197426.1	2017	24606	4857867695
09105	9105092015	3	2017	Freire	197426.1	2017	24606	4857867695
09105	9105092020	77	2017	Freire	197426.1	2017	24606	4857867695
09105	9105092025	27	2017	Freire	197426.1	2017	24606	4857867695
09105	9105092037	31	2017	Freire	197426.1	2017	24606	4857867695
09105	9105092045	19	2017	Freire	197426.1	2017	24606	4857867695
09106	9106012015	3	2017	Galvarino	147518.2	2017	11996	1769627798
09106	9106022006	2	2017	Galvarino	147518.2	2017	11996	1769627798
09106	9106022010	6	2017	Galvarino	147518.2	2017	11996	1769627798
09106	9106022019	1	2017	Galvarino	147518.2	2017	11996	1769627798
09106	9106022032	3	2017	Galvarino	147518.2	2017	11996	1769627798
09106	9106032002	1	2017	Galvarino	147518.2	2017	11996	1769627798
09106	9106032014	6	2017	Galvarino	147518.2	2017	11996	1769627798
09106	9106032021	10	2017	Galvarino	147518.2	2017	11996	1769627798
09106	9106032024	1	2017	Galvarino	147518.2	2017	11996	1769627798
09106	9106042004	3	2017	Galvarino	147518.2	2017	11996	1769627798
09106	9106042011	2	2017	Galvarino	147518.2	2017	11996	1769627798
09106	9106042018	1	2017	Galvarino	147518.2	2017	11996	1769627798
09106	9106042029	4	2017	Galvarino	147518.2	2017	11996	1769627798
09106	9106042035	2	2017	Galvarino	147518.2	2017	11996	1769627798
09106	9106052019	4	2017	Galvarino	147518.2	2017	11996	1769627798
09106	9106052901	1	2017	Galvarino	147518.2	2017	11996	1769627798
09106	9106062001	2	2017	Galvarino	147518.2	2017	11996	1769627798
09106	9106062008	11	2017	Galvarino	147518.2	2017	11996	1769627798
09106	9106062023	5	2017	Galvarino	147518.2	2017	11996	1769627798
09106	9106062031	1	2017	Galvarino	147518.2	2017	11996	1769627798
09106	9106062036	1	2017	Galvarino	147518.2	2017	11996	1769627798
09106	9106062038	5	2017	Galvarino	147518.2	2017	11996	1769627798
09106	9106062043	4	2017	Galvarino	147518.2	2017	11996	1769627798
09106	9106062045	2	2017	Galvarino	147518.2	2017	11996	1769627798
09106	9106072005	4	2017	Galvarino	147518.2	2017	11996	1769627798
09106	9106072016	3	2017	Galvarino	147518.2	2017	11996	1769627798
09106	9106072034	4	2017	Galvarino	147518.2	2017	11996	1769627798
09106	9106072039	4	2017	Galvarino	147518.2	2017	11996	1769627798
09106	9106082007	2	2017	Galvarino	147518.2	2017	11996	1769627798
09106	9106082020	5	2017	Galvarino	147518.2	2017	11996	1769627798
09106	9106082037	11	2017	Galvarino	147518.2	2017	11996	1769627798
09106	9106082041	1	2017	Galvarino	147518.2	2017	11996	1769627798
09106	9106082043	2	2017	Galvarino	147518.2	2017	11996	1769627798
09106	9106082901	2	2017	Galvarino	147518.2	2017	11996	1769627798
09106	9106092009	1	2017	Galvarino	147518.2	2017	11996	1769627798
09106	9106092012	8	2017	Galvarino	147518.2	2017	11996	1769627798
09106	9106092026	9	2017	Galvarino	147518.2	2017	11996	1769627798
09106	9106092030	9	2017	Galvarino	147518.2	2017	11996	1769627798
09106	9106092901	2	2017	Galvarino	147518.2	2017	11996	1769627798
09107	9107012004	2	2017	Gorbea	140997.5	2017	14414	2032338344
09107	9107012005	3	2017	Gorbea	140997.5	2017	14414	2032338344
09107	9107012017	4	2017	Gorbea	140997.5	2017	14414	2032338344
09107	9107012026	2	2017	Gorbea	140997.5	2017	14414	2032338344
09107	9107022006	14	2017	Gorbea	140997.5	2017	14414	2032338344
09107	9107022013	3	2017	Gorbea	140997.5	2017	14414	2032338344
09107	9107022029	2	2017	Gorbea	140997.5	2017	14414	2032338344
09107	9107022032	2	2017	Gorbea	140997.5	2017	14414	2032338344
09107	9107022041	7	2017	Gorbea	140997.5	2017	14414	2032338344
09107	9107032006	12	2017	Gorbea	140997.5	2017	14414	2032338344
09107	9107032032	15	2017	Gorbea	140997.5	2017	14414	2032338344
09107	9107042016	15	2017	Gorbea	140997.5	2017	14414	2032338344
09107	9107042024	5	2017	Gorbea	140997.5	2017	14414	2032338344
09107	9107042027	3	2017	Gorbea	140997.5	2017	14414	2032338344
09107	9107042032	1	2017	Gorbea	140997.5	2017	14414	2032338344
09107	9107052010	4	2017	Gorbea	140997.5	2017	14414	2032338344
09107	9107052012	3	2017	Gorbea	140997.5	2017	14414	2032338344
09107	9107052033	49	2017	Gorbea	140997.5	2017	14414	2032338344
09107	9107052035	1	2017	Gorbea	140997.5	2017	14414	2032338344
09107	9107052036	13	2017	Gorbea	140997.5	2017	14414	2032338344
09107	9107052037	10	2017	Gorbea	140997.5	2017	14414	2032338344
09107	9107052039	2	2017	Gorbea	140997.5	2017	14414	2032338344
09107	9107052040	3	2017	Gorbea	140997.5	2017	14414	2032338344
09107	9107052901	5	2017	Gorbea	140997.5	2017	14414	2032338344
09107	9107062008	14	2017	Gorbea	140997.5	2017	14414	2032338344
09107	9107062011	12	2017	Gorbea	140997.5	2017	14414	2032338344
09107	9107062031	2	2017	Gorbea	140997.5	2017	14414	2032338344
09107	9107062034	2	2017	Gorbea	140997.5	2017	14414	2032338344
09107	9107072010	3	2017	Gorbea	140997.5	2017	14414	2032338344
09107	9107072012	1	2017	Gorbea	140997.5	2017	14414	2032338344
09107	9107072019	3	2017	Gorbea	140997.5	2017	14414	2032338344
09107	9107072020	6	2017	Gorbea	140997.5	2017	14414	2032338344
09107	9107072038	3	2017	Gorbea	140997.5	2017	14414	2032338344
09107	9107082022	1	2017	Gorbea	140997.5	2017	14414	2032338344
09107	9107082025	1	2017	Gorbea	140997.5	2017	14414	2032338344
09107	9107082030	2	2017	Gorbea	140997.5	2017	14414	2032338344
09107	9107092002	5	2017	Gorbea	140997.5	2017	14414	2032338344
09107	9107092009	1	2017	Gorbea	140997.5	2017	14414	2032338344
09107	9107092010	1	2017	Gorbea	140997.5	2017	14414	2032338344
09107	9107092014	2	2017	Gorbea	140997.5	2017	14414	2032338344
09108	9108012045	4	2017	Lautaro	282496.1	2017	38013	10738525406
09108	9108022022	13	2017	Lautaro	282496.1	2017	38013	10738525406
09108	9108022901	6	2017	Lautaro	282496.1	2017	38013	10738525406
09108	9108032020	9	2017	Lautaro	282496.1	2017	38013	10738525406
09108	9108032026	6	2017	Lautaro	282496.1	2017	38013	10738525406
09108	9108042046	3	2017	Lautaro	282496.1	2017	38013	10738525406
09108	9108042050	6	2017	Lautaro	282496.1	2017	38013	10738525406
09108	9108052039	2	2017	Lautaro	282496.1	2017	38013	10738525406
09108	9108052901	2	2017	Lautaro	282496.1	2017	38013	10738525406
09108	9108062001	16	2017	Lautaro	282496.1	2017	38013	10738525406
09108	9108062002	6	2017	Lautaro	282496.1	2017	38013	10738525406
09108	9108062008	2	2017	Lautaro	282496.1	2017	38013	10738525406
09108	9108062015	2	2017	Lautaro	282496.1	2017	38013	10738525406
09108	9108062031	1	2017	Lautaro	282496.1	2017	38013	10738525406
09108	9108062038	8	2017	Lautaro	282496.1	2017	38013	10738525406
09108	9108072016	18	2017	Lautaro	282496.1	2017	38013	10738525406
09108	9108072034	7	2017	Lautaro	282496.1	2017	38013	10738525406
09108	9108082025	3	2017	Lautaro	282496.1	2017	38013	10738525406
09108	9108082035	1	2017	Lautaro	282496.1	2017	38013	10738525406
09108	9108082048	2	2017	Lautaro	282496.1	2017	38013	10738525406
09108	9108092051	3	2017	Lautaro	282496.1	2017	38013	10738525406
09108	9108102007	4	2017	Lautaro	282496.1	2017	38013	10738525406
09108	9108102016	30	2017	Lautaro	282496.1	2017	38013	10738525406
09108	9108112012	12	2017	Lautaro	282496.1	2017	38013	10738525406
09108	9108112013	55	2017	Lautaro	282496.1	2017	38013	10738525406
09108	9108112024	1	2017	Lautaro	282496.1	2017	38013	10738525406
09108	9108112040	11	2017	Lautaro	282496.1	2017	38013	10738525406
09108	9108122012	57	2017	Lautaro	282496.1	2017	38013	10738525406
09108	9108122033	2	2017	Lautaro	282496.1	2017	38013	10738525406
09108	9108122041	22	2017	Lautaro	282496.1	2017	38013	10738525406
09108	9108122042	17	2017	Lautaro	282496.1	2017	38013	10738525406
09108	9108132006	2	2017	Lautaro	282496.1	2017	38013	10738525406
09108	9108132009	13	2017	Lautaro	282496.1	2017	38013	10738525406
09108	9108132011	18	2017	Lautaro	282496.1	2017	38013	10738525406
09108	9108132027	8	2017	Lautaro	282496.1	2017	38013	10738525406
09108	9108132028	6	2017	Lautaro	282496.1	2017	38013	10738525406
09108	9108132030	7	2017	Lautaro	282496.1	2017	38013	10738525406
09108	9108132043	1	2017	Lautaro	282496.1	2017	38013	10738525406
09108	9108132049	3	2017	Lautaro	282496.1	2017	38013	10738525406
09108	9108132901	2	2017	Lautaro	282496.1	2017	38013	10738525406
09108	9108142004	3	2017	Lautaro	282496.1	2017	38013	10738525406
09108	9108142005	2	2017	Lautaro	282496.1	2017	38013	10738525406
09108	9108142017	2	2017	Lautaro	282496.1	2017	38013	10738525406
09108	9108142032	7	2017	Lautaro	282496.1	2017	38013	10738525406
09108	9108142036	3	2017	Lautaro	282496.1	2017	38013	10738525406
09108	9108142037	2	2017	Lautaro	282496.1	2017	38013	10738525406
09108	9108142044	18	2017	Lautaro	282496.1	2017	38013	10738525406
09109	9109012006	34	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109012030	11	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109012037	6	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109012040	4	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109012053	21	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109022009	6	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109022901	4	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109032007	12	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109032022	21	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109032023	3	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109032028	3	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109032036	2	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109032040	4	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109032054	11	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109042013	3	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109042036	2	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109042047	1	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109042901	1	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109052032	1	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109052043	1	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109062001	2	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109062008	11	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109062025	1	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109062034	17	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109062037	1	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109062048	11	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109062049	7	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109072015	2	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109072027	18	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109072031	5	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109072035	2	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109072038	14	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109072042	1	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109072045	7	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109072052	15	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109082004	16	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109082014	9	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109082021	4	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109082027	8	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109082034	6	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109082044	5	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109092002	4	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109092012	2	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109092026	4	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109092041	7	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109092044	1	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109092901	1	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109102011	4	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109102016	1	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109102017	5	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109102020	1	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109102041	5	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109102046	1	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109112005	3	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109112020	2	2017	Loncoche	160742.5	2017	23612	3795451798
09109	9109112039	1	2017	Loncoche	160742.5	2017	23612	3795451798
09110	9110012002	2	2017	Melipeuco	164670.1	2017	6138	1010744848
09110	9110012004	3	2017	Melipeuco	164670.1	2017	6138	1010744848
09110	9110012006	1	2017	Melipeuco	164670.1	2017	6138	1010744848
09110	9110012007	35	2017	Melipeuco	164670.1	2017	6138	1010744848
09110	9110012009	13	2017	Melipeuco	164670.1	2017	6138	1010744848
09110	9110012011	1	2017	Melipeuco	164670.1	2017	6138	1010744848
09110	9110012012	13	2017	Melipeuco	164670.1	2017	6138	1010744848
09110	9110012014	8	2017	Melipeuco	164670.1	2017	6138	1010744848
09110	9110012016	15	2017	Melipeuco	164670.1	2017	6138	1010744848
09110	9110012901	2	2017	Melipeuco	164670.1	2017	6138	1010744848
09110	9110022001	8	2017	Melipeuco	164670.1	2017	6138	1010744848
09110	9110022003	2	2017	Melipeuco	164670.1	2017	6138	1010744848
09110	9110022005	1	2017	Melipeuco	164670.1	2017	6138	1010744848
09110	9110022008	2	2017	Melipeuco	164670.1	2017	6138	1010744848
09110	9110022010	8	2017	Melipeuco	164670.1	2017	6138	1010744848
09110	9110022014	5	2017	Melipeuco	164670.1	2017	6138	1010744848
09110	9110022015	30	2017	Melipeuco	164670.1	2017	6138	1010744848
09111	9111012076	47	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111022035	29	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111022045	4	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111022058	1	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111022073	1	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111032028	36	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111032038	2	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111042012	9	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111042053	10	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111052005	1	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111052020	2	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111052031	3	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111052039	4	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111052040	4	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111052050	15	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111052052	3	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111052060	1	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111052071	28	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111052075	1	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111062018	4	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111062032	15	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111062038	6	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111062049	4	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111062057	9	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111062067	8	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111062068	18	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111072013	4	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111082006	2	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111082011	4	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111082017	1	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111082021	4	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111082024	4	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111082043	1	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111082046	4	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111082055	2	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111082078	1	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111082080	2	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111092003	1	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111092016	7	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111092022	3	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111092025	46	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111092029	1	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111092035	6	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111092048	3	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111092065	24	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111092070	4	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111092079	85	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111102001	5	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111102009	15	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111102026	1	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111102027	1	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111102036	1	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111102047	5	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111102061	3	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111102069	10	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111112004	4	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111112007	1	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111112010	19	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111112019	4	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111112030	1	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111112051	1	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111112054	1	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111112059	1	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111112062	6	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111112064	2	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111112072	3	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111112081	16	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09111	9111112901	1	2017	Nueva Imperial	158196.8	2017	32510	5142978907
09112	9112012010	16	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112012017	4	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112012037	13	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112012041	4	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112012050	41	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112012058	6	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112012059	24	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112012060	1	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112012061	2	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112012062	2	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112012063	4	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112012077	5	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112012089	1	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112012105	2	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112012113	12	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112012901	9	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112022008	4	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112022009	21	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112022025	12	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112022047	18	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112022049	1	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112022057	10	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112022064	24	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112022065	10	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112022070	40	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112022085	3	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112032007	32	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112032034	6	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112032038	23	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112032039	65	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112032053	53	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112032082	16	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112032095	57	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112032103	13	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112042040	9	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112042066	4	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112042108	12	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112052038	9	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112052090	5	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112062001	19	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112062015	23	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112062019	17	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112062023	5	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112062028	1	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112062031	1	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112062032	6	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112062068	8	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112062072	9	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112072018	3	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112072027	130	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112072029	22	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112072030	9	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112072042	1	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112072048	19	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112072074	5	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112072084	5	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112072086	7	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112072087	10	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112072088	21	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112072099	23	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112072104	10	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112072107	12	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112072111	25	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112072112	5	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112072901	5	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112082011	7	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112082012	1	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112082021	10	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112082036	1	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112082042	11	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112082051	2	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112082053	132	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112082056	16	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112082075	2	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112082079	22	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112082099	47	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112082100	2	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112082111	7	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112092003	4	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112092006	3	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112092014	4	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112092016	3	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112092022	5	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112092026	4	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112092052	2	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112092054	1	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112092055	1	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112092067	5	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112092073	26	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112092076	3	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112092093	16	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112092096	5	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112092101	1	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112092108	33	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112102004	1	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112102005	4	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112102013	5	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112102020	2	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112102024	1	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112102033	3	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112102035	11	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112102043	18	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112102044	9	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112102045	1	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112102046	3	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112102069	10	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112102078	1	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112102080	20	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112102091	4	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112102094	1	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112102106	4	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112102109	79	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09112	9112102110	4	2017	Padre Las Casas	169223.7	2017	76126	12882320064
09113	9113012001	14	2017	Perquenco	155106.7	2017	6905	1071011969
09113	9113012003	8	2017	Perquenco	155106.7	2017	6905	1071011969
09113	9113012008	6	2017	Perquenco	155106.7	2017	6905	1071011969
09113	9113012014	4	2017	Perquenco	155106.7	2017	6905	1071011969
09113	9113012901	4	2017	Perquenco	155106.7	2017	6905	1071011969
09113	9113022004	8	2017	Perquenco	155106.7	2017	6905	1071011969
09113	9113022011	6	2017	Perquenco	155106.7	2017	6905	1071011969
09113	9113032002	1	2017	Perquenco	155106.7	2017	6905	1071011969
09113	9113032007	4	2017	Perquenco	155106.7	2017	6905	1071011969
09113	9113032009	8	2017	Perquenco	155106.7	2017	6905	1071011969
09113	9113032013	4	2017	Perquenco	155106.7	2017	6905	1071011969
09113	9113042006	2	2017	Perquenco	155106.7	2017	6905	1071011969
09113	9113042012	8	2017	Perquenco	155106.7	2017	6905	1071011969
09114	9114012022	15	2017	Pitrufquén	205557.8	2017	24837	5105439315
09114	9114012030	21	2017	Pitrufquén	205557.8	2017	24837	5105439315
09114	9114022006	22	2017	Pitrufquén	205557.8	2017	24837	5105439315
09114	9114022007	27	2017	Pitrufquén	205557.8	2017	24837	5105439315
09114	9114022016	14	2017	Pitrufquén	205557.8	2017	24837	5105439315
09114	9114022024	59	2017	Pitrufquén	205557.8	2017	24837	5105439315
09114	9114022901	1	2017	Pitrufquén	205557.8	2017	24837	5105439315
09114	9114032001	1	2017	Pitrufquén	205557.8	2017	24837	5105439315
09114	9114032002	4	2017	Pitrufquén	205557.8	2017	24837	5105439315
09114	9114032003	2	2017	Pitrufquén	205557.8	2017	24837	5105439315
09114	9114032015	5	2017	Pitrufquén	205557.8	2017	24837	5105439315
09114	9114032017	1	2017	Pitrufquén	205557.8	2017	24837	5105439315
09114	9114032019	3	2017	Pitrufquén	205557.8	2017	24837	5105439315
09114	9114032020	7	2017	Pitrufquén	205557.8	2017	24837	5105439315
09114	9114032026	3	2017	Pitrufquén	205557.8	2017	24837	5105439315
09114	9114042005	3	2017	Pitrufquén	205557.8	2017	24837	5105439315
09114	9114042011	1	2017	Pitrufquén	205557.8	2017	24837	5105439315
09114	9114042012	21	2017	Pitrufquén	205557.8	2017	24837	5105439315
09114	9114042014	31	2017	Pitrufquén	205557.8	2017	24837	5105439315
09114	9114042017	10	2017	Pitrufquén	205557.8	2017	24837	5105439315
09114	9114042020	14	2017	Pitrufquén	205557.8	2017	24837	5105439315
09114	9114042033	17	2017	Pitrufquén	205557.8	2017	24837	5105439315
09114	9114042034	3	2017	Pitrufquén	205557.8	2017	24837	5105439315
09114	9114052004	13	2017	Pitrufquén	205557.8	2017	24837	5105439315
09114	9114052006	7	2017	Pitrufquén	205557.8	2017	24837	5105439315
09114	9114052007	2	2017	Pitrufquén	205557.8	2017	24837	5105439315
09114	9114052018	25	2017	Pitrufquén	205557.8	2017	24837	5105439315
09114	9114052025	2	2017	Pitrufquén	205557.8	2017	24837	5105439315
09114	9114052032	13	2017	Pitrufquén	205557.8	2017	24837	5105439315
09114	9114052035	3	2017	Pitrufquén	205557.8	2017	24837	5105439315
09114	9114062008	3	2017	Pitrufquén	205557.8	2017	24837	5105439315
09114	9114062009	17	2017	Pitrufquén	205557.8	2017	24837	5105439315
09114	9114062023	9	2017	Pitrufquén	205557.8	2017	24837	5105439315
09114	9114062025	42	2017	Pitrufquén	205557.8	2017	24837	5105439315
09114	9114062027	3	2017	Pitrufquén	205557.8	2017	24837	5105439315
09114	9114062031	10	2017	Pitrufquén	205557.8	2017	24837	5105439315
09114	9114072008	5	2017	Pitrufquén	205557.8	2017	24837	5105439315
09114	9114072010	15	2017	Pitrufquén	205557.8	2017	24837	5105439315
09114	9114072021	6	2017	Pitrufquén	205557.8	2017	24837	5105439315
09114	9114072029	11	2017	Pitrufquén	205557.8	2017	24837	5105439315
09115	9115012007	2	2017	Pucón	187764.8	2017	28523	5355614570
09115	9115012018	3	2017	Pucón	187764.8	2017	28523	5355614570
09115	9115012019	24	2017	Pucón	187764.8	2017	28523	5355614570
09115	9115022002	115	2017	Pucón	187764.8	2017	28523	5355614570
09115	9115022006	83	2017	Pucón	187764.8	2017	28523	5355614570
09115	9115022007	4	2017	Pucón	187764.8	2017	28523	5355614570
09115	9115022008	38	2017	Pucón	187764.8	2017	28523	5355614570
09115	9115022009	115	2017	Pucón	187764.8	2017	28523	5355614570
09115	9115022013	41	2017	Pucón	187764.8	2017	28523	5355614570
09115	9115032001	122	2017	Pucón	187764.8	2017	28523	5355614570
09115	9115032003	62	2017	Pucón	187764.8	2017	28523	5355614570
09115	9115032004	24	2017	Pucón	187764.8	2017	28523	5355614570
09115	9115032015	36	2017	Pucón	187764.8	2017	28523	5355614570
09115	9115042005	1	2017	Pucón	187764.8	2017	28523	5355614570
09115	9115042010	11	2017	Pucón	187764.8	2017	28523	5355614570
09115	9115042014	10	2017	Pucón	187764.8	2017	28523	5355614570
09115	9115042017	49	2017	Pucón	187764.8	2017	28523	5355614570
09115	9115042020	130	2017	Pucón	187764.8	2017	28523	5355614570
09115	9115042021	6	2017	Pucón	187764.8	2017	28523	5355614570
09115	9115042022	7	2017	Pucón	187764.8	2017	28523	5355614570
09115	9115042024	17	2017	Pucón	187764.8	2017	28523	5355614570
09115	9115042025	8	2017	Pucón	187764.8	2017	28523	5355614570
09115	9115052008	66	2017	Pucón	187764.8	2017	28523	5355614570
09115	9115052011	11	2017	Pucón	187764.8	2017	28523	5355614570
09115	9115052012	43	2017	Pucón	187764.8	2017	28523	5355614570
09115	9115052016	17	2017	Pucón	187764.8	2017	28523	5355614570
09115	9115062023	2	2017	Pucón	187764.8	2017	28523	5355614570
09116	9116012002	8	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116012007	2	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116012008	1	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116012027	2	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116012035	2	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116012042	37	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116012043	2	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116012044	2	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116012045	3	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116012056	6	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116012060	2	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116012062	2	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116022001	1	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116022004	1	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116022005	1	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116022009	1	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116022015	2	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116022016	1	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116022018	1	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116022020	2	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116022021	10	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116022038	5	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116022047	9	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116022050	1	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116022057	12	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116022061	5	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116022070	3	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116022901	12	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116032012	1	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116032024	4	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116032033	2	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116032036	10	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116032037	3	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116032049	2	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116032054	2	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116032055	42	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116032058	4	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116032065	3	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116032068	4	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116042010	1	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116042022	1	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116042029	9	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116042030	1	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116042034	1	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116042051	10	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116042052	1	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116042053	1	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116042063	1	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116042064	2	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116042069	2	2017	Saavedra	130775.6	2017	12450	1628156299
09116	9116042901	3	2017	Saavedra	130775.6	2017	12450	1628156299
09117	9117012002	13	2017	Teodoro Schmidt	138894.2	2017	15045	2089663239
09117	9117012004	6	2017	Teodoro Schmidt	138894.2	2017	15045	2089663239
09117	9117012045	5	2017	Teodoro Schmidt	138894.2	2017	15045	2089663239
09117	9117022016	3	2017	Teodoro Schmidt	138894.2	2017	15045	2089663239
09117	9117022021	2	2017	Teodoro Schmidt	138894.2	2017	15045	2089663239
09117	9117022030	1	2017	Teodoro Schmidt	138894.2	2017	15045	2089663239
09117	9117022031	4	2017	Teodoro Schmidt	138894.2	2017	15045	2089663239
09117	9117022037	7	2017	Teodoro Schmidt	138894.2	2017	15045	2089663239
09117	9117032008	2	2017	Teodoro Schmidt	138894.2	2017	15045	2089663239
09117	9117032015	3	2017	Teodoro Schmidt	138894.2	2017	15045	2089663239
09117	9117032027	6	2017	Teodoro Schmidt	138894.2	2017	15045	2089663239
09117	9117032042	10	2017	Teodoro Schmidt	138894.2	2017	15045	2089663239
09117	9117032046	2	2017	Teodoro Schmidt	138894.2	2017	15045	2089663239
09117	9117042003	43	2017	Teodoro Schmidt	138894.2	2017	15045	2089663239
09117	9117042015	3	2017	Teodoro Schmidt	138894.2	2017	15045	2089663239
09117	9117042022	2	2017	Teodoro Schmidt	138894.2	2017	15045	2089663239
09117	9117042023	5	2017	Teodoro Schmidt	138894.2	2017	15045	2089663239
09117	9117042033	4	2017	Teodoro Schmidt	138894.2	2017	15045	2089663239
09117	9117042039	7	2017	Teodoro Schmidt	138894.2	2017	15045	2089663239
09117	9117052019	1	2017	Teodoro Schmidt	138894.2	2017	15045	2089663239
09117	9117052033	11	2017	Teodoro Schmidt	138894.2	2017	15045	2089663239
09117	9117052037	7	2017	Teodoro Schmidt	138894.2	2017	15045	2089663239
09117	9117052048	1	2017	Teodoro Schmidt	138894.2	2017	15045	2089663239
09117	9117062006	4	2017	Teodoro Schmidt	138894.2	2017	15045	2089663239
09117	9117062014	6	2017	Teodoro Schmidt	138894.2	2017	15045	2089663239
09117	9117062020	8	2017	Teodoro Schmidt	138894.2	2017	15045	2089663239
09117	9117062025	4	2017	Teodoro Schmidt	138894.2	2017	15045	2089663239
09117	9117062028	1	2017	Teodoro Schmidt	138894.2	2017	15045	2089663239
09117	9117062034	6	2017	Teodoro Schmidt	138894.2	2017	15045	2089663239
09117	9117062041	1	2017	Teodoro Schmidt	138894.2	2017	15045	2089663239
09117	9117062050	1	2017	Teodoro Schmidt	138894.2	2017	15045	2089663239
09117	9117072006	12	2017	Teodoro Schmidt	138894.2	2017	15045	2089663239
09117	9117072007	1	2017	Teodoro Schmidt	138894.2	2017	15045	2089663239
09117	9117072010	3	2017	Teodoro Schmidt	138894.2	2017	15045	2089663239
09117	9117072017	4	2017	Teodoro Schmidt	138894.2	2017	15045	2089663239
09117	9117072018	6	2017	Teodoro Schmidt	138894.2	2017	15045	2089663239
09117	9117072026	1	2017	Teodoro Schmidt	138894.2	2017	15045	2089663239
09117	9117072047	2	2017	Teodoro Schmidt	138894.2	2017	15045	2089663239
09117	9117082007	8	2017	Teodoro Schmidt	138894.2	2017	15045	2089663239
09117	9117082026	3	2017	Teodoro Schmidt	138894.2	2017	15045	2089663239
09117	9117082032	4	2017	Teodoro Schmidt	138894.2	2017	15045	2089663239
09117	9117082036	7	2017	Teodoro Schmidt	138894.2	2017	15045	2089663239
09117	9117082038	2	2017	Teodoro Schmidt	138894.2	2017	15045	2089663239
09118	9118012016	6	2017	Toltén	113791.8	2017	9722	1106284328
09118	9118012019	8	2017	Toltén	113791.8	2017	9722	1106284328
09118	9118012026	2	2017	Toltén	113791.8	2017	9722	1106284328
09118	9118012035	3	2017	Toltén	113791.8	2017	9722	1106284328
09118	9118012039	1	2017	Toltén	113791.8	2017	9722	1106284328
09118	9118012046	1	2017	Toltén	113791.8	2017	9722	1106284328
09118	9118012047	15	2017	Toltén	113791.8	2017	9722	1106284328
09118	9118012901	10	2017	Toltén	113791.8	2017	9722	1106284328
09118	9118022005	1	2017	Toltén	113791.8	2017	9722	1106284328
09118	9118022017	1	2017	Toltén	113791.8	2017	9722	1106284328
09118	9118022018	3	2017	Toltén	113791.8	2017	9722	1106284328
09118	9118022024	2	2017	Toltén	113791.8	2017	9722	1106284328
09118	9118022031	7	2017	Toltén	113791.8	2017	9722	1106284328
09118	9118022034	3	2017	Toltén	113791.8	2017	9722	1106284328
09118	9118022038	3	2017	Toltén	113791.8	2017	9722	1106284328
09118	9118032003	3	2017	Toltén	113791.8	2017	9722	1106284328
09118	9118032015	9	2017	Toltén	113791.8	2017	9722	1106284328
09118	9118032032	17	2017	Toltén	113791.8	2017	9722	1106284328
09118	9118032049	24	2017	Toltén	113791.8	2017	9722	1106284328
09118	9118032901	2	2017	Toltén	113791.8	2017	9722	1106284328
09118	9118042002	3	2017	Toltén	113791.8	2017	9722	1106284328
09118	9118042008	2	2017	Toltén	113791.8	2017	9722	1106284328
09118	9118042032	7	2017	Toltén	113791.8	2017	9722	1106284328
09118	9118042036	2	2017	Toltén	113791.8	2017	9722	1106284328
09118	9118042040	7	2017	Toltén	113791.8	2017	9722	1106284328
09118	9118042043	3	2017	Toltén	113791.8	2017	9722	1106284328
09118	9118052042	1	2017	Toltén	113791.8	2017	9722	1106284328
09118	9118052048	2	2017	Toltén	113791.8	2017	9722	1106284328
09118	9118052049	1	2017	Toltén	113791.8	2017	9722	1106284328
09118	9118062021	2	2017	Toltén	113791.8	2017	9722	1106284328
09118	9118072001	4	2017	Toltén	113791.8	2017	9722	1106284328
09118	9118072004	2	2017	Toltén	113791.8	2017	9722	1106284328
09118	9118072005	1	2017	Toltén	113791.8	2017	9722	1106284328
09118	9118072007	13	2017	Toltén	113791.8	2017	9722	1106284328
09118	9118072037	5	2017	Toltén	113791.8	2017	9722	1106284328
09118	9118072901	1	2017	Toltén	113791.8	2017	9722	1106284328
09119	9119012019	57	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119012022	4	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119012027	10	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119012028	21	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119012031	37	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119012051	11	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119012059	5	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119022052	28	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119022058	16	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119022901	6	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119032006	6	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119032010	4	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119032021	1	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119032036	3	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119032050	4	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119032055	7	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119032901	3	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119042008	4	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119042033	12	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119042047	6	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119042057	8	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119052002	21	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119052017	15	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119052025	8	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119052034	102	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119052040	26	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119052049	25	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119062012	2	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119062016	7	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119062037	8	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119062038	5	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119062053	6	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119062054	1	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119062901	5	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119072003	2	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119072010	7	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119072014	3	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119072042	4	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119072901	4	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119082901	2	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119092005	2	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119092007	15	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119092013	14	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119092020	11	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119092023	3	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119092030	1	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119092901	1	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119102004	8	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119102044	1	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119112018	5	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119112023	8	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119112041	12	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119112045	7	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119112046	4	2017	Vilcún	135602.8	2017	28151	3817354634
09119	9119112901	3	2017	Vilcún	135602.8	2017	28151	3817354634
09120	9120022027	23	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120032024	6	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120042014	18	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120042026	15	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120042028	19	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120042033	61	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120042037	189	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120042044	8	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120042053	72	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120052002	48	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120052003	21	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120052005	5	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120052009	8	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120052013	43	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120052014	82	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120052015	2	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120052017	13	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120052019	66	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120052023	5	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120052026	39	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120052028	14	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120052031	16	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120052035	128	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120052042	24	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120052050	18	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120052901	3	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120062007	45	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120062009	10	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120062016	53	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120062029	18	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120062043	3	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120072001	17	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120072008	6	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120072010	13	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120072011	17	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120072016	12	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120072029	3	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120072901	1	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120082004	5	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120082005	10	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120082013	55	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120082023	12	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120082030	23	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120082048	7	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120082051	6	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120092004	1	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120092032	13	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120092036	26	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120092039	124	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120092046	169	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120092055	4	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120092901	2	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120102012	44	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120102020	1	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120102021	43	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120102040	20	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120102041	2	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120102045	154	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120102052	37	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120102901	3	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120112006	24	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120112025	3	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120112040	14	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120122018	3	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120122022	12	2017	Villarrica	198745.4	2017	55478	11026000004
09120	9120122049	20	2017	Villarrica	198745.4	2017	55478	11026000004
09121	9121012001	1	2017	Cholchol	115103.4	2017	11611	1336465909
09121	9121012014	1	2017	Cholchol	115103.4	2017	11611	1336465909
09121	9121012016	1	2017	Cholchol	115103.4	2017	11611	1336465909
09121	9121012025	1	2017	Cholchol	115103.4	2017	11611	1336465909
09121	9121012027	1	2017	Cholchol	115103.4	2017	11611	1336465909
09121	9121012031	1	2017	Cholchol	115103.4	2017	11611	1336465909
09121	9121012035	2	2017	Cholchol	115103.4	2017	11611	1336465909
09121	9121012042	2	2017	Cholchol	115103.4	2017	11611	1336465909
09121	9121012050	4	2017	Cholchol	115103.4	2017	11611	1336465909
09121	9121012052	1	2017	Cholchol	115103.4	2017	11611	1336465909
09121	9121012059	16	2017	Cholchol	115103.4	2017	11611	1336465909
09121	9121022012	4	2017	Cholchol	115103.4	2017	11611	1336465909
09121	9121022018	5	2017	Cholchol	115103.4	2017	11611	1336465909
09121	9121022019	1	2017	Cholchol	115103.4	2017	11611	1336465909
09121	9121022033	6	2017	Cholchol	115103.4	2017	11611	1336465909
09121	9121022047	3	2017	Cholchol	115103.4	2017	11611	1336465909
09121	9121022048	2	2017	Cholchol	115103.4	2017	11611	1336465909
09121	9121022049	3	2017	Cholchol	115103.4	2017	11611	1336465909
09121	9121022051	1	2017	Cholchol	115103.4	2017	11611	1336465909
09121	9121022901	4	2017	Cholchol	115103.4	2017	11611	1336465909
09121	9121032003	1	2017	Cholchol	115103.4	2017	11611	1336465909
09121	9121032006	3	2017	Cholchol	115103.4	2017	11611	1336465909
09121	9121032007	2	2017	Cholchol	115103.4	2017	11611	1336465909
09121	9121032029	3	2017	Cholchol	115103.4	2017	11611	1336465909
09121	9121032036	8	2017	Cholchol	115103.4	2017	11611	1336465909
09121	9121032901	1	2017	Cholchol	115103.4	2017	11611	1336465909
09121	9121042002	5	2017	Cholchol	115103.4	2017	11611	1336465909
09121	9121042004	3	2017	Cholchol	115103.4	2017	11611	1336465909
09121	9121042011	2	2017	Cholchol	115103.4	2017	11611	1336465909
09121	9121042028	6	2017	Cholchol	115103.4	2017	11611	1336465909
09121	9121042034	64	2017	Cholchol	115103.4	2017	11611	1336465909
09121	9121042040	3	2017	Cholchol	115103.4	2017	11611	1336465909
09121	9121042041	1	2017	Cholchol	115103.4	2017	11611	1336465909
09121	9121042045	7	2017	Cholchol	115103.4	2017	11611	1336465909
09121	9121042057	7	2017	Cholchol	115103.4	2017	11611	1336465909
09121	9121042064	23	2017	Cholchol	115103.4	2017	11611	1336465909
09121	9121042901	9	2017	Cholchol	115103.4	2017	11611	1336465909
09121	9121052006	2	2017	Cholchol	115103.4	2017	11611	1336465909
09121	9121052011	12	2017	Cholchol	115103.4	2017	11611	1336465909
09121	9121052021	8	2017	Cholchol	115103.4	2017	11611	1336465909
09121	9121052061	3	2017	Cholchol	115103.4	2017	11611	1336465909
09121	9121052062	2	2017	Cholchol	115103.4	2017	11611	1336465909
09121	9121052066	2	2017	Cholchol	115103.4	2017	11611	1336465909
09121	9121052901	1	2017	Cholchol	115103.4	2017	11611	1336465909
09201	9201032015	4	2017	Angol	173377.3	2017	53262	9234420713
09201	9201042020	12	2017	Angol	173377.3	2017	53262	9234420713
09201	9201042901	1	2017	Angol	173377.3	2017	53262	9234420713
09201	9201052054	1	2017	Angol	173377.3	2017	53262	9234420713
09201	9201052901	4	2017	Angol	173377.3	2017	53262	9234420713
09201	9201062011	1	2017	Angol	173377.3	2017	53262	9234420713
09201	9201062054	2	2017	Angol	173377.3	2017	53262	9234420713
09201	9201072901	1	2017	Angol	173377.3	2017	53262	9234420713
09201	9201082008	1	2017	Angol	173377.3	2017	53262	9234420713
09201	9201082013	1	2017	Angol	173377.3	2017	53262	9234420713
09201	9201082014	1	2017	Angol	173377.3	2017	53262	9234420713
09201	9201082046	1	2017	Angol	173377.3	2017	53262	9234420713
09201	9201082901	2	2017	Angol	173377.3	2017	53262	9234420713
09201	9201102006	6	2017	Angol	173377.3	2017	53262	9234420713
09201	9201102007	3	2017	Angol	173377.3	2017	53262	9234420713
09201	9201102022	4	2017	Angol	173377.3	2017	53262	9234420713
09201	9201102023	4	2017	Angol	173377.3	2017	53262	9234420713
09201	9201102040	5	2017	Angol	173377.3	2017	53262	9234420713
09201	9201102052	5	2017	Angol	173377.3	2017	53262	9234420713
09201	9201102901	2	2017	Angol	173377.3	2017	53262	9234420713
09201	9201112029	9	2017	Angol	173377.3	2017	53262	9234420713
09201	9201122012	1	2017	Angol	173377.3	2017	53262	9234420713
09201	9201122901	11	2017	Angol	173377.3	2017	53262	9234420713
09201	9201132004	5	2017	Angol	173377.3	2017	53262	9234420713
09201	9201132005	48	2017	Angol	173377.3	2017	53262	9234420713
09201	9201132018	15	2017	Angol	173377.3	2017	53262	9234420713
09201	9201132019	24	2017	Angol	173377.3	2017	53262	9234420713
09201	9201132021	28	2017	Angol	173377.3	2017	53262	9234420713
09201	9201132029	6	2017	Angol	173377.3	2017	53262	9234420713
09201	9201132031	9	2017	Angol	173377.3	2017	53262	9234420713
09201	9201142010	4	2017	Angol	173377.3	2017	53262	9234420713
09201	9201142049	10	2017	Angol	173377.3	2017	53262	9234420713
09201	9201142053	2	2017	Angol	173377.3	2017	53262	9234420713
09202	9202012001	4	2017	Collipulli	182323.1	2017	24598	4484784762
09202	9202022001	2	2017	Collipulli	182323.1	2017	24598	4484784762
09202	9202022003	7	2017	Collipulli	182323.1	2017	24598	4484784762
09202	9202022006	3	2017	Collipulli	182323.1	2017	24598	4484784762
09202	9202042012	13	2017	Collipulli	182323.1	2017	24598	4484784762
09202	9202042901	2	2017	Collipulli	182323.1	2017	24598	4484784762
09202	9202052014	2	2017	Collipulli	182323.1	2017	24598	4484784762
09202	9202052023	4	2017	Collipulli	182323.1	2017	24598	4484784762
09202	9202052901	2	2017	Collipulli	182323.1	2017	24598	4484784762
09202	9202062011	27	2017	Collipulli	182323.1	2017	24598	4484784762
09202	9202062018	11	2017	Collipulli	182323.1	2017	24598	4484784762
09202	9202062024	1	2017	Collipulli	182323.1	2017	24598	4484784762
09202	9202072024	5	2017	Collipulli	182323.1	2017	24598	4484784762
09202	9202072025	2	2017	Collipulli	182323.1	2017	24598	4484784762
09202	9202072901	1	2017	Collipulli	182323.1	2017	24598	4484784762
09202	9202082007	25	2017	Collipulli	182323.1	2017	24598	4484784762
09202	9202082901	5	2017	Collipulli	182323.1	2017	24598	4484784762
09202	9202092015	1	2017	Collipulli	182323.1	2017	24598	4484784762
09202	9202092019	7	2017	Collipulli	182323.1	2017	24598	4484784762
09202	9202102013	5	2017	Collipulli	182323.1	2017	24598	4484784762
09202	9202102027	3	2017	Collipulli	182323.1	2017	24598	4484784762
09202	9202112026	10	2017	Collipulli	182323.1	2017	24598	4484784762
09202	9202112901	2	2017	Collipulli	182323.1	2017	24598	4484784762
09202	9202122010	1	2017	Collipulli	182323.1	2017	24598	4484784762
09202	9202122022	1	2017	Collipulli	182323.1	2017	24598	4484784762
09202	9202132002	3	2017	Collipulli	182323.1	2017	24598	4484784762
09202	9202132029	1	2017	Collipulli	182323.1	2017	24598	4484784762
09203	9203012014	1	2017	Curacautín	186604.9	2017	17413	3249351008
09203	9203012035	4	2017	Curacautín	186604.9	2017	17413	3249351008
09203	9203012037	1	2017	Curacautín	186604.9	2017	17413	3249351008
09203	9203012043	2	2017	Curacautín	186604.9	2017	17413	3249351008
09203	9203022001	5	2017	Curacautín	186604.9	2017	17413	3249351008
09203	9203022017	12	2017	Curacautín	186604.9	2017	17413	3249351008
09203	9203032033	4	2017	Curacautín	186604.9	2017	17413	3249351008
09203	9203032034	1	2017	Curacautín	186604.9	2017	17413	3249351008
09203	9203032901	6	2017	Curacautín	186604.9	2017	17413	3249351008
09203	9203042023	1	2017	Curacautín	186604.9	2017	17413	3249351008
09203	9203042026	1	2017	Curacautín	186604.9	2017	17413	3249351008
09203	9203042049	1	2017	Curacautín	186604.9	2017	17413	3249351008
09203	9203042901	2	2017	Curacautín	186604.9	2017	17413	3249351008
09203	9203052010	4	2017	Curacautín	186604.9	2017	17413	3249351008
09203	9203052018	14	2017	Curacautín	186604.9	2017	17413	3249351008
09203	9203052032	14	2017	Curacautín	186604.9	2017	17413	3249351008
09203	9203052046	9	2017	Curacautín	186604.9	2017	17413	3249351008
09203	9203062005	3	2017	Curacautín	186604.9	2017	17413	3249351008
09203	9203062013	7	2017	Curacautín	186604.9	2017	17413	3249351008
09203	9203062022	4	2017	Curacautín	186604.9	2017	17413	3249351008
09203	9203062025	1	2017	Curacautín	186604.9	2017	17413	3249351008
09203	9203062028	15	2017	Curacautín	186604.9	2017	17413	3249351008
09203	9203062047	21	2017	Curacautín	186604.9	2017	17413	3249351008
09203	9203062901	5	2017	Curacautín	186604.9	2017	17413	3249351008
09203	9203072004	1	2017	Curacautín	186604.9	2017	17413	3249351008
09203	9203072027	103	2017	Curacautín	186604.9	2017	17413	3249351008
09203	9203082015	1	2017	Curacautín	186604.9	2017	17413	3249351008
09203	9203082016	5	2017	Curacautín	186604.9	2017	17413	3249351008
09203	9203082021	3	2017	Curacautín	186604.9	2017	17413	3249351008
09203	9203082036	3	2017	Curacautín	186604.9	2017	17413	3249351008
09203	9203082901	5	2017	Curacautín	186604.9	2017	17413	3249351008
09203	9203092007	22	2017	Curacautín	186604.9	2017	17413	3249351008
09203	9203092015	8	2017	Curacautín	186604.9	2017	17413	3249351008
09203	9203102029	1	2017	Curacautín	186604.9	2017	17413	3249351008
09203	9203102040	4	2017	Curacautín	186604.9	2017	17413	3249351008
09203	9203102041	16	2017	Curacautín	186604.9	2017	17413	3249351008
09203	9203102042	3	2017	Curacautín	186604.9	2017	17413	3249351008
09203	9203102044	12	2017	Curacautín	186604.9	2017	17413	3249351008
09203	9203102048	6	2017	Curacautín	186604.9	2017	17413	3249351008
09204	9204012001	1	2017	Ercilla	136678.7	2017	7733	1056936411
09204	9204012010	9	2017	Ercilla	136678.7	2017	7733	1056936411
09204	9204012011	2	2017	Ercilla	136678.7	2017	7733	1056936411
09204	9204012018	2	2017	Ercilla	136678.7	2017	7733	1056936411
09204	9204012021	1	2017	Ercilla	136678.7	2017	7733	1056936411
09204	9204012022	8	2017	Ercilla	136678.7	2017	7733	1056936411
09204	9204012901	9	2017	Ercilla	136678.7	2017	7733	1056936411
09204	9204022015	3	2017	Ercilla	136678.7	2017	7733	1056936411
09204	9204022901	2	2017	Ercilla	136678.7	2017	7733	1056936411
09204	9204032004	7	2017	Ercilla	136678.7	2017	7733	1056936411
09204	9204032016	14	2017	Ercilla	136678.7	2017	7733	1056936411
09204	9204042002	1	2017	Ercilla	136678.7	2017	7733	1056936411
09204	9204042027	4	2017	Ercilla	136678.7	2017	7733	1056936411
09204	9204042901	1	2017	Ercilla	136678.7	2017	7733	1056936411
09204	9204052005	2	2017	Ercilla	136678.7	2017	7733	1056936411
09204	9204052007	2	2017	Ercilla	136678.7	2017	7733	1056936411
09204	9204052020	18	2017	Ercilla	136678.7	2017	7733	1056936411
09204	9204052025	1	2017	Ercilla	136678.7	2017	7733	1056936411
09204	9204052028	1	2017	Ercilla	136678.7	2017	7733	1056936411
09205	9205012001	3	2017	Lonquimay	138745.9	2017	10251	1422283764
09205	9205012003	5	2017	Lonquimay	138745.9	2017	10251	1422283764
09205	9205012017	6	2017	Lonquimay	138745.9	2017	10251	1422283764
09205	9205012028	3	2017	Lonquimay	138745.9	2017	10251	1422283764
09205	9205012030	4	2017	Lonquimay	138745.9	2017	10251	1422283764
09205	9205022006	2	2017	Lonquimay	138745.9	2017	10251	1422283764
09205	9205032005	2	2017	Lonquimay	138745.9	2017	10251	1422283764
09205	9205032027	6	2017	Lonquimay	138745.9	2017	10251	1422283764
09205	9205032031	10	2017	Lonquimay	138745.9	2017	10251	1422283764
09205	9205032901	1	2017	Lonquimay	138745.9	2017	10251	1422283764
09205	9205052016	1	2017	Lonquimay	138745.9	2017	10251	1422283764
09205	9205052019	6	2017	Lonquimay	138745.9	2017	10251	1422283764
09205	9205062013	19	2017	Lonquimay	138745.9	2017	10251	1422283764
09205	9205062023	5	2017	Lonquimay	138745.9	2017	10251	1422283764
09205	9205072010	2	2017	Lonquimay	138745.9	2017	10251	1422283764
09205	9205072016	1	2017	Lonquimay	138745.9	2017	10251	1422283764
09205	9205072021	4	2017	Lonquimay	138745.9	2017	10251	1422283764
09205	9205072022	18	2017	Lonquimay	138745.9	2017	10251	1422283764
09205	9205082007	3	2017	Lonquimay	138745.9	2017	10251	1422283764
09205	9205082009	6	2017	Lonquimay	138745.9	2017	10251	1422283764
09205	9205082011	33	2017	Lonquimay	138745.9	2017	10251	1422283764
09205	9205082018	1	2017	Lonquimay	138745.9	2017	10251	1422283764
09205	9205082029	1	2017	Lonquimay	138745.9	2017	10251	1422283764
09206	9206012030	2	2017	Los Sauces	142588.7	2017	7265	1035906610
09206	9206012901	1	2017	Los Sauces	142588.7	2017	7265	1035906610
09206	9206022011	1	2017	Los Sauces	142588.7	2017	7265	1035906610
09206	9206022029	1	2017	Los Sauces	142588.7	2017	7265	1035906610
09206	9206022901	1	2017	Los Sauces	142588.7	2017	7265	1035906610
09206	9206032014	1	2017	Los Sauces	142588.7	2017	7265	1035906610
09206	9206032050	6	2017	Los Sauces	142588.7	2017	7265	1035906610
09206	9206042024	2	2017	Los Sauces	142588.7	2017	7265	1035906610
09206	9206042031	1	2017	Los Sauces	142588.7	2017	7265	1035906610
09206	9206042047	1	2017	Los Sauces	142588.7	2017	7265	1035906610
09206	9206052032	1	2017	Los Sauces	142588.7	2017	7265	1035906610
09206	9206062045	1	2017	Los Sauces	142588.7	2017	7265	1035906610
09206	9206072003	3	2017	Los Sauces	142588.7	2017	7265	1035906610
09206	9206072013	4	2017	Los Sauces	142588.7	2017	7265	1035906610
09206	9206072016	4	2017	Los Sauces	142588.7	2017	7265	1035906610
09206	9206082010	1	2017	Los Sauces	142588.7	2017	7265	1035906610
09206	9206082038	3	2017	Los Sauces	142588.7	2017	7265	1035906610
09206	9206082044	1	2017	Los Sauces	142588.7	2017	7265	1035906610
09206	9206092028	1	2017	Los Sauces	142588.7	2017	7265	1035906610
09206	9206092901	5	2017	Los Sauces	142588.7	2017	7265	1035906610
09207	9207012075	1	2017	Lumaco	170538.2	2017	9548	1628298886
09207	9207022021	1	2017	Lumaco	170538.2	2017	9548	1628298886
09207	9207022042	4	2017	Lumaco	170538.2	2017	9548	1628298886
09207	9207022069	5	2017	Lumaco	170538.2	2017	9548	1628298886
09207	9207022071	3	2017	Lumaco	170538.2	2017	9548	1628298886
09207	9207022901	4	2017	Lumaco	170538.2	2017	9548	1628298886
09207	9207032029	4	2017	Lumaco	170538.2	2017	9548	1628298886
09207	9207032063	4	2017	Lumaco	170538.2	2017	9548	1628298886
09207	9207032073	1	2017	Lumaco	170538.2	2017	9548	1628298886
09207	9207042019	1	2017	Lumaco	170538.2	2017	9548	1628298886
09207	9207042022	2	2017	Lumaco	170538.2	2017	9548	1628298886
09207	9207042028	2	2017	Lumaco	170538.2	2017	9548	1628298886
09207	9207042061	2	2017	Lumaco	170538.2	2017	9548	1628298886
09207	9207042074	1	2017	Lumaco	170538.2	2017	9548	1628298886
09207	9207042901	2	2017	Lumaco	170538.2	2017	9548	1628298886
09207	9207052024	1	2017	Lumaco	170538.2	2017	9548	1628298886
09207	9207052038	1	2017	Lumaco	170538.2	2017	9548	1628298886
09207	9207052051	1	2017	Lumaco	170538.2	2017	9548	1628298886
09207	9207052064	15	2017	Lumaco	170538.2	2017	9548	1628298886
09207	9207052065	2	2017	Lumaco	170538.2	2017	9548	1628298886
09207	9207062020	1	2017	Lumaco	170538.2	2017	9548	1628298886
09207	9207062030	1	2017	Lumaco	170538.2	2017	9548	1628298886
09207	9207062057	3	2017	Lumaco	170538.2	2017	9548	1628298886
09207	9207072027	1	2017	Lumaco	170538.2	2017	9548	1628298886
09207	9207082009	1	2017	Lumaco	170538.2	2017	9548	1628298886
09207	9207082901	2	2017	Lumaco	170538.2	2017	9548	1628298886
09207	9207092007	2	2017	Lumaco	170538.2	2017	9548	1628298886
09207	9207092010	3	2017	Lumaco	170538.2	2017	9548	1628298886
09207	9207102017	5	2017	Lumaco	170538.2	2017	9548	1628298886
09207	9207102049	1	2017	Lumaco	170538.2	2017	9548	1628298886
09207	9207102901	1	2017	Lumaco	170538.2	2017	9548	1628298886
09208	9208012003	8	2017	Purén	133537.6	2017	11779	1572938990
09208	9208022004	2	2017	Purén	133537.6	2017	11779	1572938990
09208	9208022022	1	2017	Purén	133537.6	2017	11779	1572938990
09208	9208022040	7	2017	Purén	133537.6	2017	11779	1572938990
09208	9208032004	1	2017	Purén	133537.6	2017	11779	1572938990
09208	9208032007	3	2017	Purén	133537.6	2017	11779	1572938990
09208	9208032011	1	2017	Purén	133537.6	2017	11779	1572938990
09208	9208032012	2	2017	Purén	133537.6	2017	11779	1572938990
09208	9208032015	2	2017	Purén	133537.6	2017	11779	1572938990
09208	9208032016	6	2017	Purén	133537.6	2017	11779	1572938990
09208	9208032017	1	2017	Purén	133537.6	2017	11779	1572938990
09208	9208032019	3	2017	Purén	133537.6	2017	11779	1572938990
09208	9208032021	4	2017	Purén	133537.6	2017	11779	1572938990
09208	9208032022	1	2017	Purén	133537.6	2017	11779	1572938990
09208	9208032036	1	2017	Purén	133537.6	2017	11779	1572938990
09208	9208042005	21	2017	Purén	133537.6	2017	11779	1572938990
09208	9208042009	1	2017	Purén	133537.6	2017	11779	1572938990
09208	9208042024	1	2017	Purén	133537.6	2017	11779	1572938990
09208	9208042029	1	2017	Purén	133537.6	2017	11779	1572938990
09208	9208042030	1	2017	Purén	133537.6	2017	11779	1572938990
09208	9208042038	7	2017	Purén	133537.6	2017	11779	1572938990
09208	9208052031	1	2017	Purén	133537.6	2017	11779	1572938990
09208	9208052032	1	2017	Purén	133537.6	2017	11779	1572938990
09208	9208062023	7	2017	Purén	133537.6	2017	11779	1572938990
09208	9208062028	2	2017	Purén	133537.6	2017	11779	1572938990
09208	9208062901	1	2017	Purén	133537.6	2017	11779	1572938990
09209	9209012013	3	2017	Renaico	218920.0	2017	10250	2243930000
09209	9209012014	8	2017	Renaico	218920.0	2017	10250	2243930000
09209	9209012015	4	2017	Renaico	218920.0	2017	10250	2243930000
09209	9209022002	3	2017	Renaico	218920.0	2017	10250	2243930000
09209	9209022003	2	2017	Renaico	218920.0	2017	10250	2243930000
09209	9209022009	6	2017	Renaico	218920.0	2017	10250	2243930000
09209	9209022011	3	2017	Renaico	218920.0	2017	10250	2243930000
09209	9209022016	5	2017	Renaico	218920.0	2017	10250	2243930000
09209	9209022017	3	2017	Renaico	218920.0	2017	10250	2243930000
09209	9209022018	1	2017	Renaico	218920.0	2017	10250	2243930000
09209	9209022020	5	2017	Renaico	218920.0	2017	10250	2243930000
09209	9209022901	1	2017	Renaico	218920.0	2017	10250	2243930000
09209	9209032006	2	2017	Renaico	218920.0	2017	10250	2243930000
09209	9209032008	3	2017	Renaico	218920.0	2017	10250	2243930000
09209	9209032010	20	2017	Renaico	218920.0	2017	10250	2243930000
09209	9209032019	8	2017	Renaico	218920.0	2017	10250	2243930000
09209	9209032022	13	2017	Renaico	218920.0	2017	10250	2243930000
09209	9209032901	2	2017	Renaico	218920.0	2017	10250	2243930000
09209	9209042023	1	2017	Renaico	218920.0	2017	10250	2243930000
09209	9209042901	9	2017	Renaico	218920.0	2017	10250	2243930000
09210	9210022025	14	2017	Traiguén	210526.3	2017	18843	3966946195
09210	9210042901	1	2017	Traiguén	210526.3	2017	18843	3966946195
09210	9210052901	13	2017	Traiguén	210526.3	2017	18843	3966946195
09210	9210062019	3	2017	Traiguén	210526.3	2017	18843	3966946195
09210	9210062901	2	2017	Traiguén	210526.3	2017	18843	3966946195
09210	9210072023	1	2017	Traiguén	210526.3	2017	18843	3966946195
09210	9210072031	6	2017	Traiguén	210526.3	2017	18843	3966946195
09210	9210072048	1	2017	Traiguén	210526.3	2017	18843	3966946195
09210	9210072055	1	2017	Traiguén	210526.3	2017	18843	3966946195
09210	9210072901	3	2017	Traiguén	210526.3	2017	18843	3966946195
09210	9210082006	1	2017	Traiguén	210526.3	2017	18843	3966946195
09210	9210082009	1	2017	Traiguén	210526.3	2017	18843	3966946195
09210	9210082053	5	2017	Traiguén	210526.3	2017	18843	3966946195
09210	9210082901	2	2017	Traiguén	210526.3	2017	18843	3966946195
09210	9210092010	7	2017	Traiguén	210526.3	2017	18843	3966946195
09210	9210092042	2	2017	Traiguén	210526.3	2017	18843	3966946195
09210	9210092049	1	2017	Traiguén	210526.3	2017	18843	3966946195
09210	9210092051	10	2017	Traiguén	210526.3	2017	18843	3966946195
09210	9210092052	7	2017	Traiguén	210526.3	2017	18843	3966946195
09210	9210092068	4	2017	Traiguén	210526.3	2017	18843	3966946195
09210	9210102002	1	2017	Traiguén	210526.3	2017	18843	3966946195
09210	9210102014	1	2017	Traiguén	210526.3	2017	18843	3966946195
09210	9210102017	3	2017	Traiguén	210526.3	2017	18843	3966946195
09210	9210102062	2	2017	Traiguén	210526.3	2017	18843	3966946195
09210	9210102067	3	2017	Traiguén	210526.3	2017	18843	3966946195
09210	9210112007	1	2017	Traiguén	210526.3	2017	18843	3966946195
09210	9210112044	1	2017	Traiguén	210526.3	2017	18843	3966946195
09210	9210122004	5	2017	Traiguén	210526.3	2017	18843	3966946195
09210	9210122026	1	2017	Traiguén	210526.3	2017	18843	3966946195
09210	9210122050	1	2017	Traiguén	210526.3	2017	18843	3966946195
09210	9210122073	1	2017	Traiguén	210526.3	2017	18843	3966946195
09210	9210122901	3	2017	Traiguén	210526.3	2017	18843	3966946195
09210	9210132047	1	2017	Traiguén	210526.3	2017	18843	3966946195
09210	9210132048	1	2017	Traiguén	210526.3	2017	18843	3966946195
09210	9210142003	1	2017	Traiguén	210526.3	2017	18843	3966946195
09210	9210142015	2	2017	Traiguén	210526.3	2017	18843	3966946195
09210	9210142047	3	2017	Traiguén	210526.3	2017	18843	3966946195
09211	9211042031	11	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211052074	2	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211052901	1	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211062013	2	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211062035	6	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211062072	1	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211062088	2	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211062901	4	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211072009	5	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211072038	2	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211072057	1	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211072070	1	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211082076	1	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211082901	1	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211092010	6	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211092071	3	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211092093	2	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211092901	4	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211102006	1	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211102038	8	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211102044	2	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211102056	3	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211102087	12	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211112004	2	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211112045	3	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211112089	25	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211122011	3	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211122024	1	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211122029	8	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211122058	6	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211122068	2	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211122081	20	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211122086	7	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211132023	5	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211132040	8	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211132085	1	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211132091	5	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211142049	7	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211142063	27	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211152005	1	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211152008	3	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211152060	6	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211152064	7	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211152066	24	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211162019	1	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211162022	2	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211162062	1	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211162077	1	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211162085	26	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211172031	10	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211172053	33	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211172065	11	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211172901	9	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211192017	1	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211192036	1	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211192078	1	2017	Victoria	187662.8	2017	34182	6414689393
09211	9211192901	1	2017	Victoria	187662.8	2017	34182	6414689393

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
09101	9101072007	21	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101072009	5	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101072010	13	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101072042	17	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101072060	17	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101082007	30	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101102004	445	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101102006	188	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101102018	1	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101102028	152	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101102029	28	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101102034	2	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101102052	1	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101102057	158	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112003	4	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112013	5	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112014	1	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112019	3	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112021	13	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112029	14	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112031	4	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112038	3	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112041	3	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112045	14	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112047	2	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112048	3	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112052	8	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112054	30	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112059	4	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112062	41	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112065	1	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112067	16	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112068	6	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112069	2	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112070	1	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112071	11	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112072	3	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101112073	6	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101122051	75	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101122060	24	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101122061	6	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101132015	9	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101132032	2	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101132033	1	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101132036	2	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101142008	21	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101142012	41	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101142022	7	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101142024	1	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101142037	5	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101142040	25	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101142042	18	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101142046	7	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101142054	127	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101142062	29	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101142064	4	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101142066	1	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101152002	33	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101152011	8	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101152015	2	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101152016	7	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101152017	14	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101152020	7	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101152023	2	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101152027	11	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101152035	2	2017	Temuco	173314.1	2017	282415	48946498862
09101	9101152043	2	2017	Temuco	173314.1	2017	282415	48946498862
09102	9102012028	3	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102022011	11	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102022031	4	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102022054	5	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102022901	4	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102032009	2	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102032035	1	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102032037	2	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102032042	4	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102032901	1	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102042004	11	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102042010	12	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102042015	19	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102042029	15	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102042041	3	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102042045	8	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102052018	11	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102052034	3	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102052039	1	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102052040	26	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102052043	6	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102052047	4	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102052055	16	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102062014	5	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102062032	6	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102062044	5	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102062052	1	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102072002	1	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102072003	4	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102072008	5	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102082024	12	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102082027	5	2017	Carahue	127924.5	2017	24533	3138372109
09102	9102082036	1	2017	Carahue	127924.5	2017	24533	3138372109

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
9101072007	09101	21	2017	Temuco	173314.1	2017	282415	48946498862	60	0.0002125	09101
9101072009	09101	5	2017	Temuco	173314.1	2017	282415	48946498862	16	0.0000567	09101
9101072010	09101	13	2017	Temuco	173314.1	2017	282415	48946498862	43	0.0001523	09101
9101072042	09101	17	2017	Temuco	173314.1	2017	282415	48946498862	59	0.0002089	09101
9101072060	09101	17	2017	Temuco	173314.1	2017	282415	48946498862	61	0.0002160	09101
9101082007	09101	30	2017	Temuco	173314.1	2017	282415	48946498862	79	0.0002797	09101
9101102004	09101	445	2017	Temuco	173314.1	2017	282415	48946498862	3065	0.0108528	09101
9101102006	09101	188	2017	Temuco	173314.1	2017	282415	48946498862	726	0.0025707	09101
9101102018	09101	1	2017	Temuco	173314.1	2017	282415	48946498862	25	0.0000885	09101
9101102028	09101	152	2017	Temuco	173314.1	2017	282415	48946498862	843	0.0029850	09101
9101102029	09101	28	2017	Temuco	173314.1	2017	282415	48946498862	496	0.0017563	09101
9101102034	09101	2	2017	Temuco	173314.1	2017	282415	48946498862	172	0.0006090	09101
9101102052	09101	1	2017	Temuco	173314.1	2017	282415	48946498862	25	0.0000885	09101
9101102057	09101	158	2017	Temuco	173314.1	2017	282415	48946498862	1762	0.0062390	09101
9101112003	09101	4	2017	Temuco	173314.1	2017	282415	48946498862	133	0.0004709	09101
9101112013	09101	5	2017	Temuco	173314.1	2017	282415	48946498862	214	0.0007578	09101
9101112014	09101	1	2017	Temuco	173314.1	2017	282415	48946498862	62	0.0002195	09101
9101112019	09101	3	2017	Temuco	173314.1	2017	282415	48946498862	142	0.0005028	09101
9101112021	09101	13	2017	Temuco	173314.1	2017	282415	48946498862	419	0.0014836	09101
9101112029	09101	14	2017	Temuco	173314.1	2017	282415	48946498862	181	0.0006409	09101
9101112031	09101	4	2017	Temuco	173314.1	2017	282415	48946498862	92	0.0003258	09101
9101112038	09101	3	2017	Temuco	173314.1	2017	282415	48946498862	89	0.0003151	09101
9101112041	09101	3	2017	Temuco	173314.1	2017	282415	48946498862	116	0.0004107	09101
9101112045	09101	14	2017	Temuco	173314.1	2017	282415	48946498862	292	0.0010339	09101
9101112047	09101	2	2017	Temuco	173314.1	2017	282415	48946498862	124	0.0004391	09101
9101112048	09101	3	2017	Temuco	173314.1	2017	282415	48946498862	146	0.0005170	09101
9101112052	09101	8	2017	Temuco	173314.1	2017	282415	48946498862	100	0.0003541	09101
9101112054	09101	30	2017	Temuco	173314.1	2017	282415	48946498862	443	0.0015686	09101
9101112059	09101	4	2017	Temuco	173314.1	2017	282415	48946498862	136	0.0004816	09101
9101112062	09101	41	2017	Temuco	173314.1	2017	282415	48946498862	167	0.0005913	09101
9101112065	09101	1	2017	Temuco	173314.1	2017	282415	48946498862	83	0.0002939	09101
9101112067	09101	16	2017	Temuco	173314.1	2017	282415	48946498862	514	0.0018200	09101
9101112068	09101	6	2017	Temuco	173314.1	2017	282415	48946498862	433	0.0015332	09101
9101112069	09101	2	2017	Temuco	173314.1	2017	282415	48946498862	129	0.0004568	09101
9101112070	09101	1	2017	Temuco	173314.1	2017	282415	48946498862	325	0.0011508	09101
9101112071	09101	11	2017	Temuco	173314.1	2017	282415	48946498862	230	0.0008144	09101
9101112072	09101	3	2017	Temuco	173314.1	2017	282415	48946498862	165	0.0005842	09101
9101112073	09101	6	2017	Temuco	173314.1	2017	282415	48946498862	132	0.0004674	09101
9101122051	09101	75	2017	Temuco	173314.1	2017	282415	48946498862	357	0.0012641	09101
9101122060	09101	24	2017	Temuco	173314.1	2017	282415	48946498862	80	0.0002833	09101
9101122061	09101	6	2017	Temuco	173314.1	2017	282415	48946498862	21	0.0000744	09101
9101132015	09101	9	2017	Temuco	173314.1	2017	282415	48946498862	125	0.0004426	09101
9101132032	09101	2	2017	Temuco	173314.1	2017	282415	48946498862	17	0.0000602	09101
9101132033	09101	1	2017	Temuco	173314.1	2017	282415	48946498862	36	0.0001275	09101
9101132036	09101	2	2017	Temuco	173314.1	2017	282415	48946498862	35	0.0001239	09101
9101142008	09101	21	2017	Temuco	173314.1	2017	282415	48946498862	438	0.0015509	09101
9101142012	09101	41	2017	Temuco	173314.1	2017	282415	48946498862	136	0.0004816	09101
9101142022	09101	7	2017	Temuco	173314.1	2017	282415	48946498862	90	0.0003187	09101
9101142024	09101	1	2017	Temuco	173314.1	2017	282415	48946498862	57	0.0002018	09101
9101142037	09101	5	2017	Temuco	173314.1	2017	282415	48946498862	48	0.0001700	09101
9101142040	09101	25	2017	Temuco	173314.1	2017	282415	48946498862	218	0.0007719	09101
9101142042	09101	18	2017	Temuco	173314.1	2017	282415	48946498862	426	0.0015084	09101
9101142046	09101	7	2017	Temuco	173314.1	2017	282415	48946498862	44	0.0001558	09101
9101142054	09101	127	2017	Temuco	173314.1	2017	282415	48946498862	1860	0.0065861	09101
9101142062	09101	29	2017	Temuco	173314.1	2017	282415	48946498862	113	0.0004001	09101
9101142064	09101	4	2017	Temuco	173314.1	2017	282415	48946498862	111	0.0003930	09101
9101142066	09101	1	2017	Temuco	173314.1	2017	282415	48946498862	65	0.0002302	09101
9101152002	09101	33	2017	Temuco	173314.1	2017	282415	48946498862	933	0.0033036	09101
9101152011	09101	8	2017	Temuco	173314.1	2017	282415	48946498862	290	0.0010269	09101
9101152015	09101	2	2017	Temuco	173314.1	2017	282415	48946498862	32	0.0001133	09101
9101152016	09101	7	2017	Temuco	173314.1	2017	282415	48946498862	120	0.0004249	09101
9101152017	09101	14	2017	Temuco	173314.1	2017	282415	48946498862	317	0.0011225	09101
9101152020	09101	7	2017	Temuco	173314.1	2017	282415	48946498862	101	0.0003576	09101
9101152023	09101	2	2017	Temuco	173314.1	2017	282415	48946498862	111	0.0003930	09101
9101152027	09101	11	2017	Temuco	173314.1	2017	282415	48946498862	148	0.0005241	09101
9101152035	09101	2	2017	Temuco	173314.1	2017	282415	48946498862	73	0.0002585	09101
9101152043	09101	2	2017	Temuco	173314.1	2017	282415	48946498862	83	0.0002939	09101
9102012028	09102	3	2017	Carahue	127924.5	2017	24533	3138372109	25	0.0010190	09102
9102022011	09102	11	2017	Carahue	127924.5	2017	24533	3138372109	327	0.0133290	09102
9102022031	09102	4	2017	Carahue	127924.5	2017	24533	3138372109	163	0.0066441	09102
9102022054	09102	5	2017	Carahue	127924.5	2017	24533	3138372109	190	0.0077447	09102
9102022901	09102	4	2017	Carahue	127924.5	2017	24533	3138372109	103	0.0041984	09102
9102032009	09102	2	2017	Carahue	127924.5	2017	24533	3138372109	496	0.0202177	09102
9102032035	09102	1	2017	Carahue	127924.5	2017	24533	3138372109	255	0.0103942	09102
9102032037	09102	2	2017	Carahue	127924.5	2017	24533	3138372109	104	0.0042392	09102
9102032042	09102	4	2017	Carahue	127924.5	2017	24533	3138372109	190	0.0077447	09102
9102032901	09102	1	2017	Carahue	127924.5	2017	24533	3138372109	52	0.0021196	09102
9102042004	09102	11	2017	Carahue	127924.5	2017	24533	3138372109	221	0.0090083	09102
9102042010	09102	12	2017	Carahue	127924.5	2017	24533	3138372109	302	0.0123099	09102
9102042015	09102	19	2017	Carahue	127924.5	2017	24533	3138372109	430	0.0175274	09102
9102042029	09102	15	2017	Carahue	127924.5	2017	24533	3138372109	215	0.0087637	09102
9102042041	09102	3	2017	Carahue	127924.5	2017	24533	3138372109	138	0.0056251	09102
9102042045	09102	8	2017	Carahue	127924.5	2017	24533	3138372109	205	0.0083561	09102
9102052018	09102	11	2017	Carahue	127924.5	2017	24533	3138372109	338	0.0137774	09102
9102052034	09102	3	2017	Carahue	127924.5	2017	24533	3138372109	273	0.0111279	09102
9102052039	09102	1	2017	Carahue	127924.5	2017	24533	3138372109	54	0.0022011	09102
9102052040	09102	26	2017	Carahue	127924.5	2017	24533	3138372109	730	0.0297558	09102
9102052043	09102	6	2017	Carahue	127924.5	2017	24533	3138372109	246	0.0100273	09102
9102052047	09102	4	2017	Carahue	127924.5	2017	24533	3138372109	327	0.0133290	09102
9102052055	09102	16	2017	Carahue	127924.5	2017	24533	3138372109	216	0.0088045	09102
9102062014	09102	5	2017	Carahue	127924.5	2017	24533	3138372109	264	0.0107610	09102
9102062032	09102	6	2017	Carahue	127924.5	2017	24533	3138372109	409	0.0166714	09102
9102062044	09102	5	2017	Carahue	127924.5	2017	24533	3138372109	222	0.0090490	09102
9102062052	09102	1	2017	Carahue	127924.5	2017	24533	3138372109	106	0.0043207	09102
9102072002	09102	1	2017	Carahue	127924.5	2017	24533	3138372109	72	0.0029348	09102
9102072003	09102	4	2017	Carahue	127924.5	2017	24533	3138372109	542	0.0220927	09102
9102072008	09102	5	2017	Carahue	127924.5	2017	24533	3138372109	260	0.0105980	09102
9102082024	09102	12	2017	Carahue	127924.5	2017	24533	3138372109	307	0.0125138	09102
9102082027	09102	5	2017	Carahue	127924.5	2017	24533	3138372109	218	0.0088860	09102
9102082036	09102	1	2017	Carahue	127924.5	2017	24533	3138372109	201	0.0081930	09102

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
9101072007	09101	21	2017	Temuco	173314.1	2017	282415	48946498862	60	0.0002125	09101	10398845
9101072009	09101	5	2017	Temuco	173314.1	2017	282415	48946498862	16	0.0000567	09101	2773025
9101072010	09101	13	2017	Temuco	173314.1	2017	282415	48946498862	43	0.0001523	09101	7452506
9101072042	09101	17	2017	Temuco	173314.1	2017	282415	48946498862	59	0.0002089	09101	10225531
9101072060	09101	17	2017	Temuco	173314.1	2017	282415	48946498862	61	0.0002160	09101	10572160
9101082007	09101	30	2017	Temuco	173314.1	2017	282415	48946498862	79	0.0002797	09101	13691813
9101102004	09101	445	2017	Temuco	173314.1	2017	282415	48946498862	3065	0.0108528	09101	531207687
9101102006	09101	188	2017	Temuco	173314.1	2017	282415	48946498862	726	0.0025707	09101	125826030
9101102018	09101	1	2017	Temuco	173314.1	2017	282415	48946498862	25	0.0000885	09101	4332852
9101102028	09101	152	2017	Temuco	173314.1	2017	282415	48946498862	843	0.0029850	09101	146103778
9101102029	09101	28	2017	Temuco	173314.1	2017	282415	48946498862	496	0.0017563	09101	85963789
9101102034	09101	2	2017	Temuco	173314.1	2017	282415	48946498862	172	0.0006090	09101	29810024
9101102052	09101	1	2017	Temuco	173314.1	2017	282415	48946498862	25	0.0000885	09101	4332852
9101102057	09101	158	2017	Temuco	173314.1	2017	282415	48946498862	1762	0.0062390	09101	305379427
9101112003	09101	4	2017	Temuco	173314.1	2017	282415	48946498862	133	0.0004709	09101	23050774
9101112013	09101	5	2017	Temuco	173314.1	2017	282415	48946498862	214	0.0007578	09101	37089215
9101112014	09101	1	2017	Temuco	173314.1	2017	282415	48946498862	62	0.0002195	09101	10745474
9101112019	09101	3	2017	Temuco	173314.1	2017	282415	48946498862	142	0.0005028	09101	24610601
9101112021	09101	13	2017	Temuco	173314.1	2017	282415	48946498862	419	0.0014836	09101	72618604
9101112029	09101	14	2017	Temuco	173314.1	2017	282415	48946498862	181	0.0006409	09101	31369850
9101112031	09101	4	2017	Temuco	173314.1	2017	282415	48946498862	92	0.0003258	09101	15944896
9101112038	09101	3	2017	Temuco	173314.1	2017	282415	48946498862	89	0.0003151	09101	15424954
9101112041	09101	3	2017	Temuco	173314.1	2017	282415	48946498862	116	0.0004107	09101	20104434
9101112045	09101	14	2017	Temuco	173314.1	2017	282415	48946498862	292	0.0010339	09101	50607714
9101112047	09101	2	2017	Temuco	173314.1	2017	282415	48946498862	124	0.0004391	09101	21490947
9101112048	09101	3	2017	Temuco	173314.1	2017	282415	48946498862	146	0.0005170	09101	25303857
9101112052	09101	8	2017	Temuco	173314.1	2017	282415	48946498862	100	0.0003541	09101	17331409
9101112054	09101	30	2017	Temuco	173314.1	2017	282415	48946498862	443	0.0015686	09101	76778142
9101112059	09101	4	2017	Temuco	173314.1	2017	282415	48946498862	136	0.0004816	09101	23570716
9101112062	09101	41	2017	Temuco	173314.1	2017	282415	48946498862	167	0.0005913	09101	28943453
9101112065	09101	1	2017	Temuco	173314.1	2017	282415	48946498862	83	0.0002939	09101	14385070
9101112067	09101	16	2017	Temuco	173314.1	2017	282415	48946498862	514	0.0018200	09101	89083443
9101112068	09101	6	2017	Temuco	173314.1	2017	282415	48946498862	433	0.0015332	09101	75045001
9101112069	09101	2	2017	Temuco	173314.1	2017	282415	48946498862	129	0.0004568	09101	22357518
9101112070	09101	1	2017	Temuco	173314.1	2017	282415	48946498862	325	0.0011508	09101	56327079
9101112071	09101	11	2017	Temuco	173314.1	2017	282415	48946498862	230	0.0008144	09101	39862241
9101112072	09101	3	2017	Temuco	173314.1	2017	282415	48946498862	165	0.0005842	09101	28596825
9101112073	09101	6	2017	Temuco	173314.1	2017	282415	48946498862	132	0.0004674	09101	22877460
9101122051	09101	75	2017	Temuco	173314.1	2017	282415	48946498862	357	0.0012641	09101	61873130
9101122060	09101	24	2017	Temuco	173314.1	2017	282415	48946498862	80	0.0002833	09101	13865127
9101122061	09101	6	2017	Temuco	173314.1	2017	282415	48946498862	21	0.0000744	09101	3639596
9101132015	09101	9	2017	Temuco	173314.1	2017	282415	48946498862	125	0.0004426	09101	21664261
9101132032	09101	2	2017	Temuco	173314.1	2017	282415	48946498862	17	0.0000602	09101	2946340
9101132033	09101	1	2017	Temuco	173314.1	2017	282415	48946498862	36	0.0001275	09101	6239307
9101132036	09101	2	2017	Temuco	173314.1	2017	282415	48946498862	35	0.0001239	09101	6065993
9101142008	09101	21	2017	Temuco	173314.1	2017	282415	48946498862	438	0.0015509	09101	75911572
9101142012	09101	41	2017	Temuco	173314.1	2017	282415	48946498862	136	0.0004816	09101	23570716
9101142022	09101	7	2017	Temuco	173314.1	2017	282415	48946498862	90	0.0003187	09101	15598268
9101142024	09101	1	2017	Temuco	173314.1	2017	282415	48946498862	57	0.0002018	09101	9878903
9101142037	09101	5	2017	Temuco	173314.1	2017	282415	48946498862	48	0.0001700	09101	8319076
9101142040	09101	25	2017	Temuco	173314.1	2017	282415	48946498862	218	0.0007719	09101	37782472
9101142042	09101	18	2017	Temuco	173314.1	2017	282415	48946498862	426	0.0015084	09101	73831803
9101142046	09101	7	2017	Temuco	173314.1	2017	282415	48946498862	44	0.0001558	09101	7625820
9101142054	09101	127	2017	Temuco	173314.1	2017	282415	48946498862	1860	0.0065861	09101	322364208
9101142062	09101	29	2017	Temuco	173314.1	2017	282415	48946498862	113	0.0004001	09101	19584492
9101142064	09101	4	2017	Temuco	173314.1	2017	282415	48946498862	111	0.0003930	09101	19237864
9101142066	09101	1	2017	Temuco	173314.1	2017	282415	48946498862	65	0.0002302	09101	11265416
9101152002	09101	33	2017	Temuco	173314.1	2017	282415	48946498862	933	0.0033036	09101	161702046
9101152011	09101	8	2017	Temuco	173314.1	2017	282415	48946498862	290	0.0010269	09101	50261086
9101152015	09101	2	2017	Temuco	173314.1	2017	282415	48946498862	32	0.0001133	09101	5546051
9101152016	09101	7	2017	Temuco	173314.1	2017	282415	48946498862	120	0.0004249	09101	20797691
9101152017	09101	14	2017	Temuco	173314.1	2017	282415	48946498862	317	0.0011225	09101	54940567
9101152020	09101	7	2017	Temuco	173314.1	2017	282415	48946498862	101	0.0003576	09101	17504723
9101152023	09101	2	2017	Temuco	173314.1	2017	282415	48946498862	111	0.0003930	09101	19237864
9101152027	09101	11	2017	Temuco	173314.1	2017	282415	48946498862	148	0.0005241	09101	25650485
9101152035	09101	2	2017	Temuco	173314.1	2017	282415	48946498862	73	0.0002585	09101	12651929
9101152043	09101	2	2017	Temuco	173314.1	2017	282415	48946498862	83	0.0002939	09101	14385070
9102012028	09102	3	2017	Carahue	127924.5	2017	24533	3138372109	25	0.0010190	09102	3198113
9102022011	09102	11	2017	Carahue	127924.5	2017	24533	3138372109	327	0.0133290	09102	41831316
9102022031	09102	4	2017	Carahue	127924.5	2017	24533	3138372109	163	0.0066441	09102	20851696
9102022054	09102	5	2017	Carahue	127924.5	2017	24533	3138372109	190	0.0077447	09102	24305658
9102022901	09102	4	2017	Carahue	127924.5	2017	24533	3138372109	103	0.0041984	09102	13176225
9102032009	09102	2	2017	Carahue	127924.5	2017	24533	3138372109	496	0.0202177	09102	63450559
9102032035	09102	1	2017	Carahue	127924.5	2017	24533	3138372109	255	0.0103942	09102	32620751
9102032037	09102	2	2017	Carahue	127924.5	2017	24533	3138372109	104	0.0042392	09102	13304149
9102032042	09102	4	2017	Carahue	127924.5	2017	24533	3138372109	190	0.0077447	09102	24305658
9102032901	09102	1	2017	Carahue	127924.5	2017	24533	3138372109	52	0.0021196	09102	6652075
9102042004	09102	11	2017	Carahue	127924.5	2017	24533	3138372109	221	0.0090083	09102	28271318
9102042010	09102	12	2017	Carahue	127924.5	2017	24533	3138372109	302	0.0123099	09102	38633203
9102042015	09102	19	2017	Carahue	127924.5	2017	24533	3138372109	430	0.0175274	09102	55007541
9102042029	09102	15	2017	Carahue	127924.5	2017	24533	3138372109	215	0.0087637	09102	27503771
9102042041	09102	3	2017	Carahue	127924.5	2017	24533	3138372109	138	0.0056251	09102	17653583
9102042045	09102	8	2017	Carahue	127924.5	2017	24533	3138372109	205	0.0083561	09102	26224525
9102052018	09102	11	2017	Carahue	127924.5	2017	24533	3138372109	338	0.0137774	09102	43238486
9102052034	09102	3	2017	Carahue	127924.5	2017	24533	3138372109	273	0.0111279	09102	34923392
9102052039	09102	1	2017	Carahue	127924.5	2017	24533	3138372109	54	0.0022011	09102	6907924
9102052040	09102	26	2017	Carahue	127924.5	2017	24533	3138372109	730	0.0297558	09102	93384895
9102052043	09102	6	2017	Carahue	127924.5	2017	24533	3138372109	246	0.0100273	09102	31469431
9102052047	09102	4	2017	Carahue	127924.5	2017	24533	3138372109	327	0.0133290	09102	41831316
9102052055	09102	16	2017	Carahue	127924.5	2017	24533	3138372109	216	0.0088045	09102	27631695
9102062014	09102	5	2017	Carahue	127924.5	2017	24533	3138372109	264	0.0107610	09102	33772072
9102062032	09102	6	2017	Carahue	127924.5	2017	24533	3138372109	409	0.0166714	09102	52321126
9102062044	09102	5	2017	Carahue	127924.5	2017	24533	3138372109	222	0.0090490	09102	28399242
9102062052	09102	1	2017	Carahue	127924.5	2017	24533	3138372109	106	0.0043207	09102	13559999
9102072002	09102	1	2017	Carahue	127924.5	2017	24533	3138372109	72	0.0029348	09102	9210565
9102072003	09102	4	2017	Carahue	127924.5	2017	24533	3138372109	542	0.0220927	09102	69335087
9102072008	09102	5	2017	Carahue	127924.5	2017	24533	3138372109	260	0.0105980	09102	33260374
9102082024	09102	12	2017	Carahue	127924.5	2017	24533	3138372109	307	0.0125138	09102	39272826
9102082027	09102	5	2017	Carahue	127924.5	2017	24533	3138372109	218	0.0088860	09102	27887544
9102082036	09102	1	2017	Carahue	127924.5	2017	24533	3138372109	201	0.0081930	09102	25712827

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 
## -142688952  -16230057   -7523782    6104970  347030856 
## 
## Coefficients:
##             Estimate Std. Error t value Pr(>|t|)    
## (Intercept) 19645321     945388   20.78   <2e-16 ***
## Freq.x       1323775      38368   34.50   <2e-16 ***
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 31100000 on 1310 degrees of freedom
## Multiple R-squared:  0.4761, Adjusted R-squared:  0.4757 
## F-statistic:  1190 on 1 and 1310 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 
## -142688952  -16230057   -7523782    6104970  347030856 
## 
## Coefficients:
##             Estimate Std. Error t value Pr(>|t|)    
## (Intercept) 19645321     945388   20.78   <2e-16 ***
## Freq.x       1323775      38368   34.50   <2e-16 ***
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 31100000 on 1310 degrees of freedom
## Multiple R-squared:  0.4761, Adjusted R-squared:  0.4757 
## F-statistic:  1190 on 1 and 1310 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 
## -142688952  -16230057   -7523782    6104970  347030856 
## 
## Coefficients:
##             Estimate Std. Error t value Pr(>|t|)    
## (Intercept) 19645321     945388   20.78   <2e-16 ***
## Freq.x       1323775      38368   34.50   <2e-16 ***
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 31100000 on 1310 degrees of freedom
## Multiple R-squared:  0.4761, Adjusted R-squared:  0.4757 
## F-statistic:  1190 on 1 and 1310 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 
## -71167235 -18576405  -4030945  11282798 394297963 
## 
## Coefficients:
##             Estimate Std. Error t value Pr(>|t|)    
## (Intercept)  -692961    1501843  -0.461    0.645    
## log(Freq.x) 22564941     783634  28.795   <2e-16 ***
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 33620000 on 1310 degrees of freedom
## Multiple R-squared:  0.3876, Adjusted R-squared:  0.3871 
## F-statistic: 829.2 on 1 and 1310 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 
## -98166184 -13294692  -3619432   7931983 336096524 
## 
## Coefficients:
##              Estimate Std. Error t value Pr(>|t|)    
## (Intercept)  -7978472    1389016  -5.744 1.15e-08 ***
## sqrt(Freq.x) 16016176     432395  37.041  < 2e-16 ***
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 30020000 on 1310 degrees of freedom
## Multiple R-squared:  0.5116, Adjusted R-squared:  0.5112 
## F-statistic:  1372 on 1 and 1310 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 
## -6044.1 -1359.0  -227.1  1038.7 13721.3 
## 
## Coefficients:
##              Estimate Std. Error t value Pr(>|t|)    
## (Intercept)   2313.59      92.26   25.08   <2e-16 ***
## sqrt(Freq.x)  1052.41      28.72   36.64   <2e-16 ***
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 1994 on 1310 degrees of freedom
## Multiple R-squared:  0.5062, Adjusted R-squared:  0.5058 
## F-statistic:  1343 on 1 and 1310 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.1978 -0.5591  0.1065  0.5920  2.7450 
## 
## Coefficients:
##              Estimate Std. Error t value Pr(>|t|)    
## (Intercept)  15.84345    0.03951   401.0   <2e-16 ***
## sqrt(Freq.x)  0.35293    0.01230    28.7   <2e-16 ***
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 0.854 on 1310 degrees of freedom
## Multiple R-squared:  0.386,  Adjusted R-squared:  0.3855 
## F-statistic: 823.4 on 1 and 1310 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 
## -4707.3 -1337.4  -216.6  1156.2 13037.2 
## 
## Coefficients:
##             Estimate Std. Error t value Pr(>|t|)    
## (Intercept)  2555.04      92.36   27.66   <2e-16 ***
## log(Freq.x)  1640.21      48.19   34.04   <2e-16 ***
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 2067 on 1310 degrees of freedom
## Multiple R-squared:  0.4693, Adjusted R-squared:  0.4689 
## F-statistic:  1158 on 1 and 1310 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.41629 -0.54065  0.06621  0.57067  2.47335 
## 
## Coefficients:
##             Estimate Std. Error t value Pr(>|t|)    
## (Intercept) 15.84588    0.03679  430.68   <2e-16 ***
## log(Freq.x)  0.60216    0.01920   31.37   <2e-16 ***
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 0.8236 on 1310 degrees of freedom
## Multiple R-squared:  0.4289, Adjusted R-squared:  0.4285 
## F-statistic: 983.9 on 1 and 1310 DF,  p-value: < 2.2e-16

9 Modelo elegido: sqrt (sqrt)

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

9.1 Diagrama de dispersión sobre sqrt

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=(h_y_m_comuna_corr_01$multi_pob), lpars = list(col = "red", lwd = 2, lty = 1), main="multi_pob ~ Freq.x")

9.2 Modelo sqrt

Observemos nuevamente el resultado sobre sqrt.

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 
## -98166184 -13294692  -3619432   7931983 336096524 
## 
## Coefficients:
##              Estimate Std. Error t value Pr(>|t|)    
## (Intercept)  -7978472    1389016  -5.744 1.15e-08 ***
## sqrt(Freq.x) 16016176     432395  37.041  < 2e-16 ***
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 30020000 on 1310 degrees of freedom
## Multiple R-squared:  0.5116, Adjusted R-squared:  0.5112 
## F-statistic:  1372 on 1 and 1310 DF,  p-value: < 2.2e-16

ggplot(h_y_m_comuna_corr_01, aes(x = sqrt(Freq.x) , y = (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 = -7978472 + 16016176 \cdot \sqrt {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 <- 
-7978472  + 16016176 * sqrt (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
9101072007	09101	21	2017	Temuco	173314.1	2017	282415	48946498862	60	0.0002125	09101	10398845	65416867
9101072009	09101	5	2017	Temuco	173314.1	2017	282415	48946498862	16	0.0000567	09101	2773025	27834786
9101072010	09101	13	2017	Temuco	173314.1	2017	282415	48946498862	43	0.0001523	09101	7452506	49768672
9101072042	09101	17	2017	Temuco	173314.1	2017	282415	48946498862	59	0.0002089	09101	10225531	58057913
9101072060	09101	17	2017	Temuco	173314.1	2017	282415	48946498862	61	0.0002160	09101	10572160	58057913
9101082007	09101	30	2017	Temuco	173314.1	2017	282415	48946498862	79	0.0002797	09101	13691813	79745737
9101102004	09101	445	2017	Temuco	173314.1	2017	282415	48946498862	3065	0.0108528	09101	531207687	329883131
9101102006	09101	188	2017	Temuco	173314.1	2017	282415	48946498862	726	0.0025707	09101	125826030	211624269
9101102018	09101	1	2017	Temuco	173314.1	2017	282415	48946498862	25	0.0000885	09101	4332852	8037704
9101102028	09101	152	2017	Temuco	173314.1	2017	282415	48946498862	843	0.0029850	09101	146103778	189482207
9101102029	09101	28	2017	Temuco	173314.1	2017	282415	48946498862	496	0.0017563	09101	85963789	76771165
9101102034	09101	2	2017	Temuco	173314.1	2017	282415	48946498862	172	0.0006090	09101	29810024	14671821
9101102052	09101	1	2017	Temuco	173314.1	2017	282415	48946498862	25	0.0000885	09101	4332852	8037704
9101102057	09101	158	2017	Temuco	173314.1	2017	282415	48946498862	1762	0.0062390	09101	305379427	193341739
9101112003	09101	4	2017	Temuco	173314.1	2017	282415	48946498862	133	0.0004709	09101	23050774	24053880
9101112013	09101	5	2017	Temuco	173314.1	2017	282415	48946498862	214	0.0007578	09101	37089215	27834786
9101112014	09101	1	2017	Temuco	173314.1	2017	282415	48946498862	62	0.0002195	09101	10745474	8037704
9101112019	09101	3	2017	Temuco	173314.1	2017	282415	48946498862	142	0.0005028	09101	24610601	19762359
9101112021	09101	13	2017	Temuco	173314.1	2017	282415	48946498862	419	0.0014836	09101	72618604	49768672
9101112029	09101	14	2017	Temuco	173314.1	2017	282415	48946498862	181	0.0006409	09101	31369850	51948571
9101112031	09101	4	2017	Temuco	173314.1	2017	282415	48946498862	92	0.0003258	09101	15944896	24053880
9101112038	09101	3	2017	Temuco	173314.1	2017	282415	48946498862	89	0.0003151	09101	15424954	19762359
9101112041	09101	3	2017	Temuco	173314.1	2017	282415	48946498862	116	0.0004107	09101	20104434	19762359
9101112045	09101	14	2017	Temuco	173314.1	2017	282415	48946498862	292	0.0010339	09101	50607714	51948571
9101112047	09101	2	2017	Temuco	173314.1	2017	282415	48946498862	124	0.0004391	09101	21490947	14671821
9101112048	09101	3	2017	Temuco	173314.1	2017	282415	48946498862	146	0.0005170	09101	25303857	19762359
9101112052	09101	8	2017	Temuco	173314.1	2017	282415	48946498862	100	0.0003541	09101	17331409	37322115
9101112054	09101	30	2017	Temuco	173314.1	2017	282415	48946498862	443	0.0015686	09101	76778142	79745737
9101112059	09101	4	2017	Temuco	173314.1	2017	282415	48946498862	136	0.0004816	09101	23570716	24053880
9101112062	09101	41	2017	Temuco	173314.1	2017	282415	48946498862	167	0.0005913	09101	28943453	94575093
9101112065	09101	1	2017	Temuco	173314.1	2017	282415	48946498862	83	0.0002939	09101	14385070	8037704
9101112067	09101	16	2017	Temuco	173314.1	2017	282415	48946498862	514	0.0018200	09101	89083443	56086232
9101112068	09101	6	2017	Temuco	173314.1	2017	282415	48946498862	433	0.0015332	09101	75045001	31252987
9101112069	09101	2	2017	Temuco	173314.1	2017	282415	48946498862	129	0.0004568	09101	22357518	14671821
9101112070	09101	1	2017	Temuco	173314.1	2017	282415	48946498862	325	0.0011508	09101	56327079	8037704
9101112071	09101	11	2017	Temuco	173314.1	2017	282415	48946498862	230	0.0008144	09101	39862241	45141174
9101112072	09101	3	2017	Temuco	173314.1	2017	282415	48946498862	165	0.0005842	09101	28596825	19762359
9101112073	09101	6	2017	Temuco	173314.1	2017	282415	48946498862	132	0.0004674	09101	22877460	31252987
9101122051	09101	75	2017	Temuco	173314.1	2017	282415	48946498862	357	0.0012641	09101	61873130	130725681
9101122060	09101	24	2017	Temuco	173314.1	2017	282415	48946498862	80	0.0002833	09101	13865127	70484446
9101122061	09101	6	2017	Temuco	173314.1	2017	282415	48946498862	21	0.0000744	09101	3639596	31252987
9101132015	09101	9	2017	Temuco	173314.1	2017	282415	48946498862	125	0.0004426	09101	21664261	40070056
9101132032	09101	2	2017	Temuco	173314.1	2017	282415	48946498862	17	0.0000602	09101	2946340	14671821
9101132033	09101	1	2017	Temuco	173314.1	2017	282415	48946498862	36	0.0001275	09101	6239307	8037704
9101132036	09101	2	2017	Temuco	173314.1	2017	282415	48946498862	35	0.0001239	09101	6065993	14671821
9101142008	09101	21	2017	Temuco	173314.1	2017	282415	48946498862	438	0.0015509	09101	75911572	65416867
9101142012	09101	41	2017	Temuco	173314.1	2017	282415	48946498862	136	0.0004816	09101	23570716	94575093
9101142022	09101	7	2017	Temuco	173314.1	2017	282415	48946498862	90	0.0003187	09101	15598268	34396347
9101142024	09101	1	2017	Temuco	173314.1	2017	282415	48946498862	57	0.0002018	09101	9878903	8037704
9101142037	09101	5	2017	Temuco	173314.1	2017	282415	48946498862	48	0.0001700	09101	8319076	27834786
9101142040	09101	25	2017	Temuco	173314.1	2017	282415	48946498862	218	0.0007719	09101	37782472	72102408
9101142042	09101	18	2017	Temuco	173314.1	2017	282415	48946498862	426	0.0015084	09101	73831803	59972408
9101142046	09101	7	2017	Temuco	173314.1	2017	282415	48946498862	44	0.0001558	09101	7625820	34396347
9101142054	09101	127	2017	Temuco	173314.1	2017	282415	48946498862	1860	0.0065861	09101	322364208	172514665
9101142062	09101	29	2017	Temuco	173314.1	2017	282415	48946498862	113	0.0004001	09101	19584492	78271275
9101142064	09101	4	2017	Temuco	173314.1	2017	282415	48946498862	111	0.0003930	09101	19237864	24053880
9101142066	09101	1	2017	Temuco	173314.1	2017	282415	48946498862	65	0.0002302	09101	11265416	8037704
9101152002	09101	33	2017	Temuco	173314.1	2017	282415	48946498862	933	0.0033036	09101	161702046	84027454
9101152011	09101	8	2017	Temuco	173314.1	2017	282415	48946498862	290	0.0010269	09101	50261086	37322115
9101152015	09101	2	2017	Temuco	173314.1	2017	282415	48946498862	32	0.0001133	09101	5546051	14671821
9101152016	09101	7	2017	Temuco	173314.1	2017	282415	48946498862	120	0.0004249	09101	20797691	34396347
9101152017	09101	14	2017	Temuco	173314.1	2017	282415	48946498862	317	0.0011225	09101	54940567	51948571
9101152020	09101	7	2017	Temuco	173314.1	2017	282415	48946498862	101	0.0003576	09101	17504723	34396347
9101152023	09101	2	2017	Temuco	173314.1	2017	282415	48946498862	111	0.0003930	09101	19237864	14671821
9101152027	09101	11	2017	Temuco	173314.1	2017	282415	48946498862	148	0.0005241	09101	25650485	45141174
9101152035	09101	2	2017	Temuco	173314.1	2017	282415	48946498862	73	0.0002585	09101	12651929	14671821
9101152043	09101	2	2017	Temuco	173314.1	2017	282415	48946498862	83	0.0002939	09101	14385070	14671821
9102012028	09102	3	2017	Carahue	127924.5	2017	24533	3138372109	25	0.0010190	09102	3198113	19762359
9102022011	09102	11	2017	Carahue	127924.5	2017	24533	3138372109	327	0.0133290	09102	41831316	45141174
9102022031	09102	4	2017	Carahue	127924.5	2017	24533	3138372109	163	0.0066441	09102	20851696	24053880
9102022054	09102	5	2017	Carahue	127924.5	2017	24533	3138372109	190	0.0077447	09102	24305658	27834786
9102022901	09102	4	2017	Carahue	127924.5	2017	24533	3138372109	103	0.0041984	09102	13176225	24053880
9102032009	09102	2	2017	Carahue	127924.5	2017	24533	3138372109	496	0.0202177	09102	63450559	14671821
9102032035	09102	1	2017	Carahue	127924.5	2017	24533	3138372109	255	0.0103942	09102	32620751	8037704
9102032037	09102	2	2017	Carahue	127924.5	2017	24533	3138372109	104	0.0042392	09102	13304149	14671821
9102032042	09102	4	2017	Carahue	127924.5	2017	24533	3138372109	190	0.0077447	09102	24305658	24053880
9102032901	09102	1	2017	Carahue	127924.5	2017	24533	3138372109	52	0.0021196	09102	6652075	8037704
9102042004	09102	11	2017	Carahue	127924.5	2017	24533	3138372109	221	0.0090083	09102	28271318	45141174
9102042010	09102	12	2017	Carahue	127924.5	2017	24533	3138372109	302	0.0123099	09102	38633203	47503189
9102042015	09102	19	2017	Carahue	127924.5	2017	24533	3138372109	430	0.0175274	09102	55007541	61834421
9102042029	09102	15	2017	Carahue	127924.5	2017	24533	3138372109	215	0.0087637	09102	27503771	54051911
9102042041	09102	3	2017	Carahue	127924.5	2017	24533	3138372109	138	0.0056251	09102	17653583	19762359
9102042045	09102	8	2017	Carahue	127924.5	2017	24533	3138372109	205	0.0083561	09102	26224525	37322115
9102052018	09102	11	2017	Carahue	127924.5	2017	24533	3138372109	338	0.0137774	09102	43238486	45141174
9102052034	09102	3	2017	Carahue	127924.5	2017	24533	3138372109	273	0.0111279	09102	34923392	19762359
9102052039	09102	1	2017	Carahue	127924.5	2017	24533	3138372109	54	0.0022011	09102	6907924	8037704
9102052040	09102	26	2017	Carahue	127924.5	2017	24533	3138372109	730	0.0297558	09102	93384895	73688322
9102052043	09102	6	2017	Carahue	127924.5	2017	24533	3138372109	246	0.0100273	09102	31469431	31252987
9102052047	09102	4	2017	Carahue	127924.5	2017	24533	3138372109	327	0.0133290	09102	41831316	24053880
9102052055	09102	16	2017	Carahue	127924.5	2017	24533	3138372109	216	0.0088045	09102	27631695	56086232
9102062014	09102	5	2017	Carahue	127924.5	2017	24533	3138372109	264	0.0107610	09102	33772072	27834786
9102062032	09102	6	2017	Carahue	127924.5	2017	24533	3138372109	409	0.0166714	09102	52321126	31252987
9102062044	09102	5	2017	Carahue	127924.5	2017	24533	3138372109	222	0.0090490	09102	28399242	27834786
9102062052	09102	1	2017	Carahue	127924.5	2017	24533	3138372109	106	0.0043207	09102	13559999	8037704
9102072002	09102	1	2017	Carahue	127924.5	2017	24533	3138372109	72	0.0029348	09102	9210565	8037704
9102072003	09102	4	2017	Carahue	127924.5	2017	24533	3138372109	542	0.0220927	09102	69335087	24053880
9102072008	09102	5	2017	Carahue	127924.5	2017	24533	3138372109	260	0.0105980	09102	33260374	27834786
9102082024	09102	12	2017	Carahue	127924.5	2017	24533	3138372109	307	0.0125138	09102	39272826	47503189
9102082027	09102	5	2017	Carahue	127924.5	2017	24533	3138372109	218	0.0088860	09102	27887544	27834786
9102082036	09102	1	2017	Carahue	127924.5	2017	24533	3138372109	201	0.0081930	09102	25712827	8037704

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
9101072007	09101	21	2017	Temuco	173314.1	2017	282415	48946498862	60	0.0002125	09101	10398845	65416867	1090281.11
9101072009	09101	5	2017	Temuco	173314.1	2017	282415	48946498862	16	0.0000567	09101	2773025	27834786	1739674.14
9101072010	09101	13	2017	Temuco	173314.1	2017	282415	48946498862	43	0.0001523	09101	7452506	49768672	1157410.97
9101072042	09101	17	2017	Temuco	173314.1	2017	282415	48946498862	59	0.0002089	09101	10225531	58057913	984032.43
9101072060	09101	17	2017	Temuco	173314.1	2017	282415	48946498862	61	0.0002160	09101	10572160	58057913	951769.07
9101082007	09101	30	2017	Temuco	173314.1	2017	282415	48946498862	79	0.0002797	09101	13691813	79745737	1009439.71
9101102004	09101	445	2017	Temuco	173314.1	2017	282415	48946498862	3065	0.0108528	09101	531207687	329883131	107629.08
9101102006	09101	188	2017	Temuco	173314.1	2017	282415	48946498862	726	0.0025707	09101	125826030	211624269	291493.48
9101102018	09101	1	2017	Temuco	173314.1	2017	282415	48946498862	25	0.0000885	09101	4332852	8037704	321508.16
9101102028	09101	152	2017	Temuco	173314.1	2017	282415	48946498862	843	0.0029850	09101	146103778	189482207	224771.30
9101102029	09101	28	2017	Temuco	173314.1	2017	282415	48946498862	496	0.0017563	09101	85963789	76771165	154780.58
9101102034	09101	2	2017	Temuco	173314.1	2017	282415	48946498862	172	0.0006090	09101	29810024	14671821	85301.29
9101102052	09101	1	2017	Temuco	173314.1	2017	282415	48946498862	25	0.0000885	09101	4332852	8037704	321508.16
9101102057	09101	158	2017	Temuco	173314.1	2017	282415	48946498862	1762	0.0062390	09101	305379427	193341739	109728.57
9101112003	09101	4	2017	Temuco	173314.1	2017	282415	48946498862	133	0.0004709	09101	23050774	24053880	180856.24
9101112013	09101	5	2017	Temuco	173314.1	2017	282415	48946498862	214	0.0007578	09101	37089215	27834786	130069.09
9101112014	09101	1	2017	Temuco	173314.1	2017	282415	48946498862	62	0.0002195	09101	10745474	8037704	129640.39
9101112019	09101	3	2017	Temuco	173314.1	2017	282415	48946498862	142	0.0005028	09101	24610601	19762359	139171.54
9101112021	09101	13	2017	Temuco	173314.1	2017	282415	48946498862	419	0.0014836	09101	72618604	49768672	118779.65
9101112029	09101	14	2017	Temuco	173314.1	2017	282415	48946498862	181	0.0006409	09101	31369850	51948571	287008.68
9101112031	09101	4	2017	Temuco	173314.1	2017	282415	48946498862	92	0.0003258	09101	15944896	24053880	261455.22
9101112038	09101	3	2017	Temuco	173314.1	2017	282415	48946498862	89	0.0003151	09101	15424954	19762359	222048.97
9101112041	09101	3	2017	Temuco	173314.1	2017	282415	48946498862	116	0.0004107	09101	20104434	19762359	170365.16
9101112045	09101	14	2017	Temuco	173314.1	2017	282415	48946498862	292	0.0010339	09101	50607714	51948571	177906.07
9101112047	09101	2	2017	Temuco	173314.1	2017	282415	48946498862	124	0.0004391	09101	21490947	14671821	118321.14
9101112048	09101	3	2017	Temuco	173314.1	2017	282415	48946498862	146	0.0005170	09101	25303857	19762359	135358.62
9101112052	09101	8	2017	Temuco	173314.1	2017	282415	48946498862	100	0.0003541	09101	17331409	37322115	373221.15
9101112054	09101	30	2017	Temuco	173314.1	2017	282415	48946498862	443	0.0015686	09101	76778142	79745737	180012.95
9101112059	09101	4	2017	Temuco	173314.1	2017	282415	48946498862	136	0.0004816	09101	23570716	24053880	176866.76
9101112062	09101	41	2017	Temuco	173314.1	2017	282415	48946498862	167	0.0005913	09101	28943453	94575093	566317.92
9101112065	09101	1	2017	Temuco	173314.1	2017	282415	48946498862	83	0.0002939	09101	14385070	8037704	96839.81
9101112067	09101	16	2017	Temuco	173314.1	2017	282415	48946498862	514	0.0018200	09101	89083443	56086232	109117.18
9101112068	09101	6	2017	Temuco	173314.1	2017	282415	48946498862	433	0.0015332	09101	75045001	31252987	72177.80
9101112069	09101	2	2017	Temuco	173314.1	2017	282415	48946498862	129	0.0004568	09101	22357518	14671821	113735.05
9101112070	09101	1	2017	Temuco	173314.1	2017	282415	48946498862	325	0.0011508	09101	56327079	8037704	24731.40
9101112071	09101	11	2017	Temuco	173314.1	2017	282415	48946498862	230	0.0008144	09101	39862241	45141174	196265.98
9101112072	09101	3	2017	Temuco	173314.1	2017	282415	48946498862	165	0.0005842	09101	28596825	19762359	119771.87
9101112073	09101	6	2017	Temuco	173314.1	2017	282415	48946498862	132	0.0004674	09101	22877460	31252987	236765.05
9101122051	09101	75	2017	Temuco	173314.1	2017	282415	48946498862	357	0.0012641	09101	61873130	130725681	366178.38
9101122060	09101	24	2017	Temuco	173314.1	2017	282415	48946498862	80	0.0002833	09101	13865127	70484446	881055.57
9101122061	09101	6	2017	Temuco	173314.1	2017	282415	48946498862	21	0.0000744	09101	3639596	31252987	1488237.47
9101132015	09101	9	2017	Temuco	173314.1	2017	282415	48946498862	125	0.0004426	09101	21664261	40070056	320560.45
9101132032	09101	2	2017	Temuco	173314.1	2017	282415	48946498862	17	0.0000602	09101	2946340	14671821	863048.31
9101132033	09101	1	2017	Temuco	173314.1	2017	282415	48946498862	36	0.0001275	09101	6239307	8037704	223269.56
9101132036	09101	2	2017	Temuco	173314.1	2017	282415	48946498862	35	0.0001239	09101	6065993	14671821	419194.89
9101142008	09101	21	2017	Temuco	173314.1	2017	282415	48946498862	438	0.0015509	09101	75911572	65416867	149353.58
9101142012	09101	41	2017	Temuco	173314.1	2017	282415	48946498862	136	0.0004816	09101	23570716	94575093	695405.09
9101142022	09101	7	2017	Temuco	173314.1	2017	282415	48946498862	90	0.0003187	09101	15598268	34396347	382181.63
9101142024	09101	1	2017	Temuco	173314.1	2017	282415	48946498862	57	0.0002018	09101	9878903	8037704	141012.35
9101142037	09101	5	2017	Temuco	173314.1	2017	282415	48946498862	48	0.0001700	09101	8319076	27834786	579891.38
9101142040	09101	25	2017	Temuco	173314.1	2017	282415	48946498862	218	0.0007719	09101	37782472	72102408	330744.99
9101142042	09101	18	2017	Temuco	173314.1	2017	282415	48946498862	426	0.0015084	09101	73831803	59972408	140780.30
9101142046	09101	7	2017	Temuco	173314.1	2017	282415	48946498862	44	0.0001558	09101	7625820	34396347	781735.15
9101142054	09101	127	2017	Temuco	173314.1	2017	282415	48946498862	1860	0.0065861	09101	322364208	172514665	92749.82
9101142062	09101	29	2017	Temuco	173314.1	2017	282415	48946498862	113	0.0004001	09101	19584492	78271275	692666.15
9101142064	09101	4	2017	Temuco	173314.1	2017	282415	48946498862	111	0.0003930	09101	19237864	24053880	216701.62
9101142066	09101	1	2017	Temuco	173314.1	2017	282415	48946498862	65	0.0002302	09101	11265416	8037704	123656.98
9101152002	09101	33	2017	Temuco	173314.1	2017	282415	48946498862	933	0.0033036	09101	161702046	84027454	90061.58
9101152011	09101	8	2017	Temuco	173314.1	2017	282415	48946498862	290	0.0010269	09101	50261086	37322115	128696.95
9101152015	09101	2	2017	Temuco	173314.1	2017	282415	48946498862	32	0.0001133	09101	5546051	14671821	458494.42
9101152016	09101	7	2017	Temuco	173314.1	2017	282415	48946498862	120	0.0004249	09101	20797691	34396347	286636.22
9101152017	09101	14	2017	Temuco	173314.1	2017	282415	48946498862	317	0.0011225	09101	54940567	51948571	163875.62
9101152020	09101	7	2017	Temuco	173314.1	2017	282415	48946498862	101	0.0003576	09101	17504723	34396347	340557.89
9101152023	09101	2	2017	Temuco	173314.1	2017	282415	48946498862	111	0.0003930	09101	19237864	14671821	132178.57
9101152027	09101	11	2017	Temuco	173314.1	2017	282415	48946498862	148	0.0005241	09101	25650485	45141174	305007.93
9101152035	09101	2	2017	Temuco	173314.1	2017	282415	48946498862	73	0.0002585	09101	12651929	14671821	200983.85
9101152043	09101	2	2017	Temuco	173314.1	2017	282415	48946498862	83	0.0002939	09101	14385070	14671821	176768.93
9102012028	09102	3	2017	Carahue	127924.5	2017	24533	3138372109	25	0.0010190	09102	3198113	19762359	790494.34
9102022011	09102	11	2017	Carahue	127924.5	2017	24533	3138372109	327	0.0133290	09102	41831316	45141174	138046.40
9102022031	09102	4	2017	Carahue	127924.5	2017	24533	3138372109	163	0.0066441	09102	20851696	24053880	147569.82
9102022054	09102	5	2017	Carahue	127924.5	2017	24533	3138372109	190	0.0077447	09102	24305658	27834786	146498.88
9102022901	09102	4	2017	Carahue	127924.5	2017	24533	3138372109	103	0.0041984	09102	13176225	24053880	233532.82
9102032009	09102	2	2017	Carahue	127924.5	2017	24533	3138372109	496	0.0202177	09102	63450559	14671821	29580.28
9102032035	09102	1	2017	Carahue	127924.5	2017	24533	3138372109	255	0.0103942	09102	32620751	8037704	31520.41
9102032037	09102	2	2017	Carahue	127924.5	2017	24533	3138372109	104	0.0042392	09102	13304149	14671821	141075.20
9102032042	09102	4	2017	Carahue	127924.5	2017	24533	3138372109	190	0.0077447	09102	24305658	24053880	126599.37
9102032901	09102	1	2017	Carahue	127924.5	2017	24533	3138372109	52	0.0021196	09102	6652075	8037704	154571.23
9102042004	09102	11	2017	Carahue	127924.5	2017	24533	3138372109	221	0.0090083	09102	28271318	45141174	204258.71
9102042010	09102	12	2017	Carahue	127924.5	2017	24533	3138372109	302	0.0123099	09102	38633203	47503189	157295.33
9102042015	09102	19	2017	Carahue	127924.5	2017	24533	3138372109	430	0.0175274	09102	55007541	61834421	143800.98
9102042029	09102	15	2017	Carahue	127924.5	2017	24533	3138372109	215	0.0087637	09102	27503771	54051911	251404.24
9102042041	09102	3	2017	Carahue	127924.5	2017	24533	3138372109	138	0.0056251	09102	17653583	19762359	143205.50
9102042045	09102	8	2017	Carahue	127924.5	2017	24533	3138372109	205	0.0083561	09102	26224525	37322115	182059.10
9102052018	09102	11	2017	Carahue	127924.5	2017	24533	3138372109	338	0.0137774	09102	43238486	45141174	133553.77
9102052034	09102	3	2017	Carahue	127924.5	2017	24533	3138372109	273	0.0111279	09102	34923392	19762359	72389.59
9102052039	09102	1	2017	Carahue	127924.5	2017	24533	3138372109	54	0.0022011	09102	6907924	8037704	148846.37
9102052040	09102	26	2017	Carahue	127924.5	2017	24533	3138372109	730	0.0297558	09102	93384895	73688322	100942.91
9102052043	09102	6	2017	Carahue	127924.5	2017	24533	3138372109	246	0.0100273	09102	31469431	31252987	127044.66
9102052047	09102	4	2017	Carahue	127924.5	2017	24533	3138372109	327	0.0133290	09102	41831316	24053880	73559.27
9102052055	09102	16	2017	Carahue	127924.5	2017	24533	3138372109	216	0.0088045	09102	27631695	56086232	259658.48
9102062014	09102	5	2017	Carahue	127924.5	2017	24533	3138372109	264	0.0107610	09102	33772072	27834786	105434.80
9102062032	09102	6	2017	Carahue	127924.5	2017	24533	3138372109	409	0.0166714	09102	52321126	31252987	76413.17
9102062044	09102	5	2017	Carahue	127924.5	2017	24533	3138372109	222	0.0090490	09102	28399242	27834786	125381.92
9102062052	09102	1	2017	Carahue	127924.5	2017	24533	3138372109	106	0.0043207	09102	13559999	8037704	75827.40
9102072002	09102	1	2017	Carahue	127924.5	2017	24533	3138372109	72	0.0029348	09102	9210565	8037704	111634.78
9102072003	09102	4	2017	Carahue	127924.5	2017	24533	3138372109	542	0.0220927	09102	69335087	24053880	44379.85
9102072008	09102	5	2017	Carahue	127924.5	2017	24533	3138372109	260	0.0105980	09102	33260374	27834786	107056.87
9102082024	09102	12	2017	Carahue	127924.5	2017	24533	3138372109	307	0.0125138	09102	39272826	47503189	154733.52
9102082027	09102	5	2017	Carahue	127924.5	2017	24533	3138372109	218	0.0088860	09102	27887544	27834786	127682.51
9102082036	09102	1	2017	Carahue	127924.5	2017	24533	3138372109	201	0.0081930	09102	25712827	8037704	39988.58

Guardamos:

saveRDS(h_y_m_comuna_corr_01, "P15/region_09_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