ForecastingTools Graph for Microsoft Excel 2000 and later



ForecastingTools Graph provides the most Known and commonly used Forecasting methods  for Marketing, Economics, Accounting, Operations Management. 
A simple and powerful management tool on any desktop, indispensable for those who need to perform forecastings.

 

ForecastingTools Graph Features

1 - Moving Average: Similar to Microsoft Excel Analysis ToolPack, this tool adds the  Optimizer Function that returns the number of periods (between 2 and 6) that minimizes the Mean Square Error. 

2 - Exponential Smoothing: Similar to Microsoft Excel Analysis ToolPack, this tool adds the  Optimizer Function that returns the Damping Factor  (between 0 and 1) that minimizes the Mean Square Error.

3 - Double Exponential Smoothing: This tool allows you to apply this advanced Forecasting model. You can define the two smoothing factors (Alpha and Beta) or use the Optimizer Function that returns the combination of smoothing factors (between 0 and 1) that minimizes the Mean Square Error. Only available if Correlation > 50%.

4 - Exponential Grownth : This tools allows you to calculate the curve that best fits the Time Series. Extremely useful for Internet Statistics Forecasting. Only available if Correlation > 90%.

5 - Linear Grownth : This tools allows you to calculate the line that best fits the Time Series. Only available if Correlation > 75%. 

6 - What's The Best model?: This tool performs simultaneous Time Series analyses and presents the Mean Square Errors sorted and the available methods. 

7 - Calculate Seasonal Indexes: In many situations (e.g. ice cream sales) the Time Series values vary from period to period according a similar pattern. This tools allows you to calculate the Seasonal Indexes  to complete your Forecast. 

8 - Winters model for seasonal Time Series: a powerful procedure is provided to analyze highly seasonal Time Series.

9 - Time Series Decomposition: powerful procedures to decompose Time Series in basic components (Trend, Cyclical, Seasonal and Random). 

10 - Forecasting Periods: ForecastingTools Graph can forecast any number of future periods. 

11 - High-Low-Chart: HLC module was designed to analyze stock market data and generates a simulation of future values, incorporating past errors. 

 

ForecastingTools Graph Users Comments

(...) The testing I did manage to perform using monthly UK retail car sales data appeared to work reasonably well (using the Winters model) when estimating over the full sample period.(...)  The limit of the forecast period to 1-5 is highly limiting, particularly if your modelling on a monthly basis and having to generate forecasts 2 years ahead. The seasonality elements are good and so is the decompositional time series wizard.
Generally, I was impressed with the product (especially the compact graphics output), but as I said, the restriction on forecast period was a significant downside.
Jon Shepheard

Mr. Moreira,
I solved the problem with your help, I want to thank you a lot for your preoccupation, your forecasting tools are very very useful and the have helped me a lot.

System Requirements

MS Excel 2000 or later

Additional Info

Goto Developer Web Site for more information

   Buy Online   $75.00

More Forecast Software