Forecasting Tools Graph

Excel Forecasting Tools Graph for Forecasting and Prediction

Submit an Excel Solution
Submit Solution [Guide]

Recently Added:
Economic Data
Punch Clock Template
Bezier Curve Fitting
Yellow Pages Data Mining
Multiple Workbook Control
More Resources:
Excel Help Forum




Follow Business Spreadsheets On:
 
Find Excel Solutions:
Select suggested text to load results or icon to view solution.
Browse Main Categories: Business Finance | Financial Markets | Operations Management | Excel Productivity
 

Forecasting Tools Graph

Rate this solution:
(3/5 from 3 votes)
Download Buy Now
Forecasting Tools Graph screenshot
Pin It
 Forecasting Tools 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 forecasting. Functions include:
  • 1 - Moving Average: Similar to Microsoft Excel Analysis Tool Pack, 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 Tool Pack, 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 Growth : 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 Growth : 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 analyzes 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: Forecasting Tools 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.

Download Buy Now
(Pricing is available on the next page)

Related Excel Solutions:Multiple Regression Forecasting (Forecasting and Prediction) | Neural Network Forecasting (Forecasting and Prediction) | Statistical Distribution Fitting (Risk Analysis) | Macroeconomic Model (Forecasting and Prediction) | Curve Fitting (Manufacturing and Engineering) | Data Plotting (Technical Analysis)

Share your thoughts with other users: Create your own review
 

Download Forecasting Tools Graph Reference
For iTunes & iOS Device


Popular Searches
1.
2.
3.
4.
5.
Add Economic Data to Excel Reports and Dashboards
See How Here

       
  © 2013 Business Spreadsheets. All Rights Reserved. Legal | About Us