QNT 351
August 27, 2014
Henry Jacobs

In this report we will revise, summarize, and present our updated data for BIMS case study review. Analyzing the descriptive statistics helps our team breakdown the basic features of quantitative data results from the survey. However, we do not want to risk the chance of distorting our original findings, but use these statistics to analyze the comparisons of answers from employees and departments. Utilizing the central tendency which are three measures: mean, mode, and median allows us to give senior management raw data to make better decisions with. Measures of Variability findings enables us to differentiate results from BIMS surveys which differs from their mean. Our overall recommendation and analysis will be given to senior management within this paper off the current raw data.
Data Collected The type of data collected in the survey conducted was quantitative as the data collected in the surveys was expressed numerically. Some of the questions were qualitative however the responses given were provided based on a numerical response. The survey had employees’ answer the question provided based on a scale 1-5, one being very negative and five being very positive. The data collected was later coded and entered into a spreadsheet by Debbie’s office support staff however; some errors existed when keying in the wrong number for the response provided and inputting zeros when the option was not available to employees, zero indicated no response was provided.
Level of Measurement This survey had two sections. The first section consisted of ten variables and four demographic questions. Participants were to rate the categories on a scale of five to one. The five is the most positive and one is the least positive. The variables in the first ten questions checked the following; The level of enjoyment of their work, The level of enjoyment of assigned shifts, The level of satisfaction they received the desired shift, How many times they called in sick , The level of how well they feel they were adequately trained, Are they satisfied with their level of pay, Does your supervisor treat you fairly , Does your supervisors boss treat your division fairly ,How well does the company communicate, and The level of fear of losing their job. The second section of the survey is to collect demographic information. The information collected was to determine which department they worked food, housekeeping, and maintenance. The numbers of years they have been employed with the company have been employed in years and months. What is the gender of the person taking the survey? Is the person being surveyed a manager or supervisor.
Data Evaluation The data is entered into the system by sally the data entry staff member. When entering the data she decides that all unanswered questions will be given a zero score. Sally also made a few mistakes of entering some of the fives as sixes .She took the liberty of converting the length of service from years and months to months. The Results from the survey are not correct because she changed the data, and entered some of it wrong. The data will need to be rechecked have the zeros eliminated, and the sixes changed to fives then reevaluated.
Data Corrected When the data is entered incorrectly, it is either because Sally entered a zero for unanswered questions or she input the wrong number. In order to fix the data it must be entered correctly in the system in order to achieve the proper quantitative data. An analysis of the data was conducted and must be input with all of the correct numbers. For unanswered questions they should be placed in an NA category so it will not affect the averages and numbers evaluated. Sally must go through the surveys conducted and collect the accurate numbers to input into the system utilized. After reassessing the data from last week we decided to code the data differently to make it easier to read. In the research questions number one through ten, we decided to change the zeros to ones. We also decided to change the sixes to five due to her accidently entering some fives as sixes. The reasoning behind this is the scale for these questions is 1to 5 with five for most positive and one being most negative. We decided no answer was the same as a negative answer. For question A the data deals with department’s food (1) Housekeeping (2) Maintenance (3) we decided to leave the Zero’s in this section. The zeros will be interpreted as no department indicated. For question B the time of service was given in years and months, Sally converted this to months. Data entry for Question B had no errors .Question C was about Gender female (1) male (2) the non-answered questions zero will be to represent gender unspecified. Question D asked it the participant a manager (1) or supervisor (2) none answers will be coded as zeros to represent unspecified

Descriptive Analysis We used descriptive statistics build a profile of data to show the mean, median, mode, and tendency of the quantitative data. Having the data displayed in charts helped to visualize the answers provided in the employee survey. Numeric codes were used to describe the nominal, ordinal, and interval data at BIMS. After analyzing the data collected we were able to interpret the data and conclude that BIMS was having a high turnover due to low pay and lack of communication throughout the organization.
Conclusion
The mean for Q1-Q10 found in our descriptive statistics resulted in the highest number being (2.90) and lowest (2.10), median did not drop below a (2.00), but did not surpass (3.00), mode data displayed all (2.0) which is close to very negative. Range measurements for variability is represented by the (4) excluding Q6 & Q9 that were both (3). If anything the range once again depicts the rather negative outlook your employees have in regards to your company and management daily dealings. These statistics confirm Debbie’s concern of current weakening employee morale, lack of confidence in company and focuses on unfavorable working environment. It is our recommendation to analyze all the questions annotated on the survey and improve in each area beginning with senior management.