Thank you Liang. Unfortunately, many of the counties in the Columbus MSA fall below the 65,000 count, so we will have to use 3 year sample data.
Thank you again,
Nancy
-----Original Message-----
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of liang.long(a)dot.gov
Sent: Wednesday, March 13, 2013 12:22 PM
To: ctpp-news(a)chrispy.net
Subject: Re: [CTPP] OMB Released the New Metropolitan and micropolitan areas
Hi, Nancy
As far as I know, the new MSA definitions will not be applied to ACS 2012, which will be released this year. My guess is that they may be actually applied to ACS 2013, which will be out in calendar year 2014.
Since MSAs are based on counties, you can always aggregate counties for the new MSA definitions.
Thanks,
Liang
________________________________________
From: ctpp-news-bounces(a)chrispy.net [ctpp-news-bounces(a)chrispy.net] on behalf of Nancy Reger [Nreger(a)morpc.org]
Sent: Wednesday, March 13, 2013 11:16 AM
To: ctpp-news(a)chrispy.net
Subject: Re: [CTPP] OMB Released tje New Metropolitan and micropolitan areas
Liang,
Do you know when the ACS will start using these new MSA delineations in the data reported?
Thank you,
Nancy
Nancy Reger | nreger(a)morpc.org
Deputy Director, Transportation | Mid-Ohio Regional Planning Commission
T: 614.233.4154 | | F: 614.233.4254
111 Liberty Street, Suite 100 | Columbus, OH 43215
[cid:image001.png(a)01CDADDC.13A5DD60]<http://www.morpc.org/> [cid:image002.png(a)01CDADDC.13A5DD60] <http://www.facebook.com/morpc> [cid:image003.jpg(a)01CDADDC.13A5DD60] <http://www.twitter.com/morpc>
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Liang Long
Sent: Monday, March 04, 2013 11:09 AM
To: ctpp-news(a)chrispy.net
Subject: [CTPP] OMB Released tje New Metropolitan and micropolitan areas
Hi, All
Our Census Bureau friend, Brian McKenzie told us that OMB released the metro/micro areas late last week. The new definitions' link http://www.whitehouse.gov/omb/bulletins_default .
The new 2006-2010 county worker flows will come out tomorrow some time.
Enjoy!
Liang Long
Cambridge Systematics, Inc.
4800 Hampden Lane
Suite 800
Bethesda, MD 20814
tel 301 347 0100
fax 301 347 0101
FHWA 202-366-6971
e-mail llong(a)camsys.com<mailto:llong(a)camsys.com>
www.camsys.com
Hi, Nancy
As far as I know, the new MSA definitions will not be applied to ACS 2012, which will be released this year. My guess is that they may be actually applied to ACS 2013, which will be out in calendar year 2014.
Since MSAs are based on counties, you can always aggregate counties for the new MSA definitions.
Thanks,
Liang
________________________________________
From: ctpp-news-bounces(a)chrispy.net [ctpp-news-bounces(a)chrispy.net] on behalf of Nancy Reger [Nreger(a)morpc.org]
Sent: Wednesday, March 13, 2013 11:16 AM
To: ctpp-news(a)chrispy.net
Subject: Re: [CTPP] OMB Released tje New Metropolitan and micropolitan areas
Liang,
Do you know when the ACS will start using these new MSA delineations in the data reported?
Thank you,
Nancy
Nancy Reger | nreger(a)morpc.org
Deputy Director, Transportation | Mid-Ohio Regional Planning Commission
T: 614.233.4154 | | F: 614.233.4254
111 Liberty Street, Suite 100 | Columbus, OH 43215
[cid:image001.png(a)01CDADDC.13A5DD60]<http://www.morpc.org/> [cid:image002.png(a)01CDADDC.13A5DD60] <http://www.facebook.com/morpc> [cid:image003.jpg(a)01CDADDC.13A5DD60] <http://www.twitter.com/morpc>
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Liang Long
Sent: Monday, March 04, 2013 11:09 AM
To: ctpp-news(a)chrispy.net
Subject: [CTPP] OMB Released tje New Metropolitan and micropolitan areas
Hi, All
Our Census Bureau friend, Brian McKenzie told us that OMB released the metro/micro areas late last week. The new definitions' link http://www.whitehouse.gov/omb/bulletins_default .
The new 2006-2010 county worker flows will come out tomorrow some time.
Enjoy!
Liang Long
Cambridge Systematics, Inc.
4800 Hampden Lane
Suite 800
Bethesda, MD 20814
tel 301 347 0100
fax 301 347 0101
FHWA 202-366-6971
e-mail llong(a)camsys.com<mailto:llong(a)camsys.com>
www.camsys.com
Dear CTPP community,
Through the generous support of SHRP2, we are pleased to announce that travel assistance will be available to public agency staff and qualifying students for the 14th TRB National Transportation Planning Applications Conference. Applications for support are now available on the conference website (www.trbappcon.org<http://www.trbappcon.org>) and must be submitted by April 1. Please accept our apologies for the short notice and for any cross-posting.
Also, please note that the deadline for early bird registration ends April 10th and our block of rooms at the hotel is filling up quickly. We encourage everyone interested to register for the conference and make their hotel and travel reservations soon.
For any of you who may not be familiar with the conference, the applications conference aims to provide an outlet for new transportation planning techniques and methods emphasizing practical, innovative and timely technical and policy approaches to transportation planning through professional presentations and workshops over the course of 5 days. The conference will be held in Columbus, Ohio, May 5-9, 2013. See the conference website (www.trbappcon.org<http://www.trbappcon.org>) for more details.
We hope, especially with the help of the travel assistance, to see many of you in Columbus!
Best,
Vince Bernardin
Conference Chair
Liang,
Do you know when the ACS will start using these new MSA delineations in the data reported?
Thank you,
Nancy
Nancy Reger | nreger(a)morpc.org
Deputy Director, Transportation | Mid-Ohio Regional Planning Commission
T: 614.233.4154 | | F: 614.233.4254
111 Liberty Street, Suite 100 | Columbus, OH 43215
[cid:image001.png(a)01CE1FDC.24E7F2D0]<http://www.morpc.org/> [cid:image002.png(a)01CE1FDC.24E7F2D0] <http://www.facebook.com/morpc> [cid:image003.jpg(a)01CE1FDC.24E7F2D0] <http://www.twitter.com/morpc>
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Liang Long
Sent: Monday, March 04, 2013 11:09 AM
To: ctpp-news(a)chrispy.net
Subject: [CTPP] OMB Released tje New Metropolitan and micropolitan areas
Hi, All
Our Census Bureau friend, Brian McKenzie told us that OMB released the metro/micro areas late last week. The new definitions' link http://www.whitehouse.gov/omb/bulletins_default .
The new 2006-2010 county worker flows will come out tomorrow some time.
Enjoy!
Liang Long
Cambridge Systematics, Inc.
4800 Hampden Lane
Suite 800
Bethesda, MD 20814
tel 301 347 0100
fax 301 347 0101
FHWA 202-366-6971
e-mail llong(a)camsys.com<mailto:llong(a)camsys.com>
www.camsys.com
That's true. If we knew how the census bureau was aggregating smaller areas like blocks into counties and calculating MOE's, then that would give us an idea for how to aggregate counties into arbitrary groupings.
Steven Farber, Ph.D
Assistant Professor
Department of Geography
University or Utah
http://stevenfarber.wordpress.com
-----Original Message-----
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of hprawiranata mitcrpc.org
Sent: March-12-13 10:38 AM
To: ctpp-news(a)chrispy.net
Subject: Re: [CTPP] Working with County flow data
My logic:
Measurement from single entities (one county with it sample) has its own error. Combining multiple single measurements will create sum or error from each measurements.
IF
On Tue, Mar 12, 2013 at 12:18 PM, <liang.long(a)dot.gov> wrote:
> I can see why Census doesn't recommend do more than three variables at a time. When you add 17 counties together, you get a much bigger area with more households sampled. In theory, you should get a smaller MOEs compared each individual county. But if you derive MOEs from those 17 counties, you will get a much bigger MOEs, which is contradictory to the theory.
>
>
> ________________________________________
> From: ctpp-news-bounces(a)chrispy.net [ctpp-news-bounces(a)chrispy.net] on
> behalf of Ed Christopher [edc(a)berwyned.com]
> Sent: Tuesday, March 12, 2013 11:15 AM
> To: ctpp-news(a)chrispy.net
> Subject: Re: [CTPP] Working with County flow data
>
> Thanks--I know the spread sheet allows you to recalculate MOEs for more than three variables but I remember doing more than 3 a while back and I was getting some wild MOEs. When I dug into it I found something in the Census compass reports that said not to do more than three variables at a time. I was hoping that someone figured out a way around this.
>
> Ed C
>
> On Mar 12, 2013, at 9:59 AM, "Hoctor Mulmat, Darlanne" <Darlanne.Mulmat(a)sandag.org<mailto:Darlanne.Mulmat(a)sandag.org>> wrote:
>
> The New York State Data Center developed a Statistical Calculations Menu that includes an option for computing the margin of error for the sum of three or more estimates. See attached.
>
> Darlanne Hoctor Mulmat
> Applied Research Division - Criminal Justice/Public Policy San Diego
> Association of Governments
> 619-699-7326
>
> From:
> ctpp-news-bounces(a)chrispy.net<mailto:ctpp-news-bounces(a)chrispy.net>
> [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of
> Ed.Christopher(a)dot.gov<mailto:Ed.Christopher(a)dot.gov>
> Sent: Tuesday, March 12, 2013 6:57 AM
> To: ctpp-news(a)chrispy.net<mailto:ctpp-news(a)chrispy.net>
> Subject: [CTPP] Working with County flow data
>
> Has anyone come up with some easy ways for collapsing and grouping counties together using last week's county flow data and recalculating new MOEs. I have so many counties that I want to group together that I am looking for a quick way that can handle "lots" of counties. Another issue I am struggling with is that we are always told not to group more than three variables at a time or the formulas for calculating the new MOE do not really work. This is particularly troublesome especially if I am trying to group 17 counties together. What it comes down to is 9 different calculations given that I can only group 3 counties at a time together. Anyone figure out any short cuts or ways around this short of disregarding the MOEs altogether? Given all the clustering that I am looking at using the "cheat" sheets I am used to, I will be recalculating MOEs for weeks.
>
>
> Ed Christopher
> <StatisticalCalculationsMenu.xls>
> _______________________________________________
> ctpp-news mailing list
> ctpp-news(a)ryoko.chrispy.net<mailto:ctpp-news(a)ryoko.chrispy.net>
> http://ryoko.chrispy.net/mailman/listinfo/ctpp-news
>
> _______________________________________________
> ctpp-news mailing list
> ctpp-news(a)ryoko.chrispy.net
> http://ryoko.chrispy.net/mailman/listinfo/ctpp-news
_______________________________________________
ctpp-news mailing list
ctpp-news(a)ryoko.chrispy.nethttp://ryoko.chrispy.net/mailman/listinfo/ctpp-news
I see one reason why aggregation is causing larger, rather than smaller, standard errors.
The formula used, known as Bienaymé's formula, assumes that each variable you are adding is independent of the others. In a map of the counties, this is clearly not the case, since we know the counties are autocorrelated. Perhaps you can estimate the covariance between counties and use that to more accurately estimate the variance using the formula Var(sum(X_i))=sum(sum(Cov(X_i,X_j)).
This is the more appropriate way to calculate variance of a sum of random variables that are not independent.
Isn't there a statistician in the room?
Steve
Steven Farber, Ph.D
Assistant Professor
Department of Geography
University or Utah
http://stevenfarber.wordpress.com
-----Original Message-----
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of liang.long(a)dot.gov
Sent: March-12-13 10:18 AM
To: ctpp-news(a)chrispy.net
Subject: Re: [CTPP] Working with County flow data
I can see why Census doesn't recommend do more than three variables at a time. When you add 17 counties together, you get a much bigger area with more households sampled. In theory, you should get a smaller MOEs compared each individual county. But if you derive MOEs from those 17 counties, you will get a much bigger MOEs, which is contradictory to the theory.
________________________________________
From: ctpp-news-bounces(a)chrispy.net [ctpp-news-bounces(a)chrispy.net] on behalf of Ed Christopher [edc(a)berwyned.com]
Sent: Tuesday, March 12, 2013 11:15 AM
To: ctpp-news(a)chrispy.net
Subject: Re: [CTPP] Working with County flow data
Thanks--I know the spread sheet allows you to recalculate MOEs for more than three variables but I remember doing more than 3 a while back and I was getting some wild MOEs. When I dug into it I found something in the Census compass reports that said not to do more than three variables at a time. I was hoping that someone figured out a way around this.
Ed C
On Mar 12, 2013, at 9:59 AM, "Hoctor Mulmat, Darlanne" <Darlanne.Mulmat(a)sandag.org<mailto:Darlanne.Mulmat(a)sandag.org>> wrote:
The New York State Data Center developed a Statistical Calculations Menu that includes an option for computing the margin of error for the sum of three or more estimates. See attached.
Darlanne Hoctor Mulmat
Applied Research Division - Criminal Justice/Public Policy San Diego Association of Governments
619-699-7326
From: ctpp-news-bounces(a)chrispy.net<mailto:ctpp-news-bounces(a)chrispy.net> [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Ed.Christopher(a)dot.gov<mailto:Ed.Christopher(a)dot.gov>
Sent: Tuesday, March 12, 2013 6:57 AM
To: ctpp-news(a)chrispy.net<mailto:ctpp-news(a)chrispy.net>
Subject: [CTPP] Working with County flow data
Has anyone come up with some easy ways for collapsing and grouping counties together using last week's county flow data and recalculating new MOEs. I have so many counties that I want to group together that I am looking for a quick way that can handle "lots" of counties. Another issue I am struggling with is that we are always told not to group more than three variables at a time or the formulas for calculating the new MOE do not really work. This is particularly troublesome especially if I am trying to group 17 counties together. What it comes down to is 9 different calculations given that I can only group 3 counties at a time together. Anyone figure out any short cuts or ways around this short of disregarding the MOEs altogether? Given all the clustering that I am looking at using the "cheat" sheets I am used to, I will be recalculating MOEs for weeks.
Ed Christopher
<StatisticalCalculationsMenu.xls>
_______________________________________________
ctpp-news mailing list
ctpp-news(a)ryoko.chrispy.net<mailto:ctpp-news(a)ryoko.chrispy.net>
http://ryoko.chrispy.net/mailman/listinfo/ctpp-news
_______________________________________________
ctpp-news mailing list
ctpp-news(a)ryoko.chrispy.nethttp://ryoko.chrispy.net/mailman/listinfo/ctpp-news
Sorry, unfinished email draft got sent out !
I still have to think about it and see the data..
Hary
On Tue, Mar 12, 2013 at 12:37 PM, hprawiranata mitcrpc.org
<hprawiranata(a)mitcrpc.org> wrote:
> My logic:
> Measurement from single entities (one county with it sample) has its
> own error. Combining multiple single measurements will create sum or
> error from each measurements.
>
> IF
>
>
> On Tue, Mar 12, 2013 at 12:18 PM, <liang.long(a)dot.gov> wrote:
>> I can see why Census doesn't recommend do more than three variables at a time. When you add 17 counties together, you get a much bigger area with more households sampled. In theory, you should get a smaller MOEs compared each individual county. But if you derive MOEs from those 17 counties, you will get a much bigger MOEs, which is contradictory to the theory.
>>
>>
>> ________________________________________
>> From: ctpp-news-bounces(a)chrispy.net [ctpp-news-bounces(a)chrispy.net] on behalf of Ed Christopher [edc(a)berwyned.com]
>> Sent: Tuesday, March 12, 2013 11:15 AM
>> To: ctpp-news(a)chrispy.net
>> Subject: Re: [CTPP] Working with County flow data
>>
>> Thanks--I know the spread sheet allows you to recalculate MOEs for more than three variables but I remember doing more than 3 a while back and I was getting some wild MOEs. When I dug into it I found something in the Census compass reports that said not to do more than three variables at a time. I was hoping that someone figured out a way around this.
>>
>> Ed C
>>
>> On Mar 12, 2013, at 9:59 AM, "Hoctor Mulmat, Darlanne" <Darlanne.Mulmat(a)sandag.org<mailto:Darlanne.Mulmat(a)sandag.org>> wrote:
>>
>> The New York State Data Center developed a Statistical Calculations Menu that includes an option for computing the margin of error for the sum of three or more estimates. See attached.
>>
>> Darlanne Hoctor Mulmat
>> Applied Research Division – Criminal Justice/Public Policy
>> San Diego Association of Governments
>> 619-699-7326
>>
>> From: ctpp-news-bounces(a)chrispy.net<mailto:ctpp-news-bounces(a)chrispy.net> [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Ed.Christopher(a)dot.gov<mailto:Ed.Christopher(a)dot.gov>
>> Sent: Tuesday, March 12, 2013 6:57 AM
>> To: ctpp-news(a)chrispy.net<mailto:ctpp-news(a)chrispy.net>
>> Subject: [CTPP] Working with County flow data
>>
>> Has anyone come up with some easy ways for collapsing and grouping counties together using last week’s county flow data and recalculating new MOEs. I have so many counties that I want to group together that I am looking for a quick way that can handle “lots” of counties. Another issue I am struggling with is that we are always told not to group more than three variables at a time or the formulas for calculating the new MOE do not really work. This is particularly troublesome especially if I am trying to group 17 counties together. What it comes down to is 9 different calculations given that I can only group 3 counties at a time together. Anyone figure out any short cuts or ways around this short of disregarding the MOEs altogether? Given all the clustering that I am looking at using the “cheat” sheets I am used to, I will be recalculating MOEs for weeks.
>>
>>
>> Ed Christopher
>> <StatisticalCalculationsMenu.xls>
>> _______________________________________________
>> ctpp-news mailing list
>> ctpp-news(a)ryoko.chrispy.net<mailto:ctpp-news(a)ryoko.chrispy.net>
>> http://ryoko.chrispy.net/mailman/listinfo/ctpp-news
>>
>> _______________________________________________
>> ctpp-news mailing list
>> ctpp-news(a)ryoko.chrispy.net
>> http://ryoko.chrispy.net/mailman/listinfo/ctpp-news
My logic:
Measurement from single entities (one county with it sample) has its
own error. Combining multiple single measurements will create sum or
error from each measurements.
IF
On Tue, Mar 12, 2013 at 12:18 PM, <liang.long(a)dot.gov> wrote:
> I can see why Census doesn't recommend do more than three variables at a time. When you add 17 counties together, you get a much bigger area with more households sampled. In theory, you should get a smaller MOEs compared each individual county. But if you derive MOEs from those 17 counties, you will get a much bigger MOEs, which is contradictory to the theory.
>
>
> ________________________________________
> From: ctpp-news-bounces(a)chrispy.net [ctpp-news-bounces(a)chrispy.net] on behalf of Ed Christopher [edc(a)berwyned.com]
> Sent: Tuesday, March 12, 2013 11:15 AM
> To: ctpp-news(a)chrispy.net
> Subject: Re: [CTPP] Working with County flow data
>
> Thanks--I know the spread sheet allows you to recalculate MOEs for more than three variables but I remember doing more than 3 a while back and I was getting some wild MOEs. When I dug into it I found something in the Census compass reports that said not to do more than three variables at a time. I was hoping that someone figured out a way around this.
>
> Ed C
>
> On Mar 12, 2013, at 9:59 AM, "Hoctor Mulmat, Darlanne" <Darlanne.Mulmat(a)sandag.org<mailto:Darlanne.Mulmat(a)sandag.org>> wrote:
>
> The New York State Data Center developed a Statistical Calculations Menu that includes an option for computing the margin of error for the sum of three or more estimates. See attached.
>
> Darlanne Hoctor Mulmat
> Applied Research Division – Criminal Justice/Public Policy
> San Diego Association of Governments
> 619-699-7326
>
> From: ctpp-news-bounces(a)chrispy.net<mailto:ctpp-news-bounces(a)chrispy.net> [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Ed.Christopher(a)dot.gov<mailto:Ed.Christopher(a)dot.gov>
> Sent: Tuesday, March 12, 2013 6:57 AM
> To: ctpp-news(a)chrispy.net<mailto:ctpp-news(a)chrispy.net>
> Subject: [CTPP] Working with County flow data
>
> Has anyone come up with some easy ways for collapsing and grouping counties together using last week’s county flow data and recalculating new MOEs. I have so many counties that I want to group together that I am looking for a quick way that can handle “lots” of counties. Another issue I am struggling with is that we are always told not to group more than three variables at a time or the formulas for calculating the new MOE do not really work. This is particularly troublesome especially if I am trying to group 17 counties together. What it comes down to is 9 different calculations given that I can only group 3 counties at a time together. Anyone figure out any short cuts or ways around this short of disregarding the MOEs altogether? Given all the clustering that I am looking at using the “cheat” sheets I am used to, I will be recalculating MOEs for weeks.
>
>
> Ed Christopher
> <StatisticalCalculationsMenu.xls>
> _______________________________________________
> ctpp-news mailing list
> ctpp-news(a)ryoko.chrispy.net<mailto:ctpp-news(a)ryoko.chrispy.net>
> http://ryoko.chrispy.net/mailman/listinfo/ctpp-news
>
> _______________________________________________
> ctpp-news mailing list
> ctpp-news(a)ryoko.chrispy.net
> http://ryoko.chrispy.net/mailman/listinfo/ctpp-news
The New York State Data Center developed a Statistical Calculations Menu that includes an option for computing the margin of error for the sum of three or more estimates. See attached.
Darlanne Hoctor Mulmat
Applied Research Division - Criminal Justice/Public Policy
San Diego Association of Governments
619-699-7326
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Ed.Christopher(a)dot.gov
Sent: Tuesday, March 12, 2013 6:57 AM
To: ctpp-news(a)chrispy.net
Subject: [CTPP] Working with County flow data
Has anyone come up with some easy ways for collapsing and grouping counties together using last week's county flow data and recalculating new MOEs. I have so many counties that I want to group together that I am looking for a quick way that can handle "lots" of counties. Another issue I am struggling with is that we are always told not to group more than three variables at a time or the formulas for calculating the new MOE do not really work. This is particularly troublesome especially if I am trying to group 17 counties together. What it comes down to is 9 different calculations given that I can only group 3 counties at a time together. Anyone figure out any short cuts or ways around this short of disregarding the MOEs altogether? Given all the clustering that I am looking at using the "cheat" sheets I am used to, I will be recalculating MOEs for weeks.
Ed Christopher
Has anyone come up with some easy ways for collapsing and grouping counties together using last week's county flow data and recalculating new MOEs. I have so many counties that I want to group together that I am looking for a quick way that can handle "lots" of counties. Another issue I am struggling with is that we are always told not to group more than three variables at a time or the formulas for calculating the new MOE do not really work. This is particularly troublesome especially if I am trying to group 17 counties together. What it comes down to is 9 different calculations given that I can only group 3 counties at a time together. Anyone figure out any short cuts or ways around this short of disregarding the MOEs altogether? Given all the clustering that I am looking at using the "cheat" sheets I am used to, I will be recalculating MOEs for weeks.
Ed Christopher