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.
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. Read More