« The state of charting software | Main | Highway Safety Agency goes rogue »



I wonder if a slopegraph might work even better with just two data points per school: 2005 and 2011. In the same way you applied generous smoothing here, do we really care about all the noise between 2005 and 2011?


Phillip: good suggestion. Instead of a slopegraph, I'd fit individual regressions to each school (this could be one regression with school effect added). It would take careful analysis though because if you look at York, or Queen Mary, or LSE, I'd say it's hard for a straight line to do the data justice. A longer time series may help. Also knowing the enrollment of each school will help.

Nick Redfern

Arranging the graph in this way also gives a really good indication of participation by geography, with the most inclusive schools on the left of the graph in the north of England and the most exclusive in the south. This is probably more relevant than reputation, because even if you haven't heard of a particular institution you will have heard of Liverpool (home of the Beatles), Manchester (home of Man. United and The Smiths), or Sheffield (where The Full Monty was set). This cultural recognition is often an important factor for students choosing a university, especially for overseas students.


In Australia we are undergoing a certain amount of deregulation, allowing increased domestic student numbers,so we are going to see similar effects.

When a top level university increases their student numbers, they can recruit from almost anywhere in their state. Basically they take the best students, who previously would have just missed out. These students don't come from low-participation areas, they would previously been the top students at lower ranked universities.

When a second-tier or lower university increases student numbers they have to recruit fairly much from their local area. The only way they can do that is to recruit students who otherwise wouldn't have attended university, so these come from low-participation areas. This also means a decrease in standards, as these students are usually not as capable. It does mean more money from the government which means those universities can use it to subsidise their research activities.


An irrelevant comment: http://www.imf.org/external/pubs/ft/scr/2013/cr1393.pdf
page 13, 'Household saving' or cubist reindeers?

Philip Howard

I don't think the charts given here are much improvement either. The assertion is that access to elite schools has not improved, so let us examine that, rather than deciding to lob line charts of one kind or another at the screen.

We need to contrast earlier access with later access, show any common trends or outliers, and give some idea of how access and its change relate to exclusiveness. So make one axis the eliteness of the university (e.g. rank from league tables). Next we need a measure of access; since access per year varies, let's show the access as a delta to the overall access for each year. But we are trying to show both level and change, so how about a slopegraph as Phillip suggested for each from 2005 to 2011, but I suggest also indicating whether the movement is significant; LSE's access varies wildly and a simple slope would not do it justice. Perhaps a fit line through the points, with some shading indicating the bounds of the points.

Alternatively, get hold of the ranking data for each year, and plot rank vs access as a path for each institution, picking out Oxford, Cambridge and any outliers, and using tapering or arrows to indicate the motion over time.

The point is to pick the question to ask, and make sure that at a glance you can answer it. At a glance, the new chart above just tells me that there are more and less accessible universities; the ranking puts absolute accessibility uppermost, which has not changed so significantly at any university to obscure a trend down and to the right, which is just the ranking. In 5 seconds, look at the chart and tell me whether the most elite universities have improved access. A clue: their ranking is not even present on the graph.

The comments to this entry are closed.


Link to Principal Analytics Prep

See our curriculum, instructors. Apply.
Kaiser Fung. Business analytics and data visualization expert. Author and Speaker.
Visit my website. Follow my Twitter. See my articles at Daily Beast, 538, HBR.

See my Youtube and Flickr.

Book Blog

Link to junkcharts

Graphics design by Amanda Lee

The Read

Keep in Touch

follow me on Twitter