The Regression Predictive Analytics and Forecasting template provides a solid basis for identifying value drivers and forecasting business plan data. While the analysis utilizes 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. When predictive relationships have been identified either manually or through the automatic feature selection, forecasting can be quickly accomplished based on a range of available methodologies and accompanying statistical strength. An intuitive step-wise work flow enables to develop strong forecasts for projects in a timely manner. The predictive analytics model provides simple and flexible input with integrated help icons to facilitate utilization. Results and statistics are explained in a user friendly manner to be understood by users of all levels of statistical expertise. The Multiple regression analysis provides much more functionality than the Excel Analysis Toolpak such as individual regression of all independent variables, the actual level of confidence for the results, and tests of for autocorrelation and multicollinearity. The forecasting process provides options to employ 3rd polynomial, 2nd polynomial, exponential or linear trend lines on independent variables as well as the option to override independent variable forecast data with external analysis. The predictive analytics and forecasting solution is compatible with Excel 97-2013 for Windows and Excel 2011 or 2004 for Mac as a cross platform regression and forecasting solution.
