Thanks for then response. The data are index values and I assume them
to be correct as they are taken from an application called AREMOS and
the code used to download the series is correct. My purpose is to
transfer these codes to another application which does not have a lag
function so I need to coerce these values in excel.
David Biddulph wrote:
I don't know what makes you think that the figures you've quoted are
correct, as they don't seem to be. [joeu2004's formula (effectively the
same as yours) looks OK.]

Are the values in your series intended to be the value at that date, or are
they perhaps something like a current percentage rate of growth (defined in
some way or other)?
--
David Biddulph

wrote in message
ups.com...

wrote:
wrote:
I know how to calculate cagr though can someone please let me know if
this seems right for cagr with a six month lag?
((January 1, 1992 Value/July 1, 1991)^2)-1)*100
For some reason this has not been working for me...

Using your notation, try:

( ( (July 1 1992 value) / (January 1 1992 value) )^2 - 1 ) * 100

Note that you do not need "*100" if you are writing an Excel formula.
Simply format as Percentage with 2 decimal places, if you want (Format
Cells Number).

Thanks for the response, Joe, but I didn't have any luck... here is the
series I am working on.. and below it is the correct figures I should
be getting with a 6 mth lagged cagr..I've tried everything and am
becoming desperate..


7/1/91 12.4545
8/1/91 12.5732
9/1/91 12.6147
10/1/91 12.6572
11/1/91 12.8421
12/1/91 13.0317
1/1/92 13.208
2/1/92 13.3711
3/1/92 13.4381
4/1/92 13.6484
5/1/92 13.8817
6/1/92 14.0936
7/1/92 14.3233
***********************

1/1/92 12.90030006
2/1/92 13.01828899
3/1/92 13.09353062
4/1/92 15.52380093
5/1/92 15.84093727
6/1/92 15.45566734
7/1/92 15.58660109