4 Jan
2011
4 Jan
'11
5:10 a.m.
Cliff:
The guidebook is a good start, but you can also use the Excel Summary File
Data Retrieval Tool if you know what table and tracts you are looking for.
The tool can provide both the estimate and the margin of error right next to
each other with the selected geography by check marking the option. The
tool is located at:
http://www2.census.gov/acs2009_5yr/summaryfile/UserTools/SummaryFileDataRetr
ievalTool.zip
See if the above tool will meet your need. The data is in Excel, so you can
do all kinds of charts and summations as you need.
Enjoy;
Lori
Software Engineer
From: Liang Long <LLong(a)camsys.com>
Reply-To: <ctpp-news(a)chrispy.net>
Date: Mon, 3 Jan 2011 15:25:56 -0500
To: <ctpp-news(a)chrispy.net>
Subject: [CTPP] Re: ctpp-news Digest, Vol 83, Issue 1
Hi, Cliff
The ACS General Guidebook has one chapter devoted to calculating MOEs for
derived estimates. You may find it helpful. I was trying to locate this
document on line, but didn't see it. Attached is my downloaded version from
a while ago.
Liang Long
Cambridge Systematics, Inc.
4800 Hampden Lane
Suite 800
Bethesda, MD 20814
tel 301 347 9141
fax 301 347 0101
FHWA 202-366-6971
e-mail llong(a)camsys.com
www.camsys.com
ctpp-news-request(a)chrispy.net
Sent by: ctpp-news-bounces(a)chrispy.net01/03/2011 02:39 PM
Please respond to
ctpp-news(a)chrispy.net
To
ctpp-news(a)chrispy.net
cc
Subject
ctpp-news Digest, Vol 83, Issue 1
Send ctpp-news mailing list submissions to
ctpp-news(a)chrispy.net
To subscribe or unsubscribe via the World Wide Web, visit
http://www.chrispy.net/mailman/listinfo/ctpp-news
or, via email, send a message with subject or body 'help' to
ctpp-news-request(a)chrispy.net
You can reach the person managing the list at
ctpp-news-owner(a)chrispy.net
When replying, please edit your Subject line so it is more specific
than "Re: Contents of ctpp-news digest..."
Today's Topics:
1. How to Combine Median Values for Mutliple Areas (Cook, Cliff)
2. RE: How to Combine Median Values for Mutliple Areas (Eric Kramer)
----------------------------------------------------------------------
Message: 1
Date: Mon, 3 Jan 2011 13:24:06 -0500
From: "Cook, Cliff" <ccook(a)cambridgema.gov>
Subject: [CTPP] How to Combine Median Values for Mutliple Areas
To: "ctpp-news(a)chrispy.net" <ctpp-news(a)chrispy.net>
Message-ID: <600EBD94B0166D4BADC1083702EC47C4026F6C522B(a)Mordac.City>
Content-Type: text/plain; charset="us-ascii"
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.chrispy.net/mailman/listinfo/ctpp-news>
http://www.cambridgema.gov/~CDD/>