An Analysis of the spread Coronavirus (COVID 19) Pandemic across countries Compilation of the COVID 19 epidemic data commenced on the 31 st of December 2019 First identified in Wuhan, China, and by April 2020, had spread to more than 200 countries worldwide with more than 3 million confirmed positive cases and about 235,000 deaths worldwide In September 2021, worldwide, the number of confirmed positive cases has surpassed 231 million and the number of deaths has exceeded 4 74 million In December 2020, a number of COVID19 vaccinations completed their trials and were approved by several governments of countries to be used for their citizens The number of worldwide confirmed COVID 19 positive cases and number of deaths as reported on the 26 th of September 2021 by country (for countries which have had more than 1000 confirmed COVID 19 cases) is given in 5COVID19WORLD xlsx A Using the data in worksheet ' Cases Deaths ' of 5COVID19WORLD xlsx answer the following questions Identify the top 15 countries by ranking the total number of confirmed COVID 19 cases and draw a bar chart Comment on the chart Use an appropriate chart to show the share of the number of confirmed cases in the top 15 countries in the world total (combine the rest of the countries as 'Other') As the population sizes are different, to compare the number of confirmed COVID 19 positive cases across countries, considering the number of confirmed cases per 10,000 persons would provide a better comparison across countries For the top 15 countries identified in part a , calculate the total number of confirmed cases per 10,000 persons Sort the data from largest to smallest and draw a bar chart of number of confirmed cases per 10,000 over countries for the top 15 countries Comment on the chart and compare it with the bar chart in part a Identify the top 15 countries by ranking the total number of COVID 19 deaths and draw a bar chart Comment on the chart Use an appropriate chart to show the share of the number of deaths in the top 15 countries in the world total (combine the rest of the countries as 'Other') As the population sizes are different, to compare the number of COVID 19 related deaths across countries, considering the number of deaths per 10,000 persons would provide a better comparison across countries For the top 15 countries identified in part d , calculate the total number of deaths per 10,000 persons Sort the data from largest to smallest and draw a bar chart of number of deaths per 10,000 over countries for the top 15 countries Comment on the chart and compare it with the bar chart in partd Obtain the proportion (in percentage) of number of COVID 19 related deaths per number of COVID 19 cases for each country Identify the top 15 countries with the highest percentage among all countries and present them in a bar chart Compare your results with the results in part f Based on your analysis above in parts c, f and g, in your opinion, comment on which countries have been successful and which countries are of concern in dealing with the COVID 19 pandemic with respect to number of cases and deaths B Using the data in sheet ' Vaccination ' of 5 COVID19WORLD xlsx answer the following questions Identify the top 15 countries by ranking the total number of vaccinations and draw a bar chart Comment on the chart Use an appropriate chart to show the share of the number of vaccinations in the top 15 countries in the world total (combine the rest of the countries as 'Other') As the population sizes are different, to compare the number of COVID 19 vaccinations across countries, considering proportion of the population vaccinated would provide a better comparison across countries Calculate the proportion of the population vaccinated (in percentages) for each country Sort the data from largest to smallest and identify the top 15 countries Draw a bar chart of proportion of the population vaccinated for the top 15 countries Comment on the chart Compare the top 15 countries most affected based on the number of cases and deaths per 10,000 persons in parts c and f with the top 15 countries vaccinated in part k Are any of the most affected countries in parts c and f able to vaccinate their population better than others Here is the excel file link for refrence https 1drv ms x s AqswQjmPQpq6jxXx0q Dig9jah2P e Z5BiNm if possible plese provide link for refrence Many Thanks

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jun 20, 2024

An Analysis of the spread Coronavirus (COVID-19) Pandemic across countries Compilation of the COVID-19 epidemic data commenced on the 31 st of December 2019. First

An Analysis of the spread Coronavirus (COVID-19) Pandemic across countries

Compilation of the COVID-19 epidemic data commenced on the 31^st of December 2019. First identified in Wuhan, China, and by April 2020, had spread to more than 200 countries worldwide with more than 3 million confirmed positive cases and about 235,000 deaths worldwide. In September 2021, worldwide, the number of confirmed positive cases has surpassed 231 million and the number of deaths has exceeded 4.74 million. In December 2020, a number of COVID19 vaccinations completed their trials and were approved by several governments of countries to be used for their citizens.

The number of worldwide confirmed COVID-19 positive cases and number of deaths as reported on the 26^th of September 2021 by country (for countries which have had more than 1000 confirmed COVID-19 cases) is given in 5COVID19WORLD.xlsx.

A Using the data in worksheet 'Cases&Deaths' of 5COVID19WORLD.xlsx answer the following questions.

Identify the top 15 countries by ranking the total number of confirmed COVID-19 cases and draw a bar chart. Comment on the chart.
Use an appropriate chart to show the share of the number of confirmed cases in the top 15 countries in the world total (combine the rest of the countries as 'Other').
As the population sizes are different, to compare the number of confirmed COVID-19 positive cases across countries, considering the number of confirmed cases per 10,000 persons would provide a better comparison across countries. For the top 15 countries identified in part a, calculate the total number of confirmed cases per 10,000 persons. Sort the data from largest to smallest and draw a bar chart of number of confirmed cases per 10,000 over countries for the top 15 countries. Comment on the chart and compare it with the bar chart in part a.
Identify the top 15 countries by ranking the total number of COVID-19 deaths and draw a bar chart. Comment on the chart.
Use an appropriate chart to show the share of the number of deaths in the top 15 countries in the world total (combine the rest of the countries as 'Other').
As the population sizes are different, to compare the number of COVID-19 related deaths across countries, considering the number of deaths per 10,000 persons would provide a better comparison across countries. For the top 15 countries identified in part d, calculate the total number of deaths per 10,000 persons. Sort the data from largest to smallest and draw a bar chart of number of deaths per 10,000 over countries for the top 15 countries. Comment on the chart and compare it with the bar chart in partd.
Obtain the proportion (in percentage) of number of COVID-19 related deaths per number of COVID-19 cases for each country. Identify the top 15 countries with the highest percentage among all countries and present them in a bar chart. Compare your results with the results in part f.
Based on your analysis above in parts c, f and g, in your opinion, comment on which countries have been successful and which countries are of concern in dealing with the COVID-19 pandemic with respect to number of cases and deaths.

B Using the data in sheet 'Vaccination' of 5COVID19WORLD.xlsx answer the following questions.

Identify the top 15 countries by ranking the total number of vaccinations and draw a bar chart. Comment on the chart.
Use an appropriate chart to show the share of the number of vaccinations in the top 15 countries in the world total (combine the rest of the countries as 'Other').
As the population sizes are different, to compare the number of COVID-19 vaccinations across countries, considering proportion of the population vaccinated would provide a better comparison across countries. Calculate the proportion of the population vaccinated (in percentages) for each country. Sort the data from largest to smallest and identify the top 15 countries. Draw a bar chart of proportion of the population vaccinated for the top 15 countries. Comment on the chart.
Compare the top 15 countries most affected based on the number of cases and deaths per 10,000 persons in parts c and f with the top 15 countries vaccinated in part k. Are any of the most affected countries in parts c and f able to vaccinate their population better than others?

Here is the excel file link for refrence.

https://1drv.ms/x/s!AqswQjmPQpq6jxXx0q-Dig9jah2P?e=Z5BiNm

if possible plese provide link for refrence. Many Thanks.