Above is my joined file of both the FL spreadsheets. It also includes the additional ratios.
–Identify the counties and the rates of all counties with poverty rates greater than 25%
DeSoto County (29%), Putnam County (28%), Gadsden County (26%), Hardee County (26%), Okeechobee County (25%), Hendry County (25%),
–Identify the TOP 10 counties with the highest non-citizen population by ratio
Miami-Dade County, Hendry County, Broward County, Collier County, DeSoto County, Hardee County, Palm Beach County, Orange County, Glades County, Osceola County
–Identify the TOP 10 counties with the highest US poverty by ratio.
I took this to mean the ratio the ratio of US born poverty ratio. The following is what I found
Baker County, Washington County, Bradford County, Gulf County, Madison County, Wakulla County, Franklin County, Dixie County, Taylor County, Jefferson County
Bonus Question:
–Construct a formula that determines which counties would match from the two top 10 lists of highest non-citizen by ratio and highest US poverty by ratio.
First question: //NOTE: I wrote the first question with US Poverty rates in mind. Some of you answered with a TOTAL POVERTY RATIO, which is accurate //
–Identify the counties and the rates of all counties with poverty rates greater than 25%
SELECT Geography, TOTALPOVERTY_Ratio
FROM FL_POV_IMM2
WHERE TOTALPOVERTY_RATIO > 25
Order By TOTALPoverty_Ratio DESC ;
Answer:
DeSoto County, 30.6
Hamilton County, 29.3
Putnam County, 28.7
Holmes County, 27.8
Okeechobee County, 27.7
Hardee County, 27.4
Gadsden County, 27.1
Hendry County, 26.4
Madison County, 25.7
I needed to see the data for the questions 2 and 3.
answers to the homework are posted here:
https://wordpressua.uark.edu/datareporting/april-6-class/