Tuesday, February 28, 2006
st: weighted cumulative sum
I have a panel data of firms and the number of units of products they sell each year. I am trying to generate some measures of production experience.
One measure I have simply produces a cumulative sum of the number of products sold up to the previous year: by id: gen experience1=sum(products[_n-1])
I am now trying to produce more sophisticated measures that will discount the experience by some given rate (by, say, dividing the experience by its age). The idea is that last year's experience is more valuable than the experience of the year before it and so on.
For example, if I have the following dataset
year 1 - 30 products year 2 - 20 products year 3 - 10 products year 4 - 10 products year 5 - 20 products
Right now, my experience measure for year 4 is 30+20+10=60. I am looking for a command that will give me the following value: (30/3)+(20/2)+(10/1)=30
Any idea how can this be done?
__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com * * For searches and help try: * http://www.stata.com/support/faqs/res/findit.html * http://www.stata.com/support/statalist/faq * http://www.ats.ucla.edu/stat/stata/
Links to this post: