Using Data to Build Business Practice

This report analyses data given by the government to gain a better perspective of the potential consequences of Brexit and the planned new immigration system on businesses. The report explores the data provided, analyses the data for selected questions using appropriate summary statistics in a spreadsheet, highlights interesting findings, and makes recommendations to the government. The report covers subjects such as recruitment, redundancies, and the proportion of the workforce made up of workers from different countries.

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

occupations
Elementary
occupations
(e.g.
cleaners,
catering
assistants,
hotel porters,
etc.)
11 10
Mode 4 Mode 7
Process,
plant and
machine
operatives
1 1 Standard
Deviation
13.4322
1
Standard
Deviation
11.8332
4
Sales and
customer
service
occupations
1 4 Sample
Variance
180.424
2
Sample
Variance
140.025
6
Caring,
Leisure and
Other Service
Occupations
4 14
Kurtosis
1.91993
4 Kurtosis
2.01642
6
Skilled trades
occupations 2 7 Skewness
1.73479
4 Skewness
1.73190
7
Associate
professional
and technical
occupations
(e.g. police
officers,
paramedics,
building and
fire
inspectors, IT
operations
technicians
etc.)
4 6
Range 40 Range 36
Professional
occupations
(e.g.
psychologists
, pharmacists,
lawyers etc.)
14 11
Minimum 1 Minimum 1
Other 8 1 Maximum 41 Maximum 37
Don't know 3 Sum 128 Sum 140
Count 12 Count 13

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?
Education Healthcare
Unweighte
d base 229 132
Base 171 163 Mean
81.4285
7 Mean
65.2857
1
Greater
numbers
than usual
5 7 Standard
Error
32.0912
8
Standard
Error
22.3742
1
About the
same
numbers as
usual
65 60
Median 46 Median 43
Fewer
numbers
than usual
18 23
Mode #N/A Mode #N/A
Not
applicable –
we will not
seek to
recruit any
EU
nationals
before 31
December
2020
46 29
Standard
Deviation
84.9055
5
Standard
Deviation
59.1966
1
Don't know 36 43 Sample
Variance
7208.95
2
Sample
Variance
3504.23
8
Kurtosis - Kurtosis -

0.05855 0.54719
Skewness
1.17721
1 Skewness
1.00931
3
Range 224 Range 156
Minimum 5 Minimum 7
Maximum 229 Maximum 163
Sum 570 Sum 457
Count 7 Count 7
Highlight interesting findings
1. According to a study commissioned by the British government, rule changes enacted
after Brexit could result in 57 percent fewer EU students enrolling in Higher education
institutions.
2. The sector is anticipated to lose £62.5 million (US$85.9 million) per year in income, with
only Oxford and Cambridge predicted to see an improvement as a result of the new laws.
3. Protecting Children Safe in Education Recommendations, as teachers and institutions are
likely to know, lays out legislative guidance that schools and universities should consider
when developing a hiring process. The guidance outlines the approach that schools
should use when conducting which was before inspections, such as criminal background
checks, banned list inspections, and restriction inspections.
4. While any restrictions discovered by the screening do not preclude someone from
learning in England, educational institutions should take into account the circumstances
leading up to the limitation or punishment being applied while evaluating a candidate's
eligibility for employment. As a consequence, the outcomes have the capacity to have a
significant effect on the selection process.
5. In compliance with the Protecting Children Safe in Education guidance, schools and
institutions should carry out regular safer recruiting screening on all applications. The
notion of a letter of social credentials isn't yet shown in the Keeping Children Safe in
Education guidance, thus it's not enforceable. Nevertheless, colleges must make good
decisions about whether or not to request more checks above what is necessary.
6. Healthcare recruiting in the UK will undoubtedly suffer as Brexit becomes an actuality
and the UK consecutive month itself from the laws affecting EU management. It's no

surprise that, in help to fulfill openings, recruitment parties have looked to other EU
countries proven time again before the domestic staff nurses shortages. The NHS has
gained “tremendously” from the recruitment of 130,000 European Union doctors,
doctors, and care staff, according to Simon Stevens, the present NHS England executive
chairman.
Make recommendations to the Government about the possible impact of Brexit and the proposed
new immigration system on organisations.
Brexit has had a significant influence on government recruiting and retaining workers in
the educational and health sectors. In the context of the educational sector, the UK government is
advised to use planning process. While EU citizens make up roughly 7% of the Employment
landscape, it is likely that some EU workers may choose to fill roles in terms deal Brexit.
Although one-third of the workers regard perks in the manner of packets as a crucial criterion for
new positions, the government is unable to offer the greatest salary. Whenever the government
decides to expand with a common aim, in addition to working methods, they can give vacation
rewards, flexible hours, fitness programmers, and deferred compensation savings. On the other
extreme, the government is advised to expect to lead in the healthcare sector following Brexit's
effects by strengthening the examination and recruiting as well as going digital first. Competitors
in the healthcare sector become disenchanted after a long period of time. Around 69 percent of
healthcare organizations are concerned about talent competitiveness following Brexit. So, with
thorough training course and top-of-the-line assessment technologies, the government of the
United Kingdom can recruit talent and ensure that it has the most successful individuals to serve
its inhabitants.
In light of the UK's reformed immigration system, the government should introduce
automatic modifications to temporary and employment-based permanent residency caps. To do
this, the UK government must tie growth to employment-based visas in the majority of its key
sectors, ensuring that the estimated rate of visas accessible meets the requirements of the UK
economy over time. Another idea for the planned new immigration system on organizations is to
shorten the waiting lists for relatives and work-related immigration. New migrants protest about
standing in line, thus it is advised that individuals apply in the proper manner so that they can
apply for citizenship or a short visa through the legal immigration system. Relying on

government passports is also advised to the administration for a suggested immigration system
that will work in a country with a diversified economy. This will highlight the situations of every
nation and municipality, and consolidation will lead to polarized emigration. Despite federal
oversight, the administration must allow sponsors to sponsored migrants based on their own
criteria. Although it has been found that immigration is the most important generator of wealth,
its ability in the proposed new immigration system is stifled by central agencies, outdated
regulations, and political constraints. It is suggested that the UK government implement a
communal visa system as a local answer to the country's immigration crisis. In rural locations,
communities with the most diverse criteria for immigrants. The United Kingdom requires a new
method to effective access of all kinds in obtaining the personnel they need, to revitalize regions
endangered by declining population, and to create local acceptance for globalised immigration.

REFERENCES
Books and Journal
Gull, S., Parah, S.A. and Muhammad, K., 2020. Reversible data hiding exploiting Huffman
encoding with dual images for IoMT based healthcare. Computer Communications. 163.
pp.134-149.
Hassan, T.A. and et.al., 2020. The global impact of Brexit uncertainty (No. w26609). National
Bureau of Economic Research.
Navas, L. P. and et.al., 2020. Colombian higher education institutions evaluation. Socio-
Economic Planning Sciences. 71. p.100801.
Parekh, P. and et.al., 2020. Systematic review and meta-analysis of augmented reality in
medicine, retail, and games. Visual computing for industry, biomedicine, and art. 3(1).
pp.1-20.
Raghupathi, V. and Raghupathi, W., 2020. Healthcare expenditure and economic performance:
insights from the United States Data. Frontiers in Public Health. 8. p.156.
Salas, R. N. and et.al., 2020. A pathway to net zero emissions for healthcare. Bmj, 371.
Smaldone, F., Ippolito, A. and Ruberto, M., 2020. The shadows know me: Exploring the dark
side of social media in the healthcare field. European Management Journal. 38(1). pp.19-
32.