• U.S. Census Bureau Releases 2019-2023 ACS 5-Year PUMS Files and Variance Replicate Estimate Tables

    2019-2023 ACS 5-Year Public Use Microdata Sample (PUMS)

    We are pleased to announce the release of the 2019-2023 American Community Survey (ACS) 5-year Public Use Microdata Sample (PUMS) files.

    The ACS 5-year PUMS files show the full range of population…

  • RE: Summarizing 5 year PUMS data

    It sounds like you are trying to compare results from a summary of PUMS data to summary file data. Without more information on the specific topic/table you are trying to replicate, I can only provide general comments. Hopefully they help. For questions…

  • MOE for Migration Data

    Hello,

    I am a bit confused on the county-county migration MOE's, specifically for the geographical mobility estimates for each county. The documentation just says this:

    "the files also contain additional geographical mobility estimates for each county…

  • Clean data downloads?

    I'm a non-profit researcher and policy analyst and I feel like I'm constantly banging my head against a wall to download ACS data in a usable format. I have decent statistical analysis and data analysis chops but I am not a coder.

    For example…

  • RE: Vacancy in ACS vs Decennial

    Thanks, Kathy, that's helpful. And Cliff, that is fascinating. According to ACS, vacancy increased by 67.03% in Cambridge from 2008-2012 to 2013-2017. I'm still concerned about the margins of error with that data, though.
  • RE: Statistical testing tool question

    I think you leave out the +/- sign. As far as I know, the math equation the tool uses is:
    absolute value of estimate1 - estimate 2 / square root of MOE1^2 + MOE2^2
    Since the margins of error are squared in the equation, whether or not there's a plus…
  • RE: variance estimates for 2020 ACS PUMS

    Thanks Alicia.  I had read that readme doc but I was looking for more detailed explanations.  One of the Census research paper explains a bit better why the reduced variance estimates are an essential byproduct of entrophy-balanced weights (See page 33…

  • RE: Extracting demographic details in a single file from US census website

    To follow up on Beth's posting, (I don't think that this solution will be very satisfying but ) I use R and the API to combine across tables and geos. I wrote an R function(s) to do weighted sums, products and ratios across geos and table categories …

  • 1 vs 5 year estimates regarding annual difference in median income

    We are trying to calculate the difference in median annual income at the county level between those who are high school graduates vs. those who are less than high school graduates.  There are both 1 year and 5 year estimates from the ACS available.  The…