You will be using the nation-level case and death data.

100 days out of the year of 2020 are randomly selected for this question. You will work with this dataset and submit your answers according to the questions provided below:

 

Variables in this dataset:

Date: date 
Daily Cases: the number of confirmed cases in the U.S.
Daily Deaths: the number of confirmed deaths in the U.S.

Please provide your answers in the Answer column (column G)

Between April 1, 2020, and September 25, 2020, what are the maximum and minimum number of daily cases? 

Between April 1, 2020, and September 25, 2020, what are the maximum and minimum number of daily deaths?  

How many days in this dataset have the case number greater than 10,000 and less than 100,000?  

How many days in this dataset have the case number greater than 1,000 and less than 2,000?  
 

Hint: 
Functions Sort & Filter might be helpful for answering the questions.

 

Q2: In this question, you will use the 7-day case and death data of California from 4/6/2020 to 1/25/2021. You will work with this dataset and submit your answers based on the questions provided below:

 

Variables in this dataset:
Date: date 
State: the state of the data reported
Case Increase (7 Day) the average number of daily cases in the week of Date (starting from the date)

Death Increase (7 Day) the average number of daily deaths in the week of Date (starting from the date)

Please conduct your work in Q2 directly and create your visualization in the same spreadsheet.

Please use the conditional formatting to identify the top 10 average number of daily cases and top 10 average number of daily deaths, and make heatmap for Death/Case Ration (7 Day), (using color of red to indicate higher ratio)

Create a single line chart (2-D Line) for Case Increase (7 Day) with chart title, and legend, having the date as the horizontal axis (X-Axis)?

Create a single bar chart (2-D Column) for Death Increase (7 Day with chart title), and legend, having the date as the horizontal axis (X-Axis)?

Briefly discuss what you have observed from the visualizations that you created in this question ( find a convenient place in the same spreadsheet to add your discussion)