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 11 to 16 of 16Order Replies By: Most Recent | Chronological | Highest Rated
Confused
forecasting model
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
how to use 4 variable regression model
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
Confused
What is Excel linest???
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
Confused
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 on
Confused
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 on
Confused
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 on
 Displaying page 2 of 2 

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

Solutions: Multiple Regression Forecasting

© 2020 Business Spreadsheets   Legal   Follow us: