Michigan college comparison data story

Using Google’s Advanced Search Engine I was able to find different collections of data regarding Michigan Colleges including one I used to make a data story out of. This was an Excel sheet that covered the demographics, admission basics, and costs of Michigan colleges from 2-year, 4-year, and private schools.

Using Google’s Advanced Search to find Excel formatted data of Michigan colleges.

The section that was of most interest to me was the costs of the colleges. I was able to manipulate the data and sort it from most to least expensive universities in Michigan using the Sort and Filter tool on Excel. This allowed me to see exactly how much each university costs to attend and was helpful in organizing information in the way I needed in order to make my data story.

In fact, in terms of total expenses including tuition and fees, books and supplies, room and board, transportation, and expenses for in-state freshmen of 4-year Michigan Universities, University of Michigan-Dearborn was the least expensive. It makes me proud to know that I can get a great education at a school that is rather affordable!

Sample of the data in the college comparison excel sheet.