I'm just trying to find out if Excel uses least squares regression analysis
or correlation to calculate trend lines - does anyone know?
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks