Regression Forecasting Template Support Resources

Excel Help for Regression Forecasting Template Support Resources in Excel Multiple Regression Analysis and Forecasting Template

Regression Forecasting Template Support Resources

Rate this: (3/5 from 1 vote)

	Welcome to the Excel Help Forum dedicated to the Multiple Regression Analysis and Forecasting template by Business Spreadsheets. Please feel free to post questions, answers and share solutions relating to this template in this forum. Further support resources for the Multiple Regression Analysis and Forecasting template by Business Spreadsheets include: Frequently Asked Questions, and Full Product User Guides
	Excel Business Forums Administrator
	Posted by Excel Helper on 31 Jan 2006

Replies - Displaying 11 to 16 of 16

Order Replies By: Most Recent | Chronological | Highest Rated

	Regression equations Rate this: (3/5 from 1 vote) If you want to use Cache and not the Multiple regression template, I suggest that you use the formulas and matrix processes required for multiple regression analysis. Useful information can be found at http://en.wikipedia.org/wiki/Regression_analysis
	Excel Business Forums Administrator
	Posted by Excel Helper on 26 Jul 2009

Trouble Forecasting Dependant Variable Rate this: (3/5 from 1 vote) I want to forecast what the dependent variable will be based on several independent variables, given what it has been in the past.  I can't figure out how to do it.  On the input tab, if I leave the last row of the dependent variable blank, it is not predicted on the output tab.  On the output tab, if I set the independent variables to "leave blank" in the forecast table, it doesn't work.  What am I doing wrong?

Posted by maryp on 02 Mar 2010

	Forecasting the dependent variable Rate this: (3/5 from 1 vote) 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.
	Excel Business Forums Administrator
	Posted by Excel Helper on 02 Mar 2010

Forecasting the dependent variable Rate this: (3/5 from 1 vote) I am still confused.  Say I 20 complete rows of data - 20 dependent variables and the corresponding independent variables for those 20 data points.  For the one that I want to predict, I have the values for the independent variables but I don't have the dependent variables.  I want the model to predict what the dependent variable should be.  How do I do that with this tool?

Posted by maryp on 02 Mar 2010

	Remove row from Input Rate this: (3/5 from 1 vote) In 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 Excel Helper on 02 Mar 2010

	Offshore Outsourcing Services Rate this: (3/5 from 1 vote) Taking You Forward, Inc. is a Business Process Outsourcing (BPO) Company located in Mandaue City, Cebu, Philippines. Our founding principles are order, discipline, and control. We have grown fast over the years, however, in the process of growing we have kept our business processes intact to ensure that we continuously provide excellent service to our partners. As a premier provider of BPO services in the Philippines, our organization is managed by a group of dynamic people who exceed the status quo, improving the business to be more effective and more efficient for the benefit of our clients. US Hotline : 1-904-328-1099 UK Hotline : +44-203-051-7619 AU Hotline : +61-282-142-969 PH Hotline : +63323465551
	Offshore Outsourcing Services - www.tyfinc.com
	Posted by jalicia18 on 22 Nov 2010

Back

Displaying page 2 of 2