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