For those of you who may not be familiar with how to do this, here is a video on how to plot graphs (and trend lines) on a spreadsheet:

For my students there are a few things that need to be added:

  • Don’t delete the legend as he does; move it to the bottom of the graph (an option when you right click the legend.)
  • You’ll need to include the R2 coefficient along with the trend line equation; that option is included when you set up the trend line.
  • I prefer you look at polynomial regression last rather than just after linear. (Linear is obviously where you start.)
  • Add major grid lines to the x-axis (same place as when you add the x-axis legend.)