Statalist


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

st: RE: categorising continuous variable and generating mean outcome


From   Howard Lempel <HLempel@brookings.edu>
To   "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu>
Subject   st: RE: categorising continuous variable and generating mean outcome
Date   Tue, 17 Feb 2009 19:36:20 -0500

Galina,

One way to do this would start by using -xtile- to create a variable with the decile of X for each observation.  

Then -collapse- X and Y by your decile variable to get the mean of Y and median of X for each of the ten categories.

You can then plot meanY against medianX.

See -help xtile- and -help collapse-.

Hope this helps.
Howie


-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Galina Hayes
Sent: Tuesday, February 17, 2009 7:25 PM
To: statalist@hsphsun2.harvard.edu
Subject: st: categorising continuous variable and generating mean outcome

Evening all,
I am sure there is a very simple solution to this but it has me foxed. I have two variables, Y coded as (0,1) and X which is continous. I want to break x down into 10 equal size categories (by range or percentiles, doesn't matter) and generate the mean of Y for each of the 10 categories (call it meanY) and then plot meanY against the centre value of each X category. Does this make sense? Seems like it should be easy,
Thanks
Galina
*
*   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/



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