Excel Help for Regression Forecasting Template Support Resources

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

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 1 to 10 of 16

Order Replies By: Most Recent | Chronological | Highest Rated

	Let's try Rate this: (3/5 from 1 vote) Please send your template through to the email addresss above so that I can investigate and fix these issues for you.
	Excel Business Forums Administrator
	Posted by Excel Helper on 01 Dec 2006

	Forecasting methods chosen Rate this: (3/5 from 1 vote) Thank you for including the image URLs. The charting could be due to the axis scales and the formula could be due to the forecasting methods chosen and/or the large number of observations. If you can send through your template to contact [at] business-spreadsheets.com I will investigate and resolve this for you.
	Excel Business Forums Administrator
	Posted by Excel Helper on 29 Nov 2006

	Units Rate this: (3/5 from 1 vote) The independent variables do not have to be in the same units. The regression equation is calculated based on the units for each independent variable. Then the forecast can be entered (or prefilled) in the respective units for each variable.
	Excel Business Forums Administrator
	Posted by Excel Helper on 10 May 2009

	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

	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

	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

	Evaluating the Excel template Rate this: (3/5 from 1 vote) [http://photofile.ru/photo/volony/2285501/39905523.jpg] and [http://photofile.ru/photo/volony/2285501/39905524.jpg] I am at the stage of evaluating your wonderful product, unfortunately, tarnished by few glitches. The first screenshot shows that for some reason the dependable variable's chart was not plotted. The second image portrays inconsistency in the forecast calculation formula within the same data column. I'd appreciate if someone pays attension to my post. Thanks in advance!
	Remind people that profit is the difference between revenue and expense. This makes you look smart. Scott Adams
	Posted by volony on 28 Nov 2006

	Multiple regression analysis and forecast Rate this: (3/5 from 1 vote) Thanks for your quick reply. Unfortunately, it's a toy for my purpose. For example, the forecast is limited to 50 periods, whereas I need at least a full-year forecast (i.e. 365 days-periods), and the resulting formula establishing relation between dependent and the independent variables cannot be seen.
	Remind people that profit is the difference between revenue and expense. This makes you look smart. Scott Adams
	Posted by volony on 30 Nov 2006

	Hello? Rate this: (3/5 from 1 vote) I hope, no offence
	Remind people that profit is the difference between revenue and expense. This makes you look smart. Scott Adams
	Posted by volony on 30 Nov 2006

	Forecasting Model for call Center Rate this: (3/5 from 1 vote) Hi Russell, It was great reading your atricles, let me know if you help me create a forecasting model for a call center. Thanks & regards, Vernon
	Posted by vernonlasrado on 27 Jun 2007

Displaying page 1 of 2

Solutions: Multiple Regression Forecasting

Regression Forecasting Template Support Resources