PPRuNe Forums - View Single Post - MS Excel XY Scatter graph - Linear regression trend line
Old 12th Dec 2009, 19:07
  #1 (permalink)  
scruggs
Considerably Bemused Wannabe
 
Join Date: May 2003
Location: UK
Posts: 497
Likes: 0
Received 0 Likes on 0 Posts
MS Excel XY Scatter graph - Linear regression trend line

Hi,

I've plotted an XY scatter graph in MS excel, and plotted a linear regression trend line. How can I now calculate the difference between the data points I've entered and the linear regression line?

I'm trying to work out error between the data point and the linear regression trend line.

Thanks all.

S.
scruggs is offline