Discussions
Categories
Groups
Help
Home
User Community
Discussions
One best fit lines with multiple data sets
kabradley13
How do I calculate the residuals of data set B,C, and D using the best fit line of data set A?
Accepted answers
All comments
txnelson
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.
Quick Links
All Categories
Recent Posts
Activity
Unanswered
Groups
Help
Best Of