I’m trying to figure out the amount of language speakers (limited english proficiency, spanish chinese vietnamese arabic german ext) under 125 % of poverty in Iowa. I am using excel, but the numbers I am getting are very low. I am using 2015 ACS, 2015 5 YR ACS, and 2014 5yr ACS. Variables I used are poverty, language, and statefip (19 for Iowa). Anything I could be doing wrong to get these low numbers.
Ex - 4,610 Iowas in poverty 2014 Chinese speakers (this is from the last year’s report)