Regression Analysis and Forecasting

The Multiple Regression Analysis and Forecasting template enables the confident identification of value drivers and forecasting business plan or scientific data. The multiple regression process utilizes commonly employed statistical measures to test the validity of the analysis and results are summarized in text form to be easily understood. When predictive relationships have been identified by the regression analysis, forecasting can be quickly accomplished based on a range of available methodologies and accompanying statistical strength. An intuitive stepwise work flow enables to develop strong forecasts for projects in a timely manner. The Multiple Regression Analysis and Forecasting 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 expertize. The Multiple regression analysis and forecasting template 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 Multiple Regression Analysis and Forecasting template is compatible with Excel 97-2013 for Windows and Excel 2011 or 2004 for Mac as a cross platform regression and forecasting solution.

Changes: No limit to the number of independent variables. Automatic and configurable feature selection. Faster data processing. Support for categorical and logistic/binary variables. Save as XLSM feature for recent versions of Excel and enhanced exporting functions.

Minimum requirements: Requires Microsoft Excel 97 or higher

Operating system: Win98,WinOther,Win2000,WinXP,Win7 x32,Win7 x64,Windows 8,WinVista,WinVista x64,Mac Other,Mac OS X

Program URL: http://www.business-spreadsheets.com/regfor.htm

Video: https://www.youtube.com/watch?v=7Telcw_n69M

G+ Linikedin Twitter Facebook

Prediction regression provides the automatic identification of predictor variables through multiple regression analysis and advanced statistical tests.

You are able to make multiple copies of this model on the same computer. It is recommended to make a copy of the model before use so that an original 'clean' copy is accessible without the need to download a new one. Site licenses are available on purchase so that the model can be registered for an unlimited number of users within the same organization.

Business Spreadsheets MAKE NO REPRESENTATIONS OR WARRANTIES OF ANY KIND, EXPRESS OR IMPLIED, AS TO THE OPERATION OF THIS SOFTWARE OR THE INFORMATION, CONTENT, MATERIALS, OR SERVICES INCLUDED WITHIN IT. YOU EXPRESSLY AGREE THAT YOUR USE OF THIS SOFTWARE IS AT YOUR SOLE RISK. TO THE FULL EXTENT PERMISSIBLE BY APPLICABLE LAW, Business Spreadsheets DISCLAIM ALL WARRANTIES, EXPRESSED OR IMPLIED.

Read more