PPRuNe Forums - View Single Post - MS Excel. XY scatter graph - Linear regression trend line.
Old 12th December 2009 | 21:46
  #2 (permalink)  
FTE Pruner
 
Joined: Aug 2006
Posts: 43
Likes: 0
From: UK
You can do it manually by taking the equation of the line (which is a display option within the excel line plot options) and then generate another set of y data using your data set x values and then do a simple calculation to work out the delta between your data set and your new idealised data set.

This would give you an error for each value.

Is this the sort of thing you are after?

Pruner.
FTE Pruner is offline  
Reply