Regression - trend line vs. data points??

[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.

 

[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.