Bookmark and Share

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


[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–2017 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index