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
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.
Reply
0
0
Matthew Parsons
View Public Profile
Find More Posts by Matthew Parsons