ACS Data Users Group

 View Only

  • 1.  Is there a Data Profile (DP) table to Base (B) table correspondence / crosswalk somewhere?

    Posted 03-30-2020 01:37 AM

    I am trying to figure out which Base Table the "average family size" variable (DP02_0016E) is coming from. Does anyone know?

    I am able to find the "average household size," and lots of other variables in DP tables in B tables, but not this one!

    Thanks,

    Diana



  • 2.  RE: Is there a Data Profile (DP) table to Base (B) table correspondence / crosswalk somewhere?

    Posted 03-30-2020 10:04 AM
    I don't think "average family size" exists in a B (or C) table. The closest I can find is B11016 HOUSEHOLD TYPE BY HOUSEHOLD SIZE (which has family and non-family households) that you could use to infer a minimum average household size using the top-coded 7+ category. But... no stand-alone average.


  • 3.  RE: Is there a Data Profile (DP) table to Base (B) table correspondence / crosswalk somewhere?

    Posted 03-30-2020 02:21 PM
    Thanks, Beth.

    Up until now I thought that all information in the DP tables could be constructed from a B or C table. I guess that's not really the case if this variable (DP02_0016E) is not available in the detailed tables. Just when I thought I knew the intricacies of the summary tables, I still learn something new!


  • 4.  RE: Is there a Data Profile (DP) table to Base (B) table correspondence / crosswalk somewhere?

    Posted 04-02-2020 03:27 PM
    Hi Diana,
    It looks like you can calculate average family size from Table B09019. I was able to match the national average (3.24) using this formula:
    Numerator = Row 3 (Population in family households) - Row 18 (nonrelatives in family households) = 256,766,398
    Denominator = Row 4 (Householders in family households) = 79,241,578

    This is a bit clunky though- there may be a simpler way to do this.
    -Mark