Prediction regression performs multiple linear regression analysis on large sets of variables to identify casual and influential relationships. Statistical tests are explained in simple text for fast interpretation and utilization for predictive analysis and forecasting. The identified and statistically robust prediction equation can be automatically applied to variable data to produce predictions and forecasts.
Prediction regression provides the automatic identification of predictor variables through multiple regression analysis and advanced statistical tests. Regression results are presented in a simple and easy to understand format to quantify the relative influence of each input variable. The work flow facilitates and iterative process to test, maintain and discard variables until a prediction regression equation can be established with maximum confidence. Supplementary statistical analysis to reveal underlying data relationships include autocorrelation under the Dubin-Watson statistic and multicollinearity between individual independent variables. Standard tests include F statistic confidence intervals, adjusted R-squared, standard errors, t-test statistics and p values. The resulting prediction regression equation can subsequently applied to integrated forecasting methods or custom data for the independent variables to produce predictions and forecasts of desired period length. Built-in forecasting options for predictive analysis include linear, polynomial and exponential methodologies. Prediction regression runs in Excel for both Mac and Windows platforms.
The regression prediction application is a fast and easy to use solution for forecasting and identifying causal relationships.
The Excel Multiple Regression Analysis and Forecasting Template provides a basis for identifying causal and predictive relationships within series of datasets to provide statistically confident and reliable forecasting solutions. The multiple regression process employs a set of established statistical measures to ensure the empirical validity of the regression analysis. Regression results are summarized in explanatory text to facilitate interpretation and simplify the identification appropriate predictive relationships. The forecasting solution provides analysis on several methodologies that can then be utilized for forecasting independent variables for predicting and forecasting with the predictive analytics and regression equation.
Key features of the Excel Multiple Regression Analysis and Forecasting template include:
The simple and intuitive workflow allows for sound data forecasts to be developed in a timely manner. The generic nature of the design allows any type of data to be regressed and forecast including business and financial data, time series and scientific data. Common business applications for predictive analytics via multivariate regression include real estate or market valuation and sales forecasting.
The regression input data is analyzed and checked for numerical values before processing to ensure accuracy and avoid unobserved calculation errors. Categorical and logistic (binary) data variables are detected and proxy numerical equivalent mappings are used for regression analysis.
Configurable feature selection isolates the best combination of variables to best fit the regression for maximum accuracy and persistence of predictions.
The multiple regression analysis results are displayed in user friendly explanations without requiring statistical knowledge to interpret and use.
The regression output analysis presents detailed results for both multiple regression and individual regression statistics for each independent variable including standard errors t-statistics and p-values. Statistics for isolated independent variables are useful for testing and removing variables which do not have a significant predictive relationship.
Statistical tests for significance, autocorrelation and multicollinearity are calculated, displayed and explained to be easily interpreted and acted on in order to understand and optimize the validity of the regression analysis.
The forecasting process is streamlined with options to employ 3rd polynomial, 2nd polynomial, exponential or linear trend lines on independent variables based on calculated statistical strength. Alternatively, independent variable forecast input can be left empty to use external forecast data or alternative assumptions.
Do you have any tips for using Regression Prediction? Please add them to this list.
Please vote up or down any tips that are already here. Thank you!
Do you know any Regression Prediction alternatives? Please add the names of each tool to this list and help others to find them and try them out. Please vote up or down any alternative so we find the most popular ones. Thank you!
We hope you enjoy Regression Prediction. To search for any other online tool please use our search box at the top of the page.
If you have benefited from what you have learned here we hope you will consider sharing this page with your social media friends by using one of the sharing buttons out on the left. Thank you!
If you have any questions about Regression Prediction please ask in the comment boxes below either Google+ or click over to Facebook. If you know lots about Regression Prediction or any other tool featured in The Web Tools Wiki then please let us know in the comments as well. We will connect with you and give you editing rights. We often pay regular editors for their time.