Home > Forum Home > Excel Multiple Regression Analysis and Forecasting Template > Does the Spreadsheet provide method to input new independent variables... > Forecast options from the Output sheet Share

Forecast options from the Output sheet

Excel Help for Forecast Options From The Output Sheet in Excel Multiple Regression Analysis and Forecasting Template


Forum TopicLogin

Forecast Options From The Output Sheet

Rate this:
(2.5/5 from 2 votes)
OopsAt the bottom right of the Output sheet there is an area to specify the forecasting method for each of the independent variables used for the overall regression forecast.  If values are available for the independent variables, then the option to 'Leave Blank' should be selected in the blue cells to the right under Forecast Method. This will then allows values to be entered for each independent variable where this option has been specified to be used in the predication equation.
 Excel Business Forums Administrator
 Posted by on
 
View Full Post

Find relevant Excel templates and add-ins for Forecast options from the Output sheet in the