Does Excel use least squares regression to calculate trendlines?
 

I'm just trying to find out if Excel uses least squares regression analysis
or correlation to calculate trend lines - does anyone know?

Trendy,

Excel can calculate a variety of trendlines via the Charting tool. Most use
a least squares fit, which is calculated as part of creating a regression
line for a linear trend. For more information, look up "Trendlines" in
Excel's on-help. The Help provides information on the trendline equations,
forecasting and projecting values, etc.

--
Regards,
John Mansfield
http://www.pdbook.com


"Trendy" wrote:

I'm just trying to find out if Excel uses least squares regression analysis
or correlation to calculate trend lines - does anyone know?

John Mansfield wrote:

Trendy,

Excel can calculate a variety of trendlines via the Charting tool. Most use
a least squares fit,


What ones don't use least squares?

Jerry

John Mansfield wrote:

Trendy,

Excel can calculate a variety of trendlines via the Charting tool. Most
use a least squares fit,

++++++++++++++++++++++++++

Jerry W. Lewis wrote:

What ones don't use least squares?

Jerry

++++++++++++++++++++++++++

Moving Average

Mike