DataHWApril11_FL_COMBINED2withRATIO
Identify the counties and the rates of all counties with poverty rates greater than 25%
Madison, 4211 people below the poverty line, 25.31%
Gadsden, 11054 people below the poverty line, 25.15%
Formula Used
select geography, Native_BelowP, pov_ratio_native
from FL_COMBINED2
order by pov_ratio_native DESC ;
Identify the TOP 10 counties with the highest non-citizen population by ratio
- Dade, 623639 pop, 23.63% population
- Hendry, 6918, 18.03%
- Broward, 259116, 14.05%
- Collier, 47525, 13.93%
- DeSoto, 4798, 13.93%
- Hardee, 3688, 13.42%
- Palm Beach, 163897, 11.88%
- Orange, 123757, 10.06%
- Glades, 1283, 9.66%
- Osceola, 29015, 9.64%
Formula Used
select geography, noncitizen, pop_ratio_noncitizen
from FL_COMBINED2
order by pop_ratio_noncitizen DESC ;
Identify the TOP 10 counties with the highest US poverty by ratio.
- Hamilton, 3099, 28.06%
- Putnam, 19506, 27.39%
- Holmes, 4649, 26.36%
- Madison, 4211, 25.31%
- Gadsden, 11054, 25.15%
- Okeechobee, 8408, 23.41%
- DeSoto, 7677, 23.24%
- Hardee, 5783, 22.55%
- Suwannee, 9264, 22.11%
- Gilchrist, 3440, 21.84%
Formula Used
select geography, Native_BelowP, pov_ratio_native
from FL_COMBINED2
order by pov_ratio_native DESC ;
The first answer is not correct. Answers to the homework are posted here:
https://wordpressua.uark.edu/datareporting/april-6-class/
I have two ways to figuring out the first answer:
//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
–Identify the counties and the rates of all counties with US poverty rates greater than 25%
SELECT Geography, USPOVERTY_Ratio
FROM FL_POV_IMM
WHERE USPOVERTY_RATIO > 25
Order By USPoverty_Ratio DESC ;
Hamilton County with 28.1%, Putnam County with 27.4%, Holmes County with 26.4%, Madison County with 25.3%, and Gadsden County with 25.2%
The two other questions were correct and the format was great.