Skip to Content
Personal Insights
Author's profile photo Jason Yeung

Using Analytics to Find The College That’s Right for You.

If you have kids, you’re probably well aware of the high costs of college and how these costs keep increasing.  You’re also well aware that no matter how well you plan, you can just never save enough.  But what you probably don’t know is how analytics can help you to find the true costs of colleges and which ones provide the ‘best bang for your buck’.

The US Dept of Education publishes a College Scorecard, which provides a full list of all US institutions with 100s of variables around programs and degrees, location and sizes of schools, scholarships and grants, federal loans and defaults, household statistics, and total costs of colleges (beyond just tuition).  As an analytics junkie, I wanted to do my own analysis using SAP Analytics Cloud to find what colleges would be best for my family.

Here’s what I found…

About the Data

This data set is comprised of over 2,000 schools – 60% are private, 28% public, and the remainder are online schools.

What’s the Financial Impact of Going to College?

Here are some basic financial figures.  Since 1998, college tuition has been steadily increasing each year between 3-5% – compounded to a 96% increase (2x) over the past 20 years.

While these tuition costs have increased, the median debt among students have increased at the same rate.

What do the numbers say about the difference between Private and Public schools?

If we compare public and private colleges, this is where some of the biggest differences lie.  From the visual below, we see that you need a higher SAT score to get into public schools, but the graduation rates are higher, you’ll pay less, accumulate less debt, and make higher earnings.

So on the surface, it would seem like going to a public college is the best choice.  Not so fast.  Like most things, stats (at an aggregated level) can be very misleading.

 

What Types of SAT Scores Do I Need To Get Into College?

If we look at the top 600 colleges in the US, we can see the following.  Private schools are more expensive and they typically require higher SAT scores to get in.  This makes sense because most of the top colleges is the US are private.

Does the Graduation Rate Change Based On How Much I Pay for College?

Yes, the higher you pay for a private school, the higher the graduation rate.

What Type of Debt Can I Expect At These Different Schools?

The median debt for students is higher among private schools than public ones – as private colleges are far more expensive.

Will I Make More Money (Post Graduation) If I Go To a More Expensive School?

Aside from a few key outliers, the median earnings (post grad) are higher with the “top” private schools.

Will I Make More Money If I Go To The Best College?

The visual below shows the 2019 Forbes Rankings of these colleges.  If The median earnings (post grad) are higher with the top “ranked” private schools.

 

What Can I Expect if I go to a Top School?

The visual below is filtered for just the top 100 colleges in the US – as ranked by Forbes.  It says the following:

  • 27% of these applicants are accepted.
  • You need a 1,422 combined SAT score.
  • 89% of these students will graduate within 1 year of their expected date.
  • The average tuition will be $25k.
  • 29% of these students have a federal with an average of $16.5k.
  • These students are expected to make $66.5k within 10 years of their graduation date.

 

So Where Is the Most “Bang For Your Buck”?

Not every college is the same and each will appeal to different students based on their location, majors, personalities, and personal preferences.  But from a financial perspective, of the top 50 colleges in the US, the following had the lower tuition and higher median earnings than their peers.

What Does This All Mean?

Data is everywhere and all around us.  But without analytics, data is just data.  Turning it into analytics with tools like SAP Analytics Cloud helps arms you with actionable information to make better and more informed decisions.  For your college search, it can provide a more meaningful and more relevant way to find the school that’s right for you.

Assigned tags

      5 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Iver van de Zand
      Iver van de Zand

      cool story Jason !

      Author's profile photo Davey Hajema
      Davey Hajema

      Jason.

      Your story proves once more: data is the new gold.

      From-search-to-insight to best-value-for-money.

      Thanks for sharing this excellent story.

      Author's profile photo Theodore Borden
      Theodore Borden

      I am glad I have found your post because I am searching for the college online but facing problems in choosing college. So, I am started searching for the tips online and found https://aussieessayreviews.com/review-of-edubirdie-com-services/ website in which I can read genuine edubirdie review. I took interest in that link because my little brother is searching for help online regarding his essay. And I am glad I have found your post in which you have shared very useful analytics to find the college.

      Author's profile photo Kevin Taylor
      Kevin Taylor

      Sometimes you find the college you want to enter but there are lots of exams. You should definitely prepare yourself and study a lot to meet all the requirements. It's also common for college to have an essay task during the examination. Writing a paper can be pretty hard if you don't know exactly what to do. I've used guides on essay writing from https://studyfy.com/writing-guides/how-to-write-a-cause-and-effect-essay to make it easier for me. And guess what, I've passed and now studying in college of my dreams.

      Author's profile photo Irene dwards
      Irene dwards

      This is really a wonderful post that is very helpful for the students. I am here now to find an authenticated writing service. I work in an IIT company and here I have to write many permutations in a month that is very hard tough work to do. I heard about https://www.ihatewritingessays.com/admission-essay-writing-services writing service. Have you any other suggestions?