| Home > Forum Home > Excel Multiple Regression Analysis and Forecasting Template > Regression Forecasting Template Support Resources > What is Excel linest??? | Share |
What is Excel linest???
Excel Help for What Is Excel Linest??? in Excel Multiple Regression Analysis and Forecasting Template
| Forum Topic | Login |
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 deaton on | ||
| View Full Post |
| Find relevant Excel templates and add-ins for What is Excel linest??? in the Excel Business Solutions Directory |