Acs pums how to aggregate sample
Download
1 / 25

ACS PUMS - PowerPoint PPT Presentation


  • 472 Views
  • Updated On :

ACS PUMS – How to Aggregate Sample Anthony Tersine US Census Bureau Census Information Center Meeting October 10, 2007 ACS PUMS - Sampling 2005 PUMS is limited to housing units and household population 2006 PUMS includes housing units, household population and the group quarters population

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'ACS PUMS ' - jaden


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Acs pums how to aggregate sample l.jpg

ACS PUMS – How to Aggregate Sample

Anthony Tersine

US Census Bureau

Census Information Center Meeting

October 10, 2007


Acs pums sampling l.jpg
ACS PUMS - Sampling

  • 2005 PUMS is limited to housing units and household population

  • 2006 PUMS includes housing units, household population and the group quarters population


Multiyear pums files l.jpg
Multiyear PUMS Files

  • Two approaches – both combine single year files

    • Adjust estimates at the end

    • Adjust weights at the beginning


Method 1 l.jpg
Method 1

  • Concatenate single year files

  • Adjust dollar amounts for inflation

    • Express prior year dollars in terms of latest year dollars


Adjust dollar amounts 1 l.jpg
Adjust Dollar Amounts – 1

  • First apply “ADJUST” variable within year

  • Apply the CPI-U-RS adjustment factors from BLS

  • http://www.bls.gov/cpi/cpiurs1978_2006.pdf


Adjust dollar amounts 2 l.jpg
Adjust Dollar Amounts – 2

  • Express year 2005 dollars in terms of 2006 dollars

  • Values from the CPI-U-RS table for 2005 (286.7) and 2006 (296.1)

  • Multiply the 2005 dollars by 296.1/286.7 = 1.03279


Adjust dollar amounts example l.jpg
Adjust Dollar Amounts – Example

  • 2005-2006 person income in 2006 $

  • 2005 person record

    PINC * (ADJUST / 1000000) * 1.03279

  • 2006 person record

    PINC * (ADJUST / 1000000)

  • ADJUST – different values


Method 1 tabulations l.jpg
Method 1 –Tabulations

  • Use combined file as a single-year file

  • Adjust estimates based on number of years (M) combining

  • Create counts, means, medians, etc.

    • Create separate estimates for HU and GQ persons

  • Standard Errors

    • Replicate weights

    • Generalized variances


Method 1 counts aggregates l.jpg
Method 1 – Counts / Aggregates

  • All years have GQs or only interested in HU or household pop


Method 1 counts aggregates10 l.jpg
Method 1 – Counts / Aggregates

  • Counts or aggregates - replicates

  • Counts only - generalized


Method 1 counts aggregates11 l.jpg
Method 1 – Counts / Aggregates

  • Some (but not all) years have GQs

    • M is total number of years

    • N is the number of years with GQ data


Method 1 counts aggregates12 l.jpg
Method 1 – Counts / Aggregates

  • Counts or aggregates – replicates

  • Counts – generalized


Method 1 counts example l.jpg
Method 1 – Counts Example

State of Delaware


Method 1 ratios l.jpg
Method 1 – Ratios

  • All years have GQs or only interested in HU or household pop


Method 1 ratios15 l.jpg
Method 1 – Ratios

  • Replicates

  • Proportion/percents only - generalized


Method 1 ratios16 l.jpg
Method 1 – Ratios

  • Some (but not all) years have GQs

    • M is total number of years

    • N is the number of years with GQ data


Method 1 ratios17 l.jpg
Method 1 – Ratios

  • Replicates

  • Proportion/percents only - generalized


Method 1 medians l.jpg
Method 1 – Medians

  • All years have GQs or only interested in HU or household pop

  • Normal median (X) on the combined data

  • Categorical median (Interpolated)


Method 1 medians19 l.jpg
Method 1 – Medians

  • Replicates

  • Generalized – Can be done


Method 1 medians20 l.jpg
Method 1 – Medians

  • Some (but not all) years have GQs

  • Use method 2


Method 2 l.jpg
Method 2

  • Concatenate single year files

  • Adjust weights

  • Adjust dollar amounts for inflation

    • Same approach as method 1


Adjust weights l.jpg
Adjust Weights

  • Adjustment factor is the number of years being combined

  • Divide by the factor


Adjust weights example 1 l.jpg
Adjust Weights – Example 1

  • 2005-2006 Estimate (PWGTP)

  • 2005 HU person - weight 50 becomes 25

  • 2006 HU person - weight 75 becomes 37.5

  • 2006 GQ person - weight 60 will stay 60


Adjust weights example 2 l.jpg
Adjust Weights – Example 2

  • 2005-2007 Estimate (PWGTP)

  • 2005 HU person - weight 67 becomes 22.333333

  • 2006 HU person - weight 50 becomes 16.666667

  • 2007 HU person - weight 75 becomes 25

  • 2006 GQ person - weight 60 becomes 30

  • 2007 GQ person - weight 55 becomes 27.5


Contact information l.jpg
Contact Information

Anthony.G.Tersine.Jr@census.gov

Alfredo.Navarro@census.gov


ad