Home > Forum Home > Excel Multiple Regression Analysis and Forecasting Template > Regression Forecasting Template Support Resources > Remove row from Input | Share |
Forum Topic | Login |
Remove Row From Input | Rate this: (3/5 from 1 vote) |
In this case, you should not include the row for which you want to predict in the Input sheet. Run the regression on observations for which the dependent variable exists. Then choose to forecast with the option to Leave blank the independent variables. Enter the data for the independent variables into the Forecast sheet to obatin the predicted value(s) for the dependent variable. | ||
Excel Business Forums Administrator | ||
Posted by Excel Helper on |
View Full Post |
Find relevant Excel templates and add-ins for Remove row from Input in the Excel Business Solutions Directory |