Home > Forum Home > Excel Multiple Regression Analysis and Forecasting Template > Regression Forecasting Template Support Resources > Remove row from Input Share

Remove row from Input

Excel Help for Remove Row From Input in Excel Multiple Regression Analysis and Forecasting Template


Forum TopicLogin

Remove Row From Input

Rate this:
(3/5 from 1 vote)
OopsIn 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 on
 
View Full Post

Find relevant Excel templates and add-ins for Remove row from Input in the