INTRODUCTION AND DESCRIPTIVE STATISTICS

1.2 Assignment:
Bayview Descriptive Statistics

Name
Institution
Course
Instructor
Date

1.0. Part 1: Introduction

INTRODUCTION AND DESCRIPTIVE STATISTICS 2

This report examines the turnover rate for registered nurse, physician,
administrative, and non-medical positions at Bayview Hospital. As the
Industrial/Organizational (I/O) consultant, I am tasked to review the recruiter, job
position, and engagement scores to determine the source of this problem. Apart
from examining the turnover rate, the recruiting sources will be examined to
confirm a “theory” that one of the recruiting company has a higher retention rate
than the other. Turnover refers to the rate at which staff leave their workforce and
become replaced (Dogru et al., 2023). Collaborating with the employees through
Staff Engagement Survey for 6 months is also suggested to determine the impact of
turnover on previous outcomes. Overall, this analysis will be done based on the five
constructs with greater impact on turnover (well-being, job satisfaction, cohesion,
leadership, and teamwork).
Bayview Hospital employs over 25,000 employees. For the past three years, it
has been experiencing a steady rise in turnover rate. This issue is worrying because
the cost of replacing employees is relatively high and time-consuming. The CEO has
found it essential to determine why the challenge is increasingly occurring. With
Bayview Hospital’s location in the Midwest, two recruiters based in Ohio and South
Florida provide recruiting services. Reviewing data on how recruitment is done will
confirm the authenticity of the “higher retention rate” theory.
2.0. Part 2: Descriptive Statistics
i. Recruiter’s retention rate results
a. Sue Reynolds:

96

Mean 96
Standard Error 0
Median 96
Mode 96
Standard
Deviation 0
Sample Variance 0
#DIV/
Kurtosis 0!
#DIV/
Skewness 0!
Range 0
Minimum 96
Maximum 96
Sum 960
Count 10
Largest(1) 96
Smallest(1) 96
Confidence Frequency:
Level(95.0%) 0
INTRODUCTION AND DESCRIPTIVE STATISTICS 3

Frequen
Bins cy
90.00 0
94.00 0
96.00 11

Mean: 96
Median: 96
Mode: 96

b. Anna Delvechhio:

94

Mean 94
Standard Error 0
Median 94
Mode 94
Standard
Deviation 0
Sample Variance 0
#DIV/
Kurtosis 0!
#DIV/
Skewness 0!
Range 0
Minimum 94
Maximum 94
Sum 940
Count 10
Largest(1) 94
Smallest(1) 94
Confidence
Level(95.0%) 0

Frequency:

90 0
92 0
94 11
96 0
INTRODUCTION AND DESCRIPTIVE STATISTICS 4

Mean: 94
Median: 94
Mode: 94

c. Paul Smith:

91

Mean 91
Standard Error 0
Median 91
Mode 91
Standard
Deviation 0
Sample Variance 0
#DIV/
Kurtosis 0!
#DIV/
Skewness 0!
Range 0
Minimum 91
Maximum 91
Sum 1911
Count 21
Largest(1) 91
Smallest(1) 91
Confidence
Level(95.0%) 0

Frequency:

90 0
91 22
92 0

Mean: 91
Median: 91
Mode: 91

d. Todd Hugh:
INTRODUCTION AND DESCRIPTIVE STATISTICS 5

91

Mean 91
Standard Error 0
Median 91
Mode 91
Standard
Deviation 0
Sample Variance 0
#DIV/
Kurtosis 0!
#DIV/
Skewness 0!
Range 0
Minimum 91
Maximum 91
Sum 455
Count 5
Largest(1) 91
Smallest(1) 91
Confidence
Level(95.0%) 0

Frequency:

90.00 0
91.00 6
92.00 0

Mean: 91
Median: 91
Mode: 91
e. Anna Levine:

88

87.863
Mean 64
0.1363
Standard Error 64
Median 88
Mode 88
INTRODUCTION AND DESCRIPTIVE STATISTICS 6

Standard 0.6396
Deviation 02
0.4090
Sample Variance 91
Kurtosis 22
-
4.6904
Skewness 2
Range 3
Minimum 85
Maximum 88
Sum 1933
Count 22
Largest(1) 88
Smallest(1) 85
Confidence 0.2835
Level(95.0%) 84

 Frequency:
Frequen
Bins cy
85.00 1
86.00 0
87.00 0
88.00 22.00
90.00 0

 Mean: 87.86364
 Median: 88
 Mode: 88

f. Willy Dunes:

82

Mean 82
Standard Error 0
Median 82
Mode 82
Standard
Deviation 0
INTRODUCTION AND DESCRIPTIVE STATISTICS 7

Sample Variance 0
#DIV/
Kurtosis 0!
#DIV/
Skewness 0!
Range 0
Minimum 82
Maximum 82
Sum 820
Count 10
Largest(1) 82
Smallest(1) 82
Confidence
Level(95.0%) 0

Frequency:

80.00 0
82.00 11
84.00 0

Mean: 82
Median: 82
Mode: 82
g. Shelly Day:

82

Mean 82
Standard Error 0
Median 82
Mode 82
Standard
Deviation 0
Sample Variance 0
#DIV/
Kurtosis 0!
#DIV/
Skewness 0!
Range 0
Minimum 82
Maximum 82
INTRODUCTION AND DESCRIPTIVE STATISTICS 8

Sum 902
Count 11
Largest(1) 82
Smallest(1) 82
Confidence
Level(95.0%) 0

Frequency:

80 0
82 12
84 0

Mean: 82
Median: 82
Mode: 82

h. Emily Wayne:

76

Mean 76
Standard Error 0
Median 76
Mode 76
Standard
Deviation 0
Sample Variance 0
#DIV/
Kurtosis 0!
#DIV/
Skewness 0!
Range 0
Minimum 76
Maximum 76
Sum 836
Count 11
Largest(1) 76
Smallest(1) 76
Confidence
Level(95.0%) 0
INTRODUCTION AND DESCRIPTIVE STATISTICS 9

Frequency:

74 0
76 12
78 0

Mean: 76
Median: 76
Mode: 76

i. Donald Coles:

76

Mean 76
Standard Error 0
Median 76
Mode 76
Standard
Deviation 0
Sample Variance 0
#DIV/
Kurtosis 0!
#DIV/
Skewness 0!
Range 0
Minimum 76
Maximum 76
Sum 380
Count 5
Largest(1) 76
Smallest(1) 76
Confidence
Level(95.0%) 0

Frequency:

74 0
76 6
78 0

Mean: 76
INTRODUCTION AND DESCRIPTIVE STATISTICS 10

Median: 76
Mode: 76

j. Patrick Harvey:

75

Mean 75
Standard Error 0
Median 75
Mode 75
Standard
Deviation 0
Sample Variance 0
#DIV/
Kurtosis 0!
#DIV/
Skewness 0!
Range 0
Minimum 75
Maximum 75
Sum 450
Count 6
Largest(1) 75
Smallest(1) 75
Confidence
Level(95.0%) 0

Frequency:

73 0
75 7
77 0

Mean: 75
Median: 75
Mode: 75

k. Emma Staples:
INTRODUCTION AND DESCRIPTIVE STATISTICS 11

72

Mean 72
Standard Error 0
Median 72
Mode 72
Standard
Deviation 0
Sample Variance 0
#DIV/
Kurtosis 0!
#DIV/
Skewness 0!
Range 0
Minimum 72
Maximum 72
Sum 1224
Count 17
Largest(1) 72
Smallest(1) 72
Confidence
Level(95.0%) 0

Frequency:

Bins Frequency
70.00 0
72.00 18
74.00 0

Mean: 72
Median: 72
Mode: 72

l. Stephanie Hill:

69

Mean 69
Standard Error 0
Median 69
INTRODUCTION AND DESCRIPTIVE STATISTICS 12

Mode 69
Standard
Deviation 0
Sample Variance 0
#DIV/
Kurtosis 0!
#DIV/
Skewness 0!
Range 0
Minimum 69
Maximum 69
Sum 345
Count 5
Largest(1) 69
Smallest(1) 69
Confidence
Level(95.0%) 0

Frequency:

67 0
69 6
71 0

Mean: 69
Median: 69
Mode: 69

m. Cedric Stone:

66

Mean 66
Standard Error 0
Median 66
Mode 66
Standard
Deviation 0
Sample Variance 0
#DIV/
Kurtosis 0!
#DIV/
Skewness 0!
Range 0
INTRODUCTION AND DESCRIPTIVE STATISTICS 13

Minimum 66
Maximum 66
Sum 330
Count 5
Largest(1) 66
Smallest(1) 66
Confidence
Level(95.0%) 0

Frequency:

65 0
66 6
67 0

Mean: 66
Median: 66
Mode: 66

n. Anna Long:

65

Mean 65
Standard Error 0
Median 65
Mode 65
Standard
Deviation 0
Sample Variance 0
#DIV/
Kurtosis 0!
#DIV/
Skewness 0!
Range 0
Minimum 65
Maximum 65
Sum 130
Count 2
Largest(1) 65
Smallest(1) 65
Confidence
Level(95.0%) 0
INTRODUCTION AND DESCRIPTIVE STATISTICS 14

Frequency:

64 0
65 3
66 0

Mean: 65
Median: 65
Mode: 65

o. Billy Diaz:

64

Mean 64
Standard Error 0
Median 64
Mode 64
Standard
Deviation 0
Sample Variance 0
#DIV/
Kurtosis 0!
#DIV/
Skewness 0!
Range 0
Minimum 64
Maximum 64
Sum 832
Count 13
Largest(1) 64
Smallest(1) 64
Confidence
Level(95.0%) 0

Frequency:
Bins Frequency

60 0
64 14
INTRODUCTION AND DESCRIPTIVE STATISTICS 15

68 0

Mean: 64
Median: 64
Mode: 64
p. Lilly Jones:

61

Mean 61
Standard Error 0
Median 61
Mode 61
Standard
Deviation 0
Sample Variance 0
#DIV/
Kurtosis 0!
#DIV/
Skewness 0!
Range 0
Minimum 61
Maximum 61
Sum 1037
Count 17
Largest(1) 61
Smallest(1) 61
Confidence
Level(95.0%) 0

Frequency:
Frequen
Bins cy
60 0
61 18
62 0

Mean: 61
Median: 61
Mode: 61
INTRODUCTION AND DESCRIPTIVE STATISTICS 16

q. Sammy Smith:

58

Mean 58
Standard Error 0
Median 58
Mode 58
Standard
Deviation 0
Sample Variance 0
#DIV/
Kurtosis 0!
#DIV/
Skewness 0!
Range 0
Minimum 58
Maximum 58
Sum 348
Count 6
Largest(1) 58
Smallest(1) 58
Confidence
Level(95.0%) 0

Frequen
Bins cy
57.00 0
58.00 7
59.00 0

Mean: 58
Median: 58
Mode: 58
r. Ryan Vincent

45

Mean 45
Standard Error 0
Median 45
INTRODUCTION AND DESCRIPTIVE STATISTICS 17

Mode 45
Standard
Deviation 0
Sample Variance 0
#DIV/
Kurtosis 0!
#DIV/
Skewness 0!
Range 0
Minimum 45
Maximum 45
Sum 270
Count 6
Largest(1) 45
Smallest(1) 45
Confidence
Level(95.0%) 0

Frequen
Bins cy
44.00 0
45.00 7
46.00 0

Mean: 45
Median: 45
Mode: 45

ii. Engagement Study Results (Well-being, Cohesion, Job Satisfaction,

Teamwork, Leadership) (Mean, Median, Mode):
a. Sue Reynolds:
INTRODUCTION AND DESCRIPTIVE STATISTICS 18

Table 1: Mean, Mode, and Median for the five categories

I. Overall mean score for the five categories =
4.836363636+4.827272727+4.918181818+4.6+4.818181818 = 24/5 = 4.8
II. Well-being: Median (5); Mode (5)
III. Cohesion: Median (4.9); Mode (4.9)
IV. Job satisfaction: Median (5); Mode (5)
V. Teamwork: Median (4.8); Mode (4.2)
VI. Leadership: Median (4.9); Mode (5)

b. Anna Delvichhio
INTRODUCTION AND DESCRIPTIVE STATISTICS 19

Table 2: Mean, Mode, and Median for the five categories

I. Overall mean score for five categories: 5+4.85+4.7+4.47+4.85 = 23.87/5 =
4.774
II. Well-being: Median (5); Mode (5)
III. Cohesion: Median (4.95); Mode (5)
IV. Job satisfaction: Median (4.75); Mode (4.4)
V. Teamwork: Median (4.5); Mode (4)
VI. Leadership: Median (4.9); Mode (5)

c. Paul Smith
INTRODUCTION AND DESCRIPTIVE STATISTICS 20

Table 3: Mean, Mode, and Median for the five categories

I. Overall mean score for five categories:
4.704762+4.809524+4.695238+4.7+4.780952 = 23.690476/5 =
4.7380952
II. Well-being: Median (4.8); Mode (4.8)
III. Cohesion: Median (4.9); Mode (5)
IV. Job satisfaction: Median (4.9); Mode (5)
V. Teamwork: Median (4.9); Mode (4.9)
VI. Leadership: Median (4.9); Mode (5)

d. Todd Hugh
INTRODUCTION AND DESCRIPTIVE STATISTICS 21

Table 4: Mean, Mode, and Median for the five categories

I. Overall mean score for five categories: 4.6+4.8+4.4+4.52+5 = 23.32/5 =
4.664
II. Well-being: Median (4.8); Mode (4.8)
III. Cohesion: Median (4.9); Mode (5)
IV. Job satisfaction: Median (4.9); Mode (5)
V. Teamwork: Median (4.9); Mode (4.9)
VI. Leadership: Median (4.9); Mode (5)

e. Anna Levine
INTRODUCTION AND DESCRIPTIVE STATISTICS 22

Table 5: Mean, Mode, and Median for the five categories

I. Overall mean score for five categories:
4.422727+4.768182+4.714545+4.536364+4.868182 = 23.31/5 = 4.662
II. Well-being: Median (4.4); Mode (5)
III. Cohesion: Median (4.9); Mode (5)
IV. Job satisfaction: Median (4.85); Mode (5)
V. Teamwork: Median (4.8); Mode (5)
VI. Leadership: Median (4.95); Mode (5)

f. Willy Dunes
INTRODUCTION AND DESCRIPTIVE STATISTICS 23

Table 6: Mean, Mode, and Median for the five categories

I. Overall mean score for five categories: 4.289+4.87+4.404+4.47+4.74 =
22.773/5 = 4.5546
II. Well-being: Median (4.3); Mode (4.8)
III. Cohesion: Median (4.9); Mode (5)
IV. Job satisfaction: Median (4.3); Mode (4.3)
V. Teamwork: Median (4.9); Mode (4.5)
VI. Leadership: Median (4.9); Mode (4.9)

g. Shelly Day
INTRODUCTION AND DESCRIPTIVE STATISTICS 24

Table 7: Mean, Mode, and Median for the five categories

I. Overall mean score for five categories:
4.399091+4.836364+.4.354545+4.572727+4.745454545 = 22.908/5 =
4.58
II. Well-being: Median (4.4); Mode (4.8)
III. Cohesion: Median (4.9); Mode (4.9)
IV. Job satisfaction: Median (4.4); Mode (4.4)
V. Teamwork: Median (4.8); Mode (4.8)
VI. Leadership: Median (4.8); Mode (4.8)

h. Emily Wayne
INTRODUCTION AND DESCRIPTIVE STATISTICS 25

Table 8: Mean, Mode, and Median for the five categories

I. Overall mean score for five categories:
4.422727273+4.768182+.4.714545+4.536364+4.868182 = 23.31/5 =
4.662
II. Well-being: Median (4.4); Mode (5)
III. Cohesion: Median (4.9); Mode (5)
IV. Job satisfaction: Median (4.85); Mode (5)
V. Teamwork: Median (4.8); Mode (5)
VI. Leadership: Median (4.95); Mode (5)

i. Willy Dunes
INTRODUCTION AND DESCRIPTIVE STATISTICS 26

Table 9: Mean, Mode, and Median for the five categories

I. Overall mean score for five categories: 4.289+4.87+.4.404+4.47+4.74 =
22.773/5 = 4.5546
II. Well-being: Median (4.3); Mode (4.8)
III. Cohesion: Median (4.9); Mode (5)
IV. Job satisfaction: Median (4.3); Mode (4.3)
V. Teamwork: Median (4.5); Mode (4.9)
VI. Leadership: Median (4.9); Mode (4.9)

j. Shelly Day
INTRODUCTION AND DESCRIPTIVE STATISTICS 27

Table 10: Mean, Mode, and Median for the five categories:
I. Overall mean score for five categories:
4.399+4.863+.4.354+4.5727+4.745 = 22.90/5 = 4.58
II. Well-being: Median (4.4); Mode (4.8)
III. Cohesion: Median (4.9); Mode (4.9)
IV. Job satisfaction: Median (4.4); Mode (4.4)
V. Teamwork: Median (4.8); Mode (4.8)
VI. Leadership: Median (4.8); Mode (4.8)

k. Emily Wayne
INTRODUCTION AND DESCRIPTIVE STATISTICS 28

Table 11: Mean, Mode, and Median for the five categories:
I. Overall mean score for five categories: 3.708+4.718+.4.431+4.436+4.463
= 22.138/5 = 4.4276
II. Well-being: Median (3.7); Mode (3.2)
III. Cohesion: Median (4.8); Mode (4.8)
IV. Job satisfaction: Median (4.3); Mode (4.3)
V. Teamwork: Median (4.8); Mode (4.9)
VI. Leadership: Median (4.9); Mode (4.8)

l. Donald Coles
INTRODUCTION AND DESCRIPTIVE STATISTICS 29

Table 12: Mean, Mode, and Median for the five categories:
I. Overall mean score for five categories: 4.3+4.9+.4.06+4.34+4.2 = 21.8/5
= 4.36
II. Well-being: Median (4.2); Mode (4.8)
III. Cohesion: Median (4.9); Mode (4.9)
IV. Job satisfaction: Median (4.5); Mode (3.6)
V. Teamwork: Median (4.8); Mode (4.9)
VI. Leadership: Median (4.2); Mode (4.9)

m. Patrick Harvey
INTRODUCTION AND DESCRIPTIVE STATISTICS 30

Table 13: Mean, Mode, and Median for the five categories:
I. Overall mean score for five categories: 3.98+4.72+.4.4+4.55+4.48 =
22.131/5 = 4.426
II. Well-being: Median (3.945); Mode (4.4)
III. Cohesion: Median (5); Mode (5)
IV. Job satisfaction: Median (4.4); Mode (4.4)
V. Teamwork: Median (4.85); Mode (4.9)
VI. Leadership: Median (4.85); Mode (4.9)

n. Emma Staples
INTRODUCTION AND DESCRIPTIVE STATISTICS 31

Table 14: Mean, Mode, and Median for the five categories:
I. Overall mean score for five categories: 3.899+4.329+.4.014+3.9+4.182 =
20.32/5 = 4.065
II. Well-being: Median (3.89); Mode (3.7)
III. Cohesion: Median (4.8); Mode (4.9)
IV. Job satisfaction: Median (4.2); Mode (4.4)
V. Teamwork: Median (3.6); Mode (3)
VI. Leadership: Median (4.2); Mode (5)

o. Stephanie Hill
INTRODUCTION AND DESCRIPTIVE STATISTICS 32

Table 15: Mean, Mode, and Median for the five categories:
I. Overall mean score for five categories: 4.08+4.22+.3.88+4.2+4.4 =
20.78/5 = 4.156
II. Well-being: Median (4); Mode (N/A)
III. Cohesion: Median (4.5); Mode (3.4)
IV. Job satisfaction: Median (4.4); Mode (4.4)
V. Teamwork: Median (4); Mode (5)
VI. Leadership: Median (5); Mode (5)

p. Cedric Stone
INTRODUCTION AND DESCRIPTIVE STATISTICS 33

Table 15: Mean, Mode, and Median for the five categories:
I. Overall mean score for five categories: 4.178+3.8+.3.94+3.78+4.22 =
19.918/5 = 3.9836
II. Well-being: Median (4.4); Mode (N/A)
III. Cohesion: Median (3.8); Mode (3.8)
IV. Job satisfaction: Median (4.2); Mode (4.2)
V. Teamwork: Median (3.6); Mode (N/A)
VI. Leadership: Median (3.8); Mode (3.8)

q. Anna Long
INTRODUCTION AND DESCRIPTIVE STATISTICS 34

Table 16: Mean, Mode, and Median for the five categories:
I. Overall mean score for five categories: 4.1+3.35+4.46+4.9+3.95 =
20.76/5 = 4.152
II. Well-being: Median (4.1); Mode (N/A)
III. Cohesion: Median (3.35); Mode (N/A)
IV. Job satisfaction: Median (4.46); Mode (N/A)
V. Teamwork: Median (4.9); Mode (4.9)
VI. Leadership: Median (3.95); Mode (N/A)

r. Billy Diaz
INTRODUCTION AND DESCRIPTIVE STATISTICS 35

Table 17: Mean, Mode, and Median for the five categories:
I. Overall mean score for five categories:
3.945+4.2769+3.43846+3.7769+3.830769 = 19.268/5 = 3.85
II. Well-being: Median (3.89); Mode (3.7)
III. Cohesion: Median (4.5); Mode (5)
IV. Job satisfaction: Median (3.4); Mode (4.3)
V. Teamwork: Median (3.6); Mode (3.8)
VI. Leadership: Median (3.6); Mode (3.6)

s. Lilly Jones
INTRODUCTION AND DESCRIPTIVE STATISTICS 36

Table 18: Mean, Mode, and Median for the five categories:
I. Overall mean score for five categories:
3.946+4.058824+3.548+3.935294+3.847059 = 19.335882/5 = 3.867
II. Well-being: Median (3.89); Mode (3.2)
III. Cohesion: Median (4.2); Mode (5)
IV. Job satisfaction: Median (3.6); Mode (3.6)
V. Teamwork: Median (3.8); Mode (4.9)
VI. Leadership: Median (3.8); Mode (5)

t. Sammy Smith
INTRODUCTION AND DESCRIPTIVE STATISTICS 37

Table 18: Mean, Mode, and Median for the five categories:
I. Overall mean score for five categories: 4.1467+4+3.4167+3.783+3.95 =
19.296667/5 = 3.859
II. Well-being: Median (3.945); Mode (3.89)
III. Cohesion: Median (3.8); Mode (3.8)
IV. Job satisfaction: Median (3.5); Mode (3.6)
V. Teamwork: Median (3.5); Mode (N/A)
VI. Leadership: Median (4.05); Mode (5)

u. Ryan Vincent
INTRODUCTION AND DESCRIPTIVE STATISTICS 38

Table 19: Mean, Mode, and Median for the five categories:
I. Overall mean score for five categories:
4.082+4.373+3.437+4.058253+4.07642 = 20.027/5 = 4.005
II. Well-being: Median (4.045); Mode (N/A)
III. Cohesion: Median (4.5); Mode (N/a)
IV. Job satisfaction: Median (3.5); Mode (3.6)
V. Teamwork: Median (3.92476); Mode (N/A)
VI. Leadership: Median (3.82926); Mode (3.8)

3.0. Categorizing the recruiters

Recruiter No & Name. Retention Rating (RR) Performance

(%) Description

1. Sue Reynolds 96 High

2. Anna Delvechhio 94 High
3. Paul Smith 91 High
4. Todd Hugh 91 High
5. Anna Levine 88 High
INTRODUCTION AND DESCRIPTIVE STATISTICS 39

6. Willy Dunes 82 High

7. Shelly Day 82 High
8. Emily Wayne 76 Low
9. Donald Coles 76 Low
[Link] Harvey 75 Low
[Link] Staples 72 Low
[Link] Hill 69 Low
[Link] Stone 66 Low
[Link] Long 65 Low
[Link] Diaz 64 Low
[Link] Jones 61 Low
[Link] Smith 58 Low
[Link] Vincent 45 Low

Table 20: Ranking and categorizing recruiters into high and low performers
From the table above, the first seven recruiters are considered high
performers based on their retention rates (80% and above). On the other hand, the
last eleven recruiters are considered low performers (below 80%). This
categorization will be considered in future assignments.

Reference
INTRODUCTION AND DESCRIPTIVE STATISTICS 40

Dogru, T., McGinley, S., Sharma, A., Isık, C., & Hanks, L. (2023). Employee turnover
dynamics in the hospitality industry vs. the overall economy. Tourism
Management, 99, 104783. [Link]