2b:null 2c:["$","title",null,{"children":"La trampa de los promedios | Ernesto Laval | Observable"}] 31:T424,{ const statsData = stats(target); return md`__${d3.format(",")(statsData.total)}__ estudiantes (${d3.format(".0%")(statsData.total/totalStudents)} de los egresados el 2017) obtuvieron __${target}__ o más puntos en el promedio de PSU de Lenguaje y Matemática.

Autor: Ernesto Laval (@elaval) - Fuente de datos: DEMRE / MINEDUC
Dependencia	# Estudiantes	% Estudiantes
Particular Pagado	${d3.format(".3s")(statsData.PP)}	${d3.format(".0%")(statsData.PP_pct)}
Particular Subvencionado	${d3.format(".3s")(statsData.PS)}	${d3.format(".0%")(statsData.PS_pct)}
Municipal	${d3.format(".3s")(statsData.MUN)}	${d3.format(".0%")(statsData.MUN_pct)}
Administración Delegada	${d3.format(".3s")(statsData.AD)}	${d3.format(".0%")(statsData.AD_pct)}

` }32:T39ee,BlanketVis = class { constructor(el, options) { const self = this; this.transitionBaseTime = 500; this.referenceValue = 600; debugger; this.default = { attributes : null, labels: null } // Get margin, width & height from options or assume default values if (options && options.margin) this.margin = options.margin else this.margin = {top: 30, right: 20, bottom: 40, left: 150}; if (options && options.width) this.width = options.width else this.width = width - this.margin.left - this.margin.right; if (options && options.height) this.height = options.height else this.height = width/2 - this.margin.top - this.margin.bottom; if (options && options.data) this.allData = options.data else this.allData = []; if (options && options.avgData) this.avgData = options.avgData else this.avgData = {}; if (options && options.hideReference) this.hideReference = options.hideReference else this.hideReference = false; // Get attribute configuration if (options && options.attributes) this.attributes = options.attributes else if (this.default.attributes) this.attributes = this.default.attributes else this.attributes = {} // Get labels configuration if (options && options.labels) this.labels = options.labels else if (this.default.labels) this.labels = this.default.labels else this.labels = {} // Get sortCriteria (Function for getting order value for each item) if (this.options && this.options.sortCriteria) this.sortCriteria = this.options.sortCriteria else this.sortCriteria = function(d) { if (d == "AD") return 0 else if (d == "MUN") return 1 else if (d == "PS") return 2 else if (d == "PP") return 3 else return 4 } // Tooltip //this.tooltip = new tided3.view.Tooltip(); // Reescribe función generadora del mensaje en tooltip //this.tooltip.message = this.tootipMessage; this.layout = new BlanketLayout() .categoryAttribute_(this.attributes.colorAttribute) .measurementAttribute_(this.attributes.xAttribute) .amountAttribute_(this.attributes.yAttribute) .sortCriteria_(this.sortCriteria); // Determina el rango de valores para eje X var xDomain = d3.extent(this.allData, function(d) { return +d[self.attributes.xAttribute] }) debugger; // Determina el mayor valor en el eje Y acumulando todos los datos (todas las categorias) var maxYAccumulated = this.layout.maxYAccumulated(this.allData); // Determina el mayor valor tomando las categorías por separado var maxYNonAcumulated = this.layout.maxYNonAccumulated(this.allData); // Scales this.Yscale = d3.scaleLinear().domain([0,maxYAccumulated]).range([this.height,0]); this.Xscale = d3.scaleLinear().domain(xDomain).range([0,this.width]); this.YbandScale = d3.scaleBand().range([this.height,0]).padding(0.2) // Axis this.xAxis = d3.axisBottom() .scale(this.Xscale) .ticks(width < 500 ? 7 : 14); this.color = d3.scaleOrdinal(d3.schemeCategory10); this.YbandScale.domain(this.layout.categories(this.allData)); this.Ysmallscale = d3.scaleLinear().domain([0,maxYNonAcumulated]).range([0,this.YbandScale.bandwidth()]); this.data = this.allData; // Generadores de PATH elements para distintos tipos de cgráficos // Curvas Parallelas this.unstackedArea = d3.area() .x(function(d) {return self.Xscale(d.x);}) //.y0(function(d) {return self.Yscale(0+100);}) .y0(function(d) {return self.YbandScale(d.category)+self.YbandScale.bandwidth();}) .y1(function(d) {return self.YbandScale(d.category)+self.YbandScale.bandwidth()-self.Ysmallscale(d.dy);}) .curve(d3.curveCatmullRom.alpha(0.5)); // Curvas acumuladas this.stackedArea = d3.area() .x(function(d) {return self.Xscale(d.x);}) .y0(function(d) {return self.Yscale(d.basey);}) .y1(function(d) {return self.Yscale(d.basey+d.dy);}) .curve(d3.curveNatural); // Barras this.barArea = d3.area() .x(function(d) {return self.Xscale(d.x);}) .y0(function(d) {return self.YbandScale(d.category)+self.YbandScale.bandwidth();}) .y1(function(d) {return self.YbandScale(d.category);}) .curve(d3.curveNatural); this.yAxis = d3.axisLeft() .scale(this.YbandScale) .tickFormat((d) => { return labelAlias[d] || d }) //.tickSize(10) //.orient("left") // Variable utilizada para identificar si gráficos comienzan apilados this.chartType = "bars"; // "bars" | "parallelCurves" | "stackedCurves" // Crea contenedor SVG de esta vista this.svg = d3.select(el) .attr("width",this.width+this.margin.left + this.margin.right) .attr("height", this.height+this.margin.top + this.margin.bottom) this.container =this.svg .selectAll("g.container") .data([null]) .join("g") .attr("class", "container") .attr("transform", "translate(" + this.margin.left + "," + this.margin.top + ")"); this.container.selectAll("g.x.axis") .data([null]) .join("g") .attr("class", "x axis") .attr("transform", "translate(0," + this.height + ")") .call(this.xAxis) this.container.selectAll("g.x.axis") .selectAll("text.label") .data([null]) .join("text") .attr("class", "label") .attr("x", this.width) .attr("y", 30) .style("text-anchor", "end") .text(this.labels.xLabel); this.container.selectAll("g.y.axis") .data([null]) .join("g") .attr("class", "y axis") .call(this.yAxis) .append("text") .attr("class", "label") .attr("transform", "rotate(-90)") .attr("y", 6) .attr("dy", ".71em") .style("text-anchor", "end") .text(this.labels.yLabel); this.container.selectAll("line.reference") .data([null]) .join("line") .attr("class", "reference") .attr("y1", 0) .attr("y2", this.height) .attr("x1", this.Xscale(this.referenceValue)) .attr("x2", this.Xscale(this.referenceValue)) .attr("stroke", "grey") .attr("stroke-width",1) .attr("opacity",this.hideReference ? 0 : 0.9) this.render(); } render() { debugger; var self = this; // Determina el mayor valor en el eje Y acumulando todos los datos (todas las categorias) var maxYAccumulated = this.layout.maxYAccumulated(this.allData); // Determina el mayor valor tomando las categorías por separado var maxYNonAcumulated = this.layout.maxYNonAccumulated(this.allData); this.YbandScale.domain(this.layout.categories(this.allData)); this.Ysmallscale = d3.scaleLinear().domain([0,maxYNonAcumulated]).range([0,this.YbandScale.bandwidth()]); this.container.select(".x.axis") .call(this.xAxis) .select("text.label") .text(this.labels.xLabel); this.container.select(".y.axis") .call(this.yAxis) .select("text.label") .text(this.labels.yLabel); this.container.select(".y.axis") .selectAll(".tick text") .call(this.wrap, this.margin.left); var nodes = this.layout.nodes(this.data, this.avgData); this.mantos = this.container.selectAll(".manto") .data(nodes, function(d) {return d.category}) this.mantos .enter() .append("g") .attr("class", "manto") .append("path") .attr("fill", function(d) {return self.color(d.category)}) .attr("opacity", 1) .on("click", function() { self.chartType = "bars"; self.update(); }) this.bars = this.container.selectAll(".bar") .data(nodes, function(d) {return d.category}) this.bars .enter() .append("g") .attr("class","bar") .append("rect") .on("click", function() { self.chartType = "parallelCurves"; self.update(); }) this.bars .exit() .remove() this.bars.selectAll("text.value") .data(d => [d]) .join("text") .attr("class", "value") .attr("x", d => self.Xscale(d.average)) .attr("dx", 5) .attr("y", d => self.YbandScale(d.category) + self.YbandScale.bandwidth()/2) .text(d => d3.format(".1f")(d.average)) this.bars.selectAll("rect") .data(nodes, function(d) {return d.category}) .attr("x", 0) .attr("y", function(d,i) {return self.YbandScale(d.category)}) .attr("width", function(d) {return self.Xscale(d.average)}) .attr("fill", function(d) {return self.color(d.category)}) .attr("height", self.YbandScale.bandwidth()) this.mantos .exit() .remove() this.mantos.selectAll("path") .data(nodes, function(d) {return d.category}) const referenceLine = this.container.select("line.reference") .transition() .attr("x1", this.Xscale(this.referenceValue)) .attr("x2", this.Xscale(this.referenceValue)) referenceLine.node().parentNode.appendChild(referenceLine.node()); // Parallel Curves // ---------------- if (this.chartType == "parallelCurves") { if (this.previouschartType=="bars") { this.mantos.selectAll("path") .transition() .delay(this.transitionBaseTime*0.75) .attr("d", function(d) {return self.barArea(d.data)}) .attr("opacity", 1) .transition() .duration(this.transitionBaseTime*2) .attr("d", function(d) {return self.unstackedArea(d.data)}) this.bars.selectAll("rect") .attr("opacity", 1) .transition() .duration(this.transitionBaseTime) //.attr("y", function(d,i) {return self.YbandScale(d.category)}) .attr("width", this.width) .transition() .attr("opacity", 0); this.bars.selectAll("text") .attr("opacity", 1) .transition() .duration(this.transitionBaseTime) //.attr("y", function(d,i) {return self.YbandScale(d.category)}) .attr("x", this.width) .attr("opacity", 0); } else if (this.previouschartType=="stackedCurves") { this.mantos.selectAll("path") .transition() .duration(this.transitionBaseTime*2) .attr("d", function(d) {return self.unstackedArea(d.data)}) } else if (this.previouschartType=="parallelCurves") { this.mantos.selectAll("path") .transition() .duration(this.transitionBaseTime*2) .attr("d", function(d) {return self.unstackedArea(d.data)}) } // Stacked Curves // ---------------- } else if (this.chartType == "stackedCurves"){ if (this.previouschartType=="stackedCurves") { this.mantos.selectAll("path") .transition() .duration(this.transitionBaseTime*2) .attr("d", function(d) {return self.stackedArea(d.data)}) } else { this.mantos.selectAll("path") .transition() .duration(this.transitionBaseTime*2) .attr("d", function(d) {return self.stackedArea(d.data)}) .attr("opacity", 1) this.bars.selectAll("rect") .transition(this.transitionBaseTime*2) .attr("opacity", 0); this.bars.selectAll("text") .transition() .duration(this.transitionBaseTime) .attr("opacity", 0); } // Bars // ---------------- } else if (this.chartType == "bars"){ if (this.previouschartType=="bars") { this.bars.selectAll("rect") .transition() .delay(this.transitionBaseTime*2) .attr("width", function(d) {return self.Xscale(d.average)}) } else { this.mantos.selectAll("path") .transition() .duration(this.transitionBaseTime) .attr("d", function(d) {return self.barArea(d.data)}) .attr("opacity", 1) .transition() .attr("opacity", 0) this.bars.selectAll("rect") .transition() .delay(this.transitionBaseTime*0.75) .attr("width", this.width) .attr("opacity", 1) .transition() .duration(this.transitionBaseTime*2) .attr("width", function(d) {return self.Xscale(d.average)}) //.call(showBars) this.bars.selectAll("text") .transition() .delay(this.transitionBaseTime*0.75) .attr("x", this.width) .attr("opacity", 0) .transition() .duration(this.transitionBaseTime*2) .attr("x", function(d) {return self.Xscale(d.average)}) .attr("opacity", 1); } } } // Modifica el tipo de gráfico a mostrar (barra, manto o manto acumulado) setChartOption(option) { this.previouschartType = this.chartType; this.chartType = option; this.render() } setReference(value) { this.referenceValue = value; this.render() } setData(data) { this.previouschartType = this.chartType; this.data = data; this.render(); } setAttributes(attributes) { this.attributes = attributes; this.layout .categoryAttribute(this.attributes.colorAttribute) .measurementAttribute(this.attributes.xAttribute) .amountAttribute(this.attributes.yAttribute) this.render(); } wrap(text, width) { text.each(function() { var text = d3.select(this), words = text.text().split(/\s+/).reverse(), word, line = [], lineNumber = 0, lineHeight = 1.1, // ems y = text.attr("y"), x = text.attr("x"), dy = parseFloat(text.attr("dy")), dx = parseFloat(text.attr("dx")), textLength = text.node().getComputedTextLength(), tspan = text.text(null).append("tspan").attr("x", x).attr("y", y).attr("dy", dy + "em"); text.attr("y", ((words.length > 1) && (textLength > width)) ? -10 : y); while (word = words.pop()) { line.push(word); tspan.text(line.join(" ")); if (tspan.node().getComputedTextLength() > width) { line.pop(); tspan.text(line.join(" ")); line = [word]; tspan = text.append("tspan").attr("x", x).attr("y", y).attr("dy", ++lineNumber * lineHeight + dy + "em").text(word); } } }); } }33:T17e1, /** * tided3.layout.Blanket * * Helper function to calculates coordinates for set of area shapes that represent an histogram of * subjects for different values of the measurement attribute * use: * nodes = BlanketLayout().nodes(data) * input data format: * [ * {category='A', measurement:"100", amount:"1324"}, * {category='A', measurement:"110", amount:"2543"}, * {category='B', measurement:"100", amount:"432"}, * {category='C', measurement:"110", amount:"654"}, * ] * * output data format: * [ * {category:'A', * data:[ * {x=100, dy=1324, basey=0}, * {x=110, dy=2543, basey=0}, * ]}, * {category:'B', * data:[ * {x=100, dy=432, basey=1324}, * {x=110, dy=654, basey=2543}, * ]} * ] */ BlanketLayout = class { constructor() { this.measurementAttribute = "score"; this.categoryAttribute = "category"; this.amountAttribute = "amount"; } /** * Calculates coordinates (x, dy, basey) for a group of area charts that can be stacked * each area chart is associated to a category in the data objects */ nodes(data, avgData) { var categories = this.listCategories(data); debugger; var nodes = []; var values = []; _.each(categories, (category) => { var item = {}; item.category = category; item.frequencies = this.convert(data, category); item.average = (avgData && avgData[category]) || this.average(data, category); item.data = []; // Almacena todos los valores distintos de medidas utilizados en el histograma values = (_.union(values, _.keys(item.frequencies))); values = _.sortBy(values, (d) => { return parseFloat(d); }) nodes.push(item); }) this.fillBlanks(nodes, values); // Ordenar nodos por categoría (de acuerdo a función sort) nodes = _.sortBy(nodes, (d) => {return this.sortCriteria(d.category)}) // Calcula coordenadas x, dy, basey (coordenada y de la curva en categoría anterior) y las almacena en nodes this.calculateCoordinates(nodes, values); return nodes; } size_(_) { if (!arguments.length) return this.size; this.size = _; return this; } // Consulta o modifica el atributa utilizado para la medida en el histograma measurementAttribute_(_) { if(!arguments.length) return this.measurementAttribute; this.measurementAttribute = _; return this; } // Consulta o modifica el atributa utilizado para la categoría que agrupa distintos mantos categoryAttribute_(_) { if(!arguments.length) return this.categoryAttribute; this.categoryAttribute = _; return this; } // Consulta o modifica el atributa utilizado para la camntidad de sujetos por medida amountAttribute_(_) { if(!arguments.length) return this.amountAttribute; this.amountAttribute = _; return this; } // Consulta o modifica el atributa utilizado para la camntidad de sujetos por medida sortCriteria_(_) { if(!arguments.length) return this.sortCriteria; this.sortCriteria = _; return this; } maxYAccumulated(data) { var accumulatedValues = {} var categories = this.listCategories(data); _.each(data, (d) => { var prevValue = accumulatedValues[d[this.measurementAttribute]]; var newValue = prevValue? prevValue + parseFloat(d[this.amountAttribute]): parseFloat(d[this.amountAttribute]); accumulatedValues[d[this.measurementAttribute]] = newValue; }) return _.max(_.values(accumulatedValues)); } maxYNonAccumulated(data) { var groupedData = _.groupBy(data, (d) => {return d[this.categoryAttribute]}); var categories = this.listCategories(data); var max = 0; _.each(categories, (category) => { var newMax = this.maxYAccumulated(groupedData[category]); max = newMax > max ? newMax : max; }) return max; } categories(data) { return _.sortBy(this.listCategories(data), this.sortCriteria); } // Build list of categories from input data listCategories(data) { return _.uniq(_.map(data, this.categoryAttribute)) } // Calculate the average measurement for all subjects in the category average(data, category) { // Filtra datos de entrada segun dependencia var categorydata = _.filter(data, (d) => {return d[this.categoryAttribute] == category}); // Agrega suma de monto*medida var agregation = _.reduce(categorydata, (memo,d) => { return memo + parseInt(d[this.amountAttribute])*parseInt(d[this.measurementAttribute]); },0) var totalamount = _.reduce(categorydata, (memo,d) => { return memo + parseInt(d[this.amountAttribute]); },0) return agregation/totalamount; } // Convierte arreglo de datos a un objeto con la cantidad de individuos para cada valor convert(data, category) { // Filtra datos de entrada segun dependencia var filtereddata = _.filter(data, (d) => {return d[this.categoryAttribute] == category}); // Agrupa los datos en un objeto según el puntaje SIMCE var groupeddata = _.groupBy(filtereddata, (d) => { return d[this.measurementAttribute]; }); // Calcula la cantidad total de individuos para cada valor _.each(_.keys(groupeddata), (key) => { groupeddata[key] = _.reduce(groupeddata[key], (memo,d) => { return memo + parseInt(d[this.amountAttribute]) },0) }) return groupeddata; } // Creates measurements with 0 value when nonexistent fillBlanks(nodes, values) { _.each(nodes, (node) => { _.each(values, (value) => { if (!node.frequencies[value]) node.frequencies[value] = 0; }) }) } // Generates arrays of data objects that include coordinattes x, dy, basey calculateCoordinates(nodes, values) { _.each(values, (value) => { var baseY = 0; _.each(nodes, (node) => { var amount = node.frequencies[value]; var item = {}; item.x = value; item.dy = amount; item.basey = baseY; item.category = node.category; baseY += amount; node.data.push(item); }) }) } } 34:[] 2f:{"id":"e7fe9ad915abc747","slug":"la-trampa-de-los-promedios","title":"La trampa de los promedios","thumbnail":"4996e2337006bfb66d0eb5300aff3ffcf1019cf541378024895cf194ad009c40","access_level":"public","create_time":"$D2019-07-28T15:22:57.380Z","update_time":"$D2019-07-29T18:46:38.675Z","view_time":null,"first_public_time":"$D2019-07-29T18:27:27.674Z","fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"0843f5dc42ca68a0","login":"elaval","name":"Ernesto Laval","avatar_url":"https://avatars-next.observableusercontent.com/089f0414fc9025dadb05cc06d7a406bc9be10093187c46729cb4ba3a4098dc30","tier":"starter_2024"},"version":786,"publish_version":786,"role":null,"authored":false,"authors":[{"type":"individual","id":"e04cd7b5f4351ae9","login":"elaval","name":"Ernesto Laval","avatar_url":"https://avatars-next.observableusercontent.com/089f0414fc9025dadb05cc06d7a406bc9be10093187c46729cb4ba3a4098dc30","tier":null}],"members":[{"type":"individual","id":"e04cd7b5f4351ae9","login":"elaval","name":"Ernesto Laval","avatar_url":"https://avatars-next.observableusercontent.com/089f0414fc9025dadb05cc06d7a406bc9be10093187c46729cb4ba3a4098dc30","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"subscribed":null,"forks":2,"collection":null,"type":"notebook","body":{"title":"La trampa de los promedios","cells":[{"id":0,"value":"md`# La trampa de los promedios`\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":643,"value":"html`

A veces los promedios ocultan información importante que puede cambiar nuestra percepción de la realidad.

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":504,"value":"html`En el proceso de admisión a educación superior 2018, rindieron la PSU ${d3.format(\".3s\")(totalStudents)} estudiantes que egresaron de educación escolar el año 2017 y registran puntaje en las pruebas de Lenguaje y Matemática.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":519,"value":"html`Como es conocido, hay diferencias en el promedio PSU según la dependencia de los establecimientos escolares. En este grupo, los estudiantes de colegios Particular Pagados tienen un promedio de ${d3.format(\".1f\")(data.promedios.PP.promedio)} puntos. Los establecimientos de otras dependecias tienen un promedio de ${d3.format(\".1f\")(Math.max(data.promedios.MUN.promedio, data.promedios.PS.promedio, data.promedios.AD.promedio))} puntos o menos. (Datos de egresados de Enseñana Media en 2017, que rindieron la PSU en el proceso 2018, y registran puntaje en las pruebas de Lenguaje y Matemática. Fuente: DEMRE / MINEDUC)\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":652,"value":"myVisPromedios = html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":671,"value":"html`\n\n\n\n

\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":538,"value":"{ \n const target = 600;\n const statsData = stats(target);\n /*return md`__${d3.format(\",\")(statsData.total)}__ estudiantes (${d3.format(\".0%\")(statsData.total/totalStudents)} de los egresados el 2017) obtuvieron __${target}__ o más puntos en la PSU (promedio Lenguaje y Matemática).\n* __${d3.format(\".0%\")(statsData.PP_pct)}__ proviene de colegios particular pagados*/\n\n\nreturn html`Cerca de un ${d3.format(\".0%\")(statsData.total/totalStudents)} (${d3.format(\".3s\")(statsData.total)}) de estos estudiantes, obtuvo un puntaje promedio (Lenguage / Matemática) superior a 600 puntos. Podríamos decir que los estudiantes con más de 600 puntos son los que tienen los mejores puntajes PSU.`\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":567,"value":"html`\n

¿En que tipo de colegio estudia la mayoría de los estudiantes con los mejores puntajes PSU (sobre 600 puntos)?

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":573,"value":"html`

Al mirar los promedios, parecería evidente que la mayoría de los estudiantes con buen puntaje PSU proviene de colegios Particular Pagados. ¡Pero no es así!

Los promedios ocultan una mayoría de estudiantes de establecimientos Subvencionados y Municipales que obtienen buen puntaje, tal como se aprecia en la siguiente visualización:

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":323,"value":"viewof visChoice = radio({\n title: 'Tipo de visualización',\n description: 'Seleccione la visualización para \"ver\" el promedio o distribución de puntajes PSU según dependencia',\n options: [\n { label: 'Barras (promedios)', value: 'bars' },\n { label: 'Distribución', value: 'parallelCurves' },\n { label: 'Distribución acumulada', value: 'stackedCurves' },\n { label: 'Auto play', value: 'autoplay' },\n ],\n value: 'autoplay'\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":77,"value":"myVis = html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":553,"value":"html`\n\n

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":586,"value":"html`¡La mayoría de los estudiantes con puntaje PSU sobre 600 puntos estudia en colegios Particular Subvencionados o Municipales!`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":290,"value":"{\n const target = 600;\n const statsData = stats(target);\n return md`\n* __${d3.format(\".0%\")(statsData.PP_pct)}__ (${d3.format(\".3s\")(statsData.PP)}) proviene de colegios Particular Pagados\n* __${d3.format(\".0%\")(statsData.PS_pct)}__ (${d3.format(\".3s\")(statsData.PS)}) proviene de establecimientos Particular Subvencionados\n* __${d3.format(\".0%\")(statsData.MUN_pct)}__ (${d3.format(\".3s\")(statsData.MUN)}) proviene de establecimientos Municipales\n* __${d3.format(\".0%\")(statsData.AD_pct)}__ (${d3.format(\".3s\")(statsData.AD)}) proviene de establecimientos con Administración Delegada\n}\n\n`\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":606,"value":"{\n const target = 700;\n const statsData = stats(target);\n return html`\n

Si nos focalizamos sólo en los ${d3.format(\".3s\")(statsData.total)} estudiantes con más de ${target} puntos (${d3.format(\".0%\")(statsData.total/totalStudents)} de los egresados el 2017). En este grupo sí hay una mayoría - ${d3.format(\".3s\")(statsData.PP)} (${d3.format(\".0%\")(statsData.PP_pct)}) - proveniente de colegios Particular Pagados, pero también hay un grupo importante - ${d3.format(\".3s\")(statsData.total - statsData.PP)} (${d3.format(\".0%\")(1-statsData.PP_pct)}) - proveniente de establecimientos con otras dependencias.

\n`\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":625,"value":"md`Puedes consultar la distribución para cualquier puntaje de corte a continuación:`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":213,"value":"viewof target = slider({\n min: 150, \n max: 850, \n step: 10, \n value: 600, \n title: \"Promedio PSU de corte\", \n description: \"Seleccione para modificar el puntaje de referencia\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":629,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":722,"value":"html`

\nErnesto Laval (@elaval).
\nIngeniero Civil Industrial de la P. Universidad Católica de Chile
\nPhD en Educación de la Universidad de Bristol

\nMe dedico a darle sentido a la información, a través de análisis y visualización de datos\n

`\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":701,"value":"html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":410,"value":"html`\n\n`\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":330,"value":"{\n if (visChoice !== \"autoplay\") {\n bVis.setChartOption(visChoice);\n } else {\n bVis.setChartOption(autoplayChartType);\n }\n return md`Change chart type`\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":381,"value":"autoplayChartType = {\n let i = 0\n const chartTypes = [\"bars\", \"parallelCurves\", \"stackedCurves\"]\n\n while (true) {\n i = i >= chartTypes.length -1 ? 0 : i +1\n await Promises.delay(2500);\n yield chartTypes[i]\n }\n}\n\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":188,"value":"targetStats = stats(target)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":185,"value":"stats = (target) => {\n const sel = data.buckets.filter(d => +d.promedioLM >= target);\n let totals = sel.reduce((memo, d) => {\n memo.AD = memo.AD + (d.AD || 0);\n memo.PP = memo.PP + (d.PP || 0);\n memo.PS = memo.PS + (d.PS || 0);\n memo.MUN = memo.MUN + (d.MUN || 0);\n return memo\n }, {PS:0, PP:0, MUN:0, AD:0})\n \n let sumDep = totals.PS + totals.PP + totals. MUN + totals. AD;\n totals[\"PP_pct\"] = totals.PP / sumDep || 0;\n totals[\"PS_pct\"] = totals.PS / sumDep || 0;\n totals[\"MUN_pct\"] = totals.MUN / sumDep || 0;\n totals[\"AD_pct\"] = totals.AD / sumDep || 0;\n totals[\"total\"] = sumDep;\n return totals\n}\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":83,"value":"bVis = new BlanketVis(myVis, {\n data:histData, \n avgData:avgData,\n attributes: {\n xAttribute: \"score\",\n yAttribute : \"amount\",\n keyAttribute : \"category\",\n sizeAttribute : \"estudiantes\",\n colorAttribute : \"category\"\n },\n labels: {\n xLabel : \"Promedio PSU Len/Mat egresados 2017, Admision 2018\"\n }\n \n \n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":654,"value":"{\n const bVisPromedios = new BlanketVis(myVisPromedios, {\n data:histData, \n avgData:avgData,\n attributes: {\n xAttribute: \"score\",\n yAttribute : \"amount\",\n keyAttribute : \"category\",\n sizeAttribute : \"estudiantes\",\n colorAttribute : \"category\"\n },\n labels: {\n xLabel : \"Promedio PSU Len/Mat egresados 2017, Admision 2018\"\n },\n hideReference: true\n \n \n })\n bVisPromedios.setChartOption(\"bars\");\n return md`Vis Promedios`\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":365,"value":"labelAlias = ({\n \"MUN\": \"Municipal\",\n \"PS\": \"Particular Subvencionado\",\n \"PP\": \"Particular Pagado\",\n \"AD\": \"Administración Delegada\"\n\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":475,"value":"target, bVis.setReference(target);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":276,"value":"bVis.setChartOption(\"autoplay\");","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":105,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":52,"value":"histData = {\n /* [\n* {category='A', measurement:\"100\", amount:\"1324\"}, \n* {category='A', measurement:\"110\", amount:\"2543\"},\n* {category='B', measurement:\"100\", amount:\"432\"},\n* {category='C', measurement:\"110\", amount:\"654\"},\n* ]\n*/\n \n const out = [];\n adjustedData.forEach(d => {\n ([\"PS\", \"PP\", \"MUN\", \"AD\"]).forEach(dep => {\n out.push({\n category:dep,\n score:d.promedioLM,\n amount: d[dep] || 0\n })\n })\n })\n \n return out\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":69,"value":"avgData = {\n const out = {\n \"PP\" : data.promedios[\"PP\"].promedio,\n \"MUN\" : data.promedios[\"MUN\"].promedio, \n \"PS\" : data.promedios[\"PS\"].promedio,\n \"AD\" : data.promedios[\"AD\"].promedio\n };\n \n /*\n ([\"MUN\", \"PS\", \"PP\"]).forEach(d => {\n out[d] = data.promedios[d].promedio\n })\n */\n return out\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":154,"value":"adjustedData = {\n const step = 50;\n const rangos = _.range(150,850,step);\n \n const newBuckets = {};\n \n rangos.forEach(d => {\n newBuckets[d] = {\n promedioLM: d, SUB:0, PP: 0, PS:0, MUN:0, AD:0\n }\n \n data.buckets.filter(e => +e.promedioLM >= d && +e.promedioLM < d + step).forEach(f => {\n newBuckets[d].PP = newBuckets[d].PP + (f.PP || 0);\n newBuckets[d].PS = newBuckets[d].PS + (f.PS || 0);\n newBuckets[d].MUN = newBuckets[d].MUN + (f.MUN || 0);\n newBuckets[d].AD = newBuckets[d].AD + (f.AD || 0);\n })\n })\n \n return _.map(newBuckets, (d,key) => d)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":238,"value":"totalStudents = data.promedios.PP.count +\ndata.promedios.PS.count +\ndata.promedios.MUN.count +\ndata.promedios.AD.count +\ndata.promedios.OTRO.count\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":50,"value":"data = d3.json(\"https://gist.githubusercontent.com/elaval/6fe1a566cf354149c39af04a3df03dd4/raw/7168a34f498393a1e4680185df38b86f3b964164/histograma_psu_2018.json\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":342,"value":"style_bootstrap","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":775,"value":"ga = {\n const ga = await require(\"https://www.google-analytics.com/analytics.js\").catch(() => window.ga);\n ga(\"create\", \"UA-143020946-5\", \"auto\");\n ga(\"send\", \"pageview\", html``.pathname);\n return ga;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":48,"value":"d3 = require(\"d3\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":211,"value":"import {slider, radio} from \"@jashkenas/inputs\"\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":340,"value":"import {style_bootstrap} from \"@elaval/utils\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":21,"value":"_ = require(\"lodash\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W34","stdlib":"1","titling":"auto"}} 30:"$2f:body"