- |
- 0 step |
- 51 seconds

Navigate to (or if you've already made a copy, go to your file)[https://docs.google.com/spreadsheets/d/1iAVKV8lji5YKQaSLTc9zMshmKMMFjaGU/copy](https://docs.google.com/spreadsheets/d/1iAVKV8lji5YKQaSLTc9zMshmKMMFjaGU/edit#gid=4287217)

Click "Reinitializing the Independent Variable"

Zoom Saved

Click in the cell next to the first data point.

Zoom Saved

We always reinitialize the first data point as either 0 or 1 depending on how we are describing the data. In this case, we are describing the data as years SINCE 1965, so we write 0 to indicate that 1965 is zero years SINCE 1965. Type "0 [[enter]]"

Click on the cell below the one we just typed in.

Zoom Saved

Type "="

Click on the cell with 1974 in it to tell Sheets we will use it in a formula. The name of the cell(A3 in this case) will appear in the cell we were typing in.

Zoom Saved

We want to answer the question "How many years since 1965 is 1974?" so we will subtract 1974 from 1965. Type "-"

Click on the cell with 1965 in it to tell Sheets we will use it in a formula. The name of the cell(A2 in this case) will appear in the cell we were typing in.

Zoom Saved

All of our data will answer the question, "How many years since 1965 is x?" We want the second number in our formula to always refer to the cell with 1965 in it. (A2). This is called an absolute reference. To change A2 into an absolute reference, Type " [[F4]] [[enter]]"

Once we hit enter Sheets does the math 1974-1965 and displays it in the sheet. It will then guess that we want the same formula in all the cells below and suggest that we autofill. Click the check mark to accept the autofill suggestion.

Zoom Saved

You can click on some of the cells to verify that Sheets is doing what we intended it to do. Cell B4 is subtracting cell A4 from A2 as we intended. Although the cells will always display the answers, we can see how they got to them by clicking on the cells and looking at the formula bar on top.

Zoom Saved

Cell B6 is subtracting cell A6 from A2 as we intended. Although the cells will always display the answers, we can see how they got to them by clicking on the cells and looking at the formula bar on top.

Zoom Saved

Cell B7 is subtracting cell A7 from A2 as we intended. Although the cells will always display the answers, we can see how they got to them by clicking on the cells and looking at the formula bar on top.

Zoom Saved

Cell B8 is subtracting cell A8 from A2 as we intended. Although the cells will always display the answers, we can see how they got to them by clicking on the cells and looking at the formula bar on top.

Zoom Saved

Cell B10 is subtracting cell A10 from A2 as we intended. Although the cells will always display the answers, we can see how they got to them by clicking on the cells and looking at the formula bar on top.

Zoom Saved

Click here and select the data in Cells B1 to C11

Zoom Saved

Click "Insert"

Zoom Saved

Click "Chart"

Zoom Saved

Was this Scribe helpful?

Save this document for future reference.

Save this document for future reference.

Have something to say?Create an account to leave messages for the author to see!

This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe