CIPD Data Analysis: Impact of Brexit on Organisation

This CIPD data analysis report explores the impact of Brexit on organisations and the proposed new immigration system. It covers topics such as recruitment plans, flexible working arrangements, and the overall effect of recruiting new staff. The report provides valuable insights for decision-making.

Report
(CIPD data analysis)

Contents
INTRODUCTION...........................................................................................................................................3
ANALYSIS.....................................................................................................................................................3
Question 1...............................................................................................................................................3
Highlight interesting findings................................................................................................................12
Recommendation to government about the possible impact of Brexit and the proposed new
immigration system on organisation......................................................................................................13
CONCLUSION.............................................................................................................................................14
REFERENCES..............................................................................................................................................15

INTRODUCTION
The method of gathering, modelling, and evaluating data in order to extract information that
aid decision-making is known as data analysis. Depending on the sector and the goals of the
research, there are a variety of approaches and strategies for conducting it. Developing a broader
understanding of various data collection approaches, as well as qualitative and qualitative
processes (Billing, McCann and Ortega-Argilés., 2019). This would offer the data analysis
activities a more well defined path, so it's usually a good idea to soak up this specific expertise.
In addition, there will be able to generate a powerful analytics report which will speed up your
research. Fortunately, key facets of the potential construction, such as consumer entry, which
accounts towards 80% of either the U.K. market, currently unclear. This prevented a “no-deal”
Brexit that may have been costly for the domestic economy. This article is focused on a study of
the employers and employees after Brexit and how it affected both. In addition, make proposals
for the organization's immigration scheme.
ANALYSIS
Question 1
Sector Private sector
organisation size
Privat
e
sector
Publi
c
secto
r
Third/
voluntar
y sector
Private
sector
SME
(2-249)
Private
sector
large
(250+)
A B C J K
Q1. Does
the
organisati
on
planning
to recruit
employees
in the next
THREE
months? Mean
Mo
de
Media
n
Standard
deviatio
n
Unweighte
d base 1433 427 193 781 652 3486
#N/
A 652
468.426
3
Base 1560 349 144 708 852 3613
#N/
A 708 546.02
Yes 532 217 63 150 382 1344 #N/ 217 187.908

A 8
No 869 94 70 498 371 1902
#N/
A 371 328.261
Don't
know 159 38 11 60 99 367
#N/
A 60
57.6827
5
1 2 3 4 5
0
200
400
600
800
1000
1200
1400
1600
1800
1433
427
193
781
652
1560
349
144
708
852
532
217
63 150
382
869
94 70
498
371
159
38 11 60 99
Q1. Is your organisation
planning to recruit
employees in the next
THREE months?
Unweighted base
Base Yes
No Don't know
Interpretation: As according to graph above, however many businesses expect to hire
new employees over the next 3 months in various industries such as private and public sectors.
The average, modal method, medium values as well as standard deviation was used to determine
the outcomes (Brown, Liñares-Zegarra and Wilson,, 2019). Based on these findings, determine
which sectors intend to add new talent, while the United Kingdom faces several challenges
following Brexit.
QE1. In the
past 3
years, has
your
organisatio
n employed
people
from any of
the
following
groups?
Please tick
all that
Priva
te
sector
Publi
c
secto
r
Third/
volunt
ary
sector
Privat
e
sector
SME
(2-
249)
Private
sector
large
(250+)
Mean Mo
de
Media
n
Standard
deviation

apply.
Un-
weighted
base
1433 427 193 781 652
3486
#N/
A 652 468.4263
Base 1560 349 144 708 852 3613
#N/
A 708 546.02
People aged
50-64 1024 257 112 397 627 2417
#N/
A 397 356.9066
People aged
65 and
above
467 128 62 139 328
1124
#N/
A 139 167.74
People with
a disability
or long-term
health
condition
656 216 91 176 479
1618
#N/
A 216 235.6402
People from
a Black,
Asian or
minority
ethnic
background
853 247 98 238 615
2051
#N/
A 247 312.958
People aged
19-24 with
few or no
qualification
s
883 207 77 306 577
2050
#N/
A 306 321.9208
People aged
16-18 with
few or no
qualification
s
477 121 43 133 345
1119
#N/
A 133 180.486
Ex-
offenders 206 69 25 44 162 506
#N/
A 69 78.73182
Parents
returning to
the
workforce
715 206 84 184 531
1720
#N/
A 206 266.8586
People
returning to
the
workforce
after time
out of the
labour
market for
500 159 63 91 409 1222 #N/
A
159 197.5824

reasons
other than
having a
child, for
example
because of
other caring
responsibilit
ies or a
health
condition
War
veterans 269 98 21 41 228 657
#N/
A 98 111.5137
None of the
above 130 10 7 114 16 277
#N/
A 16 61.14573
Don't know 136 32 5 22 114 309
#N/
A 32 59.01017
0
1000
2000
3000
4000
Private sector
Public sector
Third/voluntary sector
Private sector SME (2-249)
Private sector large (250+)
Mean
Mode
Median
standard deviation
Analysis: This graph shows how companies have chosen employees from various groups in the
last three years, such as public and corporate (large and SME). According to this study, how
many workers were working during the Brexit process, as well as how reaction that occurs in
various ways (Brownlow and Budd, 2019). The central-tendency of numerical values is
effectively numerically measured using the Mean estimation measurements method. This is the
sum of everything is equal to the main average of values. The exploratory analysis' key goal is to
discover, because as name implies. There is also no measure of the link in between data as well

as the factors before it (Eichengreen, Jungerman and Liu, 2020). Once user have looked at the
details, they can use exploratory research to make correlations and come up with hypotheses and
answers to particular problems. Data mining is a standard framework for exploratory research.
Q4.
Thinking
about the
next
THREE
months,
what will be
the overall
effect of
recruiting
new staff
and/or
making
redundanci
es?
Priva
te
sector
Publi
c
secto
r
Third/
volunta
ry
sector
Private
sector
SME
(2-249)
Privat
e
sector
large
(250+)
Mea
n
Mo
de
Media
n
standard
deviation
Unweighted
base 1433 427 193 781 652 3486
#N/
A 652 468.4263
Base 1560 349 144 708 852 3613
#N/
A 708 546.02
Maintain
total staff
level
719 200 89 373 346
1727
#N/
A 346 238.3386
Increase
total staff
level
263 90 27 92 171
643
#N/
A 92 90.84767
Decrease
total staff
level
399 38 21 142 256
856
#N/
A 142 158.3026
Don't know 180 21 7 100 80 388
#N/
A 80 69.2481
Promoters 263 90 27 92 171 643
#N/
A 92 90.84767
Detractors 399 38 21 142 256 856
#N/
A 142 158.3026
Net
Employment
Score
-136 52 6 -50 -86
-214
#N/
A -50 74.11613

WA1.
Which of
the
following
flexible
working
arrangemen
ts, if any,
does your
organisatio
n offer?
Please
select all
that apply.
Priva
te
sector
Publi
c
secto
r
Third/
voluntary
sector
Priva
te
sector
SME
(2-
249)
Priva
te
sector
large
(250+
)
Mea
n
Mod
e
Media
n
Standar
d
deviati
on
Unweighted
base 1433 427 193 781 652 348
6
#N/
A 652
468.42
63
Base 1560 349 144 708 852 361
3
#N/
A 708 546.02
Flexi-time 624 210 80 241 383 153
8
#N/
A 241
207.09
73
Annualised
hours
contract
166 109 27 35 131
468
#N/
A 109
60.719
03
Term time
working 189 196 35 54 135 609
#N/
A 135
74.710
78
Jobsharing 316 221 56 62 254 909
#N/
A 221
117.19
3
Zero-hours
contract 301 71 40 107 193 712
#N/
A 107
105.53
58
On-call
working 187 85 25 55 132 484
#N/
A 85
64.064
03
Working
from home
on a regular
basis
695 191 91 240 455 167
2
#N/
A 240
241.50
32
Home
working
(always
working
from home)
406 100 40 140 267
953
#N/
A 140
146.35
85
Part-time
hours 958 274 115 354 604 230
5
#N/
A 354
329.23
85
Compressed
hours (e.g.
369 190 69 93 276 997 #N/
A
190 125.54
4

4.5 day
week, 9 day
fortnight)
Career
breaks 396 176 41 52 343 100
8
#N/
A 176
163.25
84
Other 14 1 1 10 4 30 1 4
5.7879
18
None of
these 184 15 7 127 57 390
#N/
A 57
75.973
68
Unweighted base
Flexi-time
Term time working
Zero-hours contract
Working from home on a regular
basis
Part-time hours
Career breaks
None of these
0
500
1000
1500
2000
Private sector large (250+)
Private sector SME (2-249)
Third/voluntary sector
Public sector
Private sector
Interpretation: From the chart mentioned above, it has been determined that most of the people
those are impacted due to Brexit are from private sectors as these people have to leave the job
and move to other place which was decided in the norms (Eichengreen, Jungerman,and Liu,
2020). On the other side, individual working in third and voluntary sectors are the one which life
are less affected by the brexit as they can make a pause for a longer period from job and may
return in nearby future once condition are pleasant and fit for job. Using predictive analysis,
users will create and implement strategies that can not only improve the different operating
procedures and also give them a competitive advantage. They will be capable of creating an
educated prediction on the how events will proceed in specific segments of the store if they know
why such a trend, phenomenon, or occurrence occurred from data.
QM4.
Does your
organisati
Privat
e
sector
Publi
c
secto
Third/
voluntary
sector
Privat
e
sector
Privat
e
sector Mea
n
Mod
e
Media
n
Standar
d
deviatio

on
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.
r
SME
(2-
249)
large
(250+
)
n
Unweighte
d base 1433 427 193 781 652 348
6
#N/
A 652
468.42
63
Base 1560 349 144 708 852 361
3
#N/
A 708 546.02
Yes 978 256 84 273 705 229
6
#N/
A 273
369.56
28
No 508 68 50 415 93 113
4
#N/
A 93
217.29
63
Don't
know 74 26 10 19 55 184
#N/
A 26
26.771
25
Interpretation: If Europe countries employees are forced to migrate to other regions as a result
during Brexit, the labour market's allocation of forces can shift in favour of employees,
intensifying a new fight for talent between organizations (Giammetti, Russo and Gallegati,,
2020). As a result about such an outcome, UK firms' competitiveness will almost inevitably
suffer.It would help the marketing campaigns succeed in the long term by allowing them to find
new potential clients and not spending time on the right crowd or delivering the opposite
message. They may also monitor customer loyalty by looking at consumer feedback or the
results of the complaints department.

MP9.
Thinking
about your
organisatio
n, will you
seek to
recruit EU
nationals
from
overseas in
greater,
about the
same or
fewer
numbers
than usual
before 31
December
2020?
Privat
e
sector
Publi
c
secto
r
Third/
voluntary
sector
Privat
e
sector
SME
(2-
249)
Privat
e
sector
large
(250+
)
Mea
n
Mod
e
Media
n
Standar
d
deviatio
n
Unweighte
d base 1433 427 193 781 652 348
6 652
468.42
63
Base 1560 349 144 708 852 361
3 708 546.02
Greater
numbers
than usual
43 9 2 18 25
97 18
15.820
87
About the
same
numbers as
usual
414 130 44 132 282 100
2 132
146.95
17
Fewer
numbers
than usual
248 42 15 65 182
552 65
99.876
42
Not
applicable
– we will
not seek to
recruit any
EU
nationals
before 31
December
2020
495 71 49 390 106
111
1 106
205.51
08
Don't know 360 97 35 104 256 852 104
133.60
88

Unweighted base
Base
Greater numbers than usual
About the same numbers as usual
Fewer numbers than usual
Not applicable – we will not seek to
recruit any EU nationals before 31
December 2020
Don't know
1433
1560
43
414
248
495
360
781
708
18
132
65
390
104
652
852
25
282
182
106
256
Private sector large (250+)
Private sector SME (2-249)
Third/voluntary sector
Public sector
Private sector
Interpretation: The freedom of movement seen between United kingdom and The European has
ended, and the UK has adopted an immigration policy that treats all refugees equally,
irrespective of race (Hantzsche, Kara and Young , 2019). With perhaps the exception of Scottish
immigrants, those wishing to nominate from elsewhere in the UK should first meet the
requirements and apply their application for approval (Kinderman, 2020).The descriptive
analysis approach is the foundation of every analytic procedure, and it seeks to address the
question, "What happened to the people in public and private sector companies" It accomplishes
this by organising, manipulating, but rather analysing raw information from a multitude of
sources in way to switch it into useful market insights.
QM4.
Does your
organisati
on
currently
employ
any EU
nationals
in the
UK? EU
nationals
are people
working
in the UK
Privat
e
sector
Publi
c
secto
r
Third/
voluntary
sector
Privat
e
sector
SME
(2-
249)
Privat
e
sector
large
(250+
)
Mea
n
Mod
e
Media
n
Standar
d
deviatio
n

who are
citizens of
another
country in
the
European
Union,
including
the
Republic
of Ireland.
Unweighte
d base 1433 427 193 781 652 348
6
#N/
A 652
468.42
63
Base 1560 349 144 708 852 361
3
#N/
A 708 546.02
Yes 978 256 84 273 705 229
6
#N/
A 273
369.56
28
No 508 68 50 415 93 113
4
#N/
A 93
217.29
63
Don't
know 74 26 10 19 55 184
#N/
A 26
26.771
25
Interpretation: If, as a result of Brexit, jobs in the EU are forced to move to other countries, the
distribution of power in the labor market will shift in favor of workers, which could intensify
new job disputes between companies that have secured the best talent (Leruth, Gänzle and
Trondal., 2019). This result will almost certainly affect the productivity of UK companies.
MP9.
Thinking
about your
organisatio
n, will you
seek to
recruit EU
nationals
from
overseas in
greater,
about the
same or
fewer
numbers
than usual
before 31
December
Privat
e
sector
Publi
c
secto
r
Third/
voluntary
sector
Privat
e
sector
SME
(2-
249)
Privat
e
sector
large
(250+
)
Mea
n
Mod
e
Media
n
Standar
d
deviatio
n

2020?
Unweighte
d base 1433 427 193 781 652 348
6 652
468.42
63
Base 1560 349 144 708 852 361
3 708 546.02
Greater
numbers
than usual
43 9 2 18 25
97 18
15.820
87
About the
same
numbers as
usual
414 130 44 132 282 100
2 132
146.95
17
Fewer
numbers
than usual
248 42 15 65 182
552 65
99.876
42
Not
applicable
– we will
not seek to
recruit any
EU
nationals
before 31
December
2020
495 71 49 390 106
111
1 106
205.51
08
Don't know 360 97 35 104 256 852 104
133.60
88
0
400
800
1200
1600
Private sector
Public sector
Third/voluntary sector
Private sector SME (2-249)
Private sector large (250+)

Interpretation: The free movement between the UK and the European Union has ended and the
UK has introduced an immigration system that treats all immigrants equally regardless of
nationality. Anyone who intends to appoint outside the UK, excluding Irish nationality, must first
meet these criteria and apply for approval.
There are no changes to the current Tier 2 (general) specialist course. In any case, applicants
should receive a mixed score of 70 focus under the "mandatory" and "commercial" grades to
qualify (Malik, Ajonbadi and Jimoh., 2019). Candidates can get 50 focuses with their mandatory
characteristics: (1) they have a job offer from a supported company; (2) intends to participate in a
talented career at RQF level 3 or above; and (3) meet the required English prerequisites. The
remaining 20 focuses may come from "commercial" indicators, such as higher compensation or
higher academic potential. For example, applicants with a compensation offer of £ 25,600 or
more can receive 20 focuses. Cash compensation cannot fall below £ 20,480 under any
circumstances (Minto, 2020). This new approach demonstrates greater flexibility in the
framework by allowing a person with a job offer to achieve a score of 70 and obtain a Stage 2
visa with basic compensation of £ 20,480. Once done, this flexible compensation scoring system
will allow participants in the absence of low-paying residential work to meet all requirements for
a Level 2 (general) visa. We anticipate that the definitive Phase 2 strategy guide will be
published to demonstrate how the commercial focus will work with and with it.
Highlight interesting findings
An alternative would be to provide a guarantee that the UK's contribution to EU spending will
recover as the ability to adapt increases as the deficit decreases. The UK's total annual
contribution to the EU from 2010 to 2015 was about £16.8 billion. At the same time, the UK
offers discounts and rewards on various EU projects.
• It recommends that the current EU expenditure plan annual net amount is approximately £8.8
billion or approximately 0.5% of GDP over a similar period. Indeed, a number of important
reports have been released to quantify Brexit's long-term impact on UK economic performance
• This profound goal of predicting how the measure of British creation in 2030 after Brexit
would match the amount created in the year the UK stayed in the EU.

• According to a survey of 1,300 UK organizations initially conducted by Business Search in the
fourth quarter of last year, most organizations believe they have not yet been affected by Brexit.
In addition, 30% said concerns caused by Brexit caused a lot of trouble for them, while 15% said
they benefited as a result of EU adoption within six months of voting (Opatrny., 2021). Various
recent studies have shown that SMEs and UK investors have been stable and encouraging about
the referendum results.
• This is an opportunity that governments and private sectors can take to ensure that the SME
environment is adequately supported through preparation and verification, allowing SMEs to use
significant reserves for speculation.
Brexit vulnerabilities are storming the UK procurement culture and pouring family discoveries
for Congress. By investigating this, our three experts investigated Brexit's effectiveness on
grazing and alternatives to the wider UK registration area, providing information and potential
offers to be provided in the future.
Recommendation to government about impact of Brexit and proposed new immigration
system to organization.
The impact of Brexit to the United Kingdom Government where the outcome in which European
referendum to being leave the European Union. It is issuing tanging with from changes towards
regulation and the impact on the future on which funding to migration about the high impact
through better public services. Antd, while the result where the vote is known towards better
long period to making effective adjustments will now follows to bring uncertainty. The outcomes
will have its own impact to overall economy as personally as well as professionally. Here, on the
basis of implication towards public sector to help for making informed and having effective
decision about strategic preferences in which Government prepare from the high impact through
Brexit. There are some recommendation to government of United Kingdom from impact of
Brexit market:
 Leaving the European Union far from a straightforward process and economy will have
no idea what it would take.
 The United Kingdom Politician, advisors and having effective policy makers that
enhance to crate better balance which precaution the United Kingdom people.

 Increased the number of UK filing on Burden on Business: This sthe most immediate
about the consequences through Brexit from a merger control perspective is that merger
through filling to the European Commission under the EUMR wich it will no longer
cover up the United Kingdom. This change can be expected to lead a significant increase
in the number of UK filing post Brexit and possibly for modest reduction. Thus through
impact United kingdom turnover would be no longer evaluate in European Union.
 Reduction in the number of European Union filing which made presumes towards
voluntary referral request which could affected. Through EUMR, the parties would
acquiring the transaction which would other wise notify within three or more states from
which transaction would be referred to the commission review within effective manner.
As the juridical thresholds which are board, where it is uncommon in United Kingdom to
count of Jurisdictional be referred towards effective commission for review.
 The Government should negotiate to and articulate within having clear immigration
system priorities within as group. These should be better incorporated within ongoing
strategy through enough submitted towards Parliament and outlining about how
government would accomplished such goals and objectives with aiming of asses
progress. The home secretary should state about how well those goals deficit been met
what reforms which is essential needed. Apart from predetermined target like o having
budget planning objective attained. Through many firms which have adopted their
corporate architecture and approach to current environment within variety through better
incorporation. Some of companies have established linkages across European countrie
through major outcomes are effectively generates. Everyone else has pursued cross
border expansion since the barriers to companies acquiring business within better
European countries have been reduced.
 European Citizen having the freedom to actually live in any European Union country
according to better European states which established Economics Area (EEA)- Iceland,
Lichtenstein and Norway- as well as Switzerland which have some access. After joining
within European Economic areas in 1973, the concept recognised as “unlimited
immigration” or having free movement as it help to core opponent towards UK
migration policy. However, the UK government always to have complete influence over

non European Union which always used to higher than European migration, per
government figure.

CONCLSUSION
It is inferred about above report of CIPD which related to United Kingdom Brexit faces
different types of challenges and issues which create for economy that enhance different sets off
aspect. While Brexit offer impressive possibilities to the country in reference of improvising
gross domestic product rates. Through the nation was not able to provide job opportunities to
people. Within the result income level get down and impact on the economy. While, Britain is
unable to discuss free trades deals with other countries until exit from the EU is consisted in
March 2017. There is evaluation on these components which is related with the automobile
sector and impact in positive as well as negative manner.


REFERENCES
Books and Journal
Billing, C., McCann, P. and Ortega-Argilés, R., 2019. Interregional inequalities and UK sub-
national governance responses to Brexit. Regional Studies, 53(5), pp.741-760.
Brown, R., Liñares-Zegarra, J. and Wilson, J.O., 2019. The (potential) impact of Brexit on UK
SMEs: regional evidence and public policy implications. Regional Studies, 53(5),
pp.761-770.
Brownlow, G. and Budd, L., 2019. Sense making of Brexit for economic citizenship in Northern
Ireland. Contemporary social science. 14(2). pp.294-311.
Eichengreen, B., Jungerman, W. and Liu, M., 2020. Brexit, the City of London, and the
prospects for portfolio investment. Empirica. 47(1). pp.1-16.
Eichengreen, B., Jungerman, W. and Liu, M., 2020. Brexit, the City of London, and the
prospects for portfolio investment. Empirica. 47(1). pp.1-16.
Giammetti, R., Russo, A. and Gallegati, M., 2020. Key sectors in input–output production
networks: An application to Brexit. The World Economy. 43(4). pp.840-870.
Giammetti, R., Russo, A. and Gallegati, M., 2020. Key sectors in input–output production
networks: An application to Brexit. The World Economy. 43(4). pp.840-870.
Hantzsche, A., Kara, A. and Young, G., 2019. The economic effects of the UK government's
proposed Brexit deal. The World Economy, 42(1), pp.5-20.
Kinderman, D.P., 2020, December. Authoritarian Capitalism and its Impact on Business. In
Symposium on Authoritarianism and Good Governance (VA: IIIT, 2021). http://doi.
org/10.47816/02.001 (Vol. 23).
Leruth, B., Gänzle, S. and Trondal, J., 2019. Exploring Differentiated Disintegration in a Post‐
Brexit European Union. JCMS: journal of common market studies. 57(5). pp.1013-
1030.
Malik, A., Adekoya, O.D., Ajonbadi, H.A. and Jimoh, I., 2019. Investigating the Potential
Economic Impact of Brexit Decisions on Business Performance in the United Kingdom:
A Case Study of the UK Construction Industry. International journal of management,
accounting and economics, 6(4), pp.347-367.
Minto, R., 2020. Sticky networks in times of change: The case of the European Women's Lobby
and Brexit. JCMS: Journal of Common Market Studies. 58(6). pp.1587-1604.
Opatrny, M., 2021. The impact of the Brexit vote on UK financial markets: a synthetic control
method approach. Empirica. 48(2). pp.559-587.
Perraton, J. and Spreafico, M. R., 2019. Paying our way in the world? Visible and invisible
dangers of Brexit. New political economy. 24(2). pp.272-285.
Roscoe, S., Skipworth, H., Aktas, E. and Habib, F., 2020. Managing supply chain uncertainty
arising from geopolitical disruptions: evidence from the pharmaceutical industry and
brexit. International Journal of Operations & Production Management.

Vickers, B., 2019. Implications of Brexit. In The Palgrave Handbook of Contemporary
International Political Economy (pp. 283-299). Palgrave Macmillan, London.
Weiss, T., 2020. A small state’s anticipation of institutional change: effects of the looming Brexit
in the areas of the CSDP and internal market. European Security. 29(1). pp.1-15.