Question: Need analysis of the data. See Data Below What are the top 5 cities for infected cases? How many infected cases does each of those
Need analysis of the data. See Data Below
What are the top 5 cities for infected cases?
How many infected cases does each of those cities have?
What else can be deduced after evaluating the chart? Are there Temporal trends: Look at the dates to see if there are any trends over time. Do certain cities have higher case numbers at certain times of the month? Any correlation with other data: Compare the case numbers to other data about the cities, such as population density, to see if there are any correlations. Any Geographical patterns: Are cities in certain regions more affected than others? This could indicate regional factors that are influencing the spread of the virus. Explain Case severity: Without data on the severity of the cases (e.g., hospitalizations, deaths), it's hard to know the full impact of the virus in each city. However, cities with higher case numbers may be experiencing more strain on their healthcare systems.
| Cases by City | ||||
| City | Date | Cases | Prevalence Rate | Population |
| New York | 4/24/2017 | 189 | 2.267 | 8,335,897 |
| Los Angeles | 4/2/2017 | 201 | 5.258 | 3,822,224 |
| Chicago | 4/27/2017 | 14 | 0.525 | 2,665,064 |
| Houston | 4/27/2017 | 272 | 11.845 | 2,296,253 |
| Philadelphia | 4/24/2017 | 5 | 0.319 | 1,567,258 |
| Phoenix | 4/2/2017 | 289 | 17.57 | 1,644,403 |
| San Antonio | 4/7/2017 | 95 | 6.57 | 1,445,662 |
| San Diego | 4/2/2017 | 258 | 7.87 | 3,276,208 |
| Dallas | 4/24/2017 | 83 | 6.386 | 1,299,553 |
| San Jose | 4/23/2017 | 109 | 11.22 | 971,265 |
| Austin | 4/17/2017 | 281 | 28.81 | 975,335 |
| Jacksonville | 4/14/2017 | 322 | 33.15 | 971,315 |
| San Francisco | 4/9/2017 | 76 | 9.4 | 808,437 |
| Indianapolis | 4/11/2017 | 7 | 0.798 | 876,564 |
| Columbus | 4/9/2017 | 14 | 0.647 | 2,161,511 |
| Fort Worth | 4/29/2017 | 98 | 10.196 | 961,160 |
| Charlotte | 4/10/2017 | 19 | 2.116 | 897,720 |
| Seattle | 4/12/2017 | 65 | 8.675 | 749,267 |
| Denver | 4/2/2017 | 30 | 4.206 | 713,252 |
| El Paso | 4/28/2017 | 29 | 4.28 | 677,469 |
| Detroit | 4/28/2017 | 35 | 5.641 | 620,410 |
| Washington D.C. | 4/3/2017 | 61 | 9.08 | 671,803 |
| Boston | 4/13/2017 | 28 | 4.309 | 649,768 |
| Memphis | 4/25/2017 | 31 | 2.329 | 1,330,954 |
| Nashville | 4/24/2017 | 23 | 1.1237 | 2,046,715 |
| Portland | 4/2/2017 | 18 | 2.833 | 635,296 |
| Oklahoma City | 4/27/2017 | 11 | 1.583 | 694,768 |
| Las Vegas | 4/27/2017 | 146 | 22.245 | 656,302 |
| Baltimore | 4/24/2017 | 26 | 4.561 | 569,931 |
| Louisville | 4/2/2017 | 17 | 1.3225 | 1,285,426 |
| Milwaukee | 4/7/2017 | 12 | 1.3225 | 563,306 |
| Albuquerque | 4/2/2017 | 51 | 9.09 | 561,006 |
| Tucson | 4/24/2017 | 114 | 20.85 | 546,598 |
| Fresno | 4/23/2017 | 187 | 34.28 | 545,564 |
| Sacramento | 4/17/2017 | 51 | 9.658 | 528,026 |
| Kansas City | 4/14/2017 | 38 | 7.461 | 509,247 |
| Long Beach | 4/9/2017 | 215 | 47.638 | 451,319 |
| Mesa | 4/11/2017 | 231 | 45.07 | 512,523 |
| Atlanta | 4/9/2017 | 220 | 44.07 | 499,121 |
| Colorado Springs | 4/29/2017 | 5 | 0.085 | 5,839,926 |
| Virginia Beach | 4/10/2017 | 4 | 0.877 | 455,618 |
| Raleigh | 4/12/2017 | 8 | 1.676 | 477,084 |
| Omaha | 4/2/2017 | 3 | 0.618 | 485,146 |
| Miami | 4/28/2017 | 299 | 11.18 | 2,673,837 |
| Oakland | 4/28/2017 | 84 | 19.51 | 430,531 |
| Minneapolis | 4/3/2017 | 9 | 2.117 | 425,104 |
| Tulsa | 4/13/2017 | 127 | 12.29 | 1,033,157 |
| Wichita | 4/25/2017 | 83 | 12.768 | 650,039 |
| New Orleans | 4/10/2017 | 248 | 67.07 | 369,749 |
| Arlington | 4/12/2017 | 11 | 4.7008 | 234,000 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
