ExcelBanter - residual plot

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - residual plot (https://www.excelbanter.com/charts-charting-excel/112745-residual-plot.html)

How do I draw a residual plot on excel?
Thank you for your time and help.

A residual is the difference between measured Y and predicted Y. Presumably
you have X and Y in two columns of your worksheet. In the next column, put
calculated values for Y based on the fitting parameters determined from the
XY data, and in the column after that subtract the predicted from the
measured to get residuals. Now plot X and residuals in an XY chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

"erin" wrote in message
...
How do I draw a residual plot on excel?
Thank you for your time and help.

erin -

The Regression tool of Excel's Analysis ToolPak provides plots of residuals
versus each X variable for multiple regression.

- Mike
http://www.mikemiddleton.com

"erin" wrote in message
...
How do I draw a residual plot on excel?
Thank you for your time and help.