Plotting Graphs With a Spreadsheet

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

One thought on “Plotting Graphs With a Spreadsheet

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.