University Statistics and ICT Skills: COVID-19 Impact Analysis Report

This report provides a comprehensive analysis of the impact of COVID-19 in the United Kingdom, utilizing statistical data and ICT skills. The report is divided into three tasks: Task 1 examines the pandemic's effects on various aspects of life in the UK, including healthcare, the economy, and social interactions. Statistical tools such as line charts, pie charts, and bar charts are used to visualize and interpret the data related to death rates, hospital admissions, and unemployment figures. Task 2 focuses on basic statistical operations and formulas using Excel, including calculations of total, average, minimum, and maximum GDP for several countries. Finally, Task 3 discusses online learning, exploring its advantages and disadvantages. The report concludes by summarizing the key findings and the overall impact of the pandemic.

Basic Statistics and ICT skills

TABLE OF CONTENTS
Basic Statistics and ICT skills....................................................................................................1
INTRODUCTION...........................................................................................................................3
MAIN BODY..................................................................................................................................3
TASK-1............................................................................................................................................3
Impact of COVID-19 in the UK within using statistics and commenting on the line chart........3
Analysing the impact of the COVID-19 on healthcare in UK within using pie chart.................5
Identifying the impact of COVID-19 on the economy in the UK within using bar chart...........6
Discussing on the influence of COVID-19 on social life............................................................7
CONCLUSION................................................................................................................................9
TASK-2..........................................................................................................................................10
TASK-3..........................................................................................................................................13
REFERENCES................................................................................................................................1

INTRODUCTION
Business statistics is the process of application of statistics in order to analyze the data of
the business (Kim, 2020). Different companies use these statistics for testing correlations,
analysing data and forecasting. It is believed to have good maths skills to choose the business
statistics as a tool to describe the data. The following report is consisted of three tasks: Task 1
will explain about the impact of Covid-19 on the daily life in the United Kingdom in which it
will discuss the prevailing covid19 conditions in the country. Further, line chart will be used to
analyse the statistical data with proper comments of the line chart.
Impact of covid-19 on the healthcare and pie chart will show this data which will be
discussed in the following report. Moreover, it will highlight the impact of the pandemic on the
covid-19 along with unemployment figures in 2021. The report will highlight the impact of
COVID-19 pandemic on the social life of people with the help of relevant pictures. Task 2 will
be about basic operations, basic functions and formulas, and descriptive and graphs. Task 3 in
the report will be a discussion on online learning and pros and cons of online learning.
MAIN BODY
TASK-1
Impact of COVID-19 in the UK within using statistics and commenting on the line chart
COVID-19 has created the drastic impacts in the UK, whether it is about the lives of
people, economy of UK, healthcare team of UK or social lives of people, pandemic has been
proven drastic from all aspects. Death rates in the UK has been increased on a consecutive note
which has created the pressure on the healthcare department. In each part of the UK the impact
of variant was increasing that has resulted in the numerous death (Iacobucci, 2021). The
lockdown has been introduced in order to assure the safety to the people which has created
negative impact on the operations of business. Here is the description of the ratio related to
COVID death rate in UK within using below line chart.

Figure 1- COVID death in UK
It can be interpreted with the help of above line chart that, In London death rates was low
in January 2021. However, there was significant rise in the death rate of people by the July 2021
and then in the August total number of death rate was 8945. The situation is the North East was
drastic as the COVID deaths has increased on consistent note. The highest death which is up-to
16800 has taken place in the August 2021. Thus, the large number of death taken place in the
month of August. In the North West from January to July the death ratio was changed from 8000
to 16800. Whereas, in Yorkshire, In the June 2021 the death rate was high and it has decreased in
the February 2022. In the East Middles the death ratio was increasing on a fast note which has
not reduced till the end. There was total number of death 136014 has taken place in East middles.
Thus, the death rate was increasing on a drastic note in UK.

Analysing the impact of the COVID-19 on healthcare in UK within using pie chart
Figure 2- Hospital admission in UK
The above pie chart is stating the number of admissions which has taken place in the UK.
The large number of admission of COVID patient can be witnessed in The North East. 25%
admissions have been done at that time. In the North West and Yorkshire, the percentage was 24.
Whereas, in the East Midland it was 15% and in London it was 12%. Thus, this clearly depicted
that, the hospital admission in the UK was extremely high which indicates that, the COVID
patient has increased day by day.
The major pressure has been created on the healthcare team as the patient was increasing
on a high note. The pandemic has shown the vulnerabilities under the health system which has
profound implications in relation of the health progress. Healthcare workers was working in days
and night shift so the situation of the COVID can be handled (Gilleen and et.al., 2021). The
complexities were increasing which has often increased the mental health of the service
providers. Also, the resources in comparison of the emergencies were less which has also
created the drastic impact on the healthcare team as the emergencies was increasing.

Identifying the impact of COVID-19 on the economy in the UK within using bar chart
Figure 3- Unemployed data in UK
The GDP of UK has been decreased at the time of COVID-19 which states that, the economy has
faced instability during the time of COVID. The major issue was associated with the increasing
rate of unemployment in the UK. The negative impacts have been faced by the economy due to
the level of unemployment (Keogh-Brown and et.al., 2020). The safety of the people has been
prioritised due to which lock-down have been introduced which has resulted in lack of operations
and this has further resulted in lack of jobs and this was the major issue behind the increasing
rate of unemployment in UK. With the help of the above bar chart the unemployed data can be
seen and it can be identified that in UK the situation was worst.
The bar graph has depicted that in all parts of the UK, the rate of unemployment has been
increased after the COVID. In the London the ratio of unemployment was increased higher in
comparison of the other areas. In the North West and South West the situation was same. Thus,
after the pandemic there was large number of people who were unemployed in the UK. The
biggest issue was that, there was no jobs available for the people which has contributed in
making people unemployed in the UK. Thus, it can be said that, in UK the situation was worst at

the time of COVID. Large number of population has become unemployed and drastic situation
has been suffered by all of them.
From the bar chart it can be also identified that, during the COVID the unemployment was
high and in the Post COVID period as well the ratio was same or it has increased there was no
decrement has been seen at the time of pandemic and after the pandemic in the unemployment
ratio.
Discussing on the influence of COVID-19 on social life
The COVID has resulted in the loss of the human life in the worldwide. The large number of
challenges has been presented towards the public health and especially on the social lives of the
people. The public gathering has been banned by the government due to which people stayed at
their home. This has also created the pressure on the mind of the people and the cases related to
mental health has also been increased (He and Harris, 2020). The biggest impact in this context
was aligned with the restriction on the hospitality business. Before the pandemic people used to
visit different places however, due to pandemic there was banned over thus which has resulted in
disturbing the social lives of the people.

Figure 4- Public gatherings has been banned during COVID-19
People used to celebrate different functions together which has got restricted. It is highly
mandatory that social interaction among the people must be made so, they can feel socially
connected. However, the major threat has been created by pandemic is that social interaction
between the people was reduced and which has impacted the mental health of the people. Many
people died due to COVID and many has been died due to stress and anxiety (Mofijur and et.al.,
2021).
Thus, it can be said that there were large number of the social crisis has been developed
by the COVID-19. The social crisis such as- inequality, global unemployment, discrimination
and the exclusion has been faced by the people. Apart from the immediate impact on the health

of the people, the pandemic has increased the anxiety and stress level in the society and this has
resulted in impacting the social interaction among the people in the society. Hence, the social
interaction has been reduced due to the negative impacts has been created on the social lives of
the people.
CONCLUSION
Information and communication technologies are combination of different technological
tools and resources that are used to share, store, create and exchange information. It has been
concluded from the above report that COVID-19 has adversely affected the conditions in the
country of United Kingdom. The report followed with a discussion on the impact of COVID-19
on health, economic and social care. Different statistical data have been analysed in order to
highlight the impact of covid-19 in general and on employment, healthcare and on the overall
economy. Thus, pandemic has created negative impact on the economy, healthcare team and the
health of the people. Moreover, it has been summarized from the above report about the meaning
of online learning and the positives and negatives of online learning.

TASK-2
Figure 5Screenshot of solution
The above mentioned screenshot is showing the solutions which has been done in the excel
sheet. Major formulas have been used in order to find out the total, average, minimum,
maximum GDP of the countries (Canada, France, Germany, Italy, UK and US). Also the
difference between the Maximum and Minimum GDP has been calculated and test has been
conducted within using “IF” Function. Furthermore, the expected GDP 2021 has been calculated.
The GDP of the five consecutive years (2016-2020) has been used in order to perform the
calculations. Here is the description related to each calculation of the data that has done in the
excel.
Total- The total GDP of each country has been calculated within using the formula =SUM
(Number 1, number 2, number 3, number 4, number 5). With the help of this formula the total
GDP of each country of the last five years has been calculated. It has been done individually for
each country. For example- in order to calculate the total GDP of Canada, the GDP from 20-16-
2020 of Canada has been selected and in the G5 the total has been calculated within using
formula. Same has been done for identifying the total GDP of each country.
Average- The formula of average has been used in order to find out the average of GDP of five
years. The formula of average is =AVERAGE (Number 1, number 2, number 3, number 4,
number 5). In H5, the average GDP of Canada has been calculated, in H6 average GDP of

France has been calculated. In similar manner Average GDP of Germany, Italy, UK and US has
been calculated. Thus, with the help of this formula it has been identified that from the year
2016-2020, what was the average GDP in the selected countries.
Minimum- The minimum GDP in the last five years of the country has been calculated within
using formula-MIN (Number 1, number 2, number 3, number 4, number 5). For instance- in
order to know the minimum GDP from the 2016-2020 in UK, the GDP from the 2016-2020 has
been mentioned and in I9, the formula of calculating minimum of GDP has been used which is
MIN (B9:F9). In this manner, the Minimum GDP has been calculated which is 48542.1
Maximum- In order to calculate the maximum of the GDP, formula MAX (Number 1, number
2, number 3, number 4, number 5) has been used. This can be understanding within taking
example- For calculating the Maximum GDP in the last five years of Italy, in J8 the formula has
been put which “=MAX” and then the number has been selected from B8 to F8 and after
pressing the enter the value has been got which is up-to the 44397.6. This is the GDP of 2019.
Thus, this states that from year 2016-2020, in year 2019 Italy has the highest GDP.
Difference- In order to calculate the exact difference between the maximum and minimum GDP
of the countries, the formula of difference has been used. In the cell K4 the difference has been
find out for Canada. For instance, the formula =J5-I5 has been used and the difference has been
witnessed. In similar manner, difference has been find out for all countries.
Test- Within using “IF” Function it has been tested whether the difference between the
maximum and minimum GDP is bigger than 5000 or not. On the basis of this, “high” and “low”
has been identified. For conducting the test in context of Canada, formula
=IF(K5>5000,"High","Low") has been used. The difference is less than 5000 and therefore, the
outcome is low here. In case of Italy and UK also the outcome is low which depicts that, the
difference between the maximum and minimum GDP of both the countries is less than 5000.
However, for France, Germany and UK the outcomes are high which states that, difference
between maximum and minimum of GDP in these countries is High than 5000.

Expected GDP 2021- The expected growth rate for the year 2021 has been taken as 2% and on
the basis of this reference the expected GDP 2021 for all countries have been calculated. In M4
within using formula “=F5+(F5*$N$1)” the Expected GDP 2021 of Canada has been calculated
which is 49392.174. Same has been applied for calculating the Expected GDP 2021 for different
countries.
Thus, the above mentioned description is stating about the formulas and methods which has been
undertaken in order to find out the Total, average, minimum and maximum of the GDP (2016-
2020). Also, the information is highlighting the ways in which difference between the minimum
and maximum has been find out and test has been conducted. Lastly, expected GDP 2021 has
been calculated.
Bar chart
Figure 6- GDP across countries
Interpretation- The above bar chart is showing the total GDP of the Canada, France, Germany,
Italy, UK and US. From the chart it can be identified that, US has the highest GDP which is
estimated at 309790.98 and Italy has the lowest GDP which is 210111.17. After US the second