Reference no: EM132863003
Assessment 1: Data Analysis
Avoid some of the most common coursework mistakes by using the Fit To Submit Coursework Checklist
Assessment Brief
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 using MS PowerPoint with strictly no-more than 10 slides, including your name and ID.
Tasks
• Based on a research topic or case study given on BlackBoard, 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.
• Screen-capture all the important information onto MS PowerPoint slides (i.e. no more than 10 slides).
b
Your case study is to be based on the following two websites.
The data 1st Jan 2021 till 28th Feb 2021 must be downloaded from the two websites before answering the following questions
1) You need to compare the UK vaccination data in order to identify the difference and similarity in the form of visual displays (such as charts and graphs
2) You need to compare the UK vaccination data with both
- Israel
- United State
3) You MUST create the chart(s) yourself using Excel
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) You present all these in MS Power Point for no more than 10 slides. Both the "data" and the "figure" views must be clearly shown
Assessment Criteria
o Topic of understanding
- Brief description on what this summary is about. This must be specifically related to what you are presenting.
o Raw Data Presentation
- Choose appropriate data for sampling.
- Present the raw data on the spreadsheet, using Excel function, such as auto-format
- Label the raw data accordingly.
o Statistical Techniques
- Convert the raw data into meaningful information, using mean, median and mode.
o Data Manipulation
- Using Excel functions such as
a) Auto-sum formula (Sum, Average, Count, Max and Min)
b) Percentage/Decimal/Fraction/Ratio (whichever is appropriate) to manipulate the data
• Communicate the information using Visual Representations.
o Present the data in appropriate types of chart(S)
o Conclusions
o Discuss the conclusions by interpreting the obtained data using the above information.
Attachment:- Data Analysis.rar