Hi there,
I am trying to calculate the average monthly growth rate for the following
data for example:
Jan-08 Feb-08 Mar-08 Apr-08 May-08
9,203 9,520 8,078 8,744 8,070
The answer is 6.27% based on calculating it like this, putting an =AVERAGE
formula to return 6.27%:
Jan-08 Feb-08 Mar-08 Apr-08 May-08
9,203 9,520 8,078 8,744 8,070
42.53% 3.44% -15.15% 8.24% -7.71% 6.27%
Surely there is a simple excel formula to do this so it doesn't have to be
done in two lines?
Any help greatly appreciated!