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 3 of 3Order 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
Confused
Rate this:
(3/5 from 1 vote)
The Process of ForecastingDevelop the basis of forecasting. Estimate the future operations of the business. Regulate the forecast. Review the process.
Regards,Rachel Gomez
 rachel
 Posted by on
 Displaying page 1 of 1 

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