|
|
Excel Predictive Analtyics
-
Version
3.0
The Multiple Regression Forecasting template 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 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.
|