Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.

# st: RE: RE: growth rate in panel data

 From Nick Cox To "'statalist@hsphsun2.harvard.edu'" Subject st: RE: RE: growth rate in panel data Date Thu, 10 Feb 2011 14:35:33 +0000

```An alternative, better if you have irregular series, is to -tsset- your data and use time series operators. But watch out for -delta(5)-.

Nick
n.j.cox@durham.ac.uk

Nick Cox

Learn about subscripting under -by:-. Then translate your favourite formula to subscript language.

There is a tutorial on -by:- in

SJ-2-1  pr0004  . . . . . . . . . . Speaking Stata:  How to move step by: step
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  N. J. Cox
Q1/02   SJ 2(1):86--102                                  (no commands)
explains the use of the by varlist : construct to tackle
a variety of problems with group structure, ranging from
simple calculations for each of several groups to more
advanced manipulations that use the built-in _n and _N

If log GINI is 3.68, say, then GINI is perhaps exp(3.68) ~ 40 (are you measuring in percents) or 10^(3.68) ~ 4786 (seems unlikely). There is probably a substantive debate on what metric which is best to compare GINI on, but I'm unequal to the challenge.

I have a 5 yearly panel data set covering 107 countries. I have to calculate the growth rate of different variables.
I have tried the various formulas given in the archive of STATALIST but could not find the solution. My data looks like:

Countries         Years           log of GINI
A                  1965                .
A                  1970               3.68
A                  1975               2.34
A                  1980                .
B                  1965                .
B                  1970               3.24
...

I want to calculate the growth rate of log of GINI for 1965, 1970 etc for each country. The years are 1965, 1970 ..... to 2010.

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/
```