To forecast the dependent variable all of the rows should be entered on the Input sheet to run the regression analysis first.
The Output sheet then allows to forecast the dependent variable. If the forecast method chosen for an independent variable is "Leave blank", this assumes that predictive data will be entered for that variable such as that provided by external sources or analysis.
Alternatively a forecast method can be chosen such as Linear, Exponential or Polynomial. These methods analyze the historical data trend to forecast the independent variable accordingly. When all data the forecasts of the independent variables are then used in the regression equation to forecast the dependent variable reflecting the predictive regression relationships.
