Skip to main content

Story Telling With Data Challenge

I've often seen the challenges issued by Cole Knaflic on the Story Telling With Data website, and found the most recent one, creation of a scatterplot, to be too tempting to pass up. I used Tableau to create it, and yes, I've written about this before.

This is IPEDS data, from Fall of 2015 (the most recent complete set available).  It shows the strong correlation between standardized test scores and income.  And I think it shows something else, too.

On the x-axis, choose SAT or ACT scores (depending on your comfort) to see how higher scores translate into fewer lower-income students (as measured by eligibility for Pell Grants).  The bubbles are color-coded by control, and sized by selectivity (that is, the percentage of freshman applications accepted.)  Highly selective institutions are coded as larger bubbles, and less selective as smaller bubbles.

Note the cluster of private, highly selective institutions at the lower right: Most of these constitutions are among the nation's wealthiest, yet they enroll the lowest percentages of low-income students.  And, at the same time, they deny admission to the greatest numbers of students.  I presume they had many low-income students among those who were not offered admission.

Causality is complex, of course, and tests measure and vary with social capital, opportunity, and student investment as well as income and ethnicity. But this is one of those instances where a single picture tells the whole story, I think.  What about you?


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