Linear data sets (for your enjoyment)

Kicking off the year in my modeling physics course means practicing working with and interpreting linear data. Some students quickly pick up the modeling method of describing slope and intercept, while other students just need more practice for the data to speak to them in the same way.

I use the spaghetti bridge lab to introduce graphing linear relationships and have a pretty good handout1 with a few more linear data sets as practice.

However, my experience has taught me two things:

  1. There will be students that just need a bit more practice to really nail down the skill.
  2. It's deceptively hard coming up with linear data sets.

So, I sat down earlier and surfed the internet, found some real data sets, cleaned them up a bit, and imported them into Excel & Google Sheets (from whence they are easily copyable and paste-able). I might as well share them, because I know you'd prefer to avoid converting .txt data files to .xlsx. In fact, I'll make the Google Sheets version editable, so you can add your own awesome data sets).

Download the data sets

The Excel version includes graphs with the equation for best fit lines. Google Sheets doesn't do best-fit lines yet, so those have the graphs (as interpreted by the Google Sheets converter), but no equations.



  1. from the AMTA Modeling Physics curricular materials, which is why I'm not sharing them here. But, seriously, you should just join the AMTA so you can access the huge wealth of resources they provide. Here's the link. Do it. (back)
Bookmark and Share