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 Square...
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.