Regression - trend line vs. data points??


W

WA

In Excel 2003, I used the Data Analysis Toolkit to perform a linear
regression. Does anyone know how I see the variance of each datapoint away
from the line of best fit?

Tools - data analysis - regression (i dont know if there is an option in
this process that will display the data i am looking for)

Thanks.
 
Ad

Advertisements

M

Mike Middleton

WA -

The Regression tool has a checkbox for Residuals, in which case it provides
Residuals (difference between actual Y and predicted/fitted Y) for each data
point.

- Mike
http://www.MikeMiddleton.com



In Excel 2003, I used the Data Analysis Toolkit to perform a linear
regression. Does anyone know how I see the variance of each datapoint away
from the line of best fit?

Tools - data analysis - regression (i dont know if there is an option in
this process that will display the data i am looking for)

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top