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 at the end of May, and its replacement, statalist.org is already up and running.


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

st: value weighted average


From   "Braunfels, Philipp (Stud. SBE / Alumni)" <P.Braunfels@student.maastrichtuniversity.nl>
To   "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu>
Subject   st: value weighted average
Date   Sun, 29 Jul 2012 11:43:17 +0200

Hello Statlisters,
can anyone help me in calculating value weighted averages of variable X where the weights is defined by variable Y? 

ID     Y     X       Time    Group   VW-X1
1     50     1%    1990      1
2     60     2%    1990      1
3     70     3%    1990      1
6     10     4%    1990      2
....

That is, I would like to calculate the value weighted average of X in dependence to Y for group 1:

total weight group 1= 50+60+70 = 180

Value weighted X of Group 1 (VW-X1) = 50/180* 1% + 60/180*2%+70*180*3%


Is there any command that can help me achieving this goal quickly? defining separate variables for each observation and then creating a new variable (VW-X1) seems a bit time consuming to me.

thanks in advance!
*
*   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