Are you trying to compare the growth rate for the years 1959 and 1960 or
calculate the growth rate for both years? To calculate the growth rate for
1959-01-01 to 1960-01-01
I would take make a formula like this =(B13-B1)/B1) (This is assuming that
the values are in column B starting at row1.) format the cell you put the
formula as a % two decimals and you would get the % of growth from the
starting value to the ending one.
"kotlon" wrote:
DATE VALUE
1959-01-01 286.6
1959-02-01 287.7
1959-03-01 289.2
1959-04-01 290.1
1959-05-01 292.2
1959-06-01 294.1
1959-07-01 295.2
1959-08-01 296.4
1959-09-01 296.7
1959-10-01 296.5
1959-11-01 297.1
1959-12-01 297.8
1960-01-01 298.2
1960-02-01 298.5
1960-03-01 299.4
1960-04-01 300.1
1960-05-01 300.9
1960-06-01 302.3
1960-07-01 304.1
1960-08-01 306.9
1960-09-01 308.4
1960-10-01 309.5
1960-11-01 310.9
1960-12-01 312.4
1961-01-01 314.1
This is the monthly data. How can I calculate the growth rate from 1959
to 1960?
Thanks in advance
--
kotlon
------------------------------------------------------------------------
kotlon's Profile: http://www.excelforum.com/member.php...o&userid=35431
View this thread: http://www.excelforum.com/showthread...hreadid=552329