Home > Forum Home > Excel Multiple Regression Analysis and Forecasting Template > Regression Forecasting Template Support Resources Share

Regression Forecasting Template Support Resources

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


Forum TopicPost Reply Login

Regression Forecasting Template Support Resources

Rate this:
(3/5 from 1 vote)
HappyWelcome 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:

 Excel Business Forums Administrator
 Posted by on
 
Replies - Displaying 1 to 10 of 16Order Replies By: Most Recent | Chronological | Highest Rated
Confused
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 on
Surprised
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 on
Confused
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 on
Confused
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 on
Grateful
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 on
Confused
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 on
Confused
Rate this:
(3/5 from 1 vote)
i used this template for forecasting membership numbers by the end of 2009 with joiners,renewals and leavers as independent variables. Why does it give me in the forecast section the results in negetive. any explanation ?
 Posted by on
Confused
Rate this:
(3/5 from 1 vote)
Hi,

Do the variables have to have the same unit to find the forecasting value. If I have given yearly population of affected area and the severity and yearly allocation of money then how can we proceed to predict the allocation for next 5 years? Please tell me on my mail.

 vijay
 Posted by on
Surprised
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 on
Confused
Rate this:
(3/5 from 1 vote)
[email protected]


I'm about to start writing the energy demand model in Cache and reached a hurdle re the equation.

This information is all pre-smoothed for climate change via the latest PDM engine and then:


Today's demand      = var1*HDD+var2*HDD(squared) + var3*HDD(cubed)+ windvar
Tomorrow's demand = var1*HDD*predicitedHDD+var2*
predicitedHDD(squared) + var3*predicitedHDD(cubed)+ windvar

Now you said the excel automatically calculates var1, var2 and var3 through regression. How is this calculated mathematically so I can add this into Cache?

How is the windvar variable calculated?

Cheers

--
David Eaton

PDM llc

Phone: 505 695 0026
 David Eaton
 Posted by on
 Displaying page 1 of 2 

Excel templates and solutions matched for Regression Forecasting Template Support Resources:

Solutions: Multiple Regression Forecasting