The first step in running regression analysis in Excel is to double-check that the free plugin Data Analysis ToolPak is installed. This plugin makes calculating a range of statistics very easy.

For this Step-by-Step guide below, I will use the following table that contains data with a linear trend to explain how to do linear regression in Google Sheets using the LINEST function.