Linear Regression Equation Excel. ε is the random error term. Here s a more detailed definition of the formula s parameters.
From our linear regression analysis we find that r 0 9741 therefore r 2 0 9488 which is agrees with the graph. Here s the linear regression formula. Select the residuals checkbox and click ok.
Here s the linear regression formula.
Y is the predicted score of any x value. Y dependent variable b the slope of the regression line. Select regression and click ok. Can t find the data analysis button.