You work in your state’s health department. Your manager wants to help the public have a better understanding of where the Covid cases are within your state or local area.

Create 3 different data visualizations* within Microsoft Excel spreadsheet that fulfills your manager’s request by completing the following steps:

• Access data on Covid transmission rates from the CDC website. This webpage lists the data in a spreadsheet format.
• Open Microsoft Excel software.
• Create a new Microsoft Excel file named “MPH 520 Excel Assignment.”
• Create a new worksheet in your Microsoft Excel file and name it “Data and Data Visualizations.”
• Add Covid data for 5 to 10 counties in your state or neighboring states that are close to your local area.
• Create column titles that accurately describe each type of data you chose to include.
• Create 3 different data visualizations within Microsoft Excel.

Review these resources to help you complete this assignment:

*Examples of data visualizations include column charts, line charts, pie charts, scatter plots, and histograms.

Within your Excel spreadsheet, write a 150- to 175-word response on the impact of data visualizations. Consider the following questions:

• Why did you choose each of your specific data visualizations?
• How can data visualizations influence and motivate public behavior?

Review the following resources to help you complete your assignment:

• Basic tasks in Excel 
• Create a chart with recommended charts
• Excel video training

Cite any sources to support your assignment.

Submit your assignment.