Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: how to generate mean for a secquence of five year of a variable


From   Oliver Jones <ojones@wiwi.uni-bielefeld.de>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: how to generate mean for a secquence of five year of a variable
Date   Thu, 05 May 2011 16:10:59 +0200

Hi,
ok, now I got it. You want some kind of running-mean.
The function -lowess- has an option to create a new
variable that is a running mean.
BUT, this is not exactly what we want here, because this
mean is calculated at the center of the running window.
We want the mean at the right end of the window.


Maybe someone else knows of a command that dose this?


Best
Oliver

Am 05.05.2011 15:53, schrieb prakash singh:
Dear Oliver here is what I want

yearid	countryid	var1	var2	
1980	1	7.25	
1981	1	8.25		
1982	1	9.5		
1983	1	7.5		
1984	1	7.75	8.05 (mean of first five observation of var1)
...........................................
........................................
2001	1	8.25		
2002	1	9		
2003	1	9.5		
2004	1	8		
2005	1	10	8.95 (mean of last five observation of var1)

similarly for all other country.


Hope I am making my problem clear to you.


Prakash
*
*   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/

--
Universität Bielefeld
Fakultät für Wirtschaftswissenschaften
Lehrstuhl für Ökonometrie und Statistik
- -
Bielefeld University
Faculty of Business Administration and Economics
Chair of Econometrics and Statistics
- -
Raum / room:  V9-110
Tel / phone:  +49 (0)521 106 4871
---
*
*   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/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index