Skip to main content

Reworking the Chronicle of Higher Education Visualization

This morning, The Chronicle of Higher Education published a story about the University of South Carolina, and its ambitious goal to bring African-American enrollment more in line with the state's population of African-American residents.  Given that the state population is over a quarter African-American, and USC's student population is about 9.5%, and given the timeline (by 2025), this goal is ambitious, to say the least.

The story had a chart, showing the mathematical gap of the states, using a simple measure: Percentage of African-Americans in the state flagship institution, minus the percentage of African-American students in the state population.  In case you can't get to the story (and if you work in education you really should consider supporting our trade paper with a subscription), it looks like this:

On this map, you can see the light colors, where the gap is the largest, and the dark colors, where the gap is the smallest, or in some cases, actually negative (that is, the percentage of African-Americans in the flagship is higher than the state population.)

But I wanted a little more, so I did some quick re-work on the data.  (As a side note, I wish publishers would make their data available; I had to manually re-create this, which might explain any errors you find.)  

If I were doing this, I'd have started with a different base: The African-American population of 17-24 year-olds, for instance.  And I might have adjusted representation based on the inter-state migration patterns, if I had the time and the modeling skills.  I would have also used raw numbers, and then calculated the percentages separately, as both numbers and percents can be helpful. Collectively, this quibbling demonstrates how hard it is to define precisely which institutions are doing the best job in enrolling diverse populations. Maybe another time.

As an aside, I supposed I should re-do this five-year-old visualization that used Simpon's Diversity Index. 

Using the data available, I found myself dissatisfied with the simple arithmetic gap, and instead calculated a variable called Index of Concentration where 100 is perfectly representational; anything over 100 shows over-representation, and anything under 100 indicates under-representation.  It's calculated by (flagship population/state population) * 100.

As you can see in the visualization below, this shows a different picture.  The top is an array of the states, to show some sense of values, and the bar chart on the bottom to show rank and ranges.  Blue values show over-representation; orange values show under-representation, and gray values are in the middle.




This is not to suggest, of course, that this way of looking at the data is better; it's just different.  And even this view can skew your perception of reality.  It might be easy to conclude that southern states do the worst job, while northern states do better.  While it might be fair to criticize the dark orange states, it probably wouldn't be a good idea to congratulate the blue or gray states, however.

Why? Look at the same data, viewed in yet another way: A scattergram crossing state population and flagship populations of African-American students.  It's clear that the blue states (the ones presumably doing the best job) are also the ones with lower percentages of African-Americans in the general population.  

That makes the question different, and the answer "it depends."

As always, dig into this, and let me know what you see.  And especially, what you might do better.

Comments

Popular posts from this blog

Educational Attainment and the Presidential Elections

I've been fascinated for a while by the connection between political leanings and education: The correlation is so strong that I once suggested that perhaps Republicans were so anti-education because, in general, places with a higher percentage of bachelor's degree recipients were more likely to vote for Democrats. The 2024 presidential election puzzled a lot of us in higher education, and perhaps these charts will show you why: We work and probably hang around mostly people with college degrees (or higher).  Our perception is limited. With the 2024 election data just out , I thought I'd take a look at the last three elections and see if the pattern I noticed in 2016 and 2020 held.  Spoiler: It did, mostly. Before you dive into this, a couple of tips: Alaska's data is always reported in a funky way, so just ignore it here.  It's a small state (in population, that is) and it's very red.  It doesn't change the overall trends even if I could figure out how to c...

First-year student (freshman) migration, 2022

A new approach to freshman migration, which is always a popular post on Higher Ed Data Stories. If you're a regular reader, you can go right to the visualization and start interacting with it.  And I can't stress enough: You need to use the controls and click away to get the most from these visualizations. If you're new, this post focuses on one of the most interesting data elements in IPEDS: The geographic origins of first-year (freshman) students over time.  My data set includes institutions in the 50 states and DC.  It includes four-year public and four-year, private not-for-profits that participate in Title IV programs; and it includes traditional institutions using the Carnegie classification (Doctoral, Masters, Baccalaureate, and Special Focus Schools in business, engineering, and art/design. Data from other institutions is noisy and often unreliable, or (in the case of colleges in Puerto Rico, American Samoa, and other territories, often shows close to 100% of enro...

Changes in Educational Attainment, 1940 to 2018

Note: A few people have pointed out that some data on this appears to be slightly askew, even though the story is mostly unchanged.  So don't cite it. Don't look at the viz yet.  Wait until I tell you. This is an update to a post I did about five years ago , showing the growth in educational attainment in the US over time. I thought then, and I still think, it's among the most jaw-dropping visualizations I've done, not, of course, for the visualization skills, but for the story it tells, and perhaps, the future it holds for us. This is from Table A-1 on this page of the Census Bureau. First, before you dive into it, take a guess about the percentage of adults in the US, aged 35-54 with a bachelor's degree or higher.  Got a guess?  If  you have a college degree, you probably said something like fifty or sixty percent, based on my sampling of twenty people or so.  If you didn't, your guess is probably much lower, usually ten or fifteen percent.  T...