Linear Regression Equation Excel. Now first calculate the intercept and slope for the regression equation. We have all the values in the above table with n 4.
Y dependent variable b the slope of the regression line. Select the y range a1 a8. Select the x axis horizontal and y axis data and click ok.
Click in the equation area labeled c figure 5 type an equal sign and then a parentheses click in the cell representing y in.
You can find the scatterplot. On an excel chart there s a trendline you can see which illustrates the regression line the rate of change. Can t find the data analysis button. ε is the random error term.
