nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

378497_en-US

liliconcom

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?

Analytics

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.

Comments

There are no comments yet