| Home > Forum Home > Excel Multiple Regression Analysis and Forecasting Template > Does the Spreadsheet provide method to input new independent variables... > Using the forecast feature | Share |
Using the forecast feature
Excel Help for Using The Forecast Feature in Excel Multiple Regression Analysis and Forecasting Template
| Forum Topic | Login |
Using The Forecast Feature | Rate this: (3.5/5 from 2 votes) |
 | OK - now I understand too. In this case, you want to use the Forecasting feature in the bottom right of the results. Choose at least one period (to allow the input of the independent variables) and the option to 'Leave Blank' for each independent variable. This will then output a forecast for the dependent variable using the regression equation with cells available to input the values of the independent variables to return the predicted value. | |
| Excel Business Forums Administrator | ||
| Posted by Excel Helper on | ||
| View Full Post |
| Find relevant Excel templates and add-ins for Using the forecast feature in the Excel Business Solutions Directory |