STATISTIC

Go to the CDC website about the Coronavirus: https://www.cdc.gov/coronavirus/2019- ncov/index.html (Links to an external site.).

Part 1

·  The click on the ‘Data and Surveillance’ button which will take you to the information that has been being collected.

·  Create an excel spread sheet which shows the current number of cases by state and the number of deaths by state.

·  Once this data has been entered onto the excel spreadsheet, please create a line graph for each column representing this data.

·  Here are a couple of tools which may be helpful:

·  https://support.microsoft.com/en-us/office/present-your-data-in-a-column-chart-

d89050ba-e6b6-47de-b090-e9ab353c4c00

·  https://www.youtube.com/watch?v=X7O6WQl62Ks

· Part 2

·  Choose 3 states to compare the following COVID-19 data:

o Confirmed cases by gender (M/F) – create a pie graph representation o Death by gender (M/F) – create a pie graph representation o Confirmed cases by age – create a bar graph representation o Confirmed deaths by age – create a bar graph representation

Part 3

·  Provide a written summary of your findings, 1-2 pages, make sure to include references.

·  You will submit the excel spreadsheets, the corresponding graphs and summary