Forecasting and trending

[Chris]

Could someone point me in the proper direction to be able to take advantage
of Excel's forecasting and trending capabilities. Any Excel Add-in links
would be nice as well. Thank you in advance for any help any of you can
provide

 

[Jerry W. Lewis]

To forecast in Excel, you have to specify the form of the model (sorry,
no artificial intellegence here). See Help for FORECAST (straight line
trend), TREND (linear in unknown coefficients, such as polynomials,
multiple linear regression, etc), and GROWTH (exponential growth).

Jerry

 

[Michael R Middleton]

Chris -

Could someone point me in the proper direction to be able to take
advantage of Excel's forecasting and trending capabilities. Any Excel
Add-in links would be nice as well. Thank you in advance for any help any
of you can provide <

If you're interested in a book, you could try mine: Data Analysis Using
Microsoft Excel: Updated for Office XP. It has several chapters on using
regression and other Excel features for forecasting, including a chapter
with three methods for analyzing seasonality in time series data.

- Mike

www.mikemiddleton.com