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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!