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.