The Multiple Regression Forecasting template provides a solid basis for identifying value drivers and forecasting 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 Forecasting template 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.
- Quick forecasting process with options to employ 3rd polynomial, 2nd polynomial, exponential or linear trend lines on independent variables.
(Requires Microsoft Excel 97 or higher)