Question: Based on a research topic, you are required to obtain the relevant raw data. You then use MS Excel to manipulate the data obtained and

Based on a research topic, you are required to obtain the relevant raw data.

You then use MS Excel to manipulate the data obtained and present the information

Tasks Based on a research topic or case study obtain/download the raw data for sampling

Use MS Excel to manipulate the raw data with various statistical techniques.

Communicate the information using visual representations.

Case study is to be based on the following two websites.

https://coronavirus.data.gov.uk/details/vaccinations

https://ourworldindata.org/covid-vaccinations The data 1st Jan 2021 till 28th Feb 2021

4) You need to calculate the percentage/ratio/fraction (whichever appropriate) of vaccination with respect to its populations.

5) You must use the Statistical techniques (mean, median and mode) using the Excel functions, such as AVERAGE, MEDIAN and MODE to display relevant information.

6) You must also leverage on the Excel AutoSum features (SUM, AVERAGE, COUNT, MAX and MIN) for data manipulation in order to display the relevant information

7) Discuss the conclusions by interpreting the obtained data using the above information

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!