Main | July 2010 »

June 29, 2010

Class Exercises ( Wednesday)

IPUMS-USA website

Guide to Variables
Selected variables from IPUMS with PUMS, ACS, and CPS equivalent names

Register to use IPUMS

(required for making an extract)

Instructions for using the IPUMS Data Extraction System

Instructions for opening data on PC

Making an Extract of the ACS 3-year data from IPUMS
[ppt] [pdf]

Extract
(zipped)
Extract
(not zipped)

SAS program
Stata program SPSS program

FAQ on 3-year ACS data

Note about income items in 3-year data

Posted by lisan at 09:02 PM | Comments (0)

June 28, 2010

PDQ Explore software

The following is a link to the PDQ-Explore software that you used during the workshop. You will need to download the zip file to the C:\ drive on your PC.
PDQ-Explore

As a reminder of what you need to do to get started, here is the introduction to Using PDQ-Explore, which includes some technical notes.
Introduction to PDQ-Explore


Guides to PDQ Explore

There are about 10 guides that describe in quite a bit of detail how to do many of the procedures covered in the class. If you find you need a reminder, check these out. You will need to scroll down the page to see the guides.

Posted by sbriske at 10:40 AM | Comments (0)

IPUMS-USA

IPUMS-USA website

Guide to Variables
Selected variables from IPUMS with PUMS, ACS, and CPS equivalent names

Register to use IPUMS

(required for making an extract)

Instructions for using the IPUMS Data Extraction System

Instructions for opening data on PC

Making an Extract of the ACS 3-year data from IPUMS
[presentation]

Extract
(zipped)
Extract
(not zipped)

SAS program

FAQ on 3-year ACS data

Note about income items in 3-year data

Posted by sbriske at 10:37 AM | Comments (0)

Mapping Resorces

Mapping from the Census Bureau website
This is a short description of how to make maps using the Census Bureau website. It requires no GIS skills or software. All of the tools reside on the Census Bureau site. The drawback is the limited flexibility on being able to find a table and/or geography that meets the users' needs.

Social Explorer
This site provides easy access to interactive maps based on census data. One is limited to the items they make available, particularly if you use the "free" version. Many universities have subscriptions to the full service.

CensusScope
CensusScope provides access to charts & trends, maps, rankings, and segregation scores based on Census 2000 data (and soon to be Census 2010 and ACS products). For the most part, the maps are at the state or county level, not lower levels of geography like census tracts.

Posted by sbriske at 10:35 AM | Comments (0)

June 25, 2010

Statistical Links

Technical Issues (mostly statistical) Associated with the ACS
[PowerPoint presentation]

Appendices associated with each ACS Compass product

SAS code for using Replicate Weights
Statistical packages such as stata can handle replicate weights to produce standard errors and tests of significance. However, for the ACS and CPS, the replicate weights are based on a successive difference model rather than a jack-knife or generalized linear model. No statistical package handles successive difference models as an option.

Thus, one has to go through the actual algorithm to produce standard errors based on the successive difference replicate weights. The following program provides the code for this:

SAS code for using replicate weights

Replicate Weights
Garrett, B. Dale and Michael Starsinic. 2008. "ACS Public Use Microdata Samples of 2005 and 2006 - How to Use Replicate Weights." Presentation at AAPOR Conference, New Orleans, May 16, 2008.

Theoretical basis for successive difference model is:
Fay, R. and Train, G. 1995 "Aspects of Survey and Model-Based Postcensal Estimation of Income and Poverty Characteristics for States and Counties," Proceedings of the Section on Government Statistics, American Statistical Association, pp. 154-159.

Posted by sbriske at 01:51 PM | Comments (0)

Geography Extras

PUMA to County Widget [PDQ-Explore output]
This widget takes output from PDQ-Explore and converts PUMA-based characteristics to county-based characteristics

Link

PUMA to County Widget [American FactFinder output]
This widget takes output from American FactFinder and converts PUMA-based characteristics to county-based characteristics

Link

Mable/Geocorr Correspondence Engine [2000]
This is a geographic correspondence tool or crosswalk across various 2000 geographies such as Congressional Districts, counties, places, zip codes, census tracts, block groups, voting districts, and school districts.

Link

Posted by sbriske at 12:06 PM | Comments (0)

June 21, 2010

Powerpoint Presentations and Guest Speakers

Below are links to the lectures presented at the workshop. On occasion, there were handouts associated with a presentation. These are listed under the presentation.

Monday, July 12, 2010

The Census, The American Community Survey and the Nation's Statistical System
Ren Farley, Population Studies Center
[ppt] [pdf]

Additional resources:
Congressional Efforts to Control the Census and the Census Bureau
Legal Decisions Relevant to Census Taking and Apportionment
Supreme Court cases relevant to the Census
Census Taking and Census Undercount: Prickly Statistical, Political and Constitutional Issues
Annotated Bibliography on Literature on the Census

The Development of the American Community Survey
Lisa Neidert, Population Studies Center
[ppt] [pdf]

Additional Resources
Link to American Community Survey Compass Products
ACS 2008 link on Class Blog

Understanding Census Geography
Lisa Neidert, Population Studies Center
[ppt] [pdf]

Introduction to ACS Summary Products (and American FactFinder)
Lisa Neidert
[Hands-on Exercise]

Additional Resources
An Introduction to Summary Products (and American FactFinder)
[shortened version of a Census Bureau presentation]
Presentation Notes
[shortened version of a Census Bureau presentation]

Additional Resources
Link to American Community Survey Compass Products
ACS 2008 link on Class Blog

The Supplemental Poverty Measure
[pdf] [ppt] [To be added]
Trudi Renwick, Census Bureau

Additional Resources
New Federal Poverty Measure Explained
[YouTube]
CPS Table Creator II


Tuesday, July 13, 2010

Tabular or Microdata or Both or Neither
(Tabular or Microdata) or (Both or Neither)

Introduction to PDQ-Explore
Albert Anderson, PDQ
[ppt] [pdf]

PDQ Examples & Exercises
Ren Farley and Al Anderson

[See Class Exercises (Tuesday & Wednesday) for the rest of the PDQ examples]
Link to Class Exercises

Technical Issues, Mostly Statistical
Lisa Neidert
[ppt]

Additional Resources
Margins of Error, Confidence Intervals, and Significance of Difference
Margin of Error Calculator

Making an Extract of the ACS 3-year data from IPUMS
Lisa Neidert
[ppt] [pdf]
Making an Extract from the IPUMS website

From the War on Poverty to the Great Recession: Antipoverty Policies and the Future of Poverty
Sheldon Danziger, National Poverty Center
To be posted later
[To be posted later]

Other Resources
Ren Farley, Lisa Neidert, Al Anderson
[Hands-on]
[Resource]
This is a compilation of resources that supplement this workshop. It is a work in progress.

Posted by sbriske at 10:59 AM | Comments (0)