• RE: Educational attainment by race/ethnicity and county - can't get totals and subtotals to match

    Using the PUMS data which allow me to get data for planning districts on attainment by race, Spanish/Hispanic/Latino, and gender for all ages, I see what I was getting wrong.   In the regular tables for educational attainment age 25+, I can get match the…

  • Educational attainment data VS CPS ASEC

    Hi everyone!

    Has anybody looked into this apparent statistically significant difference between the two surveys on educational attainment data?

    2020 CPS counts a total of 113381 thousand 18+ civilian noninstitutionalized population with at least an associates…

  • RE: home care clients to caregivers ratio

    Dear Gwen,

    Can you give a little more context/reference?  The only ACS question that I can think of that might be related to having a caregiver is about "self-care."  There are some questions about grandparents caring for grandchildren but I don…

  • RE: Derived MOE for Percents when the value is 0 inside the square root

    Great! Thank you so much for sharing that link, that is very helpful. I'm used to using variance replicate weights with PUMS data but have yet to try it for summary tables.

    Do you know if this can be done with a subject table, when the variance replicate…

  • ACS 1 Year Microdata Question

    Hi,

    I am a total novice using MDAT. However, for a research project I am trying to download a CSV of a custom table I've built with several recoded variables with a given state as my selected geography.

    I'm haven't been able to download a CSV that has…

  • tidycensus error + SQL pseduocode

    Hello!  First time poster, so please be gentle.  I'm relatively new to unaggregated Census data, although have a solid knowledge of R, statistics, and (if dated) survey methods.

    I have spend a few hours over the long weekend trying to familiarize myself…

  • RE: PAP measure

    In PUMS, food stamps/SNAP participation is captured in the FS variable, and Medicaid/CHIP is recorded in HINS4.
    PAP reflects TANF/welfare.
    For details on each concept, see the Subject Definitions document at www2.census.gov/.../2016_ACSSubjectDefinitions…
  • 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…

  • RE: Separating Renters and Homeowners in Low Income Household Measurements

    Hi Alex,

    Are you working with the PUMS files? If so, you can merge the population file with the housing units file using the serial number (actual variable is called "serialno") and then there's a variable for tenure called "ten" in the PUMS housing…
  • Property Tax Topcodes

    Hi all,

    I am working on cross-state differences in property taxes in 2015.

    If I understand the data dictionary correctly, the ACS variable TAXAMT (PROPTX99 in IPUMS) is topcoded in all states and years at 10,000 USD (category value 68). 

    For states with high…