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.)