Home > Forum Home > Excel Multiple Regression Analysis and Forecasting Template > Run Forecast Share

Run Forecast

Excel Help for Run Forecast in Excel Multiple Regression Analysis and Forecasting Template


Forum TopicPost Reply Login

Run Forecast

Rate this:
(3/5 from 1 vote)
ConfusedWhen I run "run forecast" the forecast output for the dependant is the same and the formula reads =((($A$2)+0)+0)+0. Please help.
 Posted by on
 
Replies - Displaying 1 to 2 of 2Order Replies By: Most Recent | Chronological | Highest Rated
Oops
Rate this:
(3/5 from 1 vote)
The forecast formula for the dependent variable is the same as the regression formula.  Make sure that the regression process has been run before running the forecast setup.
 Excel Business Forums Administrator
 Posted by on
Happy
Rate this:
(3/5 from 1 vote)
This error was due to a changed behaviour in Excel 2007.  The template has now been modified for this and can be downloaded from http://www.business-spreadsheets.com/download/regfor.zip.
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Run Forecast in the