Skip to main content

Freshman Migration, 2010-2016

This is perhaps the most popular, as well as my personal favorite, post, and I'm sad that I can only do it once every two years (as the IPEDS reporting cycle only requires this data be reported bi-annually.)
This shows patterns of freshman migration within and outside of state boundaries. It's valuable to people because you can see the composition of freshman classes at colleges: Where do the students come from? You can also see patterns of state exports: Which states keep students at home, and which send them out-of-state (of course, the size and educational offerings of the various states means it's often unfair to compare, but it's still interesting.)

For this, I've limited the universe to four-year, public and private, not-for-profit institutions. Community colleges and for-profit colleges tend to have very local enrollment patterns, and high numbers of part-time students. I've also taken out institutions whose primary focus is religious training, as well as those from a few obscure Carnegie categories.

The freshmen in this analysis are only those who graduated within twelve months of enrollment in college. A word of caution: If you are afraid to click buttons and interact, stop now. This won't be of any help to you. You can't break these, and you can always reset using the controls at lower right. So click around and explore the data.

Finally, this shows the data I downloaded. Some of it is pretty clearly wrong, but that's not my problem. Contact the IR office at the offending institution and ask them what they were thinking.

So, first up: If you want to compare any four colleges on the geographic composition of their freshman classes, start here. I've added four colleges that start with "D" but you can use the controls to look at any four you want. Note: Students labeled as "in-region" are from the region, but not the state. Therefore someone "in-region" in a New Hampshire college would be from one of the five other New England states. Got it? Good. Play away on this one:



Next up: Looking at the bar charts: It's a little more complex, but you can do it.  If you want to see which colleges enroll the most (top chart) or highest percentage (bottom chart) of students from in-state, in-region, or out-of region, this is your visualization. Choose a year (it defaults to 2016), and if you wish, limit it to colleges in a region (The Southeast, for instance).  You can limit to public or private as well.  Then choose which group of students you want to explore: In-state, in-region, or out-of-region.  Again, comparing Texas to Rhode Island should only be done for the "interestingness factor," not to draw conclusions.



Here is the same data, represented on a scatter plot, in case you want to step back, and see the data all at once.  The two scales are the number of freshmen, and the percent from the region selected.



Which states export the most students, and when they export them, where do those students end up?  If you've wondered that--or if you're from Illinois or New Jersey and lament our students' mobility--this is the visualization for you.

Choose a year, and see (on the top bars, in purpley-mauve) which states exported the most students.  Then, click on a bar representing a state to see where students from that state enrolled, in the bottom chart.  If you want the college destinations to be limited to public or private, or a certain region, you can use those controls to do so.



And finally, if you're interested in which states keep students at home, you can see that, too, on this visualization. The top view looks at colleges in a state, and where their students come from; the bottom looks at students from that state, and whether they go out-of-state or stay in-state.  Again, choose a year or institutional type, if you want to look at colleges or students going to those types of colleges.



I hope you have enjoyed looking at this data as much as I have enjoyed playing with it. If you spot any errors that I've made (Tableau still has no spell check....) let me know, and I'll get to fixing them right away. Otherwise, leave a comment below with questions or observations.

Comments

Popular posts from this blog

Changes in AP Scores, 2022 to 2024

Used to be, with a little work, you could download very detailed data on AP results from the College Board website: For every state, and for every course, you could see performance by ethnicity.  And, if you wanted to dig really deep, you could break out details by private and public schools, and by grade level.  I used to publish the data every couple of years. Those days are gone.  The transparency The College Board touts as a value seems to have its limits, and I understand this to some extent: Racists loved to twist the data using single-factor analysis, and that's not good for a company who is trying to make business inroads with under-represented communities as they cloak their pursuit of revenue as an altruistic push toward access. They still publish data, but as I wrote about in my last post , it's far less detailed; what's more, what is easily accessible is fairly sterile, and what's more detailed seems to be structured in a way that suggests the company doesn...

The Highly Rejective Colleges

If you're not following Akil Bello on Twitter, you should be.  His timeline is filled with great insights about standardized testing, and he takes great effort to point out racism (both subtle and not-so-subtle) in higher education, all while throwing in references to the Knicks and his daughter Enid, making the experience interesting, compelling, and sometimes, fun. Recently, he created the term " highly rejective colleges " as a more apt description for what are otherwise called "highly selective colleges."  As I've said before, a college that admits 15% of applicants really has a rejections office, not an admissions office.  The term appears to have taken off on Twitter, and I hope it will stick. So I took a look at the highly rejectives (really, that's all I'm going to call them from now on) and found some interesting patterns in the data. Take a look:  The 1,132 four-year, private colleges and universities with admissions data in IPEDS are incl...

Freshman Migration, 1986 to 2020

(Note: I discovered that in IPEDS, Penn State Main Campus now reports with "The Pennsylvania State University" as one system.  So when you'd look at things over time, Penn State would have data until 2018, and then The Penn....etc would show up in 2020.  I found out Penn State main campus still reports its own data on the website, so I went there, and edited the IPEDS data by hand.  So if you noticed that error, it should be corrected now, but I'm not sure what I'll do in years going forward.) Freshman migration to and from the states is always a favorite visualization of mine, both because I find it a compelling and interesting topic, and because I had a few breakthroughs with calculated variables the first time I tried to do it. If you're a loyal reader, you know what this shows: The number of freshman and their movement between the states.  And if you're a loyal viewer and you use this for your work in your business, please consider supporting the costs...