Calculates the least squares fit for a line represented by the following equation:
where m is the slope and b is the intercept.
PolynomialCalculates the least squares fit through points by using the following equation:
where b and 
are constants.
Calculates the least squares fit through points by using the following equation:
where c and b are constants, and ln is the natural logarithm function.
Calculates the least squares fit through points by using the following equation:
where c and b are constants, and e is the base of the natural logarithm.
Calculates the least squares fit through points by using the following equation:
where c and b are constants.
Note The number of points in a moving average trendline equals the total number of points in the series less the number you specify for the period.
The R-squared value, also known as the coefficient of determination, is an indicator that ranges in value from 0 to 1 and reveals how closely the estimated values for the trendline correspond to your actual data. A trendline is most reliable when its R-squared value is at or near 1. When you fit a trendline to your data, the Microsoft Office Chart Component automatically calculates the R-squared value for the trendline by using the following equation:
Note The R-squared value you can display with a trendline is not an adjusted R-squared value. For logarithmic, power, and exponential trendlines, the Microsoft Office Chart Component uses a transformed regression model.