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.
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.