Re: $$Excel-Macros$$ Formulas for predictive analysis and forecasting

2012-09-25 Thread krishnanm2006
Krishnan Sent on my BlackBerry® from Vodafone -Original Message- From: David Grugeon Sender: excel-macros@googlegroups.com Date: Wed, 26 Sep 2012 09:34:10 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Formulas for predictive analysis and forecasting Th

Re: $$Excel-Macros$$ Formulas for predictive analysis and forecasting

2012-09-25 Thread David Grugeon
This is not my area of expertise but I will give you a few pointers. There are probably statisticians in the group who can improve, or may disagree with what I am saying. It depends what you are predicting. You need to understand the data and the theatre in which you are observing them. If possi

$$Excel-Macros$$ Formulas for predictive analysis and forecasting

2012-09-25 Thread krishnanm2006
Dear Excel Gurus ! Hope you guys are doing well... I required some formulas/ functions that can be used for predictive/ forecasting models... Currently I am using slope (linest) and intercept.. But require another formula which can make my analysis more perfect... Thanks in advance ! Krishnan S