The data analysis functions can be used on only one worksheet at a time. Some tools generate charts in addition to output tables. You provide the data and parameters for each analysis, and the tool uses the appropriate statistical or engineering macro functions to calculate and display the results in an output table. If you need to develop complex statistical or engineering analyses, you can save steps and time by using the Analysis ToolPak. What do you need to know about free software? 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. 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 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. 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 model provides simple and flexible input with integrated help icons to facilitate utilization. An intuitive stepwise work flow enables to develop strong forecasts for projects in a timely manner. When predictive relationships have been identified by the automatic feature selection, forecasting can be quickly accomplished based on a range of available methodologies and accompanying statistical strength. 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. The Multiple Regression Analysis and Forecasting template enables the confident identification of value drivers and forecasting business plan or scientific data.

Linear regression excel 2010