PPRuNe Forums - View Single Post - MS Excel. XY scatter graph - Linear regression trend line.
Old 20th December 2009 | 16:48
  #5 (permalink)  
Matthew Parsons
 
Joined: Feb 2005
Posts: 340
Likes: 1
From: KPHL
Rather than copying the result from the graph, use the LINEST() function. It will give you m and b from y=mx+b. That way if your data changes, then you don't have to enter the coefficients manually from the graph.
Matthew Parsons is offline  
Reply