Excel Instructions: Linear Relationships
To do this in Excel:
- Scroll down to row 16 of the data. You will see that this contains the values of the variables for the elephant.
- Click on the row header 16 to select the entire row of data.
- Right-click and choose Delete from the pop-up menu to delete the row.
You will see that the values of the variables for the elephant have been removed from the data. Notice also that the correlation between gestation and longevity has changed.