can I use the geometric mean for this?

[erwar]

Dear All,
I need to calculate an average of the growth rates of the sales of a company. Should I use the geometric mean? if so, why?
thanks a lot!
E.

 

[S2000magician]

The geometric mean growth rate is appropriate.

 

[MrSmart]

It depends why you’re calculating it.
The arithmetic mean gives you an equally weighted mean for the value of growth rate, but it might be arbitary to use in analysis because it does not take into consideration the effects of compounding and upwardly biased.
The geometric mean calculates the yearly (or quarterly) series of the average compounded growth in sales by taking the first and last data point, and giving you the growth rate needed for sales to reach the projected (or historical) amount from the initial level in a given amount of periods.

 

[erwar]

Dear Magician, could you please elaborate a bit?
thanks much

 

[erwar]

thank you

 

[S2000magician]

erwar wroteear Magician, could you please elaborate a bit?
thanks much

If you’re trying to determine the average (long-term, compound) growth rate, then you’d use the geometric average of the historical growth rates.
As MrSmart points out, however, if you’re trying to determine the most likely growth rate for a single period, the arithmetic average of the historical growth rates is appropriate.

 

[erwar]

thanks

 

[S2000magician]

You’re welcome.