7 Dec
2010
7 Dec
'10
4:15 p.m.
Correction to my earlier email: 2005-2009 ACS Block Group data WILL be released on
December 14.
From: brian.mckenzie(a)census.gov [mailto:brian.mckenzie@census.gov]
Good Afternoon Mara and Elaine,
The summary file data (block group level data) will be available on December 14th. You can
use American Factfinder as a portal. You will be able to download summary file data via
the FTP website at <http://www2.census.gov/acs2009_5yr/summaryfile/
<http://www2.census.gov/acs2009_5yr/summaryfile/> >. There will also be a
clickable link next to the familiar portion of AFF in which you select the desired ACS
year(s) for which you would like data. Hope this helps.
Brian McKenzie
Analyst, Journey to Work and Migration Statistics Branch
U.S. Census Bureau
301-763-6532
brian.mckenzie(a)census.gov
14 Dec
14 Dec
10:42 a.m.
New subject: ACS 2005-09 comparisons with 2000 SF3
Does anyone know why the Block Group data is not being released via the AFF’s standard
pull-down menus? I was under the impression that today (12/14) was the release date for
this data. I understand that it is available via Summary File, but this is far from user
friendly.
When will the data be available via the AFF’s standard access method?
Thank you,
Nick Lindeman
Nicholas Lindeman
Economic & Systems Data Analyst
Nashville Area MPO
800 2nd Ave. S.
P.O. Box 196300
Nashville, TN 37219-6300
(615) 862-7198
lindeman(a)nashvillempo.org
http://www.nashvillempo.org <http://www.nashvillempo.org/>
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of
Elaine.Murakami(a)dot.gov
Sent: Tuesday, December 07, 2010 4:15 PM
To: ctpp-news(a)chrispy.net
Subject: FW: [CTPP] ACS 2005-09 comparisons with 2000 SF3
Correction to my earlier email: 2005-2009 ACS Block Group data WILL be released on
December 14.
From: brian.mckenzie(a)census.gov [mailto:brian.mckenzie@census.gov]
Good Afternoon Mara and Elaine,
The summary file data (block group level data) will be available on December 14th. You can
use American Factfinder as a portal. You will be able to download summary file data via
the FTP website at <http://www2.census.gov/acs2009_5yr/summaryfile/
<http://www2.census.gov/acs2009_5yr/summaryfile/> >. There will also be a
clickable link next to the familiar portion of AFF in which you select the desired ACS
year(s) for which you would like data. Hope this helps.
Brian McKenzie
Analyst, Journey to Work and Migration Statistics Branch
U.S. Census Bureau
301-763-6532
brian.mckenzie(a)census.gov
11:12 a.m.
New subject: ACS 2005-09 comparisons with 2000 SF3
1> Does anyone know why the Block Group data is not being released via the
AFFâs standard pull-down menus? I was under the
impression that today
(12/14) was the release date for this data. I understand that it is
available via Summary File, but this is far from user friendly.
When will the data be available via the AFFâs standard access method?
Thank you,
Nick Lindeman
Nicholas Lindeman
Economic & Systems Data Analyst
Nashville Area MPO
800 2nd Ave. S.
P.O. Box 196300
Nashville, TN 37219-6300
(615) 862-7198
lindeman(a)nashvillempo.org
http://www.nashvillempo.org <http://www.nashvillempo.org/>
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net]
On Behalf Of Elaine.Murakami(a)dot.gov
Sent: Tuesday, December 07, 2010 4:15 PM
To: ctpp-news(a)chrispy.net
Subject: FW: [CTPP] ACS 2005-09 comparisons with 2000 SF3
Correction to my earlier email: 2005-2009 ACS Block Group data WILL be
released on December 14.
From: brian.mckenzie(a)census.gov [mailto:brian.mckenzie@census.gov]
Good Afternoon Mara and Elaine,
The summary file data (block group level data) will be available on
December 14th. You can use American Factfinder as a portal. You will be
able to download summary file data via the FTP website at
<http://www2.census.gov/acs2009_5yr/summaryfile/
<http://www2.census.gov/acs2009_5yr/summaryfile/> >. There will also be a
clickable link next to the familiar portion of AFF in which you select the
desired ACS year(s) for which you would like data. Hope this helps.
Brian McKenzie
Analyst, Journey to Work and Migration Statistics Branch
U.S. Census Bureau
301-763-6532
brian.mckenzie(a)census.gov
_______________________________________________
ctpp-news mailing list
ctpp-news(a)chrispy.net
http://www.chrispy.net/mailman/listinfo/ctpp-news
11:24 a.m.
New subject: ACS 2005-09 comparisons with 2000 SF3
This is one of those points of speculation and spin. If you ask the CB
the official line will be that it is so big and contains literally
mountains of tables that it is impractical to serve up with an online
search engine. They will tell you that comments on this were asked for in
the Federal Register and there was not a huge outcry. However, if you
"put your ear to the ground" you will hear some speculate that it is
because the tables are so hard to work with due to confidentiality
suppression and large margins of errors that the CB wanted to keep the
data from the "novice" user. As one noted user put it, "they are putting
the data on the top shelf just out of reach of the kids."
What would be of use here is for people who have begun to work with it to
share their experiences.
Form the CB press release today...
The U.S Census Bureau is pleased to announce the release of the 2005-2009
American Community Survey (ACS) 5-year estimates on American FactFinder.
There you will find tables with social, demographic, housing, and economic
data for areas down to the census tract level.
You can access the newly-released data on American FactFinder at:
2005-2009 ACS 5-year data
http://factfinder.census.gov/servlet/DatasetMainPageServlet?_program=ACS&am…
Does anyone know why the Block Group data is not being
released via the
AFFâs standard pull-down menus? I was under the impression that today
(12/14) was the release date for this data. I understand that it is
available via Summary File, but this is far from user friendly.
When will the data be available via the AFFâs standard access method?
Thank you,
Nick Lindeman
Nicholas Lindeman
Economic & Systems Data Analyst
Nashville Area MPO
800 2nd Ave. S.
P.O. Box 196300
Nashville, TN 37219-6300
(615) 862-7198
lindeman(a)nashvillempo.org
http://www.nashvillempo.org <http://www.nashvillempo.org/>
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net]
On Behalf Of Elaine.Murakami(a)dot.gov
Sent: Tuesday, December 07, 2010 4:15 PM
To: ctpp-news(a)chrispy.net
Subject: FW: [CTPP] ACS 2005-09 comparisons with 2000 SF3
Correction to my earlier email: 2005-2009 ACS Block Group data WILL be
released on December 14.
From: brian.mckenzie(a)census.gov [mailto:brian.mckenzie@census.gov]
Good Afternoon Mara and Elaine,
The summary file data (block group level data) will be available on
December 14th. You can use American Factfinder as a portal. You will be
able to download summary file data via the FTP website at
<http://www2.census.gov/acs2009_5yr/summaryfile/
<http://www2.census.gov/acs2009_5yr/summaryfile/> >. There will also be a
clickable link next to the familiar portion of AFF in which you select the
desired ACS year(s) for which you would like data. Hope this helps.
Brian McKenzie
Analyst, Journey to Work and Migration Statistics Branch
U.S. Census Bureau
301-763-6532
brian.mckenzie(a)census.gov
_______________________________________________
ctpp-news mailing list
ctpp-news(a)chrispy.net
http://www.chrispy.net/mailman/listinfo/ctpp-news
12:01 p.m.
New subject: ACS 2005-09 comparisons with 2000 SF3
The direct answer to Nick is that the block group data will NOT be posted in American
Factfinder, and will ONLY be available in Summary File format.
Ed's response was about reasons why the Census chose this differentiation.
Elaine Murakami
FHWA Office of Planning
-----Original Message-----
From: ctpp-news-bounces(a)chrispy.net on behalf of edc(a)berwyned.com
Sent: Tue 12/14/2010 12:24 PM
To: ctpp-news(a)chrispy.net
Subject: RE: [CTPP] ACS 2005-09 comparisons with 2000 SF3
This is one of those points of speculation and spin. If you ask the CB
the official line will be that it is so big and contains literally
mountains of tables that it is impractical to serve up with an online
search engine. They will tell you that comments on this were asked for in
the Federal Register and there was not a huge outcry. However, if you
"put your ear to the ground" you will hear some speculate that it is
because the tables are so hard to work with due to confidentiality
suppression and large margins of errors that the CB wanted to keep the
data from the "novice" user. As one noted user put it, "they are putting
the data on the top shelf just out of reach of the kids."
What would be of use here is for people who have begun to work with it to
share their experiences.
Form the CB press release today...
The U.S Census Bureau is pleased to announce the release of the 2005-2009
American Community Survey (ACS) 5-year estimates on American FactFinder.
There you will find tables with social, demographic, housing, and economic
data for areas down to the census tract level.
You can access the newly-released data on American FactFinder at:
2005-2009 ACS 5-year data
http://factfinder.census.gov/servlet/DatasetMainPageServlet?_program=ACS&am…
Does anyone know why the Block Group data is not being
released via the
AFFâ?Ts standard pull-down menus? I was under the impression that today
(12/14) was the release date for this data. I understand that it is
available via Summary File, but this is far from user friendly.
When will the data be available via the AFFâ?Ts standard access method?
Thank you,
Nick Lindeman
Nicholas Lindeman
Economic & Systems Data Analyst
Nashville Area MPO
800 2nd Ave. S.
P.O. Box 196300
Nashville, TN 37219-6300
(615) 862-7198
lindeman(a)nashvillempo.org
http://www.nashvillempo.org <http://www.nashvillempo.org/>
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net]
On Behalf Of Elaine.Murakami(a)dot.gov
Sent: Tuesday, December 07, 2010 4:15 PM
To: ctpp-news(a)chrispy.net
Subject: FW: [CTPP] ACS 2005-09 comparisons with 2000 SF3
Correction to my earlier email: 2005-2009 ACS Block Group data WILL be
released on December 14.
From: brian.mckenzie(a)census.gov [mailto:brian.mckenzie@census.gov]
Good Afternoon Mara and Elaine,
The summary file data (block group level data) will be available on
December 14th. You can use American Factfinder as a portal. You will be
able to download summary file data via the FTP website at
<http://www2.census.gov/acs2009_5yr/summaryfile/
<http://www2.census.gov/acs2009_5yr/summaryfile/> >. There will also be a
clickable link next to the familiar portion of AFF in which you select the
desired ACS year(s) for which you would like data. Hope this helps.
Brian McKenzie
Analyst, Journey to Work and Migration Statistics Branch
U.S. Census Bureau
301-763-6532
brian.mckenzie(a)census.gov
_______________________________________________
ctpp-news mailing list
ctpp-news(a)chrispy.net
http://www.chrispy.net/mailman/listinfo/ctpp-news
_______________________________________________
ctpp-news mailing list
ctpp-news(a)chrispy.net
http://www.chrispy.net/mailman/listinfo/ctpp-news
7:36 p.m.
New subject: ACS 2005-09 Block Group level stats
I agree with Patty Becker that the Block Group-level stats are shaky. I'd posted on
this question to the Census SDC listserv a few months back. I'll share it here (CTPP
list) as well...
According to Chapter 3 of the Bureau's ACS Design and Methodology, the
"frame" for ACS 2005-09 is still the Census 2000 MAF with five kinds of
POST-2000 maintenance. (So the frame for the ACS data released this Fall is not the 2010
MAF.)
If I understand Chapter 11, Census has taken some steps as Census Tract-level quality
control. Still Tract totals are simply the Tract-level frame counts from the MAF,
validated with administrative data counts. See
http://www.census.gov/acs/www/Downloads/survey_methodology/acs_design_metho…
for details (starting on page 11.17)
As for Block Groups... ACS housing unit totals, pop totals, and other data for Block
Groups are simply BG-level sums of weights of cases that happen to be geolocated within
the BG. Beyond that, Block Groups are unaddressed in the control total and weighting
methodology. So there’s great potential, from a research design standpoint, for screwy
results at BG-level.
Bottom line: Yes, the BG-level numbers you see in ACS 2005-09 are very shaky. And the
ACS 2006-10 data that will be released 12 months from now -- with all the raw
survey-collected data re-weighted -- could look very different at Block Group level.
________________________
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<mailto:todd.graham@metc.state.mn.us>
in: www.linkedin.com/in/toddgraham
web: http://stats.metc.state.mn.us/
________________________
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of
Lindeman, Nicholas (MPO)
Sent: Tuesday, December 14, 2010 10:42 AM
To: ctpp-news(a)chrispy.net
Subject: RE: [CTPP] ACS 2005-09 comparisons with 2000 SF3
Does anyone know why the Block Group data is not being released via the AFF’s standard
pull-down menus? I was under the impression that today (12/14) was the release date for
this data. I understand that it is available via Summary File, but this is far from user
friendly.
When will the data be available via the AFF’s standard access method?
Thank you,
Nick Lindeman
Nicholas Lindeman
Economic & Systems Data Analyst
Nashville Area MPO
800 2nd Ave. S.
P.O. Box 196300
Nashville, TN 37219-6300
(615) 862-7198
lindeman(a)nashvillempo.org
http://www.nashvillempo.org<http://www.nashvillempo.org/>
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of
Elaine.Murakami(a)dot.gov
Sent: Tuesday, December 07, 2010 4:15 PM
To: ctpp-news(a)chrispy.net
Subject: FW: [CTPP] ACS 2005-09 comparisons with 2000 SF3
Correction to my earlier email: 2005-2009 ACS Block Group data WILL be released on
December 14.
From: brian.mckenzie(a)census.gov [mailto:brian.mckenzie@census.gov]
Good Afternoon Mara and Elaine,
The summary file data (block group level data) will be available on December 14th. You can
use American Factfinder as a portal. You will be able to download summary file data via
the FTP website at <http://www2.census.gov/acs2009_5yr/summaryfile/>. There will
also be a clickable link next to the familiar portion of AFF in which you select the
desired ACS year(s) for which you would like data. Hope this helps.
Brian McKenzie
Analyst, Journey to Work and Migration Statistics Branch
U.S. Census Bureau
301-763-6532
brian.mckenzie(a)census.gov
21 Dec
21 Dec
9:22 a.m.
New subject: ACS 2005-09 data
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(a)ovrdc.org
22 Dec
22 Dec
8:22 a.m.
New subject: ACS 2005-09 data
Look here for details:
http://www.census.gov/acs/www/guidance_for_data_users/handbooks/
<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(a)ovrdc.org>wrote;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(a)ovrdc.org
_______________________________________________
ctpp-news mailing list
ctpp-news(a)chrispy.net
http://www.chrispy.net/mailman/listinfo/ctpp-news
--
Krishnan Viswanathan
1101 High Meadow Dr
Tallahassee FL 32311
9:27 a.m.
New subject: 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<htt…
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<mailto:todd.graham@metc.state.mn.us>
in: www.linkedin.com/in/toddgraham
web: http://stats.metc.state.mn.us/
________________________
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of
Krishnan Viswanathan
Sent: Wednesday, December 22, 2010 8:23 AM
To: ctpp-news(a)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<mailto: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<http://www.ovrdc.org>
Email: jgillow@ovrdc.org<mailto:jgillow@ovrdc.org>
_______________________________________________
ctpp-news mailing list
ctpp-news@chrispy.net<mailto:ctpp-news@chrispy.net>
http://www.chrispy.net/mailman/listinfo/ctpp-news
--
Krishnan Viswanathan
1101 High Meadow Dr
Tallahassee FL 32311
10:11 a.m.
New subject: ACS 2005-09 data
What I would like to know is how much MOE is too much to be useful? I have
been looking at the census tract MOE's for certain variables in my region
and they range from 25% to 200%. It's not pretty. And that's not even the
obscure sub-categories. Where do other people draw the line when determining
data reliability?
Mara
Mara Kaminowitz
GIS Analyst
.........................................................................
Baltimore Metropolitan Council
Offices at McHenry Row
1500 Whetstone Way
Suite 300
Baltimore, MD 21230
410-732-0500 ext. 1030
<mailto:mkaminowitz@baltometro.org> mkaminowitz(a)baltometro.org
<http://www.baltometro.org> www.baltometro.org
_____
From: Graham, Todd [mailto:todd.graham@metc.state.mn.us]
Sent: Wednesday, December 22, 2010 10:27 AM
To: ctpp-news(a)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: <mailto:todd.graham@metc.state.mn.us> todd.graham(a)metc.state.mn.us
in: www.linkedin.com/in/toddgraham
web: http://stats.metc.state.mn.us/
________________________
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net]
On Behalf Of Krishnan Viswanathan
Sent: Wednesday, December 22, 2010 8:23 AM
To: ctpp-news(a)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(a)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(a)ovrdc.org
_______________________________________________
ctpp-news mailing list
ctpp-news(a)chrispy.net
http://www.chrispy.net/mailman/listinfo/ctpp-news
--
Krishnan Viswanathan
1101 High Meadow Dr
Tallahassee FL 32311
12:43 p.m.
New subject: relative standard error
Where to draw the line? Probably comes down to what's your tolerance for error in
informing decisions you want to make...
Earlier in my career, I worked in a State labor market research shop. In survey work for
US BLS, we would only publish survey-based stats where relative standard error (std error
as % of the central estimate) was less than 30% (for average wage) or less than 50% (for
employment levels).
The wage statistics had a more stringent standard than employment levels because of the
nature of the data (there was less variation and uncertainty around wages) and because of
perceived criticality (data user audiences expected and needed greater accuracy).
Hope that helps.
--Todd Graham
Metropolitan Council Research
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of
Mara Kaminowitz
Sent: Wednesday, December 22, 2010 10:11 AM
To: ctpp-news(a)chrispy.net
Subject: RE: [CTPP] ACS 2005-09 data
What I would like to know is how much MOE is too much to be useful? I have been looking at
the census tract MOE's for certain variables in my region and they range from 25% to
200%. It's not pretty. And that's not even the obscure sub-categories. Where do
other people draw the line when determining data reliability?
Mara
Mara Kaminowitz
GIS Analyst
.........................................................................
Baltimore Metropolitan Council
Offices at McHenry Row
1500 Whetstone Way
Suite 300
Baltimore, MD 21230
410-732-0500 ext. 1030
mkaminowitz@baltometro.org<mailto:mkaminowitz@baltometro.org>
www.baltometro.org
<http://www.baltometro.org>
23 Dec
23 Dec
10:18 a.m.
New subject: ACS 2005-09 data
Hello
Thank you for the information, it helped greatly. I had one further question. How do you
handle the Margin of Errors 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?
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(a)ovrdc.org
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of
Graham, Todd
Sent: Wednesday, December 22, 2010 10:27 AM
To: ctpp-news(a)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<htt…
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<mailto:todd.graham@metc.state.mn.us>
in: www.linkedin.com/in/toddgraham
web: http://stats.metc.state.mn.us/
________________________
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of
Krishnan Viswanathan
Sent: Wednesday, December 22, 2010 8:23 AM
To: ctpp-news(a)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<mailto: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<http://www.ovrdc.org>
Email: jgillow@ovrdc.org<mailto:jgillow@ovrdc.org>
_______________________________________________
ctpp-news mailing list
ctpp-news@chrispy.net<mailto:ctpp-news@chrispy.net>
http://www.chrispy.net/mailman/listinfo/ctpp-news
--
Krishnan Viswanathan
1101 High Meadow Dr
Tallahassee FL 32311
27 Dec
27 Dec
11:12 a.m.
New subject: ACS 2005-09 data
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(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of
Graham, Todd
Sent: Wednesday, December 22, 2010 10:27 AM
To: ctpp-news(a)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<htt…
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<mailto:todd.graham@metc.state.mn.us>
in: www.linkedin.com/in/toddgraham
web: http://stats.metc.state.mn.us/
________________________
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of
Krishnan Viswanathan
Sent: Wednesday, December 22, 2010 8:23 AM
To: ctpp-news(a)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<mailto: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<http://www.ovrdc.org>
Email: jgillow@ovrdc.org<mailto:jgillow@ovrdc.org>
_______________________________________________
ctpp-news mailing list
ctpp-news@chrispy.net<mailto:ctpp-news@chrispy.net>
http://www.chrispy.net/mailman/listinfo/ctpp-news
--
Krishnan Viswanathan
1101 High Meadow Dr
Tallahassee FL 32311
4868
days inactive
4888
days old
12 comments
7 participants
participants (7)
-
edc＠berwyned.com -
Elaine.Murakami＠dot.gov -
Graham, Todd -
Jason Gillow -
Krishnan Viswanathan -
Lindeman, Nicholas (MPO) -
Mara Kaminowitz