BSS004-1: Brexit Impact on UK Recruitment - Data Analysis

This report analyzes the impact of Brexit on UK organizations' recruitment processes, focusing on the public and private sectors. It examines data related to hiring plans, redundancies, and the employment of EU nationals, drawing on survey data collected by YouGov plc. for the CIPD and The Adecco Group. The report addresses questions about the extent of redundancies, the overall effect of recruiting new employees, and the employment of individuals from various groups. It presents data findings, interpretations, and recommendations regarding the impact of Brexit on UK organizations' recruitment, selection, and overall headcount, considering factors like culture, sales, and performance. The report also explores the government's need for this data to understand the implications for recruitment policies and future planning.

Using data to build with this
practices
1

Contents
INTRODUCTION...........................................................................................................................3
TASK...............................................................................................................................................3
Understanding of information needed by government................................................................3
Questions to provide information needed....................................................................................3
Data findings................................................................................................................................4
Recommendations........................................................................................................................9
CONCLUSION..............................................................................................................................10
REFERENCES..............................................................................................................................12
2

INTRODUCTION
Data analysis is effective method our process of cleaning, transforming and Modifying data to
discover a useful information for the organisation decision- making. The main purpose of data
analysis is to extract useful information from the raw data and take decisions upon it.
This report will analyse public and private sector on the basis of provided data and it will try to
identify useful information that can be helpful and required by the government. this report will
select few questions to analyse and provide the information required and also analyse the data for
the questions that are selected by using the statistics and data analysis. It will also the findings
from interpretation he then the whole Research. In the end of this report well provide
recommendation on impact of Brexit on United Kingdom organisations recruit demand and
selection process on the basis of above research.
TASK
Understanding of information needed by government
The data is based on companies who are operating their business in private and public sector.
After the Brexit companies impacted both negatively and positively and on the basis of Brexit
government require data related to the future hiring plans off public and private sector
(Georgiadou, Angelopoulos. and Drake., 2020). It will also analyse how this stuff will affect
from the Brexit on the basis of culture, sales and performance. Government required this data to
identify the Impact of recruitment policies and what changes will be required for the future
plans.
Questions to provide information needed
It is necessary for the researchers to collect information from the given Excel data. they need to
select some of the questions so useful information can be obtained. Then for obtained must be
accurate and useful for government to analyse the impact of Brexit on United Kingdom an both
private and public sectors on the basis of recruitment policies. As per the Excel sheet there are
various questions given in the file So it is required to select some of these specific questions that
can provide enough information. here are some of the selected questions –
Q3a. To what extent will these redundancies affect your overall headcount over the next
three months
QE1. In the past three years, has your organization employed people from any of the
following groups? Please tick all that apply ?
3

Q4- Thinking about the next three months what will be the overall effect of recruiting new
employees or making redundancies ?
QM4- Does your organisation currently employ any European Nationals have a
particularly large representation in particular occupation or functions ?
QM4. Does your organisation currently employ any EU nationals in the UK? EU nationals
are people working in the UK who are citizens of another country in the European Union,
including the Republic of Ireland
Data findings
Q3a. To what extent will
these redundancies
affect your overall
headcount over the next
three months? Total
Private
sector
Public
sector
Third/
voluntary
sector
Private
sector
SME
(2-249)
Private
sector
large
(250+)
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
4

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
/
Interpretation- with the help of the above tabel and diagram it is very much clear that the to a
great extent the redundancies will affect the overall headcount for the next three years (Kotu and
Deshpande, 2018). This is particualrly because of the reason that when the perosn is working in
effectvie manner then this will result in effectvie redundancies and will result in affecting the
headcount of the people. With thw above graph it is evident that the out of the total the
maximum paticipant agrees to the fact that this redundancy will affect the working up to 0.01%
to 10%. This is particularly because of the reason that if the employees will not be present in the
proper and enough numbers than this will demotivate the employees and they will not work in
effective and efficient manner.
Q4_rc. Thinking about the
next THREE months_, what
will be the overall effect of Total
Privat
e
sector
Publi
c
secto
Third/
voluntary
sector
Privat
e
sector
Privat
e
sector
5

recruiting new staff and/or
making redundancies? r
SME
(2-
249)
large
(250+)
Unweighted base 1041 658 289 94 256 402
Base 1063 748 241 75 230 517
Maintain total staff level 370 219 118 33 55 164
Increase total staff level 353 245 83 25 82 163
Decrease total staff level 300 255 29 16 87 168
Don’t know 41 29 11 1 5 24
Promoters 353 245 83 25 82 163
Detractors 300 255 29 16 87 168
Net Employment Score 53 -10 54 10 -5 -5
mean 430 294 104 33 98 196
median 353 245 83 25 82 164
mode 353 245 83 25 82 163
maximum 1063 748 289 94 256 517
minimum 41 -10 11 1 -5 -5
Interpretation- with the help of the above data it is very much clear that for the next three month
is the recrutiment of new staff will take place making the redundancies then this will result in
maintaining the total staff level witihn the company (Murphy, 2019). This is pertianing to the
fact that when the required number of the employees are being present witihn the company
whether be it private, public or third sector the required number of employees must be placed. In
addition to this the average number of people states that recruiting people at right position will
increase the toal staff level as the employees are being placed at the right position and this will
motivate them in effectvei manner in ordr to improve thr working of the company. Hence, it is
advisable to the government that they mmust provide option of recruting to the employees in
such a manner that they must improve the working of the company in such a manner that it
increases the productivity and profitability of the company to a great extent (Caldera, Desha and
Dawes, 2018).
QE1. In the past three years,
has your organization
employed people from any of
the following groups? Please
tick all that apply. Total
Privat
e
sector
Publi
c
secto
r
Third/
voluntary
sector
Privat
e
sector
SME
(2-
249)
Privat
e
sector
large
(250+)
Unweighted base 2053 1433 427 193 781 652
6

Base 2053 1560 349 144 708 852
People aged 50-64 1393 1024 257 112 397 627
People aged 65 and above 657 467 128 62 139 328
People with a disability or long-
term health condition 962 656 216 91 176 479
People from a Black, Asian or
minority ethnic background 1197 853 247 98 238 615
People aged 19-24 with few or
no qualifications 1167 883 207 77 306 577
People aged 16-18 with few or
no qualifications 641 477 121 43 133 345
Ex-offenders 300 206 69 25 44 162
Parents returning to the
workforce 1005 715 206 84 184 531
People returning to the
workforce after time out of the
labor market for reasons other
than having a child, for example
because of other caring
responsibilities or a health
condition
722 500 159 63 91 409
War veterans 388 269 98 21 41 228
None of the above 147 130 10 7 114 16
Don't know 172 136 32 5 22 114
Correlation
Total
Privat
e
sector
Public
sector
Third/
voluntary
sector
Privat
e
sector
SME
(2-
249)
Priva
te
secto
r
large
(250+
)
Total 1
7

Private
sector
0.9974
3 1
Public sector 0.9829
87
0.9676
67 1
Third/
voluntary
sector 0.9725
06
0.9547
04
0.9901
38 1
Private
sector SME
(2-249) 0.9447
5
0.9477
42
0.9081
34 0.917399 1
Private
sector large
(250+) 0.9460
94
0.9480
15
0.9261
74 0.892344
0.7969
49 1
Interpretation
On the basis of about data it is showing that the people who are having the age group of 50 – 54
Total recruited by the all the sectors around 1393. among all private sector recruit 1024, public
sector 257, 3rd sector 112 and private sector SMEs around 397 and 627 from the private sector
large. among the old data total 1005 employees return back to workplace. and the private sector
around 715, 206 and private, voluntary sector 84, private last sector 184 and 531 and public large
sector (Andreouli, and Nicholson., 2018). This is particularly because of the reason that if the
employees will not be present in the proper and enough numbers than this will demotivate the
employees and they will not work in effective and efficient manner. The correlation is this
statistics that measures the degree to which two variables move in relation to each other and
figure the correlation can measure the moment of any stock variable or anything
QM4. Does your
organisation currently
employ any EU
nationals in the UK? EU
nationals are people
working in the UK who
are citizens of another
country in the European
Union, including the
Republic of Ireland. Total
Privat
e
sector
Public
sector
Third/
voluntary
sector
Private
sector
SME
(2-249)
Private
sector
large
(250+)
8

Unweighted base 2053 1433 427 193 781 652
Base 2053 1560 349 144 708 852
Yes 1317 978 256 84 273 705
No 626 508 68 50 415 93
Don't know 110 74 26 10 19 55
Interpretation
On the basis of our data or graphical representation it can be analyse that the around 978 private
companies said they employed European nationalist in United Kingdom and currently they are
working in their company. Whereas the public sector said that they are having around 256 he
employs who are employed from the around And 68 said no. in a private small medium
enterprise 273 form said that they have employed and 415 said no they do Moreover in the large
private sector companies sad yes and the number was 705 and 93 among them said no that they
do not employed employees from the euro from the United Kingdom Pens in major private
companies there are huge number of European nationalist being employed as compared to the
public sectors the people come from the other country and they are working in the United
Kingdom and getting paid by the companies.
Recommendations
Brexit has huge impact on the government policies and their procedures and mostly on
businesses. but it can also have some positive impact as well (Carreras, Irepoglu Carreras and
Bowler., 2019). After the Brexit the UK government we’ll have more freedom on making
9

decision on their trades and available to make their own regulations. this will be helpful for them
in gaining sovereignty Is seen as will situation for the UK as well As for who opted to stay in
United Kingdom. Sovereignty Was one of the biggest benefits for the people who are brexiters
becausr now they will not be required to give up some are other kind of control over some
domestic affairs. This will be further help in United Kingdom to reduce arrival of the number I
will migrants in UK as they will beginning complete control of their own borders as well as
eventually we reduce the problem of immigration that were faced by United Kingdom. Other
country people from Europe will not able to enter in the United Kingdom without having a visa
my permission from the government. they will require a visa to arrival in United Kingdom. This
will result in bringing the improvement in housing and services needs of localities and people
will get space to leave which is an advantages for the government. another biggest benefit Will
be financially becausr European government contributing European countries budget in 2016
was approximately 13.1 billion pound but they only received £4.5 billion worth of spending
within their country which was less as per the expectation. Now they can sail the other money
and spend on their own infrastructure.
The proposed new immigration system by the organisations
In order to work in the United Kingdom or continue in operating within the you get it is
necessary for the organisation to have a visa or licence organisation will be required to hold the
immigration sponsor licence which will be valid for only four years of time. this is because if
they want to sponsor individual for work visa, they themselves need to have the sponsor licence.
once they get the licence they can apply for the certificate of Spencer to individuals. this will also
be helpful for the organisation further in paying their employees Minimum wages. Before this
the organisations will needed to pay fees to the government in order to obtain the visa. these fees
will be worrying from type and the size of company and according to it they have to require to
pay fees to the government as compared (Brophy., 2018). This will directly handy companies too
re maintaining their goods and shape and there will be also able to continue the recruitment
essentially an talent Labour or employees for their necessary important business operations and
that employees were able to get the salaries After the Brexit the UK government we’ll have
more freedom on making decision on their trades and available to make their own regulations.
this will be helpful for them in gaining sovereignty Is seen as will situation for the UK as well As
for who opted to stay in United Kingdom. Sovereignty Was one of the biggest benefits for the
10

people who are brexiters becausr now they will not be required to give up some are other kind of
control over some domestic affairs.
CONCLUSION
As per the report has been analysed public and private sector on the basis of provided data and it
has been tried to identify useful information that can be helpful and required by the government.
this report has been selected few questions to analyse and provide the information required and
also analyse the data for the questions that are selected by using the statistics and data analysis. It
also has been covered findings from interpretation he then the whole Research. In the end of this
report has been provided recommendation on impact of Brexit on United Kingdom organisations
recruit demand and selection process on the basis of above research.
11

REFERENCES
Books and journals
Georgiadou, E., Angelopoulos, S. and Drake, H., 2020. Big data analytics and international
negotiations: Sentiment analysis of Brexit negotiating outcomes. International Journal of
Information Management, 51, p.102048.
Andreouli, E. and Nicholson, C., 2018. Brexit and everyday politics: An analysis of focus‐group
data on the EU referendum. Political Psychology. 39(6). pp.1323-1338.
Carreras, M., Irepoglu Carreras, Y. and Bowler, S., 2019. Long-term economic distress, cultural
backlash, and support for Brexit. Comparative Political Studies. 52(9). pp.1396-1424.
Brophy, K., 2018. The Brexit hypothesis and prehistory. Antiquity. 92(366). pp.1650-1658.
Caldera, H.T.S., Desha, C. and Dawes, L., 2018. Exploring the characteristics of sustainable business
practice in small and medium-sized enterprises: Experiences from the Australian manufacturing industry.
Journal of Cleaner Production, 177, pp.338-349.
Kotu, V. and Deshpande, B., 2018. Data science: concepts and practice. Morgan Kaufmann.
Murphy, R.H., 2019. Ben Lindbergh and Travis Sawchik, The MVP Machine: How Baseballs New
Nonconformists Are Using Data to Build Better Players. The Review of Austrian Economics, pp.1-4.
12