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