Higher Ed Data Stories

In 2015, I wrote this post on falling yield rates.  It was pretty obvious to many of us in the profession that this trend was widespread, and largely driven by a dramatic increase in applications against a more modest increase in actual students who could or would enroll.

It apparently wasn't so obvious to everyone.  Response was much stronger than I thought it would be, and I never had seen so many requests from people who wanted to share it with their trustees (btw, this is public; you never have to ask permission to share).

So I redid it, using trend data from 2005 to 2018.  First a couple of definitions:


Admit rate is the percentage of applicants who were offered admission (admits/applicants).Yield rate is the percentage of admitted students who enroll (enrollers/admits).Draw rate is not commonly known, and I wish I remember who first mentioned it to me in the 1980's.  It stuck with me and is a valuable metric, I think, as we attempt to measure market position.  It's Y…

It's always good to get some perspective. And thus, every so often, I download fresh data and do this visualization, with a few variations on a theme. We love to focus our collective attention and wonder on a handful of high profile, well known, well resourced, and highly selective institutions. Is that amount of attention warranted? You decide.

This shows just under 2,400 four-year public and private, not-for-profit institutions. I've broken these institutions into selectivity bands, based on 2018 freshman admissions data. You can see how many there are, how many students they enroll, how much of endowment they collectively control, and and what their average endowments are on the first tab. The second tab looks at variables by percentage of totals: Thus, not how much, but what percentage? Be sure to read the Data Notes tab for a few minor caveats.

This is not precise, but the patterns would hold for the most part. Of course, you can also see what percentage of colle…

Freshman Migration--or patterns of enrollment by new students, has always been of interest to me.  So I'm always thrilled when IPEDS releases new data, and the 2018 stuff is out.  This time, I decided to download every bit of it that's available, and give users the option to take a longer view, if they want.

Some caveats: IPEDS only requires this data in even-numbered years, so that's what I downloaded.  Still, there are some colleges that did not report for some years; don't write to let me know about it, as I've included it if they did.  Second, there are always a few mistakes in the data.  One year I found that Harvard reported 237 freshmen from Arkansas when they meant California. It happens.

Anyway, four views here, using the tabs across the top:

Freshman Migration Patterns shows data over time: What number and percentage of students went to college in-state, in-region, or out-of-region.  Use the filter at top right to choose one state.  The different patterns …

This is always a popular post, it seems, and I've had a couple of people already ask when it was going to be out.  Wait no more.

This is IPEDS 2018 admissions data, visualized for you in two different ways.  You can switch using the tabs across the top.

The first view is the universe of colleges and universities that report data; not every college is required to, and a few leave data out, and test optional colleges are not supposed to report test scores.  But IPEDS is not perfect, so if you find any problems, contact the college.

On the first view, you'll see 1,359 four-year private and public, not-for-profit institutions displayed.  In order to make this as clean as possible, I've taken out some specialty schools (nursing, business, engineering, etc.) as many of those don't have complete data.  But you can put them back in using the filter at top right.

Hover over any bar, and a little chart pops up showing undergraduate enrollment by ethnicity.

You can also choose to…

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.  There's a less…

This will probably be the final post in Higher Ed Data Stories for a while.  As you may already know, I'm leaving DePaul for the "best coast" to take the position of Vice Provost of Enrollment at Oregon State University, effective July 1.  Thus, I'll be in personal and professional transition for a while, and once I arrive, I'll be busy learning a new institution and working on new challenges that should keep me occupied for a while. (Additionally, I'm not sure what my Tableau situation will be like...)

As you may already know, HEDS got its start when I decided to revise and share work I was already doing in my job at DePaul. Much of it, I presumed, would be of interest to university colleagues and high school and independent counselors.  But I had no idea how many people craved information like this.

So, for now, here is information about bachelor's degrees earned in 2011, 2014, and 2017, the most recent available in the IPEDS data center.  It's pres…