Impact of Covid 19 on Business Performance: Statistical Analysis

This report analyses the impact of Covid 19 on business performance using statistical techniques and Excel AutoSum features. Data is collected from the WHO site and includes infection and vaccination rates for seven countries. Findings indicate a negative impact on business performance and productivity. The report concludes that vaccination is key to overcoming the pandemic's impact.

DHICT Assessment
1

Table of Contents
INTRODUCTION...........................................................................................................................3
MAIN BODY..................................................................................................................................3
Calculation of the percentage on collected data..........................................................................3
Application of statistical technique and Excel AutoSum features...............................................4
Charts of data with labelling........................................................................................................5
Findings and analysis...................................................................................................................7
Conclusion.......................................................................................................................................9
REFERENCES..............................................................................................................................10
2

INTRODUCTION
Covid 19 pandemic has the largest shock for the global which impact a lot of business in greater
sense. The impact of Covid 19 was negative for many businesses in the global. When pandemic
hot the nation survival countries announced a strict lockdown, many restrictions were imposed,
international trade were stop and many more. These all impact the performance and productive
of the organisation in negative way (Zhang, Gerlowski and Acs, 2022). Coronavirus has hugely
effect each and every aspects of human life. Employee turnover becomes high, customer is
purchasing only the basic product, market share is getting down and many more. In this report
data regarding the impact of coronavirus on business performance will be collected and various
statistical formula like mean, median, mode, sum would be applied so that a proper analysis can
be made. Data is collected from the site of world health organisation so that infection rate and
vaccination rate will be acquired between different countries. The information is gathered from
the year 2021 (Mahdy, 2020).
MAIN BODY
Calculation of the percentage on collected data
Table of infection case with percentage
Country Total infection cases Total infection cases in Percentage
United States of America 79091857 38.91
India 43014687 21.16
Brazil 29682615 14.60
France 23759289 11.69
The United Kingdom 20516002 10.09
Austria 3631568 1.79
Canada 3412424 1.68
Iceland 177015 0.09
3

Table of vaccination rate with percentage
Country Total vaccination rate total Vaccination rate in
Percentage
United States of America 55149115.00 1.74
India 383413147.00 12.13
Brazil 80780947.00 2.55
France 153822238.00 4.87
The United Kingdom 790396.00 0.02
Austria 1805830502.00 57.12
Canada 140156950.00 4.43
Iceland 541754260.00 17.13
Application of statistical technique and Excel AutoSum features
Country Total vaccination rate total infection cases
United States of America 55149115.00 79091857
India 383413147.00 43014687
Brazil 80780947.00 29682615
France 153822238.00 23759289
The United Kingdom 790396.00 20516002
Austria 1805830502.00 3631568
Canada 140156950.00 3412424
Iceland 541754260.00 177015
Sum 3161697555.00 203285457.00
Mean 395212194.38 25410682.13
Median 146989594.00 22137645.50
Maximum 1805830502.00 79091857.00
4

Minimum 790396.00 177015.00
Charts of data with labelling
Figure 1: Chart of infection case
Figure 2: Chart of infection case with percentage
5

Figure 3: Chart with total vaccination rate
Figure 4: Chart of total vaccination rate with percentage
6

Findings and analysis
Impact of Covid 19 in global was so worst that in the early stage it become impossible for
everyone to control the situation. The pandemic not only affected the health of the public but
also the business operation. There is a negative impact of Covid 19 on various sector of the
economy like travel and tourism industry, hospitality industry, retail industry, entertainment
industry, education industry and many more. But the sector which affected the most is retail
industry of various country (Tosti-Kharas and Michaelson, 2021). As the government of the
countries imposed various trade restriction so importing and exporting becomes difficult. The
income, employee turnover, rise in price of fuel, improper supply chain management and many
more are the consequence which were faced by business which reduce their performance and
productivity. Operating business in effective and efficient manner were become impossible and
company also make various efforts so that they can market their goods and service in order to
gain profit.
Data interpretation:
In the excel data is being collected for seven different countries which are United States
of America India, Brazil, France, The United Kingdom, Austria, Canada and Iceland for Covid
19 pandemic. The data which is gathered is total infection case and vaccination rate at the end of
the year 2021. For inspecting and analysing data different statistical technique is being used
7

which are mean, median, mode. Also other function also been used which are Maximum,
Minimum, sum. Let’s discuss each of them one by one.
Percentage: From the above table it is being concluded that the highest vaccination is
provided by united states of America. The vaccination rate is 55149115.00 at America as
compared to all other country. It indicates that the country is putting more efforts so that they can
reduce the impact of Covid a9 on their citizen and operates their business in more effective
manner. The infection rate is highest in Austria which is 57.12 percent out of 100. It means the
company business are impacted a lot at the time of Covid 19 and they struggle a lot to run their
business in more efficient manner.
Sum: Sum indicates the total number in a period. In the above gathered data the total
vaccination rate of the selected seven countries is 3161697555.00 and the infection rate is
203285457.00. This implies that countries are providing making lot of efforts to provide
vaccination to their people in order to reduce the spread of virus and enhance their economy
growth. If vaccination will be high, then citizen will operate their business without a fear of
being affected by virus. This will also help them to improve their business performance and
productivity. employment turnover will also reduce as well as trade restriction will become easy.
Mean: It is a statistical method which is used when investigator want to know the
average result. In the above result the average mean of seven different countries for the
vaccination rate is 395212194.38 and for infection rate it is 25410682.13. It implied that the
average means so high that almost each and every country is being affected which indirectly
affect the business performance of the company in greater sense. Almost all the seven country is
being affected by the pandemic which creates problem for them to function in more proper way
because majority of people are being infected by the virus so production at that time becomes
low.
Median: It is another central tendency which is used to calculate the middle number in a
series. In shorter term this is used to explained the higher and the lower half of the collected data.
In the above data the median for total vaccination is 146989594.00 and infection is 22137645.50.
This means that in France is at mid position in both providing vaccination to their people so that
they can improve their business performance and in infection rate also it is diving the other
countries.
8

Maximum: Maximum means the highest number in a series. From the above collected
data of seven countries the highest infection rate is of United States of America which is
79091857 and the higher vaccination rate is being provided by Austria which is 1805830502.00.
The above data indicates that in USA the spread of Covid 19 is so high that operating business in
that situation is very difficult and this affect their business performance as their sale and revenue
gets low. Austria is one of that country out of seven which provides highest vaccination so that
they can improve their economy in greater sense and start performing their business in sound
manner.
Minimum: Minimum means the lowest number in a series. With the above accumulated
information, it is being discussed that United Kingdom has the lowest vaccination rate as
compared to other nation. The vaccination status is 790396.00 till the end of year 2021. Talking
about spread of infection in Iceland the virus affects in minimum manner as till the end of year
2021 the century report has 177015.00 citizen of Covid 19. This means that the government is
following various measure to minimise the virus and start their business in better way in order t
improve their business productivity and performance in sound manner.
In addition to that it is also analysed that each and every country are putting their best efforts in
order to fight with the pandemic and enhance their economy by improving the business
performance and increasing productivity. It is also analysed that the impact of Covid 19 is
different in various country but all of them impact the business performance. In the existing
report there is no mode and count function for the above gathered data.
Conclusion
From the above assemble information from the WHO site it is concluded that impact of
Covid 19 is very negative for all the seven chosen country. The pandemic hit all the business of
the nation in greater way which majorly effect the overall business performance and
productivity. Covid 19 not only impact the organisation performance but the economies of the
countries are also fallen down. From the above data it is also summarised that to overcome from
the impact of pandemic vaccination is providing by the countries in greater sense. Thus, the data
will help in providing detailed information about the impact of Covid 19 on business and the way
they are working.
9

REFERENCES
Bahmanyar, A., Estebsari, A. and Ernst, D., 2020. The impact of different COVID-19
containment measures on electricity consumption in Europe. Energy Research & Social
Science. 68. p.101683.
de Jong, I.C. and van Riel, J.W., 2020. Relative contribution of production chain phases to health
and performance of broiler chickens: a field study. Poultry science. 99(1). pp.179-188.
Mahdy, M.A., 2020. The impact of COVID-19 pandemic on the academic performance of
veterinary medical students. Frontiers in veterinary science. 7. p.732.
Nehring, K. and Pivato, M., 2021. The median rule in judgement aggregation. Economic Theory,
pp.1-50.
Pokhrel, S. and Chhetri, R., 2021. A literature review on impact of COVID-19 pandemic on
teaching and learning. Higher Education for the Future. 8(1). pp.133-141.
Sarkodie, S.A. and Owusu, P.A., 2021. Impact of COVID-19 pandemic on waste
management. Environment, development and sustainability. 23(5). pp.7951-7960.
Tang, K.S., and et. al, 2022. Affordances of physical objects as a material mode of
representation: A social semiotics perspective of hands-on meaning-making. International
Journal of Science Education. pp.1-22.
Tosti-Kharas, J. and Michaelson, C., 2021. To mean is to be perceived: Studying the meaning of
work through the eyes of others. Academy of Management Perspectives. 35(3). pp.503-
516.
Usmonov, A.Q. and Usmonova, U.B., 2020. LINGUOPRAGMATIC CHARACTERISTICS OF
THE UZBEK LANGUAGE EQUIVALENT. Theoretical & Applied Science. (5). pp.855-
858.
Zhang, T., Gerlowski, D. and Acs, Z., 2022. Working from home: small business performance
and the COVID-19 pandemic. Small Business Economics. 58(2). pp.611-636.
10