QNT 351 Team Week 3 Assignment

Data Analysis

Team A performed a series of analysis on behalf of the management of Ballard Integrated Managed Services, Inc. (BIMS). These tasks were the result of an emerging trend of attrition and employee dissatisfaction within their organization. The initial actions taken involved data collection that were presented in the form of an internal employee survey. The data collection analysis revealed our hypothesis and we set out to prove that the increase in employee turnover was due to low employee morale and poor employee performance. The initial survey leads us to a very low response rate of 17.3%—we did not achieve our goal of obtaining the feedback of the vast majority of BIMS employees. By utilizing our initial findings we analyzed, displayed, and interpreted, the outcome shows that BIMS was experiencing high turnover due to lack of proper pay and poor communication within the business. This information provided seemed promising from the perspective that we were narrowing down the core issues within the company; it is never enough for management to determine an effective course of action or forecasting. The inferences made through our descriptive analysis approach made use of all three levels of measurement and dispersion and helped us rank the limited feedback on scale of one through five, changing the ordinal and ratio feedback into a numerical value, when necessary. The demographic based questions were significant collected data based on years of service, division, gender and role and facilitated in our manipulation of the survey data. In combination, we were able to scratch the surface on a pattern of data that ranked very negatively and that also met the condition of our hypothesis—so all was not lost in our initial attempt.

The research that was done for Ballard was to determine if the employees were satisfied with their work conditions and was there fair treatment from the company. The survey sent out would ask workers about working conditions, shifts, training, pay, fair treatment and the company itself. The survey was attached to their bi weekly paychecks asking them to return by a certain date. A reminder was sent out as well to encourage participation. The response to this survey was very low only 17.3 % took the time to even respond. However the data collected did provide was quantitative it provided numerical information to possibly give insight on correcting the current employment issues.

The survey sent out was a measurement on a scale from 1 to 5; five being positive and 1 negative rate the following questions. The questions consisted of do you enjoy working for the company? Do you like your shift? How was your training? Are you being paid fairly? Then basic questions to pinpoint your gender, department and position in the company.

The survey was given to determine the decrease in morale in the company and the increase of turnover of employees. Out of the 449 employees given the survey only 78 were returned. Here are the survey results coded by question and answer.

Q1.How well do you enjoy working for BIMS?

15 answered very negative, 21 answered negative, 15 answered neutral, 13 answered positive, 13 answered very positive, and one didn’t answer.

Q2. You enjoy your assigned shift.

14 answered very negative, 22 answered negative, 13 answered neutral, 14 answered positive, 12 answered very positive, and three didn’t answer.

Q3. Your request for your desired shift was fulfilled.

15 answered very negative, 21 answered negative, 15 answered neutral, 13 answered positive, 13 answered very positive, and one didn’t answer.

Q4. How many times have you called in sick in the last month?

15 answered very negative, 21 answered negative, 12 answered neutral, 12 answered positive, 15 answered very positive, and three didn’t answer.

Q5. You are well trained for work.

13 answered very negative, 22 answered negative, 14 answered neutral, 14 answered positive, 14 answered very positive, and one didn’t answer.

Q6. You are paid fairly for the work you do?

20 answered very negative, 30 answered negative, 19 answered neutral, six answered positive, Zero answered very positive, and three didn’t answer.

Q7. Your supervisor treats you fairly.

15 answered very negative, 21 answered negative, 15 answered neutral,

13 answered positive, 14 answered very positive.

Q8. Your supervisor’s boss treats your division fairly.

15 answered very negative, 22 answered negative, 12 answered neutral, 13 answered positive, 12 answered very positive, and four didn’t answer.

Q9. The company is good at communicating.

17 answered very negative, 32 answered negative, 24 answered neutral, five answered positive, zero answered very positive.

Q10. You do not fear that you will lose your job.

17 answered very negative, 22 answered negative, 12 answered neutral, 15 answered positive, 10 answered very positive, and two didn’t answer.

Out of the employees who took the survey, 12 were supervisors, 32 worked in the food division, 36worked in the housekeeping division, and nine worked in the maintenance division of the company. According to the survey of 17.3% the average length of employment with Ballard Integrated Managed Services, Inc. (BIMS) is three years and five months.

Once gathering all quantitative data, we can begin to eliminate all data input errors. In this case, it would be all unanswered survey questions, as well as all neutral answered questions. The survey can then be used to see whether negative or positive reinforcement is needed and measure how much of it is needed.

Based on the study done for BIMS, it is clear that there is a morale issue. Pay and scheduling are factors included but boosting morale would mitigate such issues. Our survey is able display the level of displeasure from the employees, having some employees even fearful of their jobs.

Our survey conducted is not intended to correct the issues but rather help create a focal point for the company going forward in restoring a healthy and fruitful work environment.

References

University of Phoenix. (). Ballard Integrated Managed Services, Inc., Part I. Retrieved from University of Phoenix, QNT351-Quantitative Analysis for Business website.