• RE: statistical test comparing ACS 5 year data to Census 2000 data

    While I am far from an expert on this particular topic I do believe that you will find instructions in how to calculate standard deviations (and by extension margin of error) for Census 2000 SF3 statistics in statistical publications from that census…

  • 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…