CIPD Data Analysis Report: Brexit Impact on UK Labour Market (2024)

This report provides a comprehensive analysis of data gathered by YouGov plc. for the Adecco group, focusing on the UK labor market across various sectors including healthcare, education, and manufacturing. The analysis addresses the UK government's need for information on the impact of Brexit on the labor market, future hiring plans, and the employment of EU nationals. The report examines key questions related to recruitment, redundancies, flexible working arrangements, and the representation of EU nationals in different job functions. The findings reveal insights into current hiring trends, the prevalence of flexible working, and the financial performance of organizations. The report concludes with recommendations to the government regarding the potential effects of Brexit on the labor market, drawing conclusions from the data analysis and providing a detailed overview of employment trends and future projections.

CIPD DATA ANALYSIS report
and excel file
1

Table of Contents
a) Explore data provided in order to gain an understanding of the information required by the
Government.................................................................................................................................3
b) Questions to be analysed for info required..............................................................................3
c) Analysis of data......................................................................................................................4
d) Findings.................................................................................................................................10
e) Recommendations to the Government about the possible impact of Brexit.........................15
REFERENCES..............................................................................................................................17
2

a) Explore data provided in order to gain an understanding of the information required by the
Government
Data and info is highly useful for government as well as companies. This is because it
provides insight about many things. The government requires data in order to take effective and
relevant decisions. On basis of data government is able to take relevant measures and develop
strategies. Similarly, here, the data is gathered by Yougov plc. For Adecco group. In the data
there are 5 categories of industry that is health care, education, private and public sector and
production (Bassily, Nissim,, and Ullman, 2021). So, the data emphasis on labour market in all
sectors. Thus, a survey has been conducted in which several questions are asked related to
employees working, future planning of hiring, etc.
Thus, here UK government need info about what will be impact of brexit on labor market
in UK. Apart from that, gov want to know what are future plans regarding hiring of employees in
future by companies operating in different sectors like health care, education, etc. along with it,
gov also want info that how many diversified people of various countries of EU are employed in
companies in UK. Furthermore, the info is also obtained regarding how many of non UK people
are working at what positions in organizations. Besides that, if there any plan of firm to recruit
people from EU nations or not after brexit and to how much proportion.
b) Questions to be analysed for info required
It is important and identify the questions which is to be analyzed. This is because there are
many questions give in data (Cui, Jing, and Chen, 2021). Also, the question selected must
provide useful outcomes. hence, if questions selected are no proper than no proper and relevant
outcomes is obtained. Thus, from present data the questions selected for analysis are as below :
Q1. Is your organisation planning to recruit employees in the next THREE months?
Q3. Is your organisation planning to make any redundancies during the next THREE months?
Q4. Thinking about the next THREE months, what will be the overall effect of recruiting new
staff and/or making redundancies?
WA1. Which of the following flexible working arrangements, if any, does your organisation
offer? Please select all that apply.
3

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.
M7. Compared to the rest of your workforce, do EU nationals have a particularly large
representation in particular occupations or functions?
CO3. Comparing your organisation to your peers and competitors within the UK, how would you
rate your profitability/financial performance?
CO6. Which of the following best describes your organisation?
CO5. Which of the following best describes the region(s) in which your organisation operates?
c) Analysis of data
Q1. Is your
organisation
planning to
recruit
employees
in the next
THREE
months?
Manufacturing
and
production
Education Healthcare
Private
sector
services
Public
administration,
police and
defence
Yes 96 88 113 355 83
No 191 67 43 627 23
Don't know 39 16 7 116 19
4

Interpretation- from above chart it can be analysed that in production sector 96 firms said yes
they are planning to hire new employees in next 3 months. 191 said no and 39 said don’t know.
In education industry 88 said yes, 67 said no and 16 said don’t know. Moreover, in health care
sector 113 firms said yes 43 said no and 7 said don’t know. In private sector firms 355 said yes
627 said no and 116 said do not know and in public industry 83 business said yes 23 said no and
19 do not know. Hence, most firms are planning to hire staff in future.
Q3. Is your
organisation
planning to
make any
redundancies
during the
next THREE
months?
Manufacturing
and
production
Education Healthcare
Private
sector
services
Public
administration,
police and
defence
Yes 82 31 18 264 18
No 169 106 112 522 84
Don't know 76 33 33 313 22
5

Interpretation- By evaluating graph it is said that in manufacturing industry 82 said yes they
plan to make redundancy in next 3 months, 169 said no and 76 said do not known. In education
sector 31 firms said yes, 106 said no and in health care industry 18 said yes and 112 said no.
Furthermore, in private industry 264 said yes and 522 said no and in public sector 18 firms said
yes and 84 said no. Hence, it is stated that many firms are not in favour or make redundancy in
next 3 months. They will try to retain staff for long time.
6

M4. 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.
Manufacturing
and
production
Education Healthcare
Private
sector
services
Public
administration,
police and
defence
Yes 200 114 116 694 89
No 118 46 39 346 22
Don't know 8 11 7 58 13
7

Interpretation- It can be analysed from table that 200 companies in manufacturing sector yes
they currently employ EU nationals in UK. 118 said no. In education industry 114 firms said yes
and 46 said no. Furthermore, in health care sector 116 said yes and 39 said no while in private
industry 694 said yes and 346 said no. 89 firms in public companies said yes and 22 said no.
Here, it can be found that in many organisations operating in various industries there are large
number of EU national employ in UK.
M7. Compared
to the rest of
your
workforce, do
EU nationals
have a
particularly
large
representation
in particular
occupations
or functions?
Manufacturing
and
production
Education Healthcare
Private
sector
services
Public
administration,
police and
defence
Yes 53 35 37 210 14
No 128 73 61 381 65
Don't know 20 7 18 104 11
8

Interpretation – It can be stated from data that 53 firms said yes 128 said no that EU staff
represent large in specific functions in production industry. In education industry 35 said yes and
73 said no whereas in health care industry 37 said yes and 61 said no. In private sector 210
business said yes and 381 said no and in public 14 said yes 65 said no. Therefore, it is analysed
that EU staff is not highly employed in different functions. There are more UK employees than
EU staff.
CO6. Which
of the
following
best
describes
your
organisation?
Manufacturing
and
production
Education Healthcare
Private
sector
services
Public
administration,
police and
defence
A high-wage
organisation 70 27 26 227 17
A medium-
wage
organisation
194 116 95 596 86
9

A low-wage
organisation 46 14 30 228 9
Don't know 17 14 11 48 13
Interpretation- From graph it is found that in manufacturing industry 70 companies said they
are high wage firms, 194 said medium wage and 46 said low wage. Also, in private sector 227
said high wage, 596 said medium and 228 said low. Besides, in health care 26 said high, 95 said
medium and 20 said low. Thus, in all industry most organisation said they offer medium wage to
staff. It is based on their skills and knowledge. Therefore, they are known as medium wage
organisation.
d) Findings
WA1. Which of the following flexible working arrangements, if any, does your
organisation offer? Please select all that apply.
Manufacturing
and
production
Education Healthcare
Private
sector
services
Public
administration,
police and
defence
Flexi-time 117 59 84 451 106
10

Annualised
hours
contract
27 44 43 119 35
Term time
working 21 106 42 143 66
Jobsharing 54 84 68 228 89
Zero-hours
contract 33 38 46 229 19
On-call
working 37 15 52 126 39
Working
from home
on a regular
basis
134 64 72 507 94
Home
working
(always
working
from home)
68 25 39 311 53
Part-time
hours 163 123 119 704 105
Compressed
hours (e.g.
4.5 day
week, 9 day
fortnight)
68 58 66 267 89
Career
breaks 61 53 49 314 83
Other 2 - 3 9 -
None of
these 51 9 10 123 3
mean 64 57 53 272 65
median 54 56 49 229 75
mode 68 #N/A #N/A #N/A 89
range 161 114 116 695 103
SD 47.05561 34.6082 30.1424 190.1138 34.74441
Interpretation- It is interpreted from table that mean value obtained is 64 in production sector,
median is 54 and SD is 47. In education mean is 57, median is 56 and SD is 34.6. Also, in health
care industry mean is 53 and SD is 30.1. the private sector mean is 272 and SD is 190.1 while in
public sector mean is65 and SD is 34.7.
11

CO3. Comparing
your organisation to
your peers and
competitors within
the UK, how would
you rate your
profitability/financial
performance?
Manufacturing
and
production
Education Healthcare
Private
sector
services
Public
administration,
police and
defence
Well above average 48 16 8 134 8
Above average 131 53 65 440 35
Average 102 62 55 352 33
Below average 22 13 10 87 8
Well below average 8 2 2 17 4
Don't know 15 25 22 69 36
Net: Above average 179 70 74 573 43
Net: Below average 31 14 12 105 12
mean 67 32 31 222 22
median 40 21 17 120 23
mode #N/A #N/A #N/A #N/A 8
range 171 68 72 556 39
SD 62.94215 25.84259 28.86916 204.4913 15.77464
Interpretation- by evaluating data it is said that mean of manufacturing industry is 67 and SD is
62.9 while in private sector mean is 222 and median is 204. The public sector mean is 22 and SD
is 15.7. However, in health care industry mean is 31 and SD is 28.8.
12

CO6. Which
of the
following
best
describes
your
organisation?
Manufacturing
and
production
Education Healthcare
Private
sector
services
Public
administration,
police and
defence
A high-wage
organisation 70 27 26 227 17
A medium-
wage
organisation
194 116 95 596 86
A low-wage
organisation 46 14 30 228 9
Don't know 17 14 11 48 13
mean 82 43 41 275 31
median 58 21 28 228 15
mode #N/A 14 #N/A #N/A #N/A
range 177 102 84 548 77
SD 77.90753 49.21636 37.24245 230.2772 36.64583
Interpretation- the table state that mean of production industry is 82 and SD is 77.9. In education
sector mean is 43, median is 21 and mode is 14. Furthermore, in private industry mean is 275
and SD is 230.2. the public sector mean is 31 and SD is 36.6.
13

Q4. Thinking
about the next
THREE
months, what
will be the
overall effect
of recruiting
new staff
and/or making
redundancies?
Manufacturing
and
production
Education Healthcare
Private
sector
services
Public
administration,
police and
defence
Maintain total
staff level 168 114 74 481 69
Increase total
staff level 45 21 70 174 37
Decrease total
staff level 85 30 9 299 8
Don't know 29 7 10 144 11
Promoters 45 21 70 174 37
Detractors 85 30 9 299 8
Net
Employment
Score
-39 -9 60 -125 30
mean 60 31 43 207 29
median 45 21 60 174 30
mode 45 21 70 174 37
range 207 123 65 606 61
SD 63.4106 39.2974 31.90835 186.3571 22.11227
Interpretation- the data shows that mean of education industry is 31 and SD is 39.2 whereas in
health care sector mean is 43 and SD is 31. The private sector mean is 2017 and SD is 186.3. In
public mean is 29 and SD is 22.1.
It is found by analyzing data that there are many EU national working in EU. The firms
in private and health care sector are planning to hire staff in next 3 months. But in production
and education industry companies will not hire staff. But in all industries there is plan to reduce
staff. It is because brexit will impact on economic growth in negative way so revenue will
decrease. Therefore, firm will not be able to pay salaries to them. Besides that, brexit will change
14

work policy for EU nationals in UK. Along with it, firms want to emphasis on hiring local from
UK after brexit (Kumar, Shenbagaraman, and Ghosh, 2021). Moreover, there are many EU
nationals who are at high position in various organization. Hence, brexit may led to making it
difficult for them to work in UK. Furthermore, there are various flexible arrangement which firm
offer such as term time working, WFH, flexible working, etc. The firms in private industry rated
their financial performance as above average. But in education sector firm rated their
performance as average and net above average. After 3 months the effect of hiring or reducing
staff will have negative impact. There will be decrease in total staff level in private and
production industry. And in public sector staff level will be maintained. In all industry most
organisation said they offer medium wage to staff. It is based on their skills and knowledge. It is
for both UK and EU nationals. There is no discrimination which is done by firms.
e) Recommendations to the Government about the possible impact of Brexit
It is necessary for UK government to take certain measures in order to minimize impact of
brexit on businesses. For that they need to take certain recommendations by which are as
follows:-
 The UK government should ease restrictions related to visa for EU people. In that they
can make it flexible rules and regulations so that people can easily get visa. This will
allow people outside EU to work in UK. So, in this way brexit impact can be minimized.
The government can provide some relaxation to employees working in UK by which they
do are not forced to leave UK (Ling, and Vieu, 2021).
 The government must set minimum wage of employees who are working in UK. This law
need to be adhere by all companies operating in various sectors. Hence, it will help to
minimize impact of brexit on labor market.
 The companies should hire staff on basis of their skills and knowledge. They must allow
EU nationals as well to work in different functions. It will enable in not making any
redundancy in staff in firm.
 The firms can provide high salary to EU nationals to retain them. In this way companies
can attain goals and develop positive culture. It also results in working in effective way
with UK staff as well.
15

16

REFERENCES
Books and journals
Bădescu, C. and O'Donnell, R., 2021, June. Improved quantum data analysis. In Proceedings of
the 53rd Annual ACM SIGACT Symposium on Theory of Computing (pp. 1398-1411).
Bassily, R., Nissim, K., and Ullman, J., 2021. Algorithmic stability for adaptive data
analysis. SIAM Journal on Computing, (0), pp.STOC16-377.
Cui, Z., Jing, X., and Chen, J., 2021. A new subspace clustering strategy for AI-based data
analysis in IoT system. IEEE Internet of Things Journal.
Kumar, M., Shenbagaraman, V. and Ghosh, A., 2021. Predictive data analysis for energy
management of a smart factory leading to sustainability. In Innovations in electrical and
electronic engineering (pp. 765-773). Springer, Singapore.
Ling, N. and Vieu, P., 2021. On semiparametric regression in functional data analysis. Wiley
Interdisciplinary Reviews: Computational Statistics, p.e1538.
17