Lecture 13

First Stab at a Graph

Download the bu-housing-dataset-9-7-16, and open the file in Excel or another Spreadsheet App. Look at the column headings: dorm, class year, school, and home town. What kinds of stories can you tell using a graph to show how those headings correlate with one another? I’m guessing it’s a story about how the student population of dorms differ, but note that you can:

  • focus on just one class year, or
  • group dorms together to focus on, say, West Campus vs. South Campus vs. East Campus, or
  • focus on just 2 or 3 colleges.
  • group hometowns together to distinguish “East Coast” vs. “Middle America” vs. “West Coast” vs. “Abroad”

Do some data wrangling to produce a graph in Excel. Take a screenshot and post the screenshot in the comments below. If you can’t label the axes, give a verbal description in your comment.

Add a Response

Your email address will not be published. Required fields are marked *

Separate ¶s with TWO returns.