Report on Brexit & Immigration: Analyzing Government Data Impact

This report analyzes government-provided data to understand the potential impacts of Brexit and the proposed new immigration system on businesses in the UK, focusing on the education and healthcare sectors. It examines recruitment and redundancy plans, the proportion of EU nationals in the workforce, and the overall effect on staffing levels. The analysis includes summary statistics and identifies interesting findings related to the representation of EU nationals in different occupations. The report concludes with recommendations to the government regarding the potential impact of Brexit and the new immigration system on organizations, highlighting the need for tailored support and proactive measures to mitigate negative consequences. Desklib provides access to similar reports and solved assignments for students.

Data to Build Business
Practice

Contents
INTRODUCTION...........................................................................................................................................3
MAIN BODY.................................................................................................................................................3
Explore the data provided in order to gain an understanding of the information required by the
Government............................................................................................................................................3
Analyse the data for your selected questions using appropriate summary statistic in a spreadsheet....8
Highlight interesting findings.................................................................................................................14
Make recommendations to the Government about the possible impact of Brexit and the proposed
new immigration system on organisations............................................................................................15
REFERENCES..............................................................................................................................................17

INTRODUCTION
Data analysis appears to be a strategy mostly employed by academics with the goal of
translating, analyzing, and storing obtained data to make informed conclusions. The main goal of
this procedure is to make sure the data gathered is useful which can be used to make educated
decisions in the future. Various methodologies are employed all through process of data
collection to aid in the production of useful results. These topics include the average, covariance,
testing of hypotheses, extrapolation, and sample size determination. Investigators use them
depending on their objectives and the method of evidence they undertake. The current reports
will analyses data given by the government in order to have a better perspective. Big questions
will be chosen in order to gain a better understanding of the potential consequences of Brexit and
the planned new immigration system on businesses by emphasizing intriguing results and
making advice to the board.
MAIN BODY
Explore the data provided in order to gain an understanding of the information required by the
Government
Q1. Is your organisation
planning to recruit
employees in the next
THREE months?
Education Healthcare
Unweighted base 229 132
Base 171 163
Yes 88 113
No 67 43
Don't know 16 7

Unweighted
base Base Yes No Don't know
0
50
100
150
200
250 229
171
88
67
16
132
163
113
43
7
Education
Healthcare
Interpretation: The graph above plainly shows that the company is intending or attempting to
hire or attract personnel within the next three months. The work force in the education and health
care sectors reported that based on the entire number of employees in the education sector, 88
employees expect the company will be recruiting people in the next three months. 67 employees
of the company also responded that they should not believe the company plans to employ more
people in the next three months. There are also 16 individuals who are unaware of the company's
policy of hiring personnel within the next three months.
Q3. Is your
organisation
planning to
make any
redundancies
during the next
THREE
months?
Education Healthcare
Unweighted
base 229 132
Base 171 163
Yes 31 18
No 106 112
Don't know 33 33

Unweighte
d base Base Yes No Don't know
0
50
100
150
200
250 229
171
31
106
33
132
163
18
112
33
Education
Healthcare
Interpretation: According to the graph above, 31 employees in the education industry said their
business is contemplating layoffs within the next three months. 106 people are stating that they
do not believe the company would make any redundancies in the next three months. 33 workers
have no idea what the company's redundancy policy would be in the next three months. During
the questioning round, 18 employees claimed that the company is preparing to implement a
redundancy strategy in the next three months. In the next three months, 112 persons decided that
redundancy will be part of the corporate policy. There are also 33 workers there who have no
idea what the corporate entity's redundancy policy will be in the following three months. Based
on the actions and statements made by personnel in both the health education and care areas, it
can be concluded that firms are not expecting any redundancies in the next three months. The
plurality of viewpoints claimed that the organizations have no plans to implement duplication in
the next three months or period. The majority of people believe that the firms are not doing so.
Q3a. To what
extent will these
redundancies
affect your
overall
headcount over
the next three
months?
Education Healthcare
Unweighted
base 41 16
Base 31 18

It will affect
0.01% to 10% 17 4
It will affect
10.01% to 20% 7 4
It will affect
20.01% to 30% 2 2
It will affect
30.01% to 40% 1 5
It will affect by
40.01% to 50% 2
It will affect
50.01% to 60% 1
Unweig
hted
base
Base It will
affect
0.01%
to 10%
It will
affect
10.01%
to 20%
It will
affect
20.01%
to 30%
It will
affect
30.01%
to 40%
It will
affect
by
40.01%
to 50%
It will
affect
50.01%
to 60%
0
5
10
15
20
25
30
35
40
45 41
31
17
7
2 1 1
16 18
4 4 2 5 2
Education
Healthcare
Interpretation: From the preceding data, it can be concluded that Brexit has had a varied effect
on the organizational recruiting and entrance exams in the United Kingdom's health care and
education sectors. The graph shows that redundancies in the education sector will actually affect
headcount by 0.01 percent to 10% over the next three months, according to 17 people, and
healthcare will be influenced by 0.01 percent to 10%, according to four people. Furthermore, it
was discovered that 7 and 4 participants, correspondingly, stated that education and healthcare
will be affected by 10.01 percent to 20%. Meanwhile two persons in the healthcare and
education sectors chose the options of 20.01 percent to 30 percent. Around the same time, the
above chart and table have helped to realize that the effect of Immigration in the UK will result
in 30.01 percent to 40% redundancies, according to 1 in the education sector and 5 in the
healthcare sector. Only two people have said that healthcare will be impacted by 40.01 percent to

50 percent, and one person has said that it will be influenced by 50.01 percent to 60 percent.
Therefore, on average, 5 respondents believe education will be impacted, whereas only 3 people
believe the healthcare sector would be impacted.
Q4. Thinking
about the next
THREE months,
what will be the
overall effect of
recruiting new
staff and/or
making
redundancies?
Education Healthcare
Unweighted base 229 132
Base 171 163
Maintain total staff
level 114 74
Increase total staff
level 21 70
Decrease total staff
level 30 9
Don't know 7 10
Promoters 21 70
Detractors 30 9
Net Employment
Score -9 60
Unweighted base
Base
Maintain total staff level
Increase total staff level
Decrease total staff level
Don't know
Promoters
Detractors
Net Employment Score
-50
0
50
100
150
200
250 229
171
114
21 30
7 21 30
-9
132
163
74 70
9 10
70
9
60
Education
Healthcare

Interpretation: The aforementioned analysis has aided in comprehending critical information
regarding the total effect of hiring new employees and/or making layoffs over the next THREE
months. On average, majority respondents said there are roughly 114 employees, and 74 said it
aids in managing total worker levels. 21 and 70 have decided that total employee levels in the
education and healthcare sectors would be increased. Additionally, from the perspectives of 30
and 9 participants, it can be deduced that there will be a decline in overall staff level, with 7 and
10 people not knowing the answer. Finally, the effect of Immigration will result in a greater
increase in training needs in the healthcare sector than in the education sector.
Analyse the data for your selected questions using appropriate summary statistic in a
spreadsheet.
QM4.
Does your
organisati
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.
Educatio
n
Healthca
re Education Healthcare
Unweighte
d base 229 132
Base 171 163 Mean 114.2 Mean 91.4
Yes 114 116 Standard
Error
39.8163
3
Standard
Error
29.3676
7

No 46 39 Median 114 Median 116
Don't know 11 7 Mode #N/A Mode #N/A
Standard
Deviation
89.0320
2
Standard
Deviation 65.6681
Sample
Variance 7926.7
Sample
Variance 4312.3
Kurtosis
-
1.65064 Kurtosis -2.1085
Skewness
0.16524
5 Skewness
-
0.43585
Range 218 Range 156
Minimum 11 Minimum 7
Maximum 229 Maximum 163
Sum 571 Sum 457
Count 5 Count 5
Unweighte
d base Base Yes No Don't know
0
50
100
150
200
250 229
171
114
46
11
132
163
116
39
7
Education
Healthcare
M3b_rc_UK. Approximately what proportion of your workforce is made up of workers from each of
the following countries?Please type in numbers not words e.g. '10' not 'ten'. Please type in '0' if none.
The proportions should add to 100%. (1) - Workers born in the UK
Unweighted base 22
9
13
2 Education Healthcare
Base 17
1
16
3
0 Mean
81.5714
3 Mean
65.2857
1
1-25% 4 2 Standard Error
33.2908
2 Standard Error
23.7463
9
26-50% 5 10 Median 73 Median 50
51-75% 12 19 Mode #N/A Mode #N/A

76-100% 77 50 Standard Deviation
88.0792
4 Standard Deviation
62.8270
5
Don`t know 73 81 Sample Variance
7757.95
2 Sample Variance
3947.23
8
Kurtosis
-
0.51206 Kurtosis
-
1.17492
Skewness
0.91050
3 Skewness
0.66672
8
Range 225 Range 161
Minimum 4 Minimum 2
Maximum 229 Maximum 163
Sum 571 Sum 457
Count 7 Count 7
M7.
Compared to
the rest of
your
workforce,
do EU
nationals
have a
particularly
large
representatio
n in
particular
occupations
or functions?
Education Healthcare
Unweighted
base 143 93
Base 114 116 Mean 74.4 Mean 65
Yes 35 37 Standard Error
24.8708
7 Standard Error
17.8801
6
No 73 61 Median 73 Median 61
Don't know 7 18 Mode #N/A Mode #N/A
Standard
Deviation
55.6129
5
Standard
Deviation
39.9812
5
Sample
Variance 3092.8
Sample
Variance 1598.5
Kurtosis
-
1.77292 Kurtosis
-
1.70184
Skewness
0.04258
8 Skewness
0.18752
9
Range 136 Range 98
Minimum 7 Minimum 18
Maximum 143 Maximum 116
Sum 372 Sum 325

Count 5 Count 5
0
40
80
120
160 143
114
35
73
7
93 116
37 61
18
Series1
Series2
M8_new. In
which of the
following
functions do
EU nationals
have a
particularly
large
representati
on in your
organisation
? Please tick
all that
apply.
Education Healthcare
Unweighted
base 41 35
Base 35 37 Mean
10.6666
7 Mean
10.7692
3
Managers,
Directors and
senior
officials
4 7 Standard
Error
3.87754
5
Standard
Error
3.28195
1
Administrati
ve and
secretarial
3 4 Median 4 Median 7