(Get Answer)
Expert Answer
This week, you will be using COVID-19 data collected and published by The New York Times Github to perform a number of basic data exploration, calculation, and visualization tasks in Excel. Please follow the guidelines provided below and submit your assignment to Canvas before the due date.
Please download the homework file from here to start working on your homework.
Q1: 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. (40 pts)
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? (10 pts)
Between April 1, 2020, and September 25, 2020, what are the maximum and minimum number of daily deaths? (10 pts)
How many days in this dataset have the case number greater than 10,000 and less than 100,000? (10 pts)
How many days in this dataset have the case number greater than 1,000 and less than 2,000? (10 pts)
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. (60 pts)
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) (15 pts)
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). (15 pts)
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). (15 pts)
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) (15 pts)
This question has already been tackled by one of our writers and a good grade recorded. You can equally get high grades by simply making your order for this or any other school assignment that you may have.
Every Student Buys Essays from us, here is why!
Pressed for time to complete assignments or when you feel like you cannot write, you can purchase an
essay on our website. Some students also want model papers to use as samples when revising or
writing. There are also students who approach our essay writing service to beat deadlines. We handle
every type of homework, assignment, and academic writing tasks. You can buy college essays and other
assignments here. At a glance, here are some reasons students prefer our website.
100% Original Essays and Papers
You can be sure that you are getting a paper that is custom written based on your instructions. We do
not sell papers that are pre-written. Instead, we write every essay from scratch. When you say “write my
essay,” we respond by giving you a paper that is 100% original and free of any plagiarism. The essays you
purchase from us have never been sold anywhere.
Flexible & Affordable Prices
It does not cost a fortune to get academic writing help on our website. If you have a question from class,
place an order, get a discount, and get cheap essay writing services. What you see as the price is what
you pay for. There are no any hidden charges. If you need urgent papers, they might cost a little more,
but the price is worth the quality you get in the end. Hire a professional academic writer beginning from
$13 a page.
Anonymity, Privacy, and Confidentiality
No one will ever know that you purchased an essay or assignment from our website. The essays you buy
from us are written by experts. Your data is only used to coordinate the essay writing services you get.
No one can access your personal information and data. Go ahead and order an essay from our website.
It is safe, secure, and convenient.
