annual growth rate from monthly data

Giganews Newsgroups
Subject: annual growth rate from monthly data
Posted by:  kotlon (kotlon.29gcgb_1150389302.3182@excelforum-nospam.com)
Date: Thu, 15 Jun 2006

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?action=getinfo&userid=35431
View this thread:http://www.excelforum.com/showthread.php?threadid=552329

Replies