How to Do Residuals in Excel. Linear regression models predict the outcome ... Excel 2013 can compare this data to determine the correlation which is defined by a regression equation. This eq ...

Estimating Coefficients and Predicting Values. The equation y = mx +b represents the most basic linear regression equation:. x is the predictor or independent variable; y is the dependent variable ...