Thanks Alan for your advise.
>>> Alan Neustadtl <[email protected]> 1/29/2007 6:10 PM >>>
You are trying to estimate the 50th percentile from grouped data.
Many introductory statistics text book cover this kind of problem. In
the social sciences you can see "Social Statistics" by Blalock or
"Statistics for Social Data Analysis" by David Knoke et al. for
examples. It is easy to do with a hand calculator.
Best,
Alan
On 1/29/07, Marcella Sapun <[email protected]> wrote:
> Dear Stata Users:
>
> I need to get the median rents for a group of renters living in
> 2-bedroom occupied housing units. I don't have the actual raw data
set
> to derive the medians. But I have a table with the following
information
> on the following Renter-Occupied categories:
>
> Categories: Estimate total#
>
-------------------------------------------------------------------------
> 2-bedrooms: 15,223,372
> with cash rent: 14,449,016
> < $200 335,924
> $200 to $299 385,018
> $300 to $499 1,849,604
> $500 to $749 4,898,457
> $750 to $999 3,803,812
> > $1000 3,176,201
> no cash rent 774,356
>
--------------------------------------------------------------------------
>
> Does someone have any ideas to compute the median rent (i.e cash
rent
> and no cash rent) among all the groups. Can I do this in STATA?
>
> Thanks!
>
> MS
>
>
>
>
> *
> * 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/
>
*
* 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/
*
* 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/
