Table 1 clearly reports the count Hispanic or Latino as a separate category from Not Hispanic or Latino by race. For that reason, I feel confident that the numbers I am reporting for those categories are accurate. However, citing the source as EEO_2006_2010 may make it appear that the data we are reporting is outdated and that we are misleading the public officials and the commission that we are presenting this to (we are not sure that we would be able to explain this in a way that they would easily understand). For that reason, we would like to use the most recently reported ACS data for 2019, but the EEO categories are not as clear. See table 2 below and the question that follows. PLEASE and THANK YOU!!!!!
TABLE 1: The EEO tabulation of ACS data EEO_2006_2010_Tables_County(050)_CSV/
TABLE 2 - ACS TABULATION FOR 2019
QUESTION: How do we report the number of people with a bachelor's degree by race and Hispanic or Latino origin without counting a person more than once?
Because there is a "White alone, not Hispanic or Latino" category, I interpret the "White alone" category are Hispanic or Latino. But if I add the educational attainment for those two categories together, the number exceeds the educational attainment for the total population. In fact, the number for each of those categories (educational attainment) exceeds that of the total population, but one might assume that has something to do with the margins of error. If I don't add them together, I need to choose one. I am inclined to chose "White alone" because the other races are reported that way -- "[Race] alone". Moving forward with that choice, I am left with the following question about the "Hispanic or Latino Origin" category. ---- Because there is a "White alone, not Hispanic or Latino" category, it would seem the number of those categorized as "White alone" (if interpreted as "White alone, Hispanic or Latino") are not included in the "Hispanic or Latino" category. But then, how do I know if a portion of the other races might also be counted in the "Hispanic or Latino Origin" category? There is no "[Race] alone, not Hispanic or Latino" category for any race except "White alone".
UPDATE! I figured it out!! Thank you!