Question: This web sitehttps://www.worldom eters.info/coronavirus/#countries(Links to an external site.) has the most up-to-date information about the number of Coronavirus cases by countries. Use Excel for this
This web sitehttps://www.worldom eters.info/coronavirus/#countries(Links to an external site.) has the most up-to-date information about the number of Coronavirus cases by countries.
Use Excel for this project. In the first column write down the dates for the last 2 weeks. In the 2nd column record the number of new cases in the U.S. for each of the days. Section any one of the other countries and record the number of new cases in the third column.
- Create a scatter plot for each country with dates on the x-axis and the number of new cases on the y-axis. Do you observe any pattern from the scatter plots? Describe your observation.
- Use Excel functions to calculate the sample mean of each set of data. Compare the two means and medians, and describe your observation.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
