Does Excel use least squares regression to calculate trendlines?

T

Trendy

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

John Mansfield

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

Jerry W. Lewis

John said:
Trendy,

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


What ones don't use least squares?

Jerry
 
M

Mike Middleton

John said:
Trendy,

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

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

Jerry W. Lewis wrote:

What ones don't use least squares?

Jerry

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

Moving Average

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Regression - trend line vs. data points?? 1
Regression Analysis on Excel 2
What's equation for R-Squared value given for chart trendlines? 4
Polynomial regression - how does Excel do it? (under "Trendline") 2
Trendline partial data 2
Deming Regression for labs 4
Trendline R square 2
Regression gives slope of zero when x values smaller than 10^-7 4

Top