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/SummaryFileDataRetrievalTool.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@camsys.com>
Reply-To: <ctpp-news@chrispy.net>
Date: Mon, 3 Jan 2011 15:25:56 -0500
To: <ctpp-news@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@camsys.com
www.camsys.com



ctpp-news-request@chrispy.net
Sent by: ctpp-news-bounces@chrispy.net

01/03/2011 02:39 PM
Please respond to
ctpp-news@chrispy.net

To
ctpp-news@chrispy.net
cc
Subject
ctpp-news Digest, Vol 83, Issue 1





Send ctpp-news mailing list submissions to
                ctpp-news@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@chrispy.net

You can reach the person managing the list at
                ctpp-news-owner@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@cambridgema.gov>
Subject: [CTPP] How to Combine Median Values for Mutliple Areas
To: "ctpp-news@chrispy.net" <ctpp-news@chrispy.net>
Message-ID: <600EBD94B0166D4BADC1083702EC47C4026F6C522B@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@cambridgema.gov
      web site => <
http://www.cambridgema.gov/~CDD/>

-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://ryoko.chrispy.net/pipermail/ctpp-news/attachments/20110103/ac128981/attachment-0001.html

------------------------------

Message: 2
Date: Mon, 3 Jan 2011 12:33:17 -0700
From: "Eric Kramer" <EKramer@pagnet.org>
Subject: RE: [CTPP] How to Combine Median Values for Mutliple Areas
To: <ctpp-news@chrispy.net>
Message-ID: <013e01cbab7d$125652e0$3702f8a0$@org>
Content-Type: text/plain; charset="us-ascii"

Skipped content of type multipart/alternative-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 24373 bytes
Desc: not available
Url :
http://ryoko.chrispy.net/pipermail/ctpp-news/attachments/20110103/a1485d2c/attachment.jpe

------------------------------

_______________________________________________
ctpp-news mailing list
ctpp-news@chrispy.net
http://www.chrispy.net/mailman/listinfo/ctpp-news


End of ctpp-news Digest, Vol 83, Issue 1
****************************************