Part $($A$)$ CASE STUDY: Analysing COVID$19$ Dataset

You are given a dataset in relation to COVID$19$ record called RAW DATA.

$($covid$19\_$July$2020\_$dataset.xlsx$).$ The dataset contains data such as country name, region, population,

total confirmed cases, total death, total recovery, and active case.

Your team has been assigned to perform data analysis using spreadsheet software such as Microsoft

Excel.

A$\mathrm{.}1$ Creating New Spreadsheet

Within the dataset workbook, create a separate spreadsheet named $$Part A Solution$$ next to Raw

Data. In Part A Solution construct a simple table which include all team members$$ name, email

address and Contribution$(\%).$

Raw Data Part A Solution

Provide an appropriate table header and highlight the team leader$$s name. Team Leader will be

responsible for the submission of the final work $($final version of the spreadsheet, any other

submission by members will not be accepted.$)$

Your file name for the submission to Blackboard should be Group xx DM$.$xls where xx is your group

number.

NOTE: You are expected to format and style all the tables in this spreadsheet with reference to the

following questions. Please label the table with reference to the question answered.

A$2$ Top $10$ Countries with COVID$19$

Create a second table below the team members table, list down the top $10$ countries with highest total

COVID$19$ cases and display the data of the top $10$ countries identified. Do not just Copy$/$Paste from

Raw Data, use excel function to extract and display data appropriately.

Number Country Total COVID cases

A$3$ Statistics

Create a third table to show the lowest, highest, total and average of the population, total COVID

cases, total death, total recovery and total active cases for all countries from the RAW Data given.

You are expected to use Excel formula to generate the data. Do not just cut and paste data from Raw

Data or unknown sources.