{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Hoja1","Hoja2","Hoja3","Hoja4"],"not_rendered":{"charts":3,"images":14,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Hoja1","index":0,"n_rows":41,"n_cols":13,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,"FUNCIÓN DE REGRESIÓN POBLACIONAL VERSUS MUESTRAL"]
[]
[null,null,"Suponga una población total de 60 familias de las que conocemos su nivel de gasto en consumo familiar una vez conocidos  "]
[null,null,"sus niveles de renta disponible correspondientes.Nuestro objetivo es conocer cómo varía el consumo medio de estas familias"]
[null,null,"a medida que varía su nivel de renta. Los datos de consumo (CO) y renta (REN) de las 60 familias son los que aparecen en el "]
[null,null,"cuadro adjunto. El consumo de las 60 familias se agrupa en 10 columnas distintas de acuerdo a sus niveles de renta.  Por consiguiente, "]
[null,null,"cada una de las columnas recoge la distribución del gasto en consumo familiar de dichas familias condicionado a sus niveles de renta "]
[null,null,"correspondiente, lo que nos permite calcular la recta de regresión poblacional. "]
[]
[]
[null,null,null,null,null,null,null,"RENTA (REN)"]
[null,null,null,80,100,120,140,160,180,200,220,240,260]
[null,null,null,55,65,79,80,102,110,120,135,137,150]
[null,null,"CONSUMO (CO)",60,70,84,93,107,115,136,137,145,152]
[null,null,null,65,74,90,95,110,120,140,140,155,175]
[null,null,null,70,80,94,103,116,130,144,152,165,178]
[null,null,null,75,85,98,108,118,135,145,157,175,180]
[null,null,null,null,88,null,113,125,140,null,160,189,185]
[null,null,null,null,null,null,115,null,null,null,162,null,191]
[null,"E(CONSUMO/RENTA)",null,{"$f":"AVERAGE(D14:D20)","v":65},77,89,101,113,125,137,149,161,173]
[]
[null,null,null,"Datos extraídos de Gujarati y Porter (2010), capítulo 2, página 35. "]
[]
[]
[null,null,"A)Obtenga la función de regresión poblacional y represéntela."]
[]
[null,null,null,"CO=b0 +b1 REN+u"]
[]
[null,null,null,"E(CO/REN)=b0 +b1 REN"]
[]
[null,null,null,"65=b0 +b1 80"]
[null,null,null,"77=b0 +b1 100"]
[]
[null,null,null,"E(CO/REN)=17+0,6 REN"]
[]
[]
[null,null,"B) Obtenga la /las funciones de regresión muestrales (algunas de ellas) y represéntelas. "]
[]
[]
[null,null,"©Este fichero Excel ha sido preparado por los profesores Víctor E. Barrios y Jorge Belaire en el marco del proyecto CONSOLIDA-PID, UV-SFPIE-PID-1639467"]

{"sheet":"Hoja2","index":1,"n_rows":76,"n_cols":26,"rows_kept":76,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,"DATOS DE LA POBLACIÓN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RECTA DE REGRESIÓN POBLACIONAL, VALORES DE LA VARIABLE DEPENDIENTE  POBLACIONAL Y TÉRMINO DE PERTURBACIÓN"]
[null,null,null,null,null,null,null,null,"Desviaciones ","media",null,"Productos cruzados",null,null,null,null,null,null,null,null,null,null,null,null,null,"GRÁFICO DE DISPERSIÓN"]
[null,null,"Consumo","Renta",null,"Desviaciones media ",null,null,"al cuadrado",null,null,"Desviaciones media",null,null,"Término de error",null,null,null,null,"POBLACIÓN"]
[null,"Obser.","CO","REN",null,"CO","REN",null,"CO","REN",null,"CO*REN",null,"E(CO/REN)","u",null,null,null,"RENTA","CONSUMO"]
[null,1,55,80,null,{"$f":"+C6-C$68","v":-66.2},{"$f":"+D6-D$68","v":-93.666666666666657},null,{"$f":"+F6^2","v":4382.4400000000005},{"$f":"+G6^2","v":8773.4444444444434},null,{"$f":"+F6*G6","v":6200.7333333333327},null,{"$f":"+$D$72+$D$73*D6","v":65.000000000000014},{"$f":"+C6-N6","v":-10.000000000000014},null,null,"Individuos","REN","CO","E(CO/REN)"]
[null,2,60,80,null,-61.2,-93.666666666666657,null,{"$f":"+F7^2","v":3745.4400000000005},{"$f":"+G7^2","v":8773.4444444444434},null,{"$f":"+F7*G7","v":5732.4},null,65.000000000000014,{"$f":"+C7-N7","v":-5.0000000000000142},null,null,1,80,55,65.000000000000014]
[null,3,65,80,null,-56.2,-93.666666666666657,null,3158.4400000000005,8773.4444444444434,null,5264.0666666666666,null,65.000000000000014,0,null,null,2,80,60,65.000000000000014]
[null,4,70,80,null,-51.2,-93.666666666666657,null,2621.4400000000005,8773.4444444444434,null,4795.7333333333327,null,65.000000000000014,4.9999999999999858,null,null,3,80,65,65.000000000000014]
[null,5,75,80,null,-46.2,-93.666666666666657,null,2134.44,8773.4444444444434,null,4327.3999999999996,null,65.000000000000014,9.9999999999999858,null,null,4,80,70,65.000000000000014]
[null,6,65,100,null,-56.2,-73.666666666666657,null,3158.4400000000005,5426.7777777777765,null,4140.0666666666666,null,77.000000000000014,-12.000000000000014,null,null,5,80,75,65.000000000000014]
[null,7,70,100,null,-51.2,-73.666666666666657,null,2621.4400000000005,5426.7777777777765,null,3771.7333333333331,null,77.000000000000014,-7.0000000000000142,null,null,6,100,65,77.000000000000014]
[null,8,74,100,null,-47.2,-73.666666666666657,null,2227.84,5426.7777777777765,null,3477.0666666666666,null,77.000000000000014,-3.0000000000000142,null,null,7,100,70,77.000000000000014]
[null,9,80,100,null,-41.2,-73.666666666666657,null,1697.4400000000003,5426.7777777777765,null,3035.0666666666666,null,77.000000000000014,2.9999999999999858,null,null,8,100,74,77.000000000000014]
[null,10,85,100,null,-36.200000000000003,-73.666666666666657,null,1310.4400000000003,5426.7777777777765,null,2666.7333333333331,null,77.000000000000014,7.9999999999999858,null,null,9,100,80,77.000000000000014]
[null,11,88,100,null,-33.200000000000003,-73.666666666666657,null,1102.2400000000002,5426.7777777777765,null,2445.7333333333331,null,77.000000000000014,10.999999999999986,null,null,10,100,85,77.000000000000014]
[null,12,79,120,null,-42.2,-53.666666666666657,null,1780.8400000000001,2880.1111111111099,null,2264.7333333333331,null,89.000000000000014,-10.000000000000014,null,null,11,100,88,77.000000000000014]
[null,13,84,120,null,-37.200000000000003,-53.666666666666657,null,1383.8400000000001,2880.1111111111099,null,1996.3999999999999,null,89.000000000000014,-5.0000000000000142,null,null,12,120,79,89.000000000000014]
[null,14,90,120,null,-31.200000000000003,-53.666666666666657,null,973.44000000000017,2880.1111111111099,null,1674.3999999999999,null,89.000000000000014,0.99999999999998579,null,null,13,120,84,89.000000000000014]
[null,15,94,120,null,-27.200000000000003,-53.666666666666657,null,739.84000000000015,2880.1111111111099,null,1459.7333333333331,null,89.000000000000014,4.9999999999999858,null,null,14,120,90,89.000000000000014]
[null,16,98,120,null,-23.200000000000003,-53.666666666666657,null,538.24000000000012,2880.1111111111099,null,1245.0666666666666,null,89.000000000000014,8.9999999999999858,null,null,15,120,94,89.000000000000014]
[null,17,80,140,null,-41.2,-33.666666666666657,null,1697.4400000000003,1133.4444444444439,null,1387.0666666666664,null,101.00000000000001,-21.000000000000014,null,null,16,120,98,89.000000000000014]
[null,18,93,140,null,-28.200000000000003,-33.666666666666657,null,795.24000000000012,1133.4444444444439,null,949.39999999999986,null,101.00000000000001,-8.0000000000000142,null,null,17,140,80,101.00000000000001]
[null,19,95,140,null,-26.200000000000003,-33.666666666666657,null,686.44000000000017,1133.4444444444439,null,882.06666666666649,null,101.00000000000001,-6.0000000000000142,null,null,18,140,93,101.00000000000001]
[null,20,103,140,null,-18.200000000000003,-33.666666666666657,null,331.24000000000012,1133.4444444444439,null,612.73333333333323,null,101.00000000000001,1.9999999999999858,null,null,19,140,95,101.00000000000001]
[null,21,108,140,null,-13.200000000000003,-33.666666666666657,null,174.24000000000007,1133.4444444444439,null,444.4,null,101.00000000000001,6.9999999999999858,null,null,20,140,103,101.00000000000001]
[null,22,113,140,null,-8.2000000000000028,-33.666666666666657,null,67.240000000000052,1133.4444444444439,null,276.06666666666666,null,101.00000000000001,11.999999999999986,null,null,21,140,108,101.00000000000001]
[null,23,115,140,null,-6.2000000000000028,-33.666666666666657,null,38.440000000000033,1133.4444444444439,null,208.73333333333338,null,101.00000000000001,13.999999999999986,null,null,22,140,113,101.00000000000001]
[null,24,102,160,null,-19.200000000000003,-13.666666666666657,null,368.6400000000001,186.77777777777752,null,262.39999999999986,null,113,-11,null,null,23,140,115,101.00000000000001]
[null,25,107,160,null,-14.200000000000003,-13.666666666666657,null,201.64000000000007,186.77777777777752,null,194.06666666666658,null,113,-6,null,null,24,160,102,113]
[null,26,110,160,null,-11.200000000000003,-13.666666666666657,null,125.44000000000007,186.77777777777752,null,153.06666666666661,null,113,-3,null,null,25,160,107,113]
[null,27,116,160,null,-5.2000000000000028,-13.666666666666657,null,27.040000000000031,186.77777777777752,null,71.066666666666663,null,113,3,null,null,26,160,110,113]
[null,28,118,160,null,-3.2000000000000028,-13.666666666666657,null,10.240000000000018,186.77777777777752,null,43.733333333333341,null,113,5,null,null,27,160,116,113]
[null,29,125,160,null,3.7999999999999972,-13.666666666666657,null,14.439999999999978,186.77777777777752,null,-51.933333333333259,null,113,12,null,null,28,160,118,113]
[null,30,110,180,null,-11.200000000000003,6.3333333333333428,null,125.44000000000007,40.111111111111228,null,-70.933333333333451,null,125,-15,null,null,29,160,125,113]
[null,31,115,180,null,-6.2000000000000028,6.3333333333333428,null,38.440000000000033,40.111111111111228,null,-39.266666666666744,null,125,-10,null,null,30,180,110,125]
[null,32,120,180,null,-1.2000000000000028,6.3333333333333428,null,1.4400000000000068,40.111111111111228,null,-7.600000000000029,null,125,-5,null,null,31,180,115,125]
[null,33,130,180,null,{"$f":"+C38-C$68","v":8.7999999999999972},{"$f":"+D38-D$68","v":6.3333333333333428},null,77.439999999999955,40.111111111111228,null,55.733333333333398,null,{"$f":"+$D$72+$D$73*D38","v":125},5,null,null,32,180,120,125]
[null,34,135,180,null,13.799999999999997,6.3333333333333428,null,190.43999999999991,40.111111111111228,null,87.400000000000119,null,125,10,null,null,33,180,130,125]
[null,35,140,180,null,18.799999999999997,6.3333333333333428,null,353.43999999999988,40.111111111111228,null,119.06666666666683,null,125,15,null,null,34,180,135,125]
[null,36,120,200,null,-1.2000000000000028,26.333333333333343,null,1.4400000000000068,693.44444444444491,null,-31.600000000000087,null,137,-17,null,null,35,180,140,125]
[null,37,136,200,null,14.799999999999997,26.333333333333343,null,219.03999999999991,693.44444444444491,null,389.73333333333341,null,137,-1,null,null,36,200,120,137]
[null,38,140,200,null,18.799999999999997,26.333333333333343,null,353.43999999999988,693.44444444444491,null,495.06666666666678,null,137,3,null,null,37,200,136,137]
[null,39,144,200,null,22.799999999999997,26.333333333333343,null,519.83999999999992,693.44444444444491,null,600.40000000000009,null,137,7,null,null,38,200,140,137]
[null,40,145,200,null,23.799999999999997,26.333333333333343,null,566.43999999999983,693.44444444444491,null,626.73333333333346,null,137,8,null,null,39,200,144,137]
[null,41,135,220,null,13.799999999999997,46.333333333333343,null,190.43999999999991,2146.7777777777787,null,639.4,null,149,-14,null,null,40,200,145,137]
[null,42,137,220,null,15.799999999999997,46.333333333333343,null,249.6399999999999,2146.7777777777787,null,732.06666666666672,null,149,-12,null,null,41,220,135,149]
[null,43,140,220,null,18.799999999999997,46.333333333333343,null,353.43999999999988,2146.7777777777787,null,871.06666666666672,null,149,-9,null,null,42,220,137,149]
[null,44,152,220,null,30.799999999999997,46.333333333333343,null,948.63999999999987,2146.7777777777787,null,1427.0666666666668,null,149,3,null,null,43,220,140,149]
[null,45,157,220,null,35.799999999999997,46.333333333333343,null,1281.6399999999999,2146.7777777777787,null,1658.7333333333336,null,149,8,null,null,44,220,152,149]
[null,46,160,220,null,38.799999999999997,46.333333333333343,null,1505.4399999999998,2146.7777777777787,null,1797.7333333333336,null,149,11,null,null,45,220,157,149]
[null,47,162,220,null,40.799999999999997,46.333333333333343,null,1664.6399999999999,2146.7777777777787,null,1890.4000000000003,null,149,13,null,null,46,220,160,149]
[null,48,137,240,null,15.799999999999997,66.333333333333343,null,249.6399999999999,4400.1111111111122,null,1048.0666666666666,null,161,-24,null,null,47,220,162,149]
[null,49,145,240,null,23.799999999999997,66.333333333333343,null,566.43999999999983,4400.1111111111122,null,1578.7333333333333,null,161,-16,null,null,48,240,137,161]
[null,50,155,240,null,33.799999999999997,66.333333333333343,null,1142.4399999999998,4400.1111111111122,null,2242.0666666666666,null,161,-6,null,null,49,240,145,161]
[null,51,165,240,null,43.8,66.333333333333343,null,1918.4399999999998,4400.1111111111122,null,2905.4,null,161,4,null,null,50,240,155,161]
[null,52,175,240,null,53.8,66.333333333333343,null,2894.4399999999996,4400.1111111111122,null,3568.7333333333336,null,161,14,null,null,51,240,165,161]
[null,53,189,240,null,67.8,66.333333333333343,null,4596.8399999999992,4400.1111111111122,null,4497.4000000000005,null,161,28,null,null,52,240,175,161]
[null,54,150,260,null,28.799999999999997,86.333333333333343,null,829.43999999999983,7453.4444444444462,null,2486.4,null,173,-23,null,null,53,240,189,161]
[null,55,152,260,null,30.799999999999997,86.333333333333343,null,948.63999999999987,7453.4444444444462,null,2659.0666666666666,null,173,-21,null,null,54,260,150,173]
[null,56,175,260,null,53.8,86.333333333333343,null,2894.4399999999996,7453.4444444444462,null,4644.7333333333336,null,173,2,null,null,55,260,152,173]
[null,57,178,260,null,56.8,86.333333333333343,null,3226.24,7453.4444444444462,null,4903.7333333333336,null,173,5,null,null,56,260,175,173]
[null,58,180,260,null,58.8,86.333333333333343,null,3457.4399999999996,7453.4444444444462,null,5076.4000000000005,null,173,7,null,null,57,260,178,173]
[null,59,185,260,null,63.8,86.333333333333343,null,4070.4399999999996,7453.4444444444462,null,5508.0666666666666,null,173,12,null,null,58,260,180,173]
[null,60,191,260,null,69.8,86.333333333333343,null,4872.04,7453.4444444444462,null,6026.0666666666675,null,173,18,null,null,59,260,185,173]
[null,"Total",{"$f":"SUM(C6:C65)","v":7272},{"$f":"SUM(D6:D65)","v":10420},null,{"$f":"SUM(F6:F65)","v":-1.7337242752546445E-12},{"$f":"SUM(G6:G65)","v":-1.6768808563938364E-12},null,{"$f":"SUM(I6:I65)","v":78421.600000000035},{"$f":"SUM(J6:J65)","v":197193.33333333326},null,{"$f":"SUM(L6:L65)","v":118315.99999999994},null,{"$f":"SUM(N6:N65)","v":7272},{"$f":"SUM(O6:O65)","v":-3.1263880373444408E-13},null,null,60,260,191,173]
[]
[null,"Mean",{"$f":"AVERAGE(C6:C65)","v":121.2},{"$f":"AVERAGE(D6:D65)","v":173.66666666666666},null,{"$f":"AVERAGE(F6:F65)","v":-2.8895404587577406E-14},{"$f":"AVERAGE(G6:G65)","v":-2.7948014273230606E-14},null,{"$f":"AVERAGE(I6:I65)","v":1307.0266666666673},{"$f":"AVERAGE(J6:J65)","v":3286.5555555555543},null,{"$f":"AVERAGE(L6:L65)","v":1971.9333333333323},null,{"$f":"AVERAGE(N6:N65)","v":121.2},{"$f":"AVERAGE(O6:O65)","v":-5.210646728907401E-15}]
[]
[]
[null,null,"Estimadores MCO de ",null,null,null,null,null,null,"Predicted value for"]
[null,null,"b0",{"$f":"+C68-D73*D68","v":17.000000000000028},null,null,null,null,null,"REN","=",80,null,{"$f":"+$D$72+$D$73*L72","v":65.000000000000014}]
[null,null,"b1",{"$f":"+L68/J68","v":0.59999999999999987}]
[]
[]
[null,"©Este fichero Excel ha sido preparado por los profesores Víctor E. Barrios y Jorge Belaire en el marco del proyecto CONSOLIDA-PID, UV-SFPIE-PID-1639467"]

{"sheet":"Hoja3","index":2,"n_rows":971,"n_cols":125,"rows_kept":971,"cut":false,"hidden":false,"merged":[]}
[null,"POBLACIÓN",null,null,null,"MUESTRA ALEATORIA 10 OBSERVACIONES",null,null,null,null,"MUESTRA DE 10 OBSERVACIONES"]
["Individuo","Consumo","Renta",null,null,"Individuo","Consumo ","Renta",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DATOS MUESTRALES, VARIABLE DEPENDIENTE AJUSTADA O ESTIMADA Y RESIDUOS DE ESTIMACIÓN"]
[1,55,80,null,1,1,{"$f":"VLOOKUP(F3,$A$3:$C$62,2,FALSE)","v":55},{"$f":"VLOOKUP(F3,$A$3:$C$62,3,FALSE)","v":80},null,null,null,null,null,null,null,null,null,"Desviaciones ","media",null,"Productos cruzados",null,"Valores",null,null,null,"Desviaciones media",null,"Estimaciones para distintas muestras",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GRÁFICO DE DISPERSIÓN"]
[2,60,80,null,2,{"$f":"RANDBETWEEN(1,60)","v":20},103,140,null,null,null,"Consumo","Renta",null,"Desviaciones media ",null,null,"al cuadrado",null,null,"Desviaciones media",null,"Ajustados","Residuos","Residuos cuadrado","Desviaciones media ","al cuadrado del",null,"beta_0","beta_1",null,null,null,null,"Gráfico de dispersión",null,null,null,null,null,null,"RECTA DE REGRESIÓN MUESTRAL 1",null,null,null,null,null,"RECTA DE REGRESIÓN MUESTRAL 2"]
[3,65,80,null,3,55,152,260,null,null,"Obser.","CO","REN",null,"CO","REN",null,"CO","REN",null,"CO*REN",null,"CO",null,null,"CO ajustado","CO ajustado",null,{"$f":"M22","v":22.651933701657498},{"$f":"M23","v":0.56118784530386723},null,null,null,null,"Obser.","REN","CO","CO ajustado",null,null,null,"REN","CO","CO ajustado",null,null,null,"REN","CO","CO ajustado"]
[4,70,80,null,4,45,157,220,null,null,1,{"$f":"G3","v":55},80,null,{"$f":"+L6-L$18","v":-75.400000000000006},{"$f":"+M6-M$18","v":-112},null,{"$f":"+O6^2","v":5685.1600000000008},{"$f":"+P6^2","v":12544},null,{"$f":"+O6*P6","v":8444.8000000000011},null,{"$f":"+$M$22+$M$23*M6","v":67.546961325966876},{"$f":"+L6-W6","v":-12.546961325966876},{"$f":"+X6^2","v":157.42623851530848},{"$f":"(W6-L$18)","v":-62.853038674033129},{"$f":"(W6-L$18)^2","v":3950.5044705595042},null,null,null,null,"Macro 1","Ctrl+a",null,1,{"$f":"M6","v":80},{"$f":"L6","v":55},{"$f":"W6","v":67.546961325966876},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(DQ6-DS6)","v":0},{"$f":"(DQ6-DR6)","v":0}]
[5,75,80,null,5,29,125,160,null,null,{"$f":"(K6+1)","v":2},{"$f":"G4","v":103},{"$f":"H4","v":140},null,-27.400000000000006,-52,null,750.76000000000033,2704,null,1424.8000000000002,null,101.21823204419891,1.7817679558010866,3.1746970483195831,-29.181767955801092,851.57558102621942,null,null,null,null,"Macro2","Ctrl+b",null,{"$f":"(AI6+1)","v":2},{"$f":"M7","v":140},{"$f":"L7","v":103},101.21823204419891,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(DQ7-DS7)","v":0},{"$f":"(DQ7-DR7)","v":0}]
[6,65,100,null,6,56,175,260,null,null,{"$f":"(K7+1)","v":3},152,260,null,21.599999999999994,68,null,466.55999999999977,4624,null,1468.7999999999997,null,168.56077348066299,-16.560773480662988,274.25921827783048,38.160773480662982,1456.2446326424711,null,null,null,null,"Macro 3","Ctrl+c",null,{"$f":"(AI7+1)","v":3},260,152,168.56077348066299,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[7,70,100,null,7,41,135,220,null,null,4,157,220,null,26.599999999999994,28,null,707.55999999999972,784,null,744.79999999999984,null,146.11325966850831,10.886740331491694,118.52111504532789,15.7132596685083,246.90652940996958,null,null,null,null,"Macro 4","Ctrl+d",null,4,220,157,146.11325966850831,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[8,74,100,null,8,29,125,160,null,null,5,125,160,null,-5.4000000000000057,-32,null,29.160000000000061,1024,null,172.80000000000018,null,112.44198895027625,12.558011049723746,157.70364152498368,-17.958011049723751,322.49016086200032,null,null,null,null,null,null,null,5,160,125,112.44198895027625,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[9,80,100,null,9,36,120,200,null,null,6,175,260,null,44.599999999999994,68,null,1989.1599999999994,4624,null,3032.7999999999997,null,168.56077348066299,6.4392265193370122,41.463638167333052,38.160773480662982,1456.2446326424711,null,null,null,null,null,null,null,6,260,175,168.56077348066299,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[10,85,100,null,10,45,157,220,null,null,7,135,220,null,4.5999999999999943,28,null,21.159999999999947,784,null,128.79999999999984,null,146.11325966850831,-11.113259668508306,123.50454045969335,15.7132596685083,246.90652940996958,null,null,null,null,null,null,null,7,220,135,146.11325966850831,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[11,88,100,null,null,null,null,null,null,null,8,125,160,null,-5.4000000000000057,-32,null,29.160000000000061,1024,null,172.80000000000018,null,112.44198895027625,12.558011049723746,157.70364152498368,-17.958011049723751,322.49016086200032,null,null,null,null,null,null,null,8,160,125,112.44198895027625,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[12,79,120,null,null,null,null,null,null,null,9,120,200,null,-10.400000000000006,8,null,108.16000000000012,64,null,-83.200000000000045,null,134.88950276243094,-14.889502762430936,221.69729251243848,4.4895027624309307,20.155635053874956,null,null,null,null,null,null,null,9,200,120,134.88950276243094,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[13,84,120,null,null,null,null,null,null,null,10,157,220,null,26.599999999999994,28,null,707.55999999999972,784,null,744.79999999999984,null,146.11325966850831,10.886740331491694,118.52111504532789,15.7132596685083,246.90652940996958,null,null,null,null,null,null,null,10,220,157,146.11325966850831,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[14,90,120,null,null,null,null,null,null,null,"Total",{"$f":"SUM(L6:L15)","v":1304},{"$f":"SUM(M6:M15)","v":1920},null,{"$f":"SUM(O6:O15)","v":-5.6843418860808015E-14},{"$f":"SUM(P6:P15)","v":0},null,{"$f":"SUM(R6:R15)","v":10494.399999999998},{"$f":"SUM(S6:S15)","v":28960},null,{"$f":"SUM(U6:U15)","v":16251.999999999996},null,{"$f":"SUM(W6:W15)","v":1304.0000000000002},{"$f":"SUM(X6:X15)","v":-1.2789769243681803E-13},{"$f":"SUM(Y6:Y15)","v":1373.9751381215465},{"$f":"SUM(Z6:Z15)","v":7.1054273576010019E-14},{"$f":"SUM(AA6:AA15)","v":9120.4248618784495}]
[15,94,120]
[16,98,120,null,null,null,null,null,null,null,"Mean",{"$f":"AVERAGE(L6:L15)","v":130.4},{"$f":"AVERAGE(M6:M15)","v":192},null,{"$f":"AVERAGE(O6:O15)","v":-5.6843418860808018E-15},{"$f":"AVERAGE(P6:P15)","v":0},null,{"$f":"AVERAGE(R6:R15)","v":1049.4399999999998},{"$f":"AVERAGE(S6:S15)","v":2896},null,{"$f":"AVERAGE(U6:U15)","v":1625.1999999999996},null,{"$f":"AVERAGE(W6:W15)","v":130.40000000000003},{"$f":"AVERAGE(X6:X15)","v":-1.2789769243681804E-14},{"$f":"AVERAGE(Y6:Y15)","v":137.39751381215464},{"$f":"AVERAGE(Z6:Z15)","v":7.1054273576010019E-15},{"$f":"AVERAGE(AA6:AA15)","v":912.04248618784493}]
[17,80,140]
[18,93,140,null,null,null,null,null,null,null,null,null,null,null,"Error estándar de la "]
[19,95,140,null,null,null,null,null,null,null,null,"Estimadores MCO de ",null,null,"regresión",null,null,null,"Predicted value for"]
[20,103,140,null,null,null,null,null,null,null,null,null,{"$f":"+L18-M23*M18","v":22.651933701657498},null,null,{"$f":"(+Y16/P$23)^0.5","v":13.105223854066489},null,null,"REN","=",80,null,{"$f":"+$M$22+$M$23*U22","v":67.546961325966876},null,null,"RESUMEN"]
[21,108,140,null,null,null,null,null,null,null,null,null,{"$f":"+U18/S18","v":0.56118784530386723},null,"n-k-1",{"$f":"(10-2)","v":8},null,null,"R2","=",{"$f":"1-Y18/R18","v":0.8690753984866646},null,null,null,null,"beta0",{"$f":"M22","v":22.651933701657498}]
[22,113,140,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"beta1",{"$f":"M23","v":0.56118784530386723}]
[23,115,140,null,null,null,null,null,null,null,"Error estándar de los estimadores ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"se(beta0)",{"$f":"M27","v":15.355655234080988}]
[24,102,160,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"se(beta1)",{"$f":"M29","v":7.700965271553413E-2}]
[25,107,160,null,null,null,null,null,null,null,null,null,{"$f":"+P$22*((S$18+M$18^2)/S$16)^0.5","v":15.355655234080988},null,null,null,null,null,null,null,null,null,null,null,null,"error estandar de "]
[26,110,160,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"la  regresion",{"$f":"P22","v":13.105223854066489}]
[27,116,160,null,null,null,null,null,null,null,null,null,{"$f":"P$22*(1/S$16)^0.5","v":7.700965271553413E-2},null,null,null,null,null,null,null,null,null,null,null,null,"R-cuadrado",{"$f":"U23","v":0.8690753984866646}]
[28,118,160,null,null,null,null,null,null,null,null,null,null,null,"donde",null,null,null,null,null,null,null,null,null,null,"Media de y",{"$f":"L18","v":130.4}]
[29,125,160,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Desviación tipica de y",{"$f":"S47","v":34.14739293774042}]
[30,110,180]
[31,115,180]
[32,120,180]
[33,130,180]
[34,135,180]
[35,140,180]
[36,120,200]
[37,136,200]
[38,140,200]
[39,144,200]
[40,145,200,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(R16/9)","v":1166.0444444444443},null,"En gretl o Eviews"]
[41,135,220]
[42,137,220]
[43,140,220]
[44,152,220]
[45,157,220,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SQRT(S42)","v":34.14739293774042},null,"En gretl o Eviews"]
[46,160,220]
[47,162,220]
[48,137,240]
[49,145,240]
[50,155,240]
[51,165,240]
[52,175,240]
[53,189,240]
[54,150,260]
[55,152,260]
[56,175,260]
[57,178,260]
[58,180,260]
[59,185,260]
[60,191,260]
[]
[]
[]
[]
[]
[]
[null,"©Este fichero Excel ha sido preparado por los profesores Víctor E. Barrios y Jorge Belaire en el marco del proyecto CONSOLIDA-PID, UV-SFPIE-PID-1639467"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(AC349:AC448)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(AD349:AD448)","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(AC640:AC739)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(AD640:AD739)","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(AC871:AC970)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(AD871:AD970)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Hoja4","index":3,"n_rows":65,"n_cols":14,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,"RECTA DE REGRESIÓN POBLACIONAL VERSUS MUESTRAL"]
[null,null,null,null,null,null,null,null,null,"CONSUMO ","CONSUMO ","PROMEDIO "]
[null,null,null,null,null,null,null,null,"RENTA","MUESTRAL","ESTIMADO O AJUSTADO ","CONSUMO POBLACION","TÉRMINO ERROR ","RESIDUO"]
[null,"REN","E(CO/REN)","REN","CO","CO ajustado",null,null,"REN","CO","CO ajustado","E(CO/REN)","U","U ESTIMADO"]
[null,80,65,{"$f":"Hoja3!AJ6","v":80},{"$f":"Hoja3!AK6","v":55},{"$f":"Hoja3!AL6","v":67.546961325966876},null,null,null,null,null,null,{"$f":"(J5-L5)","v":0},{"$f":"(J5-K5)","v":0}]
[null,100,77,{"$f":"Hoja3!AJ7","v":140},{"$f":"Hoja3!AK7","v":103},{"$f":"Hoja3!AL7","v":101.21823204419891},null,null,null,null,null,null,{"$f":"(J6-L6)","v":0},{"$f":"(J6-K6)","v":0}]
[null,120,89,{"$f":"Hoja3!AJ8","v":260},{"$f":"Hoja3!AK8","v":152},{"$f":"Hoja3!AL8","v":168.56077348066299},null,null,null,null,null,null,0,0]
[null,140,101,{"$f":"Hoja3!AJ9","v":220},{"$f":"Hoja3!AK9","v":157},{"$f":"Hoja3!AL9","v":146.11325966850831},null,null,null,null,null,null,0,0]
[null,160,113,{"$f":"Hoja3!AJ10","v":160},{"$f":"Hoja3!AK10","v":125},{"$f":"Hoja3!AL10","v":112.44198895027625},null,null,null,null,null,null,0,0]
[null,180,125,{"$f":"Hoja3!AJ11","v":260},{"$f":"Hoja3!AK11","v":175},{"$f":"Hoja3!AL11","v":168.56077348066299},null,null,null,null,null,null,0,0]
[null,200,137,{"$f":"Hoja3!AJ12","v":220},{"$f":"Hoja3!AK12","v":135},{"$f":"Hoja3!AL12","v":146.11325966850831},null,null,null,null,null,null,0,0]
[null,220,149,{"$f":"Hoja3!AJ13","v":160},{"$f":"Hoja3!AK13","v":125},{"$f":"Hoja3!AL13","v":112.44198895027625},null,null,null,null,null,null,0,0]
[null,240,161,{"$f":"Hoja3!AJ14","v":200},{"$f":"Hoja3!AK14","v":120},{"$f":"Hoja3!AL14","v":134.88950276243094},null,null,null,null,null,null,0,0]
[null,260,173,{"$f":"Hoja3!AJ15","v":220},{"$f":"Hoja3!AK15","v":157},{"$f":"Hoja3!AL15","v":146.11325966850831},null,null,null,null,null,null,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["©Este fichero Excel ha sido preparado por los profesores Víctor E. Barrios y Jorge Belaire en el marco del proyecto CONSOLIDA-PID, UV-SFPIE-PID-1639467"]