How to Add Linear Regression Data Analysis Tool in Excel. In this post we shall look at how one can use find a linear regression of any model using excel and Google sheets. You need to calculate the linear regression line of the data set.
Select the Linear TrendRegression type.
If we expect a set of data to have a linear correlation it is not necessary for us to plot the data in order to determine the constants m slope and b y-intercept of the equation. Then click and drag your cursor in the Input Y Range field to select all the numbers you want to analyze. We have used Excel formulas to get the foretasted sales using linear regression equation. How to do linear regression excel Before we start creating the linear regression line we first need to know which data to put.