Groupweek6

Running head: Report III 1

Report III 8

Report III

From the previous reports, we used the total number of infected people in the major cities and categorized the individual into age groups varying from the age of under 18 to the individuals of age sixty and over. The people of age below 18 and the people age 60 and over got infected from the data collected. Whereas, the majority of the people aged between 19-30 years seem to be least infected.

Gathered Data

In this section of the report, we will be using the data gathered from the excel sheets to produce 3D maps to demonstrate which regions are highly contagious and which regions have a lower level risk to the disease. The level of the risk and the cities are all seen from the 3D maps generated in excel. It is imperative to derive these results because depending upon the risk of getting the disease, the precautions and the lockdown procedures will get implemented strictly to ensure the disease does not spread further (Patel et al., 2020). The figure below shows the 3D map of the infected cities.

Figure 1: Infected Cities

For the results of the report, we will be using the data collected from five major cities, which have a considerable contribution to the percentage of infected individuals. The table below shows the infected cases from each of the five major cities during February, March, and April.

City	Number of cases
Jacksonville	429
Miami	392
Phoenix	390
Austin	368
Houston	310

Table 1: Infected cases in 5 major cities

Besides these five significant cities, New Orleans is another region with a high risk of infection, having a total number of 361 cases in the recorded months. Other than that, the regions of moderate infection risks shown in the table below. Following that, table 3 shows the regions with a slight risk of infection with having less than 50 cases in the past three months.

City	Number of cases
New York	264
Los Angeles	219
San Antonio	110
San Diego	299
San Jose	142
Fort Worth	132
Las Vegas	169
Tucson	125
Fresno	245
Long Beach	247
Mesa	268
Atlanta	266
Oakland	102
Tulsa	178

Table 2: Cities with moderate risk

City	Number of cases
Philadelphia	17
Indianapolis	6
Columbus	9
Charlotte	20
Denver	22
El Paso	43
Boston	36
Memphis	31
Nashville	40
Portland	28
Oklahoma City	25
Baltimore	13
Louisville	35
Milwaukee	34
Colorado Springs	16
Virginia Beach	5
Raleigh	4
Omaha	10
Minneapolis	3
Arlington	13

Table 3: Cities with Low Risk

Conclusion

From the 3D map generated and the data analyzed from the cases recorded in the cities during the past months of February, March, and April we see that a few cities are having a very high risk of infection having more than 300 cases among which all the major cities like, Miami, Jacksonville, Phoenix, Austin, and New Orleans get included. We can also derive from the results that the precaution to contaminate the disease is not getting followed strictly. On the other side, we see several cities having cases less than 50 in the past month, which include Minneapolis with the least cases, just three. Then there are other cities like Columbus and Boston, with very few patients less than 40 in the past three months. This data shows that the regions with less infection risk are correctly following the precaution measures, and they are correctly applying social distancing measures (Khan, 2020).