Used formulas in Excel to analyze the number of Mississippi Projects located in Persistent Poverty Counties.
Downloaded data on Mississippi Projects receiving low income housing tax credit which included physical addresses but not counties. Then downloaded data on Persistent Poverty Counties. Finally found data on Mississippi zip codes for each county. Used Vlookup to identify counties for each project. Then used IFNA to determine which project counties were on the Persistent Poverty County list.
Finally returned the number of Mississippi Projects located in Persistent Poverty Counties.