Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open excel from htm page | Excel Discussion (Misc queries) | |||
Getting Excel Data from One Sheet to Another.... | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel |