Introduction: Data Analysis
Get free samples written by our Top-Notch subject experts for taking online assignment help.
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.
5 Years | PhD
