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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started