• Calculating a median

    Hi All,

    Occasionally I need a median income or median age value for either an aggregated area or for a population that only has the data available in a distribution table (like in attached screenshot). I created a VBA macro that will run in Excel and calculate…

  • Age Distribution of Non-Hispanic African American/Black

    Hello

    How can I have the detailed age distribution of non-Hispanic African Americans (at all geo levels) using the ACS data.

    My understanding is that B01001B are for all blacks regardless of their ethnicity.

    Thank you for any advice!

    Li Jiao

  • Tables S2701 and S2702

    I am looking at the 1-year estimates for these tables and cannot figure out why some states are suppressed in S2702 and not in S2701? 

  • 2018 ACS 5-Year Estimate Tables question

    Is it possible to differentiate the institutionalized population from the non-institutionalized population via the 2018 ACS 5-Year Estimate Tables (filtered by geography -> 860: 5 Digit ZCTA)? i.e. Are there any specific reports that combine both institutionalized…

  • Poverty in S0201 vs B17001

    Looking for clarification on the difference between the poverty estimates provided in tables S0201 and B17001, specifically for adults ages 65+.  Calculating by summing across sex and ages within B17001 yields pretty different estimates compared with the…

  • ACS Table for Severe Housing Burden

    There are a variety of tables similar to "PERCENT OF RENTER-OCCUPIED UNITS SPENDING 30 PERCENT OR MORE OF HOUSEHOLD INCOME ON RENT AND UTILITIES", but is anyone aware of a table to includes spending of 50 percent or more of household income in rent…

  • Health Insurance Table Changes

    First off, thanks to the ACS folks for releasing today's documentation on next week's ACS release; it's very helpful to have this information in advance.

    I wanted to bring people's attention to changes to tables on health insurance by age…

  • Question about table B09008: Presence of Unmarried Partner by Household Type for Population Under 18 Years in Households

    I'm trying to wrap my head around the cases that would be in lines 6 and 12 of Table B09008 (children in nonfamily households).  At first I thought this was possibly 16- or 17-year-olds living with their boyfriend/girlfriend/spouse, but then the universe…

  • Where are definitions of "private" and "public" schools for table B14002? (How are charter schools and homeschooling captured?)

    Hello, 

    Does anyone know where I can find additional documentation on some definitions for the school enrollment (B14XXX) tables?  Specifically, what is included in public vs. private, e.g., charter schools and homeschooling.  From the questionnaires  it seems…