I'm trying to understand this table better.
Take for example Cass County, MO which has a population count at just at 100,000. We have extrapolated a number of datasets to arrive at an available workforce defined as 18 to 64, have a HS / GED, removed those w/a Grad School education or higher to arrive at a population count of 40,806 for this county.
There are 28,283 families in this county, 12,466 with both spouses in the workforce and Other Families containing single parent home of 5,464.
I am providing the above numbers as a point of reference for my question. The 37,945 total doesn't seem out of line for what is being reported, but I guess I'm just needing to ensure I understand what these numbers are saying. They just seem to be out of balance with the above referenced numbers.
Can anyone provide insight on this? Thank you.
In reply to Patty Becker:
In reply to KC_Researcher:
In reply to Stas Kolenikov:
So, I don't see the ability to upload a saved query. Here is a link to the table I'm most interested in understanding. ACS Table B08201- 2017
As you know the query doesn't save the geography being studied. I'm looking at a total of 8 counties, but the same question applies to all of these counties. The county referenced above is Cass County, Missouri.
Well, I finally figured this table out. The top grouping is a summary for the 1, 2, 3, and 4 person households. What's weird about what they did is if you look at the cells I highlighted in pink roll up to the # highlighted in yellow. The same follows suit for the other categories. And, the top # is the # of households for this county. It would be nice if they would identify the fields a little better but I now understand what they are doing with this table.