Data is not aligning properly

[Ivan_Strahof]

raceeth is a variable created by another user in the online analysis tool that uses responses from RACE and HISPAN; it codes respondents of any race who reported being Hispanic into a Latino category. For example, someone who identified as Black and Hispanic will be coded as Latino and will not be included in the non-Hispanic Black category. Using this variable in combination with POVERTY and STATEFIP in the online analysis tool (see screenshot below), I’m finding that non-hispanic Blacks form 9.4% of the proportion of individuals under 125% of poverty in Iowa. This corresponds to 43,548 individuals from a total of 114,523, or around 38% of the total non-hispanic Black population of Iowa. This is within the margin of error of the official Census ACS data table which reports that 38.4% (with a 2.3% margin of error) of the state population that identifies as only Black or African American earns less than 125% of the poverty line. I recommend reviewing the variable description for POVERTY to note how it is constructed to determine if it’s comparable to the data your organization collected.