Combo Offer 30% Off + 5% Extra OFF

Assessment 1: Data Analysis Assignment Samples

Order on WhatsApp Get Upto 50% off
Securing Higher Grades Costing Your Pocket? Book Your Assignment At The Lowest Price Now!
  • Order on Whatsapp
X

Assessment 1: Data Analysis Assignment Samples

INTRODUCTION

Get free samples written by our Top-Notch subject experts for taking online assignment help & australian assignment help services 

  This presentation will be providing comparison data that has been process in the Microsoft excel. Skills of using excel sheet for data analysis, processing, and presentation will be reflecting in the report. Various charts, graphs, and information tables will be used in the report to provide better of information processes in the Microsoft Excel

According to the data which is collected from the specific sources, From date 19/03/2021 to 19/04/2021 total 8414720 people were completely vaccinated in United Kingdom and as compared to this there are total 469125 people were vaccinated in same period (GOV.UK Coronavirus (COVID-19) in the UK, 2021). From the above data, it can be said that, Vaccination performed in UK is way more faster than the vaccination that is performed in Israel. Total difference between vaccinated people in Israel and United Kingdom in same period is too high. This is a huge difference in the vaccinated data between these two countries. By analysing above data, it can be interpreted that, vaccination process in UK is much efficient then the vaccination performed in Israel.

Difference of Vaccination Data for United Kingdom and Israel

For better comparison, this is most important to analyse the vaccinated data on daily basis to evaluate the effectiveness of vaccination program of the country. According to the below graph there is huge difference between the vaccination data between both countries. This graph is reflecting the date to day vaccination data of both countries from 19/03/2021 to 19/04/2021. According to the graph, data of both country is going parallel and there is a huge difference between the data of countries

Difference of Vaccination Data for United Kingdom and Israel

According to the processes data above, it can be observed that difference between the vaccination data is varying day by day. According to the waveform obtained from the excel calculation it can be interpreted that, on daily basis there are too many people have been vaccinated completely as compared to the United Kingdom

On different other measures, Covid 19 vaccination data has been evaluated to manipulate the results. According to the calculation performed in the MS Excel it has been evaluated that there is an average 262960 people who were vaccinated each day. All the calculations has been performed with no number has been considered after decimal. There is total 15530 people vaccinated each day. As the auto sum feature used in the calculated in excel it can be explained that, there are total 8414720 people were vaccinated between 19/03/2021 to 19/04/2021 in United Kingdom. In Israel, total 469125 people were vaccinated within the period provided above (Number of people fully vaccinated against COVID-19, 2021). The median of vaccination data that has been evaluated in excel calculation is about 240752 and the median that have been found for the vaccination data between 19/03/2021 to 19/04/2021 is 13644. This is how different calculations has been performed in the excel sheet to analyse data and manipulate the results in effective way.

People Vaccination Date

People Vaccinated in UK

People Vaccinated in Israel

Daily Basis Vaccination in Israel

Difference Between Vaccination Data In United Kingdom and Israel

19-03-2021

125725

4515342

27847

97878

20-03-2021

91977

4530565

15223

76754

21-03-2021

52612

4570900

40335

12277

22-03-2021

82300

4611293

40393

41907

23-03-2021

169155

4618436

7143

162012

24-03-2021

242642

4664768

46332

196310

25-03-2021

234382

4699934

35166

199216

26-03-2021

283654

4713133

13199

270455

27-03-2021

238861

4717323

4190

234671

28-03-2021

147594

4721866

4543

143051

29-03-2021

168230

4751995

30129

138101

30-03-2021

277682

4774267

22272

255410

31-03-2021

387574

4793568

19301

368273

01-04-2021

445416

4812103

18535

426881

02-04-2021

246631

4820059

7956

238675

03-04-2021

178913

4822926

2867

176046

04-04-2021

47708

4845643

22717

24991

05-04-2021

64590

4866737

21094

43496

06-04-2021

186793

4883092

16355

170438

07-04-2021

408396

4898128

15036

393360

08-04-2021

449269

4914970

16842

432427

09-04-2021

450136

4921027

6057

444079

10-04-2021

475230

4924554

3527

471703

11-04-2021

189665

4938642

14088

175577

12-04-2021

201191

4951752

13110

188081

13-04-2021

312685

4956478

4726

307959

14-04-2021

343783

4961549

5071

338712

15-04-2021

417683

4961933

384

417299

16-04-2021

499664

4968365

6432

493232

17-04-2021

499635

4970247

1882

497753

18-04-2021

221193

4977605

7358

213835

19-04-2021

273751

4984467

6862

266889

total

8414720

469125

 

Information Calculated

Average of Difference in the Vaccination data

247430

Total Number of People Vaccinated in United Kingdom

8414720

Total Number of People Vaccinated in Israel

496972

Median Of Vaccination Data in United Kingdom

240752

Median Of Vaccination Data in Israel

13644

Average People Vaccinated in UK Each Day

262960

Average People Vaccinated in Israel Each Day

15530.375

Total % People Vaccinated in United Kingdom Between 19/03/2021 to 18/04/2021

13%

Total % People Vaccinated in Israel Between 19/03/2021 to 18/04/2021

5%

The above chart is reflecting all that data which is calculated within the Microsoft excel. The above chart is representing that, Total number of people who were vaccinated in Israel and largest column in chart is reflecting information. In the above chart, proper difference between all data can be effectively analysed.

CONCLUSION

´  In this presentation, different charts and tables will be represented that are measured in MS Excel. Various formulas and functions of Microsoft Excel has been used to generate manipulated data for the presentation. For effective analysis of vaccinated related information and data has been evaluated in report.

Free Download Full Sample Free Download Full Sample
Get best price for your work

offer valid for limited time only*

Get a callback
In a Hurry-Get a Callback

© Copyright 2021 | New Assignment Help | All rights reserved