Hi, I need to measure uptake / success of a program. This success is being evaluated based on transaction volumes.
Here's what I am thinking in terms of an approach. I'm not sure it's a good way to go. And I don't know for sure how to do the necessary calculations:
I have monthly transaction volume data from January 2011 to December 2011, inclusive. I am trying to figure out:
The annual growth rate
The monthly growth rate
I want the monthly growth rate because it (and the 2011 data) will be used as a baseline. The baseline will then be used to predict the volumes in 2012 and onward. The difference between the predicted volumes (based on the historical growth rate) and actual volumes will be the uptake and help evaluate effectiveness of a program.
I've found several sites on the web that provide answers but I don't feel confident in them. I don't think I want compound growth rate. Is that the same as Constant Growth Rate?
P.S. I also need the formula in a format that i can use with Excel.