divendres, 15 de març de 2013

Forecasting by using Straight Line Relationships

Hi again,

Every business analyst should have the ability to estimate the relationship between important business variables. The trend curve, which I discuss in this Excel fileif often helpful in determining the relationship between two variables. The variable that analyst try to predict is called the dependent variable. The variable we use for prediction is called the independant variable.

It is nice to see as we could forecast the behavior of the independant variable throughtout our decisions in the dependant variable. We could see how it's apply in the Excell file presented below.

Click here

Cap comentari:

Publica un comentari a l'entrada