Assessment 1: Data Analysis Assignment Samples

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.

Information Calculated

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.