Operations & Maintenance Manual (O&M Manual) Template

To look at regression residuals in Excel, first do a regression and specify that you want to save the residuals Below the summary output from the regression will be a column with the residuals You can then do a scatterplot of the residuals against the explanatory variable(s) by copying the column of residuals to a column next to the explanatory ... ................
................