I'm in a statisticians dream, but my nightmare..... Sonny Sanders, GISP Capital Area Metropolitan Planning Organization City of Jefferson - Department of Community Development's Planning and Transportation Services 320 E. McCarty St. Jefferson City, MO 65101 573-634-6439 www.jeffcitymo.org/campo [cid:image001.jpg(a)01CBAB61.4C0D2B60] ________________________________ From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Jason Gillow Sent: Monday, January 03, 2011 3:28 PM To: ctpp-news(a)chrispy.net Subject: [CTPP] RE: How to Combine Median Values for Multiple Areas Hello I had a similar issue median and average values, I had to contact the Census Bureau themselves to get an answer. Below was my question and their answer to me. I have attached a revised version of you table with what I think is the appropriate approximations of the MOE of means, medians and ratios. You should check to make sure I found them all. (See attached file: Ohio county spreadsheet.xlsx) Please note: 1. I have changed the concept of your medians. They are now the average median instead of the median of medians. I did this because it makes it easier to calculate the MOE. We get back to taking the square root of the sum of MOE^2 which is as given in the appendix you mention below. Except now we divide it by the squared number of estimates in the average. In this case 144 (or 12^2). The benefit of the shift is the MOE is much smaller than what you had initially. I have to warn you that it may be an underestimate since we have not adjusted for correlation between the estimates. 2. I noticed that the median values didn't change much with the shift and the new medians seem more in line with the distributions shown that are associated with the medians. 3. Your idea of taking the square root of the median MOE^2 is inventive, but all you did was assign an MOE from one of the other median estimates to selected median of the medians. 4. If you are unhappy with the concept change, you can go back to taking the median of medians, but I am suspicious that it isn't the truly overall median. As far as the median's MOE, it would be a lot of work using linear interpolation and you probably won't get anything useful. Instead just use the median's own MOE and not the median of the MOEs. This result does give an extremely conservative MOE so technically you cannot go wrong except it probably isn't useful. 5. Your average of the means concept was fine, but I made the same change to the MOE formula as I did for the medians. 6. I did check some of your count estimates and they seem to be calculated correctly. Again I want you to understand that what you and I are calculating here are approximations. They maybe overestimates or underestimates. But I feel they are better than what you had. Hopefully they will be useful. Karen E. King Supervisory Mathematical Statistician ACS Variance Estimation and Statistical Support Branch Decennial Statistical Studies Division U.S. Census Bureau Phone: 301 763-1974 From: Jason G Date: 12/30/2010 09:24 AM Subject: RE: Regarding question about summing estimates Hello Both questions refer to the same matter. I work for a regional planning commission that serves 12 counties in south central Ohio. I am developing a regional profile based off American Community Survey 5-year 2005-2009 data - profile tables. I am using the formulas referenced in http://www.census.gov/acs/www/Downloads/handbooks/ACSResearch.pdf in Appendix 3 on page A-14 under section "Calculating MOEs for Aggregated Count Data" to get the aggregate estimate and Margin of error (MOE) numbers for our region. I know this works with like "total household" category for example to get the aggregate estimate and its MOE. But the problem I have is calculating the aggregate estimate and its MOE for "Average household size", "median family income" and "Rental vacancy rate" for example. I have figured out the formulas for the aggregate estimates of these types, but I have trouble with the calculating the MOEs for these aggregate estimates for like "Average household size", "median family income" and "Rental vacancy rate" for example for the region. Attached is my main work table in Excel format for reference. The numbers in bolded red color are for the region I serve, and gray highlighted cells are the MOEs I had trouble with. What I need to know is the formulas for calculating the MOEs in the gray highlighted cells in my spreadsheet. Jason Gillow Research/Planning Specialist II Ohio Valley Regional Development Commission 9329 St Rt 220 E, Suite A Waverly, OH 45690 Phone: 740-947-2853 or 800-223-7491 (In Ohio) Fax: 740-947-3468 www.ovrdc.org Email: jgillow(a)ovrdc.org From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Cook, Cliff Sent: Monday, January 03, 2011 1:24 PM To: ctpp-news(a)chrispy.net Subject: [CTPP] How to Combine Median Values for Mutliple Areas I am looking for guidance on how to combine median income values for several census tracts into a single value and associated margin of error. I recall seeing something about this topic in an ACS document but cannot locate the information at this time. Any help would be appreciated. Cliff Cook ----------------------------------------------------------------------------- Clifford Cook Planning Information Manager Cambridge Community Development Dept. 344 Broadway Cambridge, MA. 02139 617/349-4656 FAX 617/349-4669 TTY 617/349-4621 email => ccook(a)cambridgema.gov web site => <http://www.cambridgema.gov/~CDD/> ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________