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

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

 From Humaira Asad To STATA HELP Subject RE: st: RE: growth rate in panel data Date Thu, 10 Feb 2011 14:40:10 +0000

```Thank you Nick for your reply. The Gini is in percentage and I have taken natural logs of the Gini coefficient. I have used:

. bysort country: gen ln_gini_gr=(ln_gini/ln_gini[_n-1]-1)*100

PhD Research Scholar

University of Exeter, England

----------------------------------------
> From: n.j.cox@durham.ac.uk
> To: statalist@hsphsun2.harvard.edu
> Date: Thu, 10 Feb 2011 14:29:27 +0000
> Subject: st: RE: growth rate in panel data
>
> 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.
>
> Nick
> n.j.cox@durham.ac.uk
>
>
> 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/
*
*   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/
```