brothertruffle880

asked on

# Excel 2010 - Linear Trendlines - How are they calculated

Is the linear trendline (in the picture) actually R squared? or is it based on some other formula.

trendlines.jpg

trendlines.jpg

The linear trendline on a chart is a least squares fit to the data. You can display both coefficients and R-squared.

ASKER CERTIFIED SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**