MHA 507 University Of Phoenix Infected Cases In United States Report

Now that we know where the outbreaks are located, your organization wants to know more about who it affects. The age of the patient will determine what kind of resources will be needed in those areas.(See Prevouse Paper attached)

Create a side-by-side bar graph using Microsoft Excel® and the data provided in the Ages Impacted (See Attached document) to identify the age groups affected by the virus.

Note: This information will be used for further analysis in future assignments.

Write a 350- to 525-word report of an analysis of the data. Include an answer to the following questions:

• Which age groups are most affected?
• Which age groups are least affected?
• What is the prevalence rate per age demographic?
• What else can be deduced after evaluating the chart?

Include your side-by-side bar graph in the report.Please cite where the informations from.

Leveraging Informatics in the Health Sector

What are the top five cities for infected cases?

According to the provided data and the bar graph output, the five most infectious cities with leading virus cases are Jacksonville, Miami, Phoenix, Austin, and Houston. The virus infection rate in these cities follows in their respective order, with Jacksonville topping the chart. 

How many infected cases does each of those cities have?

In the five US cities topping the infection chart with the dangerous virus, Jacksonville recorded the highest number of 322 cases, and it was the only city that went beyond the 300 level. It was followed by Miami that indicated 299 cases, which was still higher since it was closer to 300. Phoenix and Austin followed with their plights holding at 289 and 281, respectively. However, Houston had the lowest cases in the top-five category since it did not attain the 280 level, with the city’s infections being 272. 

What is the prevalence rate per 100,000 people?

In calculating the prevalence rate, we consider the total number of infections in all fifty cities. The figure is then divided by 100,000, and multiplied by 100.

The Prevalence Rate = (total infection cases/ 100,000) * 100.

From the excel calculations, the total number of infection plights in all fifty cities is 4,852 cases.

Therefore, 

The Prevalence Rate = (4,852/ 100,000) * 100

= 4.852%.

It implies that the dangerous virus is spreading at the rate of 4.852% among 100,000 people in all the identified US cities.

Since the total cases in five leading cities is 1,363, we can also calculate their prevalence rate per 100,000 people as shown below;

The Prevalence Rate = (1,363/ 100,000) * 100

                                                                            = 1.363%.

The result indicates that the dangerous virus is spreading at the rate of 1.363% among 100,000 people in the five cities topping the infection chart.

What else can be deduced after evaluating the chart?

From the bar chart, it is possible to have various observations. Given the total number of cities involved, the chart depicts outlier cases. Some few cities fall on the extreme ends. For example, the ones identified above recorded higher infection cases as opposed to most that have moderate levels, while another fraction also has very minimal cases. It implies that the country does not suffer evenly from the dangerous virus; some suffer a lot, while the rest seem to have taken precautionary measures, and they have the issue at bay. In summary, most cities have controlled the prevalence since they either indicate moderate or smaller virus cases, as opposed to a few that that recorded figures beyond 200.

City Date Cases <18  19-30 31-60 61+ New York 4/24/2017 189 68 15 34 72 Los Angeles 4/2/2017 201 64 16 56 65 Chicago 4/27/2017 14 4 1 3 6 Houston 4/27/2017 272 98 16 52 106 Philadelphia 4/24/2017 5 2 0 1 2 Phoenix 4/2/2017 289 145 20 32 92 San Antonio 4/7/2017 95 46 6 12 31 San Diego 4/2/2017 258 114 15 34 95 Dallas 4/24/2017 83 42 8 12 21 San Jose 4/23/2017 109 49 9 17 31 Austin 4/17/2017 281 151 12 39 79 Jacksonville 4/14/2017 322 93 19 61 149 San Francisco 4/9/2017 76 27 5 25 19 Indianapolis 4/11/2017 7 3 0 1 3 Columbus 4/9/2017 14 7 1 2 4 Fort Worth 4/29/2017 98 47 7 12 32 Charlotte 4/10/2017 19 11 1 2 5 Seattle 4/12/2017 65 36 7 10 12 Denver 4/2/2017 30 16 2 1 11 El Paso 4/28/2017 29 14 2 5 8 Detroit 4/28/2017 35 10 2 7 16 Washington D.C. 4/3/2017 61 22 4 12 23 Boston 4/13/2017 28 10 1 4 13 Memphis 4/25/2017 31 16 2 5 12 Nashville 4/24/2017 23 11 2 2 8 Portland 4/2/2017 18 8 1 2 7 Oklahoma City 4/27/2017 11 6 1 2 2 Las Vegas 4/27/2017 146 59 12 37 41 Baltimore 4/24/2017 26 15 2 2 7 Louisville 4/2/2017 17 5 1 3 8 Milwaukee 4/7/2017 12 4 1 2 5 Albuquerque 4/2/2017 51 19 3 7 22 Tucson 4/24/2017 114 51 8 19 36 Fresno 4/23/2017 187 93 13 19 62 Sacramento 4/17/2017 51 22 3 7 9 Kansas City 4/14/2017 38 19 4 6 9 Long Beach 4/9/2017 215 76 17 40 82 Mesa 4/11/2017 231 129 12 25 65 Atlanta 4/9/2017 220 63 13 42 102 Colorado Springs 4/29/2017 5 2 0 1 2 Virginia Beach 4/10/2017 4 1 0 1 2 Raleigh 4/12/2017 8 4 1 1 2 Omaha 4/2/2017 3 1 0 0 2 Miami 4/28/2017 299 170 18 30 81 Oakland 4/28/2017 84 42 8 18 16 Minneapolis 4/3/2017 9 6 1 1 3 Tulsa 4/13/2017 127 71 10 32 118 Wichita 4/25/2017 83 24 5 22 32 New Orleans 4/10/2017 248 89 15 47 97 Arlington 4/12/2017 11 4 1 2 4