residual plot

[erin]

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

 

[Jon Peltier]

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

 

[Mike Middleton]

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