Regression Analysis and Forecasting 1.0
Producing statistically sound value driver identification for forecasting data
From: Business Spreadsheets
The multiple regression analysis and forecasting model provides a solid basis for identifying value drivers and forecasting business plan data. While it utilises a range of commonly employed statistical measures to test the validity of the analysis, results are summarized in text for ease of use. Once relationships have been identified, forecasting can be accomplished based on a range of available methodologies. The intuitive step-by-step usage flow enables you to develop strong forecasts for your projects in a timely manner. The key features of the Multiple Regression Analysis and Forecasting model include: Ease and flexibility of input, with embedded help prompts; User-friendly results display for the 'Non-statistician'; Multiple and Individual Regression of independent variables; Tests for statistical significance, auto-correlation, and multi-colinearity; and Quick forecasting process with options to employ 3rd polynomial, 2nd polynomial, exponential or linear trend lines on independent variables.
Changes on the new version:
Improved user interface design, work flow and cross platform compatibility.