# Qnt351 Week 3 Team Assignment Essay

1791 WordsJan 14, 20138 Pages
Data Collection BIMS, Ballard Integrated Managed Services, Inc. is a corporation specializes in the services of food and housekeeping to corporations and institutions. The general manager, Barbara Tucker, has noticed that over the last four months the turnover rate has shot up to 64%. Not only is the turnover rate higher than usual, but also employees seemed unmotivated to do their job. There are more employees walking around doing nothing and more employees not doing their job well enough, resulting in complaints from the hospital administration in which they are working. Debbie Homer, HR manage, has developed an employee survey instrument to try to identify why employees are leaving and why each employee is no longer motivated.…show more content…
After entering the data, it must be reviewed to catch any errors. Cleaning the data is done with basic steps. Of course the data is imported from the source, but there should always be some backup involved in order to keep the integrity of the data. In some cases the next step would be manipulation or spellchecking. This depends on what kind of data is involved. However, in this case spell checking is not necessary, but manipulation is. For instance with manipulation, they may have to add a column or two, or even add a zero randomly for missing data. Below is numbers 6-10 on the data set, the data has been cleaned up by changing the number 6 to the number 5 thus correcting the errors Sally made. Where a question wasn’t answered a zero was added to indicate missing data. No. Q1 Q2 Q3 Q4 Q5 Q6 Q7 Q8 Q9 Q10 A B C D 6 5 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 Measures of Central Tendency The example below lists the results for numbers 6-10. The measures of central tendency include mean, median, and mode. In this example the measures of central tendency will be calculated based on row B, which indicates the number of months that a particular employee has been with the company. The data being analyzed is the