Impact of COVID-19 on Infectious and Vaccination Rates: Statistical Analysis using MS Excel

DHICT BA30589E

Table of Contents
INTRODUCTION ..........................................................................................................................3
Main Body.......................................................................................................................................3
Impact Of covid-19.................................................................................................................3
Raw data presentation.............................................................................................................3
Statistical Techniques.............................................................................................................4
Data manipulation..................................................................................................................4
Chart Representation..............................................................................................................5
Analysis and Findings............................................................................................................6
CONCLUSION ...............................................................................................................................7
REFERENCES................................................................................................................................8

INTRODUCTION
The attached MS- excel document represents the data on COVID-19 and also reflects the
adverse impact of noble corona virus. The Covid-19 pandemic was such a mishap that it gave
rise to the situations like lock-down, deaths, restrictions on the import and export trade practices
(Bose and et.al.,2019). The impact of this disease has not only affected the lives of people but it
has given a big hit to each and every industry be it a hospitality industry, vehicle industry or any.
It has even led to the conditions like poverty, loss of employment and even decline in GDP rate
of economy through different globes. In the following report the data has been taken from an
authentic source like from the website of World Health Organisation. The data is taken for the
year 2021 for two certain factors the one is infectious rate and the another one is total
vaccination rate. The report highlights the data interpretation from the measures of central
tendency- mean, mode and median along with the other functions of excel like Maximum,
Minimum, Sum & Count.
Main Body
Impact of covid-19
The nobel corona virus has caused economic and social disruption which is very
devastating. It has led to the dramatic loss of human life among different nations and has
reflected remarkable challenge to the health of people. It has also affected the food system of
nations and has placed millions of livelihood in a huge risk. All this has left to the economy in a
stand-still position. Instead of the ban and restrictions on the certain activities, the countries has
to face several issues in terms of per capita income, gross domestic product, manufacturing and
production scale, profitability etc (. Dutil and et.al., 2018). The spread of Nobel corona virus
kept on increasing with a horrifying speed and has even caused mental health issues.
Raw data presentation
The data has been taken for the year 2021 from an authentic and reliable source of World
Health Organisation website. The purpose of taking this data is to understand and interpret the
effect of COVID – 19 pandemics in accordance with the two segments, they are - infectious rate
and the total vaccination rates.