Written instructions for finding a "trendline" in Google Sheets.

Make sure each column has a header.
The independent data is in the left column and the dependent data is in the right column.
Highlight both columns of data, including the header,to be graphed.
From Google's "Insert"menu select "chart."

From the shart types menu select "scatter"

Assuming your data looks linear, go to the "Customization" tab in the "Chart Editor's" window.

There is a scrolling window in the left side of this dialog box. Scroll down until you see a command called "tredline."

 

There is a drop down buttom next to where it says trendlind. From this button choose "linear.

Underneath the trendline command is a title that says "Label." To the left of this is a drop down button. Click on it and select "Use equation."

Underneath all of this is a check box that says Show R2. Check this box.

10  Click on the "Insert" button in the dialog box. To the right of the graph is hte trandline equationand R2.

 


Below is a video showing how to use Google's Sheets Linearize data by finding the trendline

This video can be found on YouTube at https://youtu.be/F1jP_8y6nPc


by Tony Wayne ...(If you are a teacher, please feel free to use these resources in your teaching.)