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
Get step-by-step solutions from verified subject matter experts
