| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
residual plot
How do I draw a residual plot on excel?
Thank you for your time and help. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
residual plot
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. |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
residual plot
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Plot area settings... | Charts and Charting in Excel | |||
| Continuous series plot | Charts and Charting in Excel | |||
| Can I copy x-y scatter plot data direct from one plot to another? | Charts and Charting in Excel | |||
| Plot Wizard -- "Not enough system resources to display completely. | Charts and Charting in Excel | |||
| Contour plot | Charts and Charting in Excel | |||
Linear Mode
