How to Plot Data onto a Map in Microsoft Excel PDF Essay Paper

How to Plot Data onto a Map in Microsoft Excel PDF Essay Paper

Assignment Content
Resource: How to Plot Data onto a Map in Microsoft Excel PDF

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.How to Plot Data onto a Map in Microsoft Excel PDF Essay Paper

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.

Permalink: 

Assignment: How to Plot Data onto a Map in Microsoft Excel PDF

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?How to Plot Data onto a Map in Microsoft Excel PDF Essay Paper

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

Assignment: How to Plot Data onto a Map in Microsoft Excel PDF

Format your citations according to APA guidelines.

Since the location of the highest widespread virus outbreaks have been recognized, it is important to know now what age group is mostly affected by the virus. Documenting these given age groups shall assist to determine the kinds of resources which shall be necessary at these locations to correctly treat these patients.

Age Groups Most Affected

Following the World Health Organization (2019) show that children, pregnant women and adults are particularly the ones who are vulnerable and take a relatively biggest share of the diseases load. The analysis of the given information, show that the progression of the age group most affected starting with the highest are under 18,61 and over 31-60 and finally 19-30 that correspond to the research of the World Health Organization on most vulnerable groups of individuals.How to Plot Data onto a Map in Microsoft Excel PDF Essay Paper

Age Groups Least Affected

The age groups least affected are the 19-30 years old in addition to those under 31- 60 years old. Generally, this kind of group comprises of the young adults as well as individuals in their middle ages. The reason why this group is probably least affected is due to the fact that this age brackets the body immune system is possibly more strong in preventing and fighting infections thus making the individual much healthier (Lesourd & Meaume, 1994).

Assignment: How to Plot Data onto a Map in Microsoft Excel PDF How to Plot Data onto a Map in Microsoft Excel PDF Essay Paper

Bar Graph Showing Ages Affected

Chart Evaluation

The bar graph above illustrates that the least age groups affected are ones between 19 to 30 years old. According to Morse (2001) explain that the observed age outlines can impact after intolerance diagnosing, identifying as well as cases recording, changes in exposure as well as variances invulnerability to the virus. Therefore by determining if change with age is contingent on exposure or vulnerability requires an evaluation of exposures in individual with and without the illness. Individual influences results to virus occurrences that can be recognized in nearly all incidents.How to Plot Data onto a Map in Microsoft Excel PDF Essay Paper

Prevalence Rates

The prevalence rate for this disease changes among the diverse age groups in every city. According to United States Census Bureau (2017) explanation the current population of the United States of America is 325,365,189 as of December 18, 2017. Therefore to determine the prevalence rate per 100,000 for this disease equals, the number of infection in the particular age group divided by the United States population, then multiplied by 100,000.

The following chart shows the prevalence rate for each age group in each of the top five cities affected by this disease.

City

<18 Prevalence Rate

19-30 Prevalence Rate

31-60 Prevalence Rate

61+ Prevalence Rate

Jacksonville

0.02858

0.00584

0.01875

0.04579

Miami  How to Plot Data onto a Map in Microsoft Excel PDF Essay Paper

0.05225

0.00553

0.00922

0.02490

Phoenix

0.04457

0.00615

0.00984

0.02828

Austin

0.04641

0.00369

0.01199

0.02428

Houston

0.03012

0.00492

0.01598

0.03258

Conclusion How to Plot Data onto a Map in Microsoft Excel PDF Essay Paper

Finally, the study of age groups that are mainly affected and vulnerable as well as the previous data on the locations of outbreaks shall provide us clue and knowledge to come up with a treatment for the disease. Also, it is relevant to determine what age groups are highest affected and the prevalence rates in these particular groups in order that further effective resources and techniques may be determined, eventually resulting to a disease-free community.How to Plot Data onto a Map in Microsoft Excel PDF Essay Paper