Groeifactor bereken van trendlijn van spreidingsdiagram

[raulz]

Excuus voor mijn luiheid om mijn onbeantwoorde vraag op een engelstalig forum rechtstreeks te copy-pasten. Maar ik ga er van uit dat u allen de Engelse taal machtig bent Reacties mogen wat mij betreft in elke taal van uw voorkeur.


Hey everyone,

I'm doing research in international business. I will skip the details and get too my basic problem directly.

I have 300 firms in my sample, for which I have 5 yearly numbers of total sales.

For each firm I would like to calculate a variable that catches the trend in (negative) sales growth. I need a (trend) variable for sales growth in a regression analysis.

Visualizing this one can easily plot trend lines in a spread diagram in Excel. These graphs express the trend I want to translate into a variable that allows me for comparison between firms.

Is there any formula?

I will give an example for one firm:

Sales between 2005-2008:
2005: 193145
2006: 154512
2007: 448355
2008: 524282
2009: 586035

trend line formula: y=115555x +34601 (where y=total sales and x=time (t1,t2.. etc)

I know that it is not difficult to calculate a steepness variable of the lineair graph (íf you know two couples of x and y, but I can't catch these). I can't find out how in Excel. Neither in SPSS.

Besides it would be way easier if I could use a formula, so I won't have to calculate each variable independently.

THANK YOU IN ADVANCE!

[meneer van Hoesel]

trend line formula: y=115555x −231537619.2 (where y=total sales and x=time (t1,t2.. etc)

in Numbers (Apple) kun je beide waarden voor je trendlijn uitrekenen met SLOPE(y-waarden; x-waarde) en INTERCEPT(y-waarden; x-waarde)

Code: Selecteer alles

Company    2005    2006    2007    2008    2009   Slope     Intercept
							
Akzo     193145  154512  448355  524282  586035  115555  -231537619.2
BP							
CocaCola							
...							

met
G3=SLOPE($B3:$F3;$B$1:$F$1)
H3=INTERCEPT($B3:$F3;$B$1:$F$1)

Hopenlijk is dit wat je zocht.

m.vr.gr.
meneer van Hoesel