• RE: Statistically comparing estimates

    Here is the response I got from the Census Bureau directly.  Just some food for thought!

    "You are correct that the poverty rate for Cook county is not independent from Illinois.  Depending on what they are using…

  • RE: Zip Code Population by County

    Geocorr works by reducing both source and target geographies into collections of blocks -- the "atoms", if you will. We know the population of every block. So we can take all the blocks that are in ZCTA 21771 (say) and add up the populations of all those…

  • Households by type difference between DHC and ACS

    We were asked to create a timeline of the local number of households with children by household type. We extracted data from past Censuses, Census 2020 and recent 1-year ACS. We noticed some differences between the ACS and the DHC counts that seemed to…

  • RE: census block group has zero occupied housing units but positive population

    They have set up a separate GQ Count Review for the 2020.  Apparently some of the GQs were put in nearby wrong blocks.  One of the problems, however, is that Differential Privacy was applied to the Block Groups, so in NY State after the prisoner relocations…

  • How to read the ACS data into SAS?

    Greetings! How to read the data from Table DP05 of the 2019 American Community Survey (ACS) 5-year estimates into SAS? When I deleted the second row on variable definition and read it into SAS, errors came (copied below). When I read all lines starting…

  • RE: which questions used to create which tables

    Hi Gene,

    If you look in the Subject Definitions file found here:
    www2.census.gov/.../2015_ACSSubjectDefinitions.pdf

    On page 73 it defines hispanic or latino origin and provides quite a bit of detail about how the data are derived. Also, it gives you…
  • RE: Proposed changes to the ACS Summary File format

    As a longtime ACS Summary File user, this is a huge, and welcome change. Perhaps the best improvement is having column headers in the data files. This not only reduces the complexity in using the files, but it lessens the possibility of errors.

    One request…

  • Calculating a Median From a Weighted Distribution

    I'm reading through the PDF "Understanding and Using American Community Survey Data - What State and Local Government Users Need to Know" and need help recreating the calculation for the median salary in Case Study #1 as shown in Figure 3.8…

  • EEO tabulation vs. ACS tabulation for Race & Ethnicity - Educational Attainment

    Table 1 clearly reports the count Hispanic or Latino as a separate category from Not Hispanic or Latino by race. For that reason, I feel confident that the numbers I am reporting for those categories are accurate. However, citing the source as EEO_2006_2010…

  • Design Factor for Poverty Status

    Hi, 

     

    I'm looking to cross tabulate a few different variables with a dichotomous poverty variable (below threshold or not) in the 1-year PUMS.  I derived the poverty status variable by recoding the income to poverty ratio.  Unfortunately the statistical…