- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
One best fit lines with multiple data sets
How do I calculate the residuals of data set B,C, and D using the best fit line of data set A?
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: One best fit lines with multiple data sets
- Run the regression on your initial data table
- Go to the red triangle in the output and Save the Predicted Formula, or Save Predicted, both will give you the information you need
- Go to the new column and open the formula for Predicted column
- Copy the formula into the paste buffer
- Go to the new data table you want the residuals for
- Create a new column in the data table, and open the formula for the new column.
- Paste the prediction formula into the formula for the new column
- Create another new column and name it Residual
- Apply a formula which is the Response column minus the Predicted column.
Jim