Read the following scenario:
Now that you know where the outbreaks are located and which age groups are most affected, your organization wants to map out the areas that pose the highest exposure risk.
Create a symbols map using Microsoft® Excel® and the data provided in the High-Risk Areas document to determine the areas of the country with the most risk.
Review the “Plotting Data onto a Map in Microsoft® Excel® PDF document for instructions on completing this portion of the assignment.
Write a 350- to 525-word report of your analysis of the data.
Include an answer to the following questions:
· Which cities (states) are high risk and low risk?
· What areas of the country are high risk and low risk?
· What else can be deduced after evaluating the chart?
Include your map within the report, not separately. Label as a Figure according to APA formatting. Also, include title and reference pages.
Cite at least 2 scholarly references to support your assignment. Feel free to use supplemental readings as references, if from peer-reviewed journals. DO NOT use “.com” commercial, “.edu” education, “.org” or “.net” proprietary sources. Okay to use one .gov reference, such as CDC or NIH
Format your citations according to APA guidelines.
Report I
This paper was published based on the statistical analysis of the infected cases observed in the major cities. The prevalence rate understanding got based over per 100,000 people division. The primary consideration got placed over the top five cities and their related causes and the prevalence rates to prepare the meaningful analysis (Eupati, 2020).
Case Study
There are top five cities filtered out, from the data provided to develop the understanding of the infection rates, which are as follows:
Highest Cases Ranked Cities
Total Number of Cases
Prevalence Rate (@ 100,000 people)
Jacksonville
322
0.32%
Miami
299
0.30%
Phoenix
289
0.29%
Austin
281
0.28%
Houston
272
0.27%
As we can see, the top five cities include Jacksonville, Miami, Phoenix, Austin, and Houston, which have almost 1463 cases out of the total reported 4852 cases. This data makes contributions of 30.15%. They were reflecting on five cities that have a significant contribution to the total number of cases. Hence, these cities mainly focused on making the overall decrease in the rate of cases that got observed.
If we look into the individual cases in the top five cities, we can see that the highest number of cases got observed in Jacksonville at 322. In contrast, the lowest of these top cases are observed in Houston at 272 cases, stating no significant difference in the infected cities.
The prevalence rate observed at the rate of 100,000 people diversification, hence the highest at Jacksonville, is stated at 0.32%. In contrast, the lowest at Houston stated at 0.27%. Overall, the prevalence reflects a lower prevalence in every 100,000 people in the city.
Conclusion
From the study above, we can state that the top cities are contributing to the significant cases individually, which got reported overall; however, the prevalence rate is still low. However, this rate cannot get neglected. To control the overall infection rate, we can take this rate of prevalence as the guideline to prepare the plan of rectification implementation. The below-developed chart is used as the projection to represent the infected cities rate (top 5 cities), along with their number of cases, and their infection prevalence rates.
References Eupati. (2020, August 3). Epidemiologic Concepts: Incidence and Prevalence. Retrieved from Eupati: https://toolbox.eupati.eu/resources/epidemiologic-concepts-incidence-and-prevalence/
Report I
This paper was published based on the statistical analysis of the infected cases observed in the major cities.
The prevalence rate understanding got based over per 100,000 people division. The primary consideration
got placed over the top
five
cities and the
ir related causes and the prevalence rates to prepare the
meaningful analysis
(Eupati, 2020)
.
Case Study
There are top five cities filtered out, from the data provided to develop the understanding of the infection
rates, which
are as follows:
Highest
C
ases
R
anked Cities
Total
N
umber
of
C
ases
Prevalence
R
ate
(@ 100,000
people)
Jacksonville
322
0.32%
Miami
299
0.30%
Phoenix
289
0.29%
Austin
281
0.28%
Houston
272
0.27%
As we can see, the top five cities include
Jacksonville, Miami, Phoenix, Austin, and Houston, which have
almost 1463 cases out of the total reported 4852 cases. This data makes contributions of 30.15%. They were
reflecting on five cities that have a significant contribution to the total number of c
ases. Hence, these cities
mainly focused on making the overall decrease in the rate of cases that got observed.
If we look into the individual cases in the top five cities, we can see that the highest number of cases got
observed in
Jacksonville at 322. In contrast, the lowest of these top cases are observed in Houston at 272
cases, stating no significant difference in the infected cities.
The prevalence rate observed at the rate of 100,000 people diversification, hence the highest at
Jacksonville,
is stated at 0.32%. In contrast, the lowest at Houston stated at 0.27%. Overall, the prevalence reflects a
lower prevalence in every 100,000 people in the city.
Conclusion
From the study above, we can state that the top
cities are contributing to the significant cases individually,
which got reported overall; however, the prevalence rate is still low. However, this rate cannot get
neglected. To control the overall infection rate, we can take this rate of prevalence as the
guideline to
Report I
This paper was published based on the statistical analysis of the infected cases observed in the major cities.
The prevalence rate understanding got based over per 100,000 people division. The primary consideration
got placed over the top five cities and their related causes and the prevalence rates to prepare the
meaningful analysis (Eupati, 2020).
Case Study
There are top five cities filtered out, from the data provided to develop the understanding of the infection
rates, which are as follows:
Highest Cases Ranked Cities
Total Number
of Cases
Prevalence Rate
(@ 100,000
people)
Jacksonville 322 0.32%
Miami 299 0.30%
Phoenix 289 0.29%
Austin 281 0.28%
Houston 272 0.27%
As we can see, the top five cities include Jacksonville, Miami, Phoenix, Austin, and Houston, which have
almost 1463 cases out of the total reported 4852 cases. This data makes contributions of 30.15%. They were
reflecting on five cities that have a significant contribution to the total number of cases. Hence, these cities
mainly focused on making the overall decrease in the rate of cases that got observed.
If we look into the individual cases in the top five cities, we can see that the highest number of cases got
observed in Jacksonville at 322. In contrast, the lowest of these top cases are observed in Houston at 272
cases, stating no significant difference in the infected cities.
The prevalence rate observed at the rate of 100,000 people diversification, hence the highest at Jacksonville,
is stated at 0.32%. In contrast, the lowest at Houston stated at 0.27%. Overall, the prevalence reflects a
lower prevalence in every 100,000 people in the city.
Conclusion
From the study above, we can state that the top cities are contributing to the significant cases individually,
which got reported overall; however, the prevalence rate is still low. However, this rate cannot get
neglected. To control the overall infection rate, we can take this rate of prevalence as the guideline to
The post Create a symbols map using Microsoft® Excel® and the data provided in the High-Risk Areas document to determine the areas of the country with the most risk. appeared first on Versed Writers.