Forum Discussion
Calculating the Trendline
When analyzing a scatter plot, what method does Excel use to create the Trendline?
I'm assuming that the Trendline is the same as the Line of Best Fit and would use a method such as "Least Squares Method" to calculate the linear equation with the highest possible correlation coefficient.
1 Reply
- Excel uses the least squares method for trendlines indeed. You can get the trendline parameters by using the LINEST worksheet function using the same x and y data as in your chart.
