Ballard Integrated Managed Services, Inc.
BIMS Case Study
The Ballard Integrated Managed Services has identified a significant change in their turnover rate; however, the cause of the increase has not been identified. To identify the cause BIMS decide to approach the employees with a survey that focuses on employee morale, job satisfaction, and equality. The case analysis approaches a possible solution to the problem from the statistical point of view.
BIMS Overview
Ballard Integrated Managed Services, Inc. (BIMS) is a company that provides housekeeping and foodservices to large corporations and businesses. BIMS employs a total of 452 employees, including full-time workers, part-time workers, and management employees. The average turnover rate for BIMS is typically 55-60%. During the past four months, the turnover rate has increased to over 64%. …show more content…
Despite the efforts to get to the root of the issue causing the high turnover rate, management at BIMS has been unsuccessful. Morale is low at BIMS, and there has been an increase in the use of sick leave. The performance of workers has become insufficient, which has caused a number of complaints from clients.
Data Collection
Ballard Integrated Managed Services, Inc.’s General Manager, Barbara Tucker, was concerned about why the morale in the staff went down. The HR director, Debbie Homer, developed an employee survey in order to collect data to find out why worker morale has decreased. The survey will be sent out to all employees, excluding upper management. The survey will be distributed with the employees’ bi-weekly payroll checks, with all responses to be both voluntary and anonymous. The survey questions ask the workers to share their opinions about working conditions, fair treatment, shift hours, quality of training, internal company communications, level of compensation, and job security.
Types Of Data Collected
The data included in the BIMS Employee Survey provided by Ballard Integrated Managed Services, Inc., has both qualitative and quantitative data. Employees were given the opportunity to complete the survey at their leisure. The firm expects the survey to collect all necessary data for analysis. The first 10 questions provide the firm qualitative data. The instructions inform employees to answer the questions by circling the number closest to their view. The structure is set up to allow employees to circle numbers one through five to show their positive or negative views toward each particular question (with one being very negative and five being very positive). There are four additional quantitative questions presented (questions A-D). The questions address work division, years of service, gender, and employee level.
The survey presented two the two types of variables.
While the first 10 questions provided the qualitative data, the last 4 questions provided the quantitative data. The survey utilizes nominal, ordinal, and interval data. Nominal is used to represent items such as gender and division. Ordinal data is used to measure the number of months at BIMS. Finally, the data gathered from the first 10 questions represents interval data.
Data Evaluation
There are fourteen questions on the BIMS employee questionnaire survey to be filled out by all employees. Only 78% of their employees answered the survey, out of them there is a high percentage that is dissatisfied. Food service and housekeeping employees were the departments that filled out the most surveys; as well as being the most tenured. Also noted, more men completed the survey, as well as 12 managers. A data matrix was created to present the data gathered. The data code of the following variables 1 = strongly dissatisfied, 2 = dissatisfied, 3 = neutral, 4 = satisfied, and 5 = strongly satisfied. A member of the support staff entered the data manually. The data was entered into a spreadsheet (See Appendix Exhibit
A). The data was collected, analyzed, and organized; the errors in the data were discovered and remove or corrected. Sally made 23 errors throughout the process of entering the data. However, no errors were made in the length of time BIMS service. In the spreadsheet, the errors are labeled error and null information (See Appendix Exhibit B).
Conclusions Drawn
The survey brought to light several key issues. Overall, BIMS employees are dissatisfied, with an overall average of 2.72. The two main areas of concern for employees were pay (mean: 2.18) and communication (mean: 2.22). Both of these items had the lowest mean and standard deviation. This illustrates that employees were most in unison in answering the questions.
Management should consider a compensation review, in order to increase employee satisfaction and reduce turnover. Employees would be less likely to leave BIMS if they felt their compensation was fair. Additionally, management should review their current method and plan for communicating with employees. The survey clearly shows that employees do not feel the company is good at communicating with them. If employees feel that management is not communicating with them, they will not be open and responsive to change. The firm should implement a compensation review and a new communication plan. The firm should do a follow up survey after implementing the recommendations to see if scores have increased. Exhibit A
BIMS Employee Survey
Using the scale provided, record your answer by circling the number that is closest to your view where 5 is a very positive response and 1 is a very negative choice.
Very Negative Very Positive
1. How well do you enjoy working for BIMS?
2. You enjoy your assigned shift.
3. Your request for your desired shift was fulfilled.
4. How many times have you called in sick in the last month?
5. You are well trained for your work.
6. You are paid fairly for the work you do.
7. Your supervisor treats you fairly.
8. Your supervisor’s boss treats your division fairly.
9. The company is good at communicating.
10. You do not fear that you will lose your job.
A. In which division do you work?
B. How long have you worked for BIMS?
C. What is your gender?
D. Are you a manager or supervisor?
1 2 3 4 5
1 2 3 4 5
1 2 3 4 5
1 2 3 4 5
1 2 3 4 5
1 2 3 4 5
1 2 3 4 5
1 2 3 4 5
1 2 3 4 5
1 2 3 4 5
Food: _ Housekeeping: _ Maintenance: _
Years: _____ Months: _____
Female: _____ Male: _____
Yes: _____ No: _____
Exhibit B (Raw Data)
Survey A Data Set
No
Q1
Q2
Q3
Q4
Q5
Q6
Q7
Q8
Q9
Q10
A
B
C
D
1
3
4
0
1
5
1
3
0
3
2
3
37
2
2
2
5
5
5
5
5
3
5
5
2
5
1
12
1
2
3
1
2
1
5
5
1
1
1
1
1
2
76
1
2
4
2
5
3
3
2
4
5
1
3
4
2
3
2
1
5
4
4
5
1
4
1
3
3
2
4
2
16
1
2
6
6
2
5
4
3
3
2
1
2
1
1
52
1
2
7
0
1
4
5
3
2
5
4
2
1
1
8
2
2
8
1
3
2
2
5
2
4
5
3
2
2
28
0
2
9
3
3
1
4
4
2
2
2
2
4
3
15
2
1
10
5
1
3
2
2
2
1
4
1
1
1
83
2
2
11
5
4
3
3
1
3
3
2
2
1
2
21
1
1
12
4
5
1
3
3
2
3
3
3
2
1
216
2
2
13
2
2
4
0
3
3
1
3
3
3
1
27
1
1
14
1
4
5
5
1
3
4
0
2
1
2
5
1
2
15
3
2
2
4
4
0
5
5
3
4
3
27
2
2
16
3
3
4
1
5
2
2
4
4
5
2
16
2
2
17
1
3
2
1
2
3
4
1
2
2
1
4
1
2
18
4
0
3
2
4
1
2
1
1
4
2
58
2
2
19
5
5
3
5
2
1
3
2
3
2
1
108
0
1
20
2
4
2
1
3
2
3
5
3
3
2
82
2
2
21
4
1
5
5
4
3
5
2
1
3
1
43
2
2
22
2
1
4
2
2
1
5
4
3
0
0
14
1
0
23
3
2
1
3
5
4
4
2
2
5
2
96
1
2
24
3
5
1
2
4
2
1
3
2
4
2
251
2
2
25
2
1
2
2
1
3
1
2
4
1
3
87
1
1
26
5
4
5
3
1
2
2
2
2
1
1
15
1
2
27
4
2
1
5
2
2
5
3
3
2
2
7
2
2
28
1
3
4
4
5
3
1
5
3
5
2
36
2
2
29
1
2
2
4
1
2
4
4
2
1
1
139
1
2
30
2
2
3
2
4
1
2
4
1
4
1
47
2
0
31
5
3
2
2
2
4
3
2
4
2
2
14
2
2
32
1
5
2
3
3
2
2
2
1
3
1
9
2
2
33
4
4
3
1
2
2
2
3
1
2
3
7
1
2
34
2
4
5
1
2
3
3
1
2
2
2
116
2
2
35
3
2
4
2
3
1
5
1
3
3
1
73
2
1
36
2
2
4
5
5
1
4
2
1
5
1
157
1
2
37
2
3
2
4
4
2
4
5
3
4
2
14
2
2
38
3
1
2
2
4
1
2
4
2
4
1
2
1
2
39
5
1
3
1
2
3
2
2
3
2
2
69
2
2
40
4
2
1
0
2
2
3
1
2
2
1
14
2
1
41
4
5
1
3
3
1
1
0
2
3
2
67
2
2
42
2
4
2
2
1
0
1
3
3
1
2
44
1
2
43
2
2
5
1
1
3
2
2
2
1
1
60
2
2
44
3
1
4
4
2
2
5
1
4
2
1
8
2
1
45
1
0
2
3
5
1
4
4
2
5
2
57
2
2
46
1
3
1
2
4
1
2
3
2
4
2
277
1
2
47
2
2
5
5
2
3
1
2
2
2
1
328
2
2
48
5
1
3
3
1
2
5
5
3
1
2
57
2
2
49
4
4
2
2
5
2
3
3
1
0
1
97
1
2
50
2
3
1
1
3
3
2
2
1
3
2
54
2
2
51
1
2
4
4
2
2
1
1
2
2
3
17
2
2
52
5
5
3
4
1
1
4
4
3
1
1
6
2
2
53
3
3
2
1
4
2
3
4
2
4
2
209
1
2
54
2
2
5
2
3
4
2
1
2
3
1
96
2
2
55
1
1
3
5
2
1
5
2
1
2
1
5
2
1
56
4
4
2
2
5
2
3
5
3
5
2
6
2
2
57
3
4
1
3
3
2
2
2
3
3
2
12
2
2
58
2
1
4
3
2
2
1
3
2
2
1
4
2
2
59
5
2
4
2
1
3
4
3
1
1
2
7
2
2
60
3
5
1
3
0
3
4
2
1
4
3
19
1
2
61
2
2
2
2
4
2
1
3
3
4
2
119
2
2
62
1
3
5
1
1
3
2
2
2
1
1
53
2
2
63
4
3
2
4
2
2
5
1
2
2
2
22
2
1
64
4
2
3
5
5
1
2
4
3
5
1
14
2
2
65
1
3
3
2
2
4
3
5
2
2
2
23
1
2
66
2
2
2
1
3
1
3
2
1
3
1
7
2
2
67
5
1
3
6
3
2
2
1
2
3
1
5
2
2
68
2
4
2
2
2
1
3
6
4
2
2
9
1
2
69
3
5
1
0
3
3
2
2
1
3
2
19
2
2
70
3
2
4
4
2
2
1
0
2
2
3
18
1
2
71
2
1
5
5
1
0
4
4
2
1
2
57
1
2
72
3
6
2
1
4
3
5
5
2
4
2
49
2
2
73
2
2
1
2
5
2
2
1
3
5
1
61
1
2
74
1
0
4
4
2
1
1
2
3
2
1
11
2
2
75
4
4
5
5
1
2
4
4
2
1
2
90
2
1
76
5
5
2
1
4
2
5
5
3
6
3
47
1
2
77
2
1
1
2
5
4
2
1
1
2
1
63
1
2
78
1
2
3
6
2
1
1
2
1
4
2
10
2
2
Sally, the office support staff member in charge of data entry, made a decision when she was entering the data: For any missing data, she would enter a 0. She felt that would best represent any questions that people failed to answer. She also has a bad habit of typing 6 when she means 5. However, she was very careful when entering an employee’s length of service. She did not make any errors in that column when she converted the years and months into just total months.
Exhibit B (Cleaned)
Survey A Data Set
Data Cleaned
No
Q1
Q2
Q3
Q4
Q5
Q6
Q7
Q8
Q9
Q10
A
B
C
D
1
3
4
3
1
5
1
3
3
3
2
3
37
2
2
2
5
5
5
5
5
3
5
5
2
5
1
12
1
2
3
1
2
1
5
5
1
1
1
1
1
2
76
1
2
4
2
5
3
3
2
4
5
1
3
4
2
3
2
1
5
4
4
5
1
4
1
3
3
2
4
2
16
1
2
6
5
2
5
4
3
3
2
1
2
1
1
52
1
2
7
3
1
4
5
3
2
5
4
2
1
1
8
2
2
8
1
3
2
2
5
2
4
5
3
2
2
28
0
2
9
3
3
1
4
4
2
2
2
2
4
3
15
2
1
10
5
1
3
2
2
2
1
4
1
1
1
83
2
2
11
5
4
3
3
1
3
3
2
2
1
2
21
1
1
12
4
5
1
3
3
2
3
3
3
2
1
216
2
2
13
2
2
4
3
3
3
1
3
3
3
1
27
1
1
14
1
4
5
5
1
3
4
3
2
1
2
5
1
2
15
3
2
2
4
4
3
5
5
3
4
3
27
2
2
16
3
3
4
1
5
2
2
4
4
5
2
16
2
2
17
1
3
2
1
2
3
4
1
2
2
1
4
1
2
18
4
3
3
2
4
1
2
1
1
4
2
58
2
2
19
5
5
3
5
2
1
3
2
3
2
1
108
0
1
20
2
4
2
1
3
2
3
5
3
3
2
82
2
2
21
4
1
5
5
4
3
5
2
1
3
1
43
2
2
22
2
1
4
2
2
1
5
4
3
3
*
14
1
0
23
3
2
1
3
5
4
4
2
2
5
2
96
1
2
24
3
5
1
2
4
2
1
3
2
4
2
251
2
2
25
2
1
2
2
1
3
1
2
4
1
3
87
1
1
26
5
4
5
3
1
2
2
2
2
1
1
15
1
2
27
4
2
1
5
2
2
5
3
3
2
2
7
2
2
28
1
3
4
4
5
3
1
5
3
5
2
36
2
2
29
1
2
2
4
1
2
4
4
2
1
1
139
1
2
30
2
2
3
2
4
1
2
4
1
4
1
47
2
0
31
5
3
2
2
2
4
3
2
4
2
2
14
2
2
32
1
5
2
3
3
2
2
2
1
3
1
9
2
2
33
4
4
3
1
2
2
2
3
1
2
3
7
1
2
34
2
4
5
1
2
3
3
1
2
2
2
116
2
2
35
3
2
4
2
3
1
5
1
3
3
1
73
2
1
36
2
2
4
5
5
1
4
2
1
5
1
157
1
2
37
2
3
2
4
4
2
4
5
3
4
2
14
2
2
38
3
1
2
2
4
1
2
4
2
4
1
2
1
2
39
5
1
3
1
2
3
2
2
3
2
2
69
2
2
40
4
2
1
3
2
2
3
1
2
2
1
14
2
1
41
4
5
1
3
3
1
1
3
2
3
2
67
2
2
42
2
4
2
2
1
3
1
3
3
1
2
44
1
2
43
2
2
5
1
1
3
2
2
2
1
1
60
2
2
44
3
1
4
4
2
2
5
1
4
2
1
8
2
1
45
1
3
2
3
5
1
4
4
2
5
2
57
2
2
46
1
3
1
2
4
1
2
3
2
4
2
277
1
2
47
2
2
5
5
2
3
1
2
2
2
1
328
2
2
48
5
1
3
3
1
2
5
5
3
1
2
57
2
2
49
4
4
2
2
5
2
3
3
1
3
1
97
1
2
50
2
3
1
1
3
3
2
2
1
3
2
54
2
2
51
1
2
4
4
2
2
1
1
2
2
3
17
2
2
52
5
5
3
4
1
1
4
4
3
1
1
6
2
2
53
3
3
2
1
4
2
3
4
2
4
2
209
1
2
54
2
2
5
2
3
4
2
1
2
3
1
96
2
2
55
1
1
3
5
2
1
5
2
1
2
1
5
2
1
56
4
4
2
2
5
2
3
5
3
5
2
6
2
2
57
3
4
1
3
3
2
2
2
3
3
2
12
2
2
58
2
1
4
3
2
2
1
3
2
2
1
4
2
2
59
5
2
4
2
1
3
4
3
1
1
2
7
2
2
60
3
5
1
3
3
3
4
2
1
4
3
19
1
2
61
2
2
2
2
4
2
1
3
3
4
2
119
2
2
62
1
3
5
1
1
3
2
2
2
1
1
53
2
2
63
4
3
2
4
2
2
5
1
2
2
2
22
2
1
64
4
2
3
5
5
1
2
4
3
5
1
14
2
2
65
1
3
3
2
2
4
3
5
2
2
2
23
1
2
66
2
2
2
1
3
1
3
2
1
3
1
7
2
2
67
5
1
3
5
3
2
2
1
2
3
1
5
2
2
68
2
4
2
2
2
1
3
5
4
2
2
9
1
2
69
3
5
1
3
3
3
2
2
1
3
2
19
2
2
70
3
2
4
4
2
2
1
3
2
2
3
18
1
2
71
2
1
5
5
1
3
4
4
2
1
2
57
1
2
72
3
5
2
1
4
3
5
5
2
4
2
49
2
2
73
2
2
1
2
5
2
2
1
3
5
1
61
1
2
74
1
3
4
4
2
1
1
2
3
2
1
11
2
2
75
4
4
5
5
1
2
4
4
2
1
2
90
2
1
76
5
5
2
1
4
2
5
5
3
5
3
47
1
2
77
2
1
1
2
5
4
2
1
1
2
1
63
1
2
78
1
2
3
5
2
1
1
2
1
4
2
10
2
2
* indicates incomplete data entry
indicates adjusted data
The Ballard Integrated Managed Services has identified a significant change in their turnover rate; however, the cause of the increase has not been identified. To identify the cause BIMS decide to approach the employees with a survey that focuses on employee morale, job satisfaction, and equality. The case analysis approaches a possible solution to the problem from the statistical point of view.
BIMS Overview
Ballard Integrated Managed Services, Inc. (BIMS) is a company that provides housekeeping and foodservices to large corporations and businesses. BIMS employs a total of 452 employees, including full-time workers, part-time workers, and management employees. The average turnover rate for BIMS is typically 55-60%. During the past four months, the turnover rate has increased to over 64%. …show more content…
Despite the efforts to get to the root of the issue causing the high turnover rate, management at BIMS has been unsuccessful. Morale is low at BIMS, and there has been an increase in the use of sick leave. The performance of workers has become insufficient, which has caused a number of complaints from clients.
Data Collection
Ballard Integrated Managed Services, Inc.’s General Manager, Barbara Tucker, was concerned about why the morale in the staff went down. The HR director, Debbie Homer, developed an employee survey in order to collect data to find out why worker morale has decreased. The survey will be sent out to all employees, excluding upper management. The survey will be distributed with the employees’ bi-weekly payroll checks, with all responses to be both voluntary and anonymous. The survey questions ask the workers to share their opinions about working conditions, fair treatment, shift hours, quality of training, internal company communications, level of compensation, and job security.
Types Of Data Collected
The data included in the BIMS Employee Survey provided by Ballard Integrated Managed Services, Inc., has both qualitative and quantitative data. Employees were given the opportunity to complete the survey at their leisure. The firm expects the survey to collect all necessary data for analysis. The first 10 questions provide the firm qualitative data. The instructions inform employees to answer the questions by circling the number closest to their view. The structure is set up to allow employees to circle numbers one through five to show their positive or negative views toward each particular question (with one being very negative and five being very positive). There are four additional quantitative questions presented (questions A-D). The questions address work division, years of service, gender, and employee level.
The survey presented two the two types of variables.
While the first 10 questions provided the qualitative data, the last 4 questions provided the quantitative data. The survey utilizes nominal, ordinal, and interval data. Nominal is used to represent items such as gender and division. Ordinal data is used to measure the number of months at BIMS. Finally, the data gathered from the first 10 questions represents interval data.
Data Evaluation
There are fourteen questions on the BIMS employee questionnaire survey to be filled out by all employees. Only 78% of their employees answered the survey, out of them there is a high percentage that is dissatisfied. Food service and housekeeping employees were the departments that filled out the most surveys; as well as being the most tenured. Also noted, more men completed the survey, as well as 12 managers. A data matrix was created to present the data gathered. The data code of the following variables 1 = strongly dissatisfied, 2 = dissatisfied, 3 = neutral, 4 = satisfied, and 5 = strongly satisfied. A member of the support staff entered the data manually. The data was entered into a spreadsheet (See Appendix Exhibit
A). The data was collected, analyzed, and organized; the errors in the data were discovered and remove or corrected. Sally made 23 errors throughout the process of entering the data. However, no errors were made in the length of time BIMS service. In the spreadsheet, the errors are labeled error and null information (See Appendix Exhibit B).
Conclusions Drawn
The survey brought to light several key issues. Overall, BIMS employees are dissatisfied, with an overall average of 2.72. The two main areas of concern for employees were pay (mean: 2.18) and communication (mean: 2.22). Both of these items had the lowest mean and standard deviation. This illustrates that employees were most in unison in answering the questions.
Management should consider a compensation review, in order to increase employee satisfaction and reduce turnover. Employees would be less likely to leave BIMS if they felt their compensation was fair. Additionally, management should review their current method and plan for communicating with employees. The survey clearly shows that employees do not feel the company is good at communicating with them. If employees feel that management is not communicating with them, they will not be open and responsive to change. The firm should implement a compensation review and a new communication plan. The firm should do a follow up survey after implementing the recommendations to see if scores have increased. Exhibit A
BIMS Employee Survey
Using the scale provided, record your answer by circling the number that is closest to your view where 5 is a very positive response and 1 is a very negative choice.
Very Negative Very Positive
1. How well do you enjoy working for BIMS?
2. You enjoy your assigned shift.
3. Your request for your desired shift was fulfilled.
4. How many times have you called in sick in the last month?
5. You are well trained for your work.
6. You are paid fairly for the work you do.
7. Your supervisor treats you fairly.
8. Your supervisor’s boss treats your division fairly.
9. The company is good at communicating.
10. You do not fear that you will lose your job.
A. In which division do you work?
B. How long have you worked for BIMS?
C. What is your gender?
D. Are you a manager or supervisor?
1 2 3 4 5
1 2 3 4 5
1 2 3 4 5
1 2 3 4 5
1 2 3 4 5
1 2 3 4 5
1 2 3 4 5
1 2 3 4 5
1 2 3 4 5
1 2 3 4 5
Food: _ Housekeeping: _ Maintenance: _
Years: _____ Months: _____
Female: _____ Male: _____
Yes: _____ No: _____
Exhibit B (Raw Data)
Survey A Data Set
No
Q1
Q2
Q3
Q4
Q5
Q6
Q7
Q8
Q9
Q10
A
B
C
D
1
3
4
0
1
5
1
3
0
3
2
3
37
2
2
2
5
5
5
5
5
3
5
5
2
5
1
12
1
2
3
1
2
1
5
5
1
1
1
1
1
2
76
1
2
4
2
5
3
3
2
4
5
1
3
4
2
3
2
1
5
4
4
5
1
4
1
3
3
2
4
2
16
1
2
6
6
2
5
4
3
3
2
1
2
1
1
52
1
2
7
0
1
4
5
3
2
5
4
2
1
1
8
2
2
8
1
3
2
2
5
2
4
5
3
2
2
28
0
2
9
3
3
1
4
4
2
2
2
2
4
3
15
2
1
10
5
1
3
2
2
2
1
4
1
1
1
83
2
2
11
5
4
3
3
1
3
3
2
2
1
2
21
1
1
12
4
5
1
3
3
2
3
3
3
2
1
216
2
2
13
2
2
4
0
3
3
1
3
3
3
1
27
1
1
14
1
4
5
5
1
3
4
0
2
1
2
5
1
2
15
3
2
2
4
4
0
5
5
3
4
3
27
2
2
16
3
3
4
1
5
2
2
4
4
5
2
16
2
2
17
1
3
2
1
2
3
4
1
2
2
1
4
1
2
18
4
0
3
2
4
1
2
1
1
4
2
58
2
2
19
5
5
3
5
2
1
3
2
3
2
1
108
0
1
20
2
4
2
1
3
2
3
5
3
3
2
82
2
2
21
4
1
5
5
4
3
5
2
1
3
1
43
2
2
22
2
1
4
2
2
1
5
4
3
0
0
14
1
0
23
3
2
1
3
5
4
4
2
2
5
2
96
1
2
24
3
5
1
2
4
2
1
3
2
4
2
251
2
2
25
2
1
2
2
1
3
1
2
4
1
3
87
1
1
26
5
4
5
3
1
2
2
2
2
1
1
15
1
2
27
4
2
1
5
2
2
5
3
3
2
2
7
2
2
28
1
3
4
4
5
3
1
5
3
5
2
36
2
2
29
1
2
2
4
1
2
4
4
2
1
1
139
1
2
30
2
2
3
2
4
1
2
4
1
4
1
47
2
0
31
5
3
2
2
2
4
3
2
4
2
2
14
2
2
32
1
5
2
3
3
2
2
2
1
3
1
9
2
2
33
4
4
3
1
2
2
2
3
1
2
3
7
1
2
34
2
4
5
1
2
3
3
1
2
2
2
116
2
2
35
3
2
4
2
3
1
5
1
3
3
1
73
2
1
36
2
2
4
5
5
1
4
2
1
5
1
157
1
2
37
2
3
2
4
4
2
4
5
3
4
2
14
2
2
38
3
1
2
2
4
1
2
4
2
4
1
2
1
2
39
5
1
3
1
2
3
2
2
3
2
2
69
2
2
40
4
2
1
0
2
2
3
1
2
2
1
14
2
1
41
4
5
1
3
3
1
1
0
2
3
2
67
2
2
42
2
4
2
2
1
0
1
3
3
1
2
44
1
2
43
2
2
5
1
1
3
2
2
2
1
1
60
2
2
44
3
1
4
4
2
2
5
1
4
2
1
8
2
1
45
1
0
2
3
5
1
4
4
2
5
2
57
2
2
46
1
3
1
2
4
1
2
3
2
4
2
277
1
2
47
2
2
5
5
2
3
1
2
2
2
1
328
2
2
48
5
1
3
3
1
2
5
5
3
1
2
57
2
2
49
4
4
2
2
5
2
3
3
1
0
1
97
1
2
50
2
3
1
1
3
3
2
2
1
3
2
54
2
2
51
1
2
4
4
2
2
1
1
2
2
3
17
2
2
52
5
5
3
4
1
1
4
4
3
1
1
6
2
2
53
3
3
2
1
4
2
3
4
2
4
2
209
1
2
54
2
2
5
2
3
4
2
1
2
3
1
96
2
2
55
1
1
3
5
2
1
5
2
1
2
1
5
2
1
56
4
4
2
2
5
2
3
5
3
5
2
6
2
2
57
3
4
1
3
3
2
2
2
3
3
2
12
2
2
58
2
1
4
3
2
2
1
3
2
2
1
4
2
2
59
5
2
4
2
1
3
4
3
1
1
2
7
2
2
60
3
5
1
3
0
3
4
2
1
4
3
19
1
2
61
2
2
2
2
4
2
1
3
3
4
2
119
2
2
62
1
3
5
1
1
3
2
2
2
1
1
53
2
2
63
4
3
2
4
2
2
5
1
2
2
2
22
2
1
64
4
2
3
5
5
1
2
4
3
5
1
14
2
2
65
1
3
3
2
2
4
3
5
2
2
2
23
1
2
66
2
2
2
1
3
1
3
2
1
3
1
7
2
2
67
5
1
3
6
3
2
2
1
2
3
1
5
2
2
68
2
4
2
2
2
1
3
6
4
2
2
9
1
2
69
3
5
1
0
3
3
2
2
1
3
2
19
2
2
70
3
2
4
4
2
2
1
0
2
2
3
18
1
2
71
2
1
5
5
1
0
4
4
2
1
2
57
1
2
72
3
6
2
1
4
3
5
5
2
4
2
49
2
2
73
2
2
1
2
5
2
2
1
3
5
1
61
1
2
74
1
0
4
4
2
1
1
2
3
2
1
11
2
2
75
4
4
5
5
1
2
4
4
2
1
2
90
2
1
76
5
5
2
1
4
2
5
5
3
6
3
47
1
2
77
2
1
1
2
5
4
2
1
1
2
1
63
1
2
78
1
2
3
6
2
1
1
2
1
4
2
10
2
2
Sally, the office support staff member in charge of data entry, made a decision when she was entering the data: For any missing data, she would enter a 0. She felt that would best represent any questions that people failed to answer. She also has a bad habit of typing 6 when she means 5. However, she was very careful when entering an employee’s length of service. She did not make any errors in that column when she converted the years and months into just total months.
Exhibit B (Cleaned)
Survey A Data Set
Data Cleaned
No
Q1
Q2
Q3
Q4
Q5
Q6
Q7
Q8
Q9
Q10
A
B
C
D
1
3
4
3
1
5
1
3
3
3
2
3
37
2
2
2
5
5
5
5
5
3
5
5
2
5
1
12
1
2
3
1
2
1
5
5
1
1
1
1
1
2
76
1
2
4
2
5
3
3
2
4
5
1
3
4
2
3
2
1
5
4
4
5
1
4
1
3
3
2
4
2
16
1
2
6
5
2
5
4
3
3
2
1
2
1
1
52
1
2
7
3
1
4
5
3
2
5
4
2
1
1
8
2
2
8
1
3
2
2
5
2
4
5
3
2
2
28
0
2
9
3
3
1
4
4
2
2
2
2
4
3
15
2
1
10
5
1
3
2
2
2
1
4
1
1
1
83
2
2
11
5
4
3
3
1
3
3
2
2
1
2
21
1
1
12
4
5
1
3
3
2
3
3
3
2
1
216
2
2
13
2
2
4
3
3
3
1
3
3
3
1
27
1
1
14
1
4
5
5
1
3
4
3
2
1
2
5
1
2
15
3
2
2
4
4
3
5
5
3
4
3
27
2
2
16
3
3
4
1
5
2
2
4
4
5
2
16
2
2
17
1
3
2
1
2
3
4
1
2
2
1
4
1
2
18
4
3
3
2
4
1
2
1
1
4
2
58
2
2
19
5
5
3
5
2
1
3
2
3
2
1
108
0
1
20
2
4
2
1
3
2
3
5
3
3
2
82
2
2
21
4
1
5
5
4
3
5
2
1
3
1
43
2
2
22
2
1
4
2
2
1
5
4
3
3
*
14
1
0
23
3
2
1
3
5
4
4
2
2
5
2
96
1
2
24
3
5
1
2
4
2
1
3
2
4
2
251
2
2
25
2
1
2
2
1
3
1
2
4
1
3
87
1
1
26
5
4
5
3
1
2
2
2
2
1
1
15
1
2
27
4
2
1
5
2
2
5
3
3
2
2
7
2
2
28
1
3
4
4
5
3
1
5
3
5
2
36
2
2
29
1
2
2
4
1
2
4
4
2
1
1
139
1
2
30
2
2
3
2
4
1
2
4
1
4
1
47
2
0
31
5
3
2
2
2
4
3
2
4
2
2
14
2
2
32
1
5
2
3
3
2
2
2
1
3
1
9
2
2
33
4
4
3
1
2
2
2
3
1
2
3
7
1
2
34
2
4
5
1
2
3
3
1
2
2
2
116
2
2
35
3
2
4
2
3
1
5
1
3
3
1
73
2
1
36
2
2
4
5
5
1
4
2
1
5
1
157
1
2
37
2
3
2
4
4
2
4
5
3
4
2
14
2
2
38
3
1
2
2
4
1
2
4
2
4
1
2
1
2
39
5
1
3
1
2
3
2
2
3
2
2
69
2
2
40
4
2
1
3
2
2
3
1
2
2
1
14
2
1
41
4
5
1
3
3
1
1
3
2
3
2
67
2
2
42
2
4
2
2
1
3
1
3
3
1
2
44
1
2
43
2
2
5
1
1
3
2
2
2
1
1
60
2
2
44
3
1
4
4
2
2
5
1
4
2
1
8
2
1
45
1
3
2
3
5
1
4
4
2
5
2
57
2
2
46
1
3
1
2
4
1
2
3
2
4
2
277
1
2
47
2
2
5
5
2
3
1
2
2
2
1
328
2
2
48
5
1
3
3
1
2
5
5
3
1
2
57
2
2
49
4
4
2
2
5
2
3
3
1
3
1
97
1
2
50
2
3
1
1
3
3
2
2
1
3
2
54
2
2
51
1
2
4
4
2
2
1
1
2
2
3
17
2
2
52
5
5
3
4
1
1
4
4
3
1
1
6
2
2
53
3
3
2
1
4
2
3
4
2
4
2
209
1
2
54
2
2
5
2
3
4
2
1
2
3
1
96
2
2
55
1
1
3
5
2
1
5
2
1
2
1
5
2
1
56
4
4
2
2
5
2
3
5
3
5
2
6
2
2
57
3
4
1
3
3
2
2
2
3
3
2
12
2
2
58
2
1
4
3
2
2
1
3
2
2
1
4
2
2
59
5
2
4
2
1
3
4
3
1
1
2
7
2
2
60
3
5
1
3
3
3
4
2
1
4
3
19
1
2
61
2
2
2
2
4
2
1
3
3
4
2
119
2
2
62
1
3
5
1
1
3
2
2
2
1
1
53
2
2
63
4
3
2
4
2
2
5
1
2
2
2
22
2
1
64
4
2
3
5
5
1
2
4
3
5
1
14
2
2
65
1
3
3
2
2
4
3
5
2
2
2
23
1
2
66
2
2
2
1
3
1
3
2
1
3
1
7
2
2
67
5
1
3
5
3
2
2
1
2
3
1
5
2
2
68
2
4
2
2
2
1
3
5
4
2
2
9
1
2
69
3
5
1
3
3
3
2
2
1
3
2
19
2
2
70
3
2
4
4
2
2
1
3
2
2
3
18
1
2
71
2
1
5
5
1
3
4
4
2
1
2
57
1
2
72
3
5
2
1
4
3
5
5
2
4
2
49
2
2
73
2
2
1
2
5
2
2
1
3
5
1
61
1
2
74
1
3
4
4
2
1
1
2
3
2
1
11
2
2
75
4
4
5
5
1
2
4
4
2
1
2
90
2
1
76
5
5
2
1
4
2
5
5
3
5
3
47
1
2
77
2
1
1
2
5
4
2
1
1
2
1
63
1
2
78
1
2
3
5
2
1
1
2
1
4
2
10
2
2
* indicates incomplete data entry
indicates adjusted data