QNT/351 Week 3 � Summarizing and Presenting Data

Name: QNT/351 Week 3 � Summarizing and Presenting Data
Brand: University of Phoenix
Price: 2 USD
Availability: InStock
Author: William Chen

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

William Chen

Contributor

4.3

about 1 month ago

Preview (5 of 15)

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.

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

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

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

Preview Mode

100%

Study Now!

XY-Copilot AI

Unlimited Access

Secure Payment

Instant Access

24/7 Support

Document Chat

Document Details

University

University of Phoenix

Subject

Statistics

QNT/351 Week 3 � Summarizing and Presenting Data

Study Now!

Document Details

Related Documents

QNT/351 Analyzing and Interpreting Data

QNT 351 BIMS Research Study

Data Collection Ballard Integrated Managed Services, Inc. (BIMS) - QNT351 Consulting Group

Dell � Change Management

The Statistics of Inheritance

Estimation and Hypothesis Testing

SPSS Cumulative Assessment Instructions

Hypothesis Testing � Comparing Two Groups

STAT 250-004 Data Analysis Assignment 4

Applying Hypothesis Tests Discussion #8

Company

Explore

Study Tools