One best fit lines with multiple data sets

kabradley13 — Fri, 09 Jun 2023 00:32:23 GMT

How do I calculate the residuals of data set B,C, and D using the best fit line of data set A?

Re: One best fit lines with multiple data sets

txnelson — Wed, 21 Apr 2021 03:27:50 GMT

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.