Skip to content
Solved Assignments

QNT/351 Week 3 � Summarizing and Presenting Data

This assignment covers methods for summarizing and presenting statistical data in business and research settings.

Preview 5 of 15 pages

See the first 5 pages exactly as they appear in the document.

  1. Page 1
    Read page 1 as text

    Week 3 – Summarizing and Presenting Data Name QNT/351 Date Instructor Name Summarizing and Presenting Data Ballard Integrated Managed Services, Inc. (BIMS) performed an instrument of measure by implementing a survey to its employees. The purpose of the employee survey via paycheck submission was to attempt to determine possible reasons for high employee turnover rates. Data analysis is a vital function for companies to accurately interpret survey results and helps companies make the necessary operational adjustments to remain competitive and be successful. This paper will examine six questions from the BIMS survey and analyze the data using descriptive statistics. Suggestions to the BIMS management team to improve their employee turnover rate will be presented based on the data analysis. Question 1 – How well do you enjoy working for BIMS? BIMS staff used numeric codes to describe the nominal, ordinal, and interval data. The data is organized and assessed to evaluate the procedures that were implemented. Appendix A is a BIMS staff coded employee numerical survey. Descriptive statistics were used to present a profile of the data, including averages, mean, median, and mode to describe the group scores or ratings. With the use of ordinal measurements, BIMS staff can use mode, the most common value, or median, the middle ranking, to determine the central tendency.

  2. Page 2
  3. Page 3
    Read page 3 as text

    The analysis of Question 1, how well the employee enjoys working for BIMS, reveals a mean of 2.81, a median of 3, and a mode of 2. The sample standard deviation is 1.41 with a sample variance of 1.98. The data indicates that most employees responded with a response of 2, which indicated employees’ enjoyment of their work experiences is below average as illustrated below. Figure 1: Descriptive statistics: How well do you enjoy working for BIMS? Q1 count 78 mean 2.81 sample standard deviation 1.41 sample variance 1.98 minimum 0 maximum 5 range 5 1st quartile 2.00 median 3.00 3rd quartile 4.00 interquartile range 2.00 mode 2.00 low extremes 0 low outliers 0 high outliers 0 high extremes 0 Frequency Distribution – Quantitative Q1 cumulative lower upper midpoint width frequency percent frequency percent 0 < 0 0 1 1 1.3 1 1.3 1 < 1 1 1 0 0.0 1 1.3 1 < 1 1 1 15 19.2 16 20.5 2 < 2 2 1 0 0.0 16 20.5

  4. Page 4
    Read page 4 as text

    2 < 2 2 1 21 26.9 37 47.4 3 < 3 3 1 0 0.0 37 47.4 3 < 3 3 1 15 19.2 52 66.7 4 < 4 4 1 0 0.0 52 66.7 4 < 4 4 1 13 16.7 65 83.3 5 < 5 5 1 0 0.0 65 83.3 5 < 5 5 0 13 16.7 78 100.0 78 100.0 Question 2 – Do You Enjoy Your Shift? Below are charts and diagrams that indicate the descriptive statistics based on the survey results for question number 2; do you enjoy your shift? The results show that the majority of employees surveyed do not highly enjoy their shift. The mean result was 2.73, with a standard deviation of 1.45 and a sample variance of 2.10. This indicates that of the 78 employees surveyed, 28.2% were not satisfied with their shift, while 17.9% were highly dissatisfied. Only 15.4% were totally satisfied with their assigned shift, and 17.9% were somewhat satisfied with

  5. Page 5
    Read page 5 as text

    their shift, leaving a percentage of 16.7 employees surveyed who were in the middle. Some employees chose not to answer resulting in 3.8% unknown. The histogram and frequency polygon clearly indicate that the majority of employees surveyed were dissatisfied with their shift, marking a score of two on the question. This is a good indicator of low employee moral and most likely a contributing factor to the high employee turnover rate. These results are further proved by the mode for the data set: two. The median and mean were fairly close, at 2.5 and 2.73 respectively. However, the best measure of central tendency would be the median in this case because a total of 46.1% of employees surveyed were dissatisfied with their assigned shift versus only 33.3% of employees who were satisfied. The 16.7% of employees who scored a three on the question can be lumped into the dissatisfied category. Although they were more or less indifferent on their assigned shift, by not scoring a positive result, it can be reasoned that they feel there is room for improvement in their assigned shift, otherwise they would have scored a more positive result of four or five. To help improve employee moral and lower the high turnover rate, the BIMS management team could institute a more flexible shift assignment protocol, taking into consideration their employee’s requests for certain shifts based on lifestyle and other duties they may have outside of work. By instituting a more flexible policy and allowing employees to swap shifts with each other, this could help to lower the high turnover rate by helping to keep the employees satisfied with the shifts they have to work. Results for Data Analysis of Question 2: Descriptive statistics # 1 count 78 mean 2.73 sample standard 1.45

10 more pages in the full document

Unlock it once and it stays in your library, ready to chat with or turn into flashcards.

Unlock the full document

More Statistics study materials

See all

Study this document with CramX

Once it is in your library, every tool can work from it.