Impact of Covid 19 on Business Performance: Statistical Analysis

This report analyses the impact of Covid 19 on business performance of various countries using statistical techniques like mean, median, mode, sum and Excel AutoSum features. Data is collected from the site of World Health Organisation in order to get infection rate and death rate of humans in different countries.

DHICT Assessment

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

INTRODUCTION
Covid 19 pandemic is the biggest shock that has affected economy of the various country.
Global pandemic has a greater impact on business performance and productivity. There is a
negative impact of Covid 19 on the productivity of the business. When the cases of Covid 19
rises in the world a complete and strict lock down was announced which affect various industry.
Various restriction was imposed on trading as well as international travelling was also banned
which affect the hospitality industry in huge manner (Gopalan and Misra, 2020). Human life is
not only affect by the Covid 19 but also the operation of the organisation is being impacted. The
effect of pandemic on businesses are high employee turnover, lower production, market sale
were low, purchasing power decreases in greater sense. In this report information that would be
gathered will be analysed in order to see the impact of Covid 19 pandemic on business
performance of various countries (Girdhar and et. al, 2021). The data will be evaluated various
stastical formula like mean, median, mode, sum which will be applied so that a proper data
analysis can be done. For this report data will be gathered from the site of World health
organisation in order to get infection rate and death rate of human in different countries. The
information is collected from the year 2022.
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 79139385 31.81
India 43016372 17.29
Brazil 29729991 11.95
France 23903547 9.61
The United Kingdom 20613821 8.29
Germany 19893028 8.00
Russia 17715390 7.12
Turkey 14760331 5.93

Table of death rate with percentage
Country Total death cases Total death cases in Percentage
United States of America 967905 31.86
India 516755 17.01
Brazil 657998 21.66
France 138273 4.55
The United Kingdom 164282 5.41
Germany 128110 4.22
Russia 366618 12.07
Turkey 97598 3.21
Application of statistical technique and Excel AutoSum features
Country Total infection cases Total death cases
United States of
America 79139385 967905
India 43016372 516755
Brazil 29729991 657998
France 23903547 138273
The United Kingdom 20613821 164282
Germany 19893028 128110
Russia 17715390 366618
Turkey 14760331 97598
Sum 248771865 3037539
Mean 31096483.13 379692.375
Median 22258684 265450
Maximum 79139385 967905
Minimum 14760331 97598

Charts of data with labelling
Figure 1: Chart of total infection rate in countries
Figure 2: Graph of total death case

Figure 3: Graph of percentage of total infection in a country
Figure 4: Graph of death in percentage

Findings and analysis
There is a negative and very huge impact of Covid 19 on various countries. It becomes
impossible for the nation to control the situation at fast pace. Covid 19 not only affect the life of
human but also its impact were seen on various business sector. Covid 19 has a negative impact
on the business performance. Various sector like retail, entertainment, fast food, hospitality were
seen a downfall in their business performance. Almost each and every department of the
different organisation is being affected by global crisis (Song and Zhou, 2020). The legal
authority of the countries put various restriction in order to reduce the spread of the virus and
save their economy. Some of the rules are limiting export and import, international travelling
was banned. A complete lockdown was imposed which affect the business productivity of the
country. The major problem that were encounter by the companies are improper supply chain
management, high employee turnover, limited income and sale and many more. All this affect
the business performance and productivity in greater sense. It becomes very difficult for the
companies to market their product in huge amount and earn profit out of them.
Data interpretation:
In this report data is collected for seven different countries in the form of infection rate
and death rate which is putted in excel to analyse the data. The seven countries which is chosen
are United States of America, India, Brazil, France, The United Kingdom, Germany, Russia and
Turkey. For evaluating and analysing information different statistical technique is being selected
some of them is mean, median, mode. Other excel function is also used in this report which are
sum, maximum, minimum and percentage.
Percentage: From the above table it is seen that high infection percentage is on United
state of America which indicate that Covid 19 impact a lot on America which affect their
business productivity. The death rate is also high in the country which is 31.86 percent. This
means that almost one fourth of the total infection population dies. it becomes were difficult for
the people of the country to do their business as the fear of risk was high inn the country as
compared to other nations. The infection rate is 79139385 and the death rate is 967905 in United
state of America.
Sum: Sum function is used in the Excel to calculate the total number in a series. From the
accumulated data from WHO it is seen that the total cases in seven countries are 248771865 and
the death rate is 3037539. It means that if the total number of cases in the sevn countires is so

high that performing business in such critically condition is quite impossible for the organisation.
As the number of cases increases the productivity decrease, because employee wants to save
them for the caught of virus. It is very important for the government to safe their citizen and for
that they applied strict restriction which impact the various business.
Mean: Mean is used to denote the average of the series. It is calculated by dividing a
particular number of the series by the total of the series. In this report mean is calculated to know
the average number of infection rate and death rate of the seven countries. With the piece f
information it is found that the average infection rate of nation is 31096483 and the death rate
mean is 379692. The average is quite high which means operating business in such situation is
very risky for the companies.
Median: This is another aspect of central tendency which is used to divide the column in
upper and lower part. In the above collected information it is seen that the median of infection
rate is 22258684 and death rate is 265450. This means that if counties reduced their infection
rate and death rate from the above value then they will perform their business in more effective
and efficient manner. To improve the business performance and productivity they need to take
proper measure so employee feels safe while working in the organisation.
Maximum: Maximum function is used to know the highest number of the data. From the
assemble data of seven countries the highest number of cases is in United state of America and
the death rate is also high in that country. So the nation were business are largely impacted is
United state of America.
Minimum: Minimum refers to lowest number in a series. With the above accumulate
data; it is being fin that turkey has the lowest infection rate as compared to other nation. The
infection rate is 147660331 and also the death rate is also low which is 97598. So doing business
i that nation is quite easier as compared to other if they put effective measures to overcome from
Covid 19 pandemic and enhance their business performance. If government put ore efforts of
turkey them business can come back to the original track before Covid 19.
In this report count ad mode function is not applied because there is no need of the two function.
It is also analysed that impact of Covid 119 pandemic was worst for the companies and economy
of nation

CONCLUSION
From the above accumulated data from the WHO site it is concluded that impact of Covid
19 on business performance are so worse. The pandemic hit the entire nation in greater way
which hugely impact their business performance and productivity. Covid 19 has fallen down the
economy of the countries in just two year. From the data it is also concluded that if any Crisis
occur in the business impact a lot and it becomes very difficult to take measure. The above data
summarised that the infection rate was so high that it not only impact the people but indirectly its
impact was largely on the business operation. The information helps in gaining detailed insight
of Covid19 and how it impacts the working of organisation.

REFERENCES
Becker, L.T. and Gould, E.M., 2019. Microsoft power BI: extending excel to manipulate,
analyze, and visualize diverse data. Serials Review. 45(3). pp.184-188.
Canela, M.Á., Alegre, I. and Ibarra, A., 2019. Summary Statistics. In Quantitative Methods for
Management (pp. 3-11). Springer, Cham.
Girdhar, A., and et. al, 2021. Effect of COVID-19 outbreak on urban health and environment. Air
Quality, Atmosphere & Health. 14(3). pp.389-397.
Goel, R.K., Saunoris, J.W. and Goel, S.S., 2021. Supply chain performance and economic
growth: The impact of COVID-19 disruptions. Journal of Policy Modeling. 43(2).
pp.298-316.
Gopalan, H.S. and Misra, A., 2020. COVID-19 pandemic and challenges for socio-economic
issues, healthcare and National Health Programs in India. Diabetes & Metabolic
Syndrome: Clinical Research & Reviews. 14(5.pp.757-759.
Kiesslich, T., and et. al 2021. Citation inequality and the Journal Impact Factor: median, mean,
(does it) matter?. Scientometrics. 126(2). pp.1249-1269.
Song, L. and Zhou, Y., 2020. The COVID‐19 pandemic and its impact on the global economy:
what does it take to turn crisis into opportunity?. China & World Economy. 28(4). pp.1-
25.
Steinke, A. and Kopp, B., 2020. RELEX: An Excel-based software tool for sampling split-half
reliability coefficients. Methods in Psychology. 2. p.100023.