PPRuNe Forums - View Single Post - MS Excel. XY scatter graph - Linear regression trend line.
Thread: MS Excel. XY scatter graph - Linear regression trend line.
View Single Post
Old 12th December 2009 | 19:34
  #1 (permalink)  
scruggs
Considerably Bemused Wannabe
20 Anniversary
 
Joined: May 2003
Posts: 498
Likes: 0
From: UK
MS Excel. XY scatter graph - Linear regression trend line.
Hi guys, hope you don't mind me posting this here, just seems the type of question could answer...

I've plotted an XY scatter graph in MS excel, and added 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 each XY data point and the linear regression trend line.

Thanks all.

S.
scruggs is offline  
Reply
0