REPORTS

profiletoopoor4u
MHA5074WEEKSHOMEWORKK.docx

This will be an ongoing project due weekly accepting first part must be willing to continue working on it for the next four weeks. PLEASE READ ENTIRE ASSIGNMENT BEFORE BIDDING ONCE BID IS ACCEPTED I WILL NOT ACCEPT AN INCREASE IN FEE AND ANY INCREASE WILL BE DISPUTED. Plagiarized work is not acceptable

Report 1 DUE 12/04

Read the following scenario:

Data has been collected to identify specific cases of people who are infected with a dangerous virus. Your organization has an interest in knowing where the population is most affected in an effort to move resources to areas that need them.

Create a bar chart using Microsoft Excel® and the data provided in the Cases by City document to identify the cities with the highest counts of cases.

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

Report 2 Due 12/11

Read the following scenario:

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.

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

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

Report 3 Due 12/18

Resources: How to Plot Data onto a Map in Microsoft Excel

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. Note: Watch the "How to Plot Data onto a Map in Microsoft Excel" video for more information about plotting data on a map in Excel. Note also that this information will be used for further analysis in Week 6.