Data Collection: BIMS
5/5/15
QNT351
Dr. Oggs

Data Collection: BIMS BIMS is a support services company that specializes in providing housekeeping and foodservice to corporations and institutions. The company provides various services such as housekeeping, foodservice, general cleaning, and physical plant maintenance which helps the company compete in this highly competitive industry. The food service division, led by Flora Torres, is responsible for providing daily meals for the 5,300 staff members, nurses, and doctors as well as the general public in the six cafeterias. The hospitality division, managed by Henry Dumas, is responsible for refreshing each hospital room, including changing the linens on empty beds, replacing towels, and sanitizing bathrooms, which includes maintaining the public areas: hallways, lobbies, elevators, and so on. The Physical Plant Maintenance division, led by Matt Lee, is responsible for all of the nonmedical equipment and physical aspects of the medical center. Considering the low-skill nature of the majority of positions, BIMS typically experiences an annual turnover rate of 55 to 60% at this location. However, during the past 4 months the rate has climbed to over 64%. Additionally, a gernal malaise has settled over the staff resulting in poor work quality. The company has been receiving more complaints from the hospitality administration.
Problem Statement
The problem at BIMS is they are experiencing high turnover rates and low morale among their employees.
Purpose Statement
The purpose of this paper is to determine what factors are affecting the high turnover rates and low morale at BIMS.
Research Question
What effect does working conditions, shift hours, quality of training, level of compensation, fair treatment, internal company communications, and job security have on high turnover rate and low morale within BIMS?
Hypothesis
H0: Working conditions will not have an effect on low morale and high turnover rate.
H1: Working conditions will have an effect on low morale and high turnover rate.

H0:Shift hours will not have an effect on low morale and high turnover rate.
H1: Shift hours will have an effect on low morale and high turnover rate.

H0: Quality of training will not have an effect on low morale and high turnover rate.
H1: Quality of training will have an effect on low morale and high turnover rate.

H0: Level of compensation will not have an effect on low morale and high turnover rate.
H1: Level of compensation will have an effect on low morale and high turnover rate.

H0: Fair treatment will not have an effect on low morale and high turnover rate.
H1: Fair treatment will have an effect on low morale and high turnover rate.

H0: Internal company communications will not have an effect on low morale and high turnover rate.
H1: Internal company communications will have an effect on low morale and high turnover rate.

H0: Job security will not have an effect on low morale and high turnover rate.
H1: Job security will have an effect on low morale and high turnover rate.
Instruments
The instrument used to collect the data was a survey. The in depth survey will be given to all employees with their paychecks; excluding all top management employees. This assessment will contain 10 questions that will be graded by the employee on a scale 1 through 5; with 1 stating the least favorable situation, and 5 representing the highest regard. Additionally, the survey will also have 4 questions; 3 needing a check next to the answer and one needing a filled in answer. The survey questions were tailor- made to assess the contentment level of the employees at BIMS. These questions are meant to single out the underlying issues and concerns that were causing high turnover and low morale at BIMS. The BIMS survey includes 4 Demographic genre questions pertaining to time of service, gender, and labor grade. This allows BIMS to narrow policy concerns where they have problems; including hierarchy layers in lower management and/or personnel issues with current management style. This survey can provide a detailed insight to the people responsible for BIMS working conditions, pay, and benefits.
Level of Measurement
During the BIMS research there were different levels of measurement used to identify the variable involved in the BIMS case study. The levels of measurements are referring to the relationships of the values that are assigned to the variable used to identify the levels of measurement for each of the variables involved in the study. There are four different types of levels of measurements in statistics which are nominal, ordinal, interval, and ratio. A nominal variable is where order does not matter but the category does. The ordinal variable is where the order does matter but the value difference does not. The interval variable is where the difference of two variable are important. Even though the ratio variable consists of all the attributes of an interval variable, an interval variable has a clear definition of zero. Ordinal level of measurement was used for questions 1 through 10.The nominal level of measurement was used for questions A, C and D. Lastly, the interval level of measurement was used for question B.
Types of Data
After each employee completed their survey, we were able to decide how to make our company better. This survey from exhibit A will tell us the true feeling of some of our employees. We can identify the type of data for each question below as quantitative or quantitative or both. Once we determine how each employee answered their question we can then make the needed changes to make our employees happy.
Questions 1 through 10 are all quantitative questions because each questions is answered on a scale of 1 through 5. There are no words or areas to give a brief explanation on he or she feels. The last section of the survey is geared towards the demographic. Questions A, C, and D are qualitative, because the questions ask for a check next to a word. Letter B is quantitative because it asked for a number.
Code and Clean the Data Ballard Integrated Managed Services, Inc. sent out a survey to their employees. They had 78 out of the 449 employees respond. The survey consisted of 10 questions which had numerical values that represented the employee’s feelings, coded 1 through 5. There were 4 general questions that needed to be coded. These questions allow the analyst to review certain types of employees. The following chart shows the codes assigned to questions A, B, C and D. Question A: | Question B: | Question C: | Question D: | Food: 1 | 1-14 months: 1 | Female: 1 | Yes: 1 | Housekeeping: 2 | 15-49 months: 2 | Male: 2 | No: 2 | Maintenance: 3 | 50-99 months: 3 | | | | 100-328 months: 4 | | |

As the data from the 78 received surveys was being input into excel, Sally, the office support staff member, entered 6 instead of 5 several times. Six is not an applicable answer, so it is a noticeable error. Once this error was corrected and the general questions were coded the data is ready to analyze. Any questions that were not answered on the survey are coded with a 0. The below table shows the data after it has been cleaned and coded: 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 | 2 | 2 | 2 | 2 | 5 | 5 | 5 | 5 | 5 | 3 | 5 | 5 | 2 | 5 | 1 | 1 | 1 | 2 | 3 | 1 | 2 | 1 | 5 | 5 | 1 | 1 | 1 | 1 | 1 | 2 | 3 | 1 | 2 | 4 | 2 | 5 | 3 | 3 | 2 | 4 | 5 | 1 | 3 | 4 | 2 | 1 | 2 | 1 | 5 | 4 | 4 | 5 | 1 | 4 | 1 | 3 | 3 | 2 | 4 | 2 | 2 | 1 | 2 | 6 | 5 | 2 | 5 | 4 | 3 | 3 | 2 | 1 | 2 | 1 | 1 | 3 | 1 | 2 | 7 | 0 | 1 | 4 | 5 | 3 | 2 | 5 | 4 | 2 | 1 | 1 | 1 | 2 | 2 | 8 | 1 | 3 | 2 | 2 | 5 | 2 | 4 | 5 | 3 | 2 | 2 | 2 | 0 | 2 | 9 | 3 | 3 | 1 | 4 | 4 | 2 | 2 | 2 | 2 | 4 | 3 | 2 | 2 | 1 | 10 | 5 | 1 | 3 | 2 | 2 | 2 | 1 | 4 | 1 | 1 | 1 | 3 | 2 | 2 | 11 | 5 | 4 | 3 | 3 | 1 | 3 | 3 | 2 | 2 | 1 | 2 | 2 | 1 | 1 | 12 | 4 | 5 | 1 | 3 | 3 | 2 | 3 | 3 | 3 | 2 | 1 | 4 | 2 | 2 | 13 | 2 | 2 | 4 | 0 | 3 | 3 | 1 | 3 | 3 | 3 | 1 | 2 | 1 | 1 | 14 | 1 | 4 | 5 | 5 | 1 | 3 | 4 | 0 | 2 | 1 | 2 | 1 | 1 | 2 | 15 | 3 | 2 | 2 | 4 | 4 | 0 | 5 | 5 | 3 | 4 | 3 | 2 | 2 | 2 | 16 | 3 | 3 | 4 | 1 | 5 | 2 | 2 | 4 | 4 | 5 | 2 | 2 | 2 | 2 | 17 | 1 | 3 | 2 | 1 | 2 | 3 | 4 | 1 | 2 | 2 | 1 | 1 | 1 | 2 | 18 | 4 | 0 | 3 | 2 | 4 | 1 | 2 | 1 | 1 | 4 | 2 | 3 | 2 | 2 | 19 | 5 | 5 | 3 | 5 | 2 | 1 | 3 | 2 | 3 | 2 | 1 | 4 | 0 | 1 | 20 | 2 | 4 | 2 | 1 | 3 | 2 | 3 | 5 | 3 | 3 | 2 | 3 | 2 | 2 | 21 | 4 | 1 | 5 | 5 | 4 | 3 | 5 | 2 | 1 | 3 | 1 | 2 | 2 | 2 | 22 | 2 | 1 | 4 | 2 | 2 | 1 | 5 | 4 | 3 | 0 | 0 | 1 | 1 | 0 | 23 | 3 | 2 | 1 | 3 | 5 | 4 | 4 | 2 | 2 | 5 | 2 | 3 | 1 | 2 | 24 | 3 | 5 | 1 | 2 | 4 | 2 | 1 | 3 | 2 | 4 | 2 | 4 | 2 | 2 | 25 | 2 | 1 | 2 | 2 | 1 | 3 | 1 | 2 | 4 | 1 | 3 | 3 | 1 | 1 | 26 | 5 | 4 | 5 | 3 | 1 | 2 | 2 | 2 | 2 | 1 | 1 | 2 | 1 | 2 | 27 | 4 | 2 | 1 | 5 | 2 | 2 | 5 | 3 | 3 | 2 | 2 | 1 | 2 | 2 | 28 | 1 | 3 | 4 | 4 | 5 | 3 | 1 | 5 | 3 | 5 | 2 | 2 | 2 | 2 | 29 | 1 | 2 | 2 | 4 | 1 | 2 | 4 | 4 | 2 | 1 | 1 | 4 | 1 | 2 | 30 | 2 | 2 | 3 | 2 | 4 | 1 | 2 | 4 | 1 | 4 | 1 | 2 | 2 | 0 | 31 | 5 | 3 | 2 | 2 | 2 | 4 | 3 | 2 | 4 | 2 | 2 | 1 | 2 | 2 | 32 | 1 | 5 | 2 | 3 | 3 | 2 | 2 | 2 | 1 | 3 | 1 | 1 | 2 | 2 | 33 | 4 | 4 | 3 | 1 | 2 | 2 | 2 | 3 | 1 | 2 | 3 | 1 | 1 | 2 | 34 | 2 | 4 | 5 | 1 | 2 | 3 | 3 | 1 | 2 | 2 | 2 | 4 | 2 | 2 | 35 | 3 | 2 | 4 | 2 | 3 | 1 | 5 | 1 | 3 | 3 | 1 | 3 | 2 | 1 | 36 | 2 | 2 | 4 | 5 | 5 | 1 | 4 | 2 | 1 | 5 | 1 | 4 | 1 | 2 | 37 | 2 | 3 | 2 | 4 | 4 | 2 | 4 | 5 | 3 | 4 | 2 | 1 | 2 | 2 | 38 | 3 | 1 | 2 | 2 | 4 | 1 | 2 | 4 | 2 | 4 | 1 | 1 | 1 | 2 | 39 | 5 | 1 | 3 | 1 | 2 | 3 | 2 | 2 | 3 | 2 | 2 | 3 | 2 | 2 | 40 | 4 | 2 | 1 | 0 | 2 | 2 | 3 | 1 | 2 | 2 | 1 | 1 | 2 | 1 | 41 | 4 | 5 | 1 | 3 | 3 | 1 | 1 | 0 | 2 | 3 | 2 | 3 | 2 | 2 | 42 | 2 | 4 | 2 | 2 | 1 | 0 | 1 | 3 | 3 | 1 | 2 | 2 | 1 | 2 | 43 | 2 | 2 | 5 | 1 | 1 | 3 | 2 | 2 | 2 | 1 | 1 | 3 | 2 | 2 | 44 | 3 | 1 | 4 | 4 | 2 | 2 | 5 | 1 | 4 | 2 | 1 | 1 | 2 | 1 | 45 | 1 | 0 | 2 | 3 | 5 | 1 | 4 | 4 | 2 | 5 | 2 | 3 | 2 | 2 | 46 | 1 | 3 | 1 | 2 | 4 | 1 | 2 | 3 | 2 | 4 | 2 | 4 | 1 | 2 | 47 | 2 | 2 | 5 | 5 | 2 | 3 | 1 | 2 | 2 | 2 | 1 | 4 | 2 | 2 | 48 | 5 | 1 | 3 | 3 | 1 | 2 | 5 | 5 | 3 | 1 | 2 | 3 | 2 | 2 | 49 | 4 | 4 | 2 | 2 | 5 | 2 | 3 | 3 | 1 | 0 | 1 | 3 | 1 | 2 | 50 | 2 | 3 | 1 | 1 | 3 | 3 | 2 | 2 | 1 | 3 | 2 | 3 | 2 | 2 | 51 | 1 | 2 | 4 | 4 | 2 | 2 | 1 | 1 | 2 | 2 | 3 | 2 | 2 | 2 | 52 | 5 | 5 | 3 | 4 | 1 | 1 | 4 | 4 | 3 | 1 | 1 | 1 | 2 | 2 | 53 | 3 | 3 | 2 | 1 | 4 | 2 | 3 | 4 | 2 | 4 | 2 | 4 | 1 | 2 | 54 | 2 | 2 | 5 | 2 | 3 | 4 | 2 | 1 | 2 | 3 | 1 | 3 | 2 | 2 | 55 | 1 | 1 | 3 | 5 | 2 | 1 | 5 | 2 | 1 | 2 | 1 | 1 | 2 | 1 | 56 | 4 | 4 | 2 | 2 | 5 | 2 | 3 | 5 | 3 | 5 | 2 | 1 | 2 | 2 | 57 | 3 | 4 | 1 | 3 | 3 | 2 | 2 | 2 | 3 | 3 | 2 | 1 | 2 | 2 | 58 | 2 | 1 | 4 | 3 | 2 | 2 | 1 | 3 | 2 | 2 | 1 | 1 | 2 | 2 | 59 | 5 | 2 | 4 | 2 | 1 | 3 | 4 | 3 | 1 | 1 | 2 | 1 | 2 | 2 | 60 | 3 | 5 | 1 | 3 | 0 | 3 | 4 | 2 | 1 | 4 | 3 | 2 | 1 | 2 | 61 | 2 | 2 | 2 | 2 | 4 | 2 | 1 | 3 | 3 | 4 | 2 | 4 | 2 | 2 | 62 | 1 | 3 | 5 | 1 | 1 | 3 | 2 | 2 | 2 | 1 | 1 | 3 | 2 | 2 | 63 | 4 | 3 | 2 | 4 | 2 | 2 | 5 | 1 | 2 | 2 | 2 | 2 | 2 | 1 | 64 | 4 | 2 | 3 | 5 | 5 | 1 | 2 | 4 | 3 | 5 | 1 | 1 | 2 | 2 | 65 | 1 | 3 | 3 | 2 | 2 | 4 | 3 | 5 | 2 | 2 | 2 | 2 | 1 | 2 | 66 | 2 | 2 | 2 | 1 | 3 | 1 | 3 | 2 | 1 | 3 | 1 | 1 | 2 | 2 | 67 | 5 | 1 | 3 | 5 | 3 | 2 | 2 | 1 | 2 | 3 | 1 | 1 | 2 | 2 | 68 | 2 | 4 | 2 | 2 | 2 | 1 | 3 | 5 | 4 | 2 | 2 | 1 | 1 | 2 | 69 | 3 | 5 | 1 | 0 | 3 | 3 | 2 | 2 | 1 | 3 | 2 | 2 | 2 | 2 | 70 | 3 | 2 | 4 | 4 | 2 | 2 | 1 | 0 | 2 | 2 | 3 | 2 | 1 | 2 | 71 | 2 | 1 | 5 | 5 | 1 | 0 | 4 | 4 | 2 | 1 | 2 | 3 | 1 | 2 | 72 | 3 | 5 | 2 | 1 | 4 | 3 | 5 | 5 | 2 | 4 | 2 | 2 | 2 | 2 | 73 | 2 | 2 | 1 | 2 | 5 | 2 | 2 | 1 | 3 | 5 | 1 | 3 | 1 | 2 | 74 | 1 | 0 | 4 | 4 | 2 | 1 | 1 | 2 | 3 | 2 | 1 | 1 | 2 | 2 | 75 | 4 | 4 | 5 | 5 | 1 | 2 | 4 | 4 | 2 | 1 | 2 | 3 | 2 | 1 | 76 | 5 | 5 | 2 | 1 | 4 | 2 | 5 | 5 | 3 | 5 | 3 | 2 | 1 | 2 | 77 | 2 | 1 | 1 | 2 | 5 | 4 | 2 | 1 | 1 | 2 | 1 | 3 | 1 | 2 | 78 | 1 | 2 | 3 | 5 | 2 | 1 | 1 | 2 | 1 | 4 | 2 | 1 | 2 | 2 |