Thank you for the information, it helped greatly. I had one further question. How do you handle the Margin of Errors(MOE) for median, mean and rate values of combine areas? For example the MOE for the “median family income” or “rental vacancy rate” for combine areas like counties. Is it the same process as the estimates MOE calculations referred to 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” or is there a different formula to calculate it?
I am trying to develop a regional profile of 12 combined counties in south central Ohio. I was able to calculate the estimates and their MOEs based off the guide that is mentioned in the link, but I am having trouble with the estimates for rates, means, and medians in getting their combined MOE.
Thanks
Jason
From: ctpp-news-bounces@chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Graham, Todd
Sent: Wednesday, December 22, 2010 10:27 AM
To: ctpp-news@chrispy.net
Subject: RE: [CTPP] ACS 2005-09 data
It’s all basic statistics.
Our State Demographer’s Office took the Census-provided documentation for error calculation and built a general, multi-purpose spreadsheet. It’s ready to use, and a big time saver….
Statistical Significance Calculator (excel file): www.demography.state.mn.us/documents/StatisticalCalculationsMenu.xls
All you need to do is plug in the “n”, etc., and you’ll have what you need.
________________________
Todd Graham
Principal Forecaster
Metropolitan Council
390 Robert Street North
Saint Paul, MN 55101
ph: 651/602-1322
email: todd.graham@metc.state.mn.us
in: www.linkedin.com/in/toddgraham
web: http://stats.metc.state.mn.us/
________________________
From: ctpp-news-bounces@chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Krishnan Viswanathan
Sent: Wednesday, December 22, 2010 8:23 AM
To: ctpp-news@chrispy.net
Subject: Re: [CTPP] ACS 2005-09 data
Look here for details: http://www.census.gov/acs/www/guidance_for_data_users/handbooks/
and the document what Researchers need to know will help you too: http://www.census.gov/acs/www/Downloads/handbooks/ACSResearch.pdf
On Tue, Dec 21, 2010 at 10:22 AM, Jason Gillow <jason.gillow@ovrdc.org> wrote:
Hello
I was wondering how do you handle combining different geographic areas with each other to form a regional profile. For example, my office is a regional planning organization that serves 12 counties. I want to take the profile data from ACS 2005-09 5-year estimates for each county and form a profile of my regional, I know how to combine the estimates and do the percentages, but how do I handle the margin of error columns? Is there their a reference or guidance on this?
Thank you
Jason
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@ovrdc.org
_______________________________________________
ctpp-news mailing list
ctpp-news@chrispy.net
http://www.chrispy.net/mailman/listinfo/ctpp-news
--
Krishnan Viswanathan
1101 High Meadow Dr
Tallahassee FL 32311