I have sales by 30 different products over years (2015-2022). I need to compute Compound Annual Growth Rate, however some of the product groups have high CAGR and some of them have quite low CAGR. So there is high variance.
In order to get a better overall picture, I am thinking about calculating the average of each product's CAGR. Do you think this is a good idea? Or what would you offer? Like:
- Average Anual Growth Rate
- Geometric mean of CAGRs