Linear Regression
Open the spreadsheet below. Make your own copy.
https://docs.google.com/spreadsheets/d/1MRhPlwldEGehkGD9bvz-ws4qkUkttSqdP6_4fmxvOBM/edit?usp=sharing
Get the XLMiner add-on. Go to Add-ons --> Get Add-ons, search for "XL Miner" and then click on "XL Miner Analysis Toolpack" and add it.
When you are ready to carry out a regression:
Carry out a linear regression on Gestation Period vs. Average Life Span
Open XLMiner. Choose "Linear Regression."
Select the y-values, then the x-values.
Select an output range. Make sure it is to the right of the data, so it doesn't overwrite your data. It only needs to be one cell.
Select: Labels, Residuals, and Line Fit Plots.
Press OK.