All numerical calculations and graphs

Instructions:

• Data files are provided in Excel in the assessment section of the course website.
• All numerical calculations and graphs/plots should be done using EXCEL as much as possible.
• Your answers should be typed in Word – equations, symbols could be hand-written. Present the answers to all questions as efficiently as possible in the main assignment with all relevant (Excel) output (eg, plots, tables etc) inserted into the main document.
• The completed assignment must be scanned and submitted electronically. You also need to submit the Excel file with your original data and all the calculations for Question B3.
• You are required to keep a hard copy and the scanned electronic copy of the submitted assignment to re-submit, in case the original submission is lost for some reason.
• GOOD LUCK!

Important Notice:

As this is an individual assessment item, students should submit their individual assignment. If found to have cheated, all submissions involved would receive a mark of zero for this assessment item.

Marking criteria:

For each question, marking will use the following weighting:

1. Correctness of the identification of the data type and methodology used (10%)

2. Successful application using the computer software (Excel) (10%)

3. Interpretation of the results from computer output (10%)

4. Correct answers to the question(s) (60%)

5. Professional presentation of the report (10%)

ASSIGNMENT – PART B

QUESTION B1: An Analysis of the spread Coronavirus (COVID-19) Pandemic across countries (14 marks)

Compilation of the COVID-19 epidemic data commenced on the 31^st of December 2019. It commenced in Wuhan, China, and as at 14 April 2020, has spread to more than 200 countries worldwide. The worldwide number of confirmed positive cases has surpassed 3 million and the number of deaths has also passed 235,000.

The number of worldwide confirmed COVID-19 positive cases and number of deaths as reported between 31/12/2019 and 10/4/2020 by country is given in COVID19WORLD.xlsx. Source:

Using the data in sheet ‘Total’ of COVID19WORLD.xlsx answer the following questions.

1. 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 15 countries in the world total (combine the rest of the countries as ‘Other’).
2. 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 15 countries in the world total (combine the rest of the countries as ‘Other’).
3. 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 1,000,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 1,000,000 persons. Sort the data from largest to smallest and draw a bar chart of number of confirmed cases per 1,000,000 over countries for the top 15 countries. Comment on the chart and compare it with the bar chart in part a.
4. As the population sizes are different, to compare the number of COVID-19 related deaths across countries, considering the number of deaths per 1,000,000 persons would provide a better comparison across countries. For the top 15 countries identified in part b, calculate the total number of deaths per 1,000,000 persons. Sort the data from largest to smallest and draw a bar chart of number of deaths per 1,000,000 over countries for the top 15 countries. Comment on the chart and compare it with the bar chart in part b.

Using the daily data in sheet ‘Daily Data by country’ of COVID19WORLD.xlsx answer the following questions.

5. Using the daily data for the top 10 countries (top 10 out of the 15 identified in part a), construct individual time series charts of the daily number of confirmed cases over time for the 10 countries. Comment on the distribution of the number of confirmed cases over time and compare the trend across the 10 countries.
6. Using the daily data for the top 10 countries (top 10 out of the 15 identified in part b), construct individual time series charts of the daily number of deaths over time for the 10 countries. Comment on the distribution of the number of deaths over time and compare the trend across the 10 countries.

7. Calculate the growth factor (the ratio of current 5-day average divided by lagged 5-day average) of number of confirmed positive cases for Australia, Brazil, Russia, the UK and the US from 10/3/2020-10/4/2020. [Hint: To calculate the growth factor for 10/3/2020, calculate the current 5-day average (average of 6/3-10/3) and divide by the lagged 5-day average (average of 5/3-9/3). Continue the same by copying the cells for the rest of the days up to 10/4/2020. If a current or lagged average is zero, then the growth factor will be 0.] Draw a time series chart (all five countries in the same plot). Compare the movement of the growth factor during this period across the five countries and identify the successful countries in combating the pandemic. A growth factor less than 1 is considered to show success in combating the virus. The lower the factor the better. More details about the growth factor can be found in https://www.abc.net.au/news/2020-04-10/coronavirus-data-australia-growth-factor-covid-19/12132478

QUESTION B2: Distribution of the Spread of COVID-19 in Australia and its Eight States/Territories (6 marks)

1. The diagram below, also saved as COVIDAustralia.pdf, presents several graphical presentations about the status of the COVID-19 pandemic over time, by states, by gender and by age group in Australia. Based on these plots, present an analysis (minimum 500 words, use subheadings etc within your analysis) of the distribution of the number of COVID-19 cases in Australia. You can cut and paste any of the graphs in your discussion.

2. The article ‘Charting the COVID-19 spread in Australia’ in the website below presents detailed analysis of the distribution of the Coronavirus pandemic across the Australian states. It also places Australia in the world picture showing its trend compared to other countries. Present a 150-word (minimum) report of the current status in Australia as a whole and also the rate of infection compared to other countries. Using all the state-wide information and graphs presented in the website report, https://www.abc.net.au/news/2020-03-17/coronavirus-cases-data-reveals-how-covid-19-spreads-in-australia/12060704, present a detailed comparison of the COVID-19 pandemic across the 8 Australian states and territories.

QUESTION B3: An Analysis of the spread Coronavirus (COVID-19) Pandemic across countries (10 marks)

This question is based on your own data collected over the period 5/3/2020 and 1/5/2020.

1. Your original data should be stored in the data file called COVID19GLOBAL.xlsx in worksheet ‘Raw data’. In a new worksheet called Tables, enter country names in the first column (column A) and Number of positive COVID-19 confirmed cases and number of deaths in columns B and C for the first date. Then columns D, E and F for country, confirmed cases and deaths for the next date, and so on. Then you need to make sure that the country names align for different dates. First copy with the country name for each date. Once the country names align, you can remove the country name columns. The best way to do this is to first sort the data each day by largest to smallest (number of confirmed cases) and then copy the data, so that most of the newly included countries would appear at the bottom. Note that some ranking order will be different on different days. You need the data for the top 10 countries (ranked based on the last day of your data collection), then the rest of the countries’ total as ‘Other’ and the last row for the ‘Total’ for the data period. Then copy the worksheet and make separate worksheets for ‘Confirmed cases’ and ‘Deaths’.
2. Draw an appropriate chart to show the trend in the total cumulative number of confirmed cases globally during the data period. Comment on your chart.
3. Draw an appropriate chart to show the trend in the total cumulative number of deaths globally during the data period. Comment on your chart.
4. Draw an appropriate chart to show the trend in the cumulative number of confirmed cases for the top 5 countries during the data period. Compare the trend in the 5 countries
5. Draw an appropriate chart to show the trend in the cumulative number of deaths for the top 5 countries during the data period. Compare the trend in the 5 countries.
6. Consider the data for the top 10 countries and ‘Other countries’ on the first day of your data collection (e.g., 5/3/2020). Use an appropriate chart to show the share of the (i) number of confirmed cases (ii) number of deaths in the 10 countries in the world total (combine the rest of the countries as ‘Other’).
7. Consider the data for the top 10 countries and ‘Other countries’ on the last day of your collection (e.g., 1/5/2020). Use an appropriate chart to show the share of the (i) number of confirmed cases (ii) number of deaths in the 10 countries in the world total (combine the rest of the countries as ‘Other’).
8. Based on your answer to parts f and g, compare how the share has changed between the first and last day of your data collection.
9. Write a brief analysis of how the COVID-19 pandemic has spread across countries by looking at the rate the number of countries have increased during your data collection period.
10. Based on your data, in your opinion, comment on which countries have been successful and which countries are of concern in dealing with the COVID-19 pandemic.

END OF THE ASSIGNMENT

The post All numerical calculations and graphs appeared first on My Assignment Online.

Expert Help With This Assignment — On Your Terms