Analyzing Brexit's Impact on UK Organizations Using Data and ICT

This report examines the impact of Brexit on private, public, and SME organizations in the UK, focusing on data analysis and the use of ICT. The study explores the effects of Brexit on redundancies and overall business performance. Statistical techniques, including mean, median, and mode, are applied to a dataset to evaluate the extent of the impact. The report also addresses the communication of information through visual representations, such as charts and graphs. The analysis includes data on organizations' planning for employee recruitment and the potential impact on headcount over the next three months. The report references several academic sources, including journal articles and books, to support its findings and conclusions about the effects of Brexit on UK organizations.

Data Handling & Using ICT

Topic of understanding
 The research topic is related to the impact of Brexit on private and public
organization and SME of UK. As per selecting the topic in order to perform the
mathematical data and manage or control in proper manner (Vivaudou, 2019).
 the research topic is all about identify the any kind of planning redundancies during next
three months. These are directly affecting on the performance of Private and public
organization.

Statistical Techniques
 Mean- it is based on the concept in mathematics and statistics. The mean is that calculate
average or most common value in collection of numbers. In context of statistics, it can be
measured the central tendency of probability distribution among mode, median. For Data
set, the arithmetic means, also known as average (Dunbar, 2020).
 Median – it is basically define the middle number of group of numbers. That is half of
number have identified the values which become greater than median, half the number
have values that are less than median (Grech, 2018).

Cont..
 Mode- it is another kind of technique which may consider values that appears most
frequently in a large data set (Schmidt, Church and Riley, 2020). This the best technique is
helping to measure central tendency which include mean, middle value in set.

Data manipulation
Q3a. To what extent will
these redundancies affect
your overall headcount over
the next three months?
Private sector Public sector Third/voluntary sector Private sector SME (2-
249)
Private sector large
(250+)
It will affect 0.01% to 10% 118 32 14 24 95
It will affect 10.01% to 20% 64 11 5 19 45
It will affect 20.01% to 30% 53 5 3 21 32
It will affect 30.01% to 40% 22 4 1 12 10
It will affect by 40.01% to
50% 23 2 1 13 10
It will affect 50.01% to 60% 14 1 - 6 8
It will affect 60.01% to 70% 3 1 - 1 2
It will affect 70.01% to 80% 8 - - 4 4
It will affect 80.01% to 90% 3 - - 1 2
It will affect 90.01% to
100% 7 1 - 4 3
Don't know 45 6 - 4 41
mean 33 7 5 10 23
median 22 4 3 6 10
SD 33.59137 9.357113 4.833218 7.959609 27.43407
mode

Q3a. To what extent will these redundancies
affect your overall headcount over the next three
months?
Unweighted base 431 327 75 29 127 200
Base 446 362 60 24 110 252
It will affect 0.01% to 10% 164 118 32 14 24 95
It will affect 10.01% to 20% 80 64 11 5 19 45
It will affect 20.01% to 30% 60 53 5 3 21 32
It will affect 30.01% to 40% 27 22 4 1 12 10
It will affect by 40.01% to 50% 27 23 2 1 13 10
It will affect 50.01% to 60% 14 14 1 - 6 8
It will affect 60.01% to 70% 4 3 1 - 1 2
It will affect 70.01% to 80% 8 8 - - 4 4
It will affect 80.01% to 90% 3 3 - - 1 2
It will affect 90.01% to 100% 8 7 1 - 4 3
Don't know 51 45 6 - 4 41
sum Average count max Min
1189 198 6 431 29
1254 209 6 446 24
447 75 6 164 14
224 37 6 80 5
174 29 6 60 3
76 13 6 27 1
76 13 6 27 1
43 9 5 14 1
11 2 5 4 1
24 6 4 8 4
9 2 4 3 1
23 5 5 8 1

Q1. Is your
organisation
planning to
recruit employees
in the next
THREE months?
Private
sector
Public
sector
Third/voluntary
sector
Private
sector SME
(2-249)
Private
sector large
(250+)
Yes 532 217 63 150 382
No 869 94 70 498 371
Don't know 159 38 11 60 99

Communicate the information using Visual
Representations

Conclusions
 From above discussion, it has been summarized about the concept of statistical
technique or method that help for calculating the accurate result and outcome. It has been
chosen the large data set about the Brexit where different public and private of SMEs
perform significant operations in UK. As per analysis, it has summarized that select
appropriate data for sampling, present raw data on spreadsheet and perform the excel
functions such as mean, median and mode. Furthermore, it has been described the
communication of information in order to represent into the form of different charts.

REFERENCES
Book and Journals
 Dunbar, L., 2020. The Other Part of the Job: Rapid Data Analysis with Excel and
Sheets. General Music Today. 33(2). pp.83-86.
 Grech, V., 2018. WASP (Write a Scientific Paper) using Excel—1: Data entry and
validation. Early human development. 117. pp.98-103.
 Schmidt, P.J., Church, K.S. and Riley, J., 2020. Clinging to Excel as a security blanket:
Investigating accountants' resistance to emerging data analytics technology. Journal of
Emerging Technologies in Accounting. 17(1). pp.33-39.
 Vivaudou, M., 2019. eeFit: a Microsoft Excel-embedded program for interactive analysis
and fitting of experimental dose–response data. BioTechniques. 66(4). pp.186-193.

THANK YOU