|
|
 |
Operations
Management/Industrial Engineering |
| |
-
Forecasting |
| |
The
add-in implements several forecasting methods for data series
including: moving average, exponential smoothing, regression
and double exponential smoothing. The add-in constructs a form
that holds the data and uses functions to compute forecasts
and forecast errors. Several data series can be analyzed on
a single worksheet page. An option allows comparison of several
methods for a single time series. A simulation option creates
data simulated with the Monte Carlo technique. A portfolio
option evaluates and forecasts a portfolio of investments.
Adjustments are provided for series with seasonality. |
|
| Add-in - Click the add-in
name to download a zipped .xla file. |
Add-in Name |
File |
Date |
|
forecast.xla |
2/06/2011 |
| Demonstration Files -
Click the demo name to download a .xls file. |
Demo Name |
File Name |
|
|
forecast_demo.xls |
|
|
| |
|
|
