Informatics Data Analysis PowerPoint Presentation with Speaker Notes

7

HIGH RISK AREAS WORD REPORT ASSIGNMENT

Jason Parkhill

University of Phoenix

MHA/507

3/29/2021

Rea Burleson

Figure showing the Smallest to Largest values Custom sort settings in Excel Worksheet.

Figure showing the Pivot Chart Fields for the Excel Data.

Figure showing the Pivot Chart illustration for February Cases.

Figure showing March cases in pictorial view using Pivot Chart.

Figure showing the February March and April cases using the Pivot Chart.

The Pivot Chart indicates that

.

Figure showing the sorting criteria for the Low infection rates.

The OR conditions selects the cities where the February cases are lower than 19, March Cases less than 78 and April Cases lower than 84. These values come from the descriptive statistical values given by the three months i.e., February, March and April.

Figure showing the sorting Criteria for the High Infection rates

The sorting criteria for the high values such that it uses the values above the mean 10 for February. Above 35 for March and above 95 cases for April. Note that these values originate from the descriptive statistics obtained through the Excel Data Analysis. For instance, the mean for February cases is 10.9411 with standard error of ±1 while that for March is 41±6 making 35 an ideal option for classifying the Highest cases. Results from these values ranks Jacksonville as the riskiest city in April, New Orleans in March and Austin in April.

City	Feb. Cases	March Cases	April Cases
New York	19	56	189
Los Angeles	6	12	201
Houston	19	19	272
San Diego	3	38	258
San Jose	10	23	109
Austin	28	59	281
Jacksonville	10	97	322
Fort Worth	8	26	98
Las Vegas	1	22	146
Tucson	2	9	114
Fresno	13	45	187
Long Beach	13	19	215
Mesa	2	35	231
Atlanta	11	35	220
Miami	21	72	299
Tulsa	8	43	127
New Orleans	12	101	248

Table showing the Cities with the most and least cases where the green color denotes the low rates and Red the high infection rates.

	High Risk	Low Risk
Cities	Jacksonville Austin Miami New Orleans Mesa Long Beach	Los Angeles San Jose Fort Worth Las Vegas Tucson New York

The same technique illustrated above works with government agencies such as the Center of Disease control in determining the cases caused by variants that includes a U.S map with the various confirmed cases in the country. Additionally, in other specific statistical analysis like the cases by countries, deaths and currently the vaccinations for the COVID-19 (Center of Disease Control and Prevention, 2021). In current statistical analysis for instance in estimating the level of cumulative incident based on individual age groups, it uses the estimates and age groups information with the symptomatic illnesses and hospitalizations. This information goes further by expressing their individual place of residence which helps in disease control and management (Wu and McGoogan, 2020).

REFERENCES

Center of Disease Control and Prevention. (2021). Estimated Disease Burden of COVID-19. Accessed on 27th March 2021. Retrieved from Estimated Disease Burden of COVID-19 | CDC

Wu, Z., & McGoogan, J. M. (2020). Characteristics of and important lessons from the coronavirus disease 2019 (COVID-19) outbreak in China: summary of a report of 72 314 cases from the Chinese Center for Disease Control and Prevention. Jama, 323(13), 1239-1242.

APRIL CASES

Sum of April Cases Albuquerque Arlington Baltimore Boston Charlotte Chicago Colorado Springs Columbus Dallas Denver Detroit El Paso Indianapolis Kansas City Louisville Memphis Milwaukee Minneapolis Nashville Oakland Oklahoma City Omaha Philadelphia Portland Raleigh Sacramento San Francisco Seattle Virginia Beach Washington D.C. Wichita 51 11 26 28 19 14 5 14 83 30 35 29 7 38 17 31 12 9 23 84 11 3 5 18 8 51 76 65 4 61 83 Sum of March Cases Albuquerque Arlington Baltimore Boston Charlotte Chicago Colorado Springs Columbus Dallas Denver Detroit El Paso Indianapolis Kansas City Louisville Memphis Milwaukee Minneapolis Nashville Oakland Oklahoma City Omaha Philadelphia Portland Raleigh Sacramento San Francisco Seattle Virginia Beach Washington D.C. Wichita 15 2 8 2 2 3 0 5 13 11 14 4 2 13 15 7 3 3 4 15 1 0 1 6 2 9 13 10 0 18 12 Sum of Feb. Cases Albuquerque Arlington Baltimore Boston Charlotte Chicago Colorado Springs Columbus Dallas Denver Detroit El Paso Indianapolis Kansas City Louisville Memphis Milwaukee Minneapolis Nashville Oakland Oklahoma City Omaha Philadelphia Portland Raleigh Sacramento San Francisco Seattle Virginia Beach Washington D.C. Wichita 2 1 1 1 1 0 0 1 4 2 4 3 0 3 2 2 1 1 1 3 1 0 0 1 0 2 2 1 0 2 1

FEB CASES

Total Albuquerque Arlington Atlanta Austin Baltimore Boston Charlotte Chicago Colorado Springs Columbus Dallas Denver Detroit El Paso Fort Worth Fresno Houston Indianapolis Jacksonville Kansas City Las Vegas Long Beach Los Angeles Louisville Memphis Mesa Miami Milwaukee Minneapolis Nashville New Orleans New York Oakland Oklahoma City Omaha Philadelphia Phoenix Portland Raleigh Sacramento San Antonio San Diego San Francisco San Jose Seattle Tucson Tulsa Virginia Beach Washington D.C. Wichita 2 1 11 28 1 1 1 0 0 1 4 2 4 3 8 13 19 0 10 3 1 13 6 2 2 2 21 1 1 1 12 19 3 1 0 0 23 1 0 2 6 3 2 10 1 2 8 0 2 1

MARCH CASES

Total Albuquerque Arlington Atlanta Austin Baltimore Boston Charlotte Chicago Colorado Springs Columbus Dallas Denver Detroit El Paso Fort Worth Fresno Houston Indianapolis Jacksonville Kansas City Las Vegas Long Beach Los Angeles Louisville Memphis Mesa Miami Milwaukee Minneapolis Nashville New Orleans New York Oakland Oklahoma City Omaha Philadelphia Phoenix Portland Raleigh Sacramento San Antonio San Diego San Francisco San Jose Seattle Tucson Tulsa Virginia Beach Washington D.C. Wichita 15 2 35 59 8 2 2 3 0 5 13 11 14 4 26 45 19 2 97 13 22 19 12 15 7 35 72 3 3 4 101 56 15 1 0 1 78 6 2 9 9 38 13 23 10 9 43 0 18 12