Question
1. Use the Data of Italy and calculate the average growth rate of the number of cases (starting from the date in which Italy had
1. Use the Data of Italy and calculate the average growth rate of the number of cases (starting from the date in which Italy had more than 100 cases). USE EXCEL 2. Use the Data of Spain and calculate the average growth rate of the number of cases. (starting from the date in which Spain had more than 100 cases). USE EXCEL 3. Use the Data of the US and calculate the average growth rate of the number of cases. (starting from the date in which US had more than 100 cases). USE EXCEL 4. Plot the data for the three countries (in levels). In the same plot, all countries should start at from the date when they had more than 100 cases: Meaning the X-axis should represent "number of days after the date of the 100th case"). 5. Plot the data for the three countries in the ratio-scale (log-scale). In the same plot, all countries should start at from the date when they had more than 100 cases: Meaning the X-axis should represent "number of days after the date of the 100th case").
DATA:https://docs.google.com/spreadsheets/d/1-IKaq8NYh9Pi_P2W0Fd1UFmxBFZik8olja58DecbeFE/edit?usp=sharing
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