Covenant Hospital operates a main hospital and three outlying
clinics in a medium-size city. All four locations perform similar
outpatient services, and patients typically visit the location
nearest them. The hospital has recently had more congestion—longer
waiting lines—than it (or its patients) would like. As part of a
study to learn the causes of these long lines and to suggest
possible solutions, all locations have kept track of customer
arrivals during 1-hour intervals for the past 10 weeks. All
locations are open Monday through Friday from 9 a.m. until 5 p.m.
and on Saturday from 9 a.m. until noon. For each location, the
hospital and clinics collected data that contains the number of
customer arrivals during each hour of a 10-week period. The manager
of Covenant has hired you to make some sense of these data.
Specifically, your task is to present charts and/or tables that
indicate how customer traffic into the hospital locations varies by
day of week and hour of day. There is also interest in whether any
daily or hourly patterns you observe are stable across weeks.
Although you don’t have full information about the way the hospital
currently runs its operations—you know only its customer arrival
pattern and the fact that it is currently experiencing long
lines—you are encouraged to append any suggestions for improving
operations based on your analysis of the data.Review the Covenant
Hospital data files. Reflect on what analyses might be required to
address the manager’s request.The Assignment: (3–5 pages)Submit
your answers and embedded Excel analysis as a Microsoft Word
management report.Be sure to adhere to APA format when generating
your management report.Albright, S. C., & Winston, W. L.
(2015). Business analytics: Data analysis and decision making (5th
ed.). Stamford, CT: Cengage Learning.
Chapter 1, “Introduction to Data Analysis and Decision
Making” (pp. 1–16)Chapter 2, “Describing the Distribution of a
Single Variable” (pp. 19–78)Chapter 3, “Finding Relationships Among
Variables” (pp. 79–136)Kohane, I. S. (2015). Health care policy:
Ten things we have to do to achieve precision medicine. Science,
349(6243), 37–38.Note: Retrieved from the Walden Library
databases.Zwitter, A. (2014). Commentary: Big data ethics. Big Data
& Society, 1–6.Note: Retrieved from the Walden Library
databases.Document: Covenant Data File [Excel spreadsheet]
This is fictitious data.
Day
Mon
Mon
Mon
Mon
Mon
Mon
Mon
Mon
Tue
Tue
Tue
Tue
Tue
Tue
Tue
Tue
Wed
Wed
Wed
Wed
Wed
Wed
Wed
Wed
Thu
Thu
Thu
Thu
Thu
Thu
Thu
Thu
Fri
Fri
Fri
Fri
Fri
Fri
Fri
Fri
Sat
Sat
Sat
Hour
9 to 10
10 to 11
11 to noon
Noon to 1
1 to 2
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
Noon to 1
1 to 2
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
Noon to 1
1 to 2
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
Noon to 1
1 to 2
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
Noon to 1
1 to 2
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
Clinic 1
29
26
57
68
60
35
23
69
35
22
50
82
52
36
20
69
31
22
71
70
36
27
19
77
36
25
52
67
49
39
23
65
45
44
94
129
85
57
43
110
86
47
135
Clinic 2
20
13
28
30
18
23
12
32
14
9
30
22
28
19
15
25
13
10
20
35
26
15
11
26
11
17
30
41
22
14
13
20
41
25
66
64
37
35
33
56
38
27
76
Clinic 3
20
13
26
31
35
14
11
37
13
11
38
39
24
14
17
37
19
13
30
36
26
17
10
33
16
11
30
43
17
17
15
32
30
22
48
61
42
29
30
59
30
30
79
Clinic 4
18
12
29
41
15
22
4
30
15
10
34
34
18
20
11
23
15
15
27
29
24
23
14
29
13
12
21
44
24
18
12
35
27
19
47
71
44
30
17
48
32
27
71
These show the number of patient
arrivals for consecutive hourly periods.
Mon
Mon
Mon
Mon
Mon
Mon
Mon
Mon
Tue
Tue
Tue
Tue
Tue
Tue
Tue
Tue
Wed
Wed
Wed
Wed
Wed
Wed
Wed
Wed
Thu
Thu
Thu
Thu
Thu
Thu
Thu
Thu
Fri
Fri
Fri
Fri
Fri
Fri
Fri
Fri
Sat
Sat
Sat
Mon
9 to 10
10 to 11
11 to noon
Noon to 1
1 to 2
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
Noon to 1
1 to 2
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
Noon to 1
1 to 2
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
Noon to 1
1 to 2
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
Noon to 1
1 to 2
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
9 to 10
38
22
62
96
41
35
22
79
26
18
56
61
45
37
34
74
34
19
48
70
44
32
21
58
26
26
64
58
50
30
27
69
53
32
96
108
88
56
33
83
83
41
123
39
16
17
25
37
33
15
15
45
20
15
25
36
22
13
7
28
17
12
31
46
25
21
13
32
12
9
28
44
17
19
5
48
34
15
53
73
37
30
25
74
39
32
70
12
24
16
36
41
26
23
7
29
20
12
25
29
25
19
15
29
16
19
22
43
23
9
17
36
19
10
27
44
23
18
12
33
29
20
52
60
45
27
27
57
40
20
76
11
19
13
19
35
21
19
12
28
15
9
33
33
23
17
16
52
16
7
17
22
20
22
9
30
18
9
38
39
23
27
13
35
30
22
51
63
48
31
20
62
39
37
74
20
Mon
Mon
Mon
Mon
Mon
Mon
Mon
Tue
Tue
Tue
Tue
Tue
Tue
Tue
Tue
Wed
Wed
Wed
Wed
Wed
Wed
Wed
Wed
Thu
Thu
Thu
Thu
Thu
Thu
Thu
Thu
Fri
Fri
Fri
Fri
Fri
Fri
Fri
Fri
Sat
Sat
Sat
Mon
Mon
10 to 11
11 to noon
Noon to 1
1 to 2
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
Noon to 1
1 to 2
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
Noon to 1
1 to 2
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
Noon to 1
1 to 2
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
Noon to 1
1 to 2
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
9 to 10
10 to 11
22
57
60
47
22
25
70
35
13
51
74
52
38
28
60
41
26
64
84
62
29
22
61
41
24
51
62
60
30
28
57
53
35
105
125
80
46
42
109
75
56
138
26
21
6
20
40
31
20
12
30
22
15
28
30
26
21
16
32
15
10
32
33
25
25
6
37
12
10
20
34
29
21
11
27
38
18
47
68
51
27
23
59
45
29
61
17
14
11
32
32
26
17
20
42
17
14
26
36
28
13
7
22
23
10
23
34
26
14
13
37
12
14
27
30
16
17
12
27
42
21
49
46
42
34
26
47
36
24
64
9
3
12
31
39
16
18
6
33
13
16
20
33
27
17
10
25
21
12
35
41
28
16
12
29
15
14
35
27
30
21
9
29
30
26
51
69
39
27
27
54
37
31
73
13
15
Mon
Mon
Mon
Mon
Mon
Mon
Tue
Tue
Tue
Tue
Tue
Tue
Tue
Tue
Wed
Wed
Wed
Wed
Wed
Wed
Wed
Wed
Thu
Thu
Thu
Thu
Thu
Thu
Thu
Thu
Fri
Fri
Fri
Fri
Fri
Fri
Fri
Fri
Sat
Sat
Sat
Mon
Mon
Mon
11 to noon
Noon to 1
1 to 2
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
Noon to 1
1 to 2
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
Noon to 1
1 to 2
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
Noon to 1
1 to 2
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
Noon to 1
1 to 2
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
9 to 10
10 to 11
11 to noon
56
64
50
30
19
63
30
18
64
82
50
39
25
66
40
23
65
70
51
26
28
78
34
24
55
78
48
27
25
60
52
42
105
126
75
69
39
117
72
54
131
42
27
61
28
41
25
16
8
28
8
14
32
48
21
14
16
46
17
12
32
32
18
21
12
36
17
12
28
28
25
19
9
36
21
23
42
53
59
34
22
49
46
38
66
18
11
25
31
38
29
13
9
30
24
13
22
30
22
14
9
27
17
12
31
33
21
8
9
33
16
13
31
24
23
14
16
32
26
24
39
70
61
27
20
56
39
30
66
18
18
31
26
32
21
16
15
23
15
19
36
35
22
20
11
39
18
5
41
31
28
21
10
33
22
8
33
32
17
16
7
34
32
31
66
50
49
29
24
47
45
33
70
17
12
29
Mon
Mon
Mon
Mon
Mon
Tue
Tue
Tue
Tue
Tue
Tue
Tue
Tue
Wed
Wed
Wed
Wed
Wed
Wed
Wed
Wed
Thu
Thu
Thu
Thu
Thu
Thu
Thu
Thu
Fri
Fri
Fri
Fri
Fri
Fri
Fri
Fri
Sat
Sat
Sat
Mon
Mon
Mon
Mon
Noon to 1
1 to 2
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
Noon to 1
1 to 2
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
Noon to 1
1 to 2
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
Noon to 1
1 to 2
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
Noon to 1
1 to 2
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
9 to 10
10 to 11
11 to noon
Noon to 1
71
59
37
19
69
25
27
56
76
63
35
21
78
30
20
66
77
51
33
23
65
25
26
56
70
54
28
28
56
57
46
107
120
80
55
44
123
93
67
125
43
24
54
73
26
23
18
17
36
17
10
29
41
27
12
10
31
9
14
30
35
25
14
11
27
13
17
30
38
27
25
11
31
35
23
49
55
43
29
17
54
37
33
67
19
13
28
37
42
28
21
13
39
13
14
34
36
21
9
9
34
15
12
30
36
27
20
11
32
17
12
29
40
24
16
14
28
29
16
51
67
50
18
15
64
47
22
77
14
19
22
36
36
26
11
16
37
24
11
31
41
22
20
6
40
10
11
45
37
22
17
8
32
20
12
19
37
30
18
13
30
24
23
45
56
47
29
18
66
32
22
74
18
19
37
32
Mon
Mon
Mon
Mon
Tue
Tue
Tue
Tue
Tue
Tue
Tue
Tue
Wed
Wed
Wed
Wed
Wed
Wed
Wed
Wed
Thu
Thu
Thu
Thu
Thu
Thu
Thu
Thu
Fri
Fri
Fri
Fri
Fri
Fri
Fri
Fri
Sat
Sat
Sat
Mon
Mon
Mon
Mon
Mon
1 to 2
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
Noon to 1
1 to 2
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
Noon to 1
1 to 2
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
Noon to 1
1 to 2
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
Noon to 1
1 to 2
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
9 to 10
10 to 11
11 to noon
Noon to 1
1 to 2
39
44
29
69
27
20
55
77
53
37
31
61
26
28
55
66
46
29
26
59
29
22
59
58
34
19
22
78
60
40
90
102
88
54
43
114
79
48
134
32
22
66
75
47
21
15
7
35
16
10
30
32
25
17
14
29
15
9
44
34
17
18
14
34
21
8
32
49
24
17
8
26
26
24
46
64
37
31
27
69
43
30
87
23
12
27
38
27
21
20
11
41
18
14
26
49
19
8
14
24
15
13
23
40
23
23
12
34
14
10
27
32
25
18
12
31
27
23
43
70
25
39
20
62
40
29
59
13
10
22
39
30
25
10
7
30
16
8
20
43
18
8
13
25
16
8
38
49
26
24
8
37
16
14
23
42
30
12
15
36
32
25
54
62
31
26
16
46
37
17
56
13
13
32
47
25
Mon
Mon
Mon
Tue
Tue
Tue
Tue
Tue
Tue
Tue
Tue
Wed
Wed
Wed
Wed
Wed
Wed
Wed
Wed
Thu
Thu
Thu
Thu
Thu
Thu
Thu
Thu
Fri
Fri
Fri
Fri
Fri
Fri
Fri
Fri
Sat
Sat
Sat
Mon
Mon
Mon
Mon
Mon
Mon
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
Noon to 1
1 to 2
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
Noon to 1
1 to 2
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
Noon to 1
1 to 2
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
Noon to 1
1 to 2
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
9 to 10
10 to 11
11 to noon
Noon to 1
1 to 2
2 to 3
22
21
50
34
21
48
82
33
31
24
66
37
26
78
91
55
31
18
78
41
24
54
69
58
32
24
85
58
40
121
124
72
59
38
118
84
65
128
22
21
53
70
43
23
11
9
37
21
12
28
39
24
13
13
39
13
6
27
39
15
19
13
34
14
5
27
47
30
19
11
29
26
17
52
65
46
26
20
50
49
27
70
17
11
32
44
21
21
23
11
27
15
11
30
55
30
8
15
36
15
21
31
39
39
14
9
30
18
14
39
38
22
25
10
32
24
16
44
71
43
27
23
71
35
25
68
20
9
22
37
17
19
23
17
30
17
12
28
30
27
16
9
37
12
12
33
24
24
16
10
38
16
19
27
32
25
15
15
38
33
11
37
66
50
37
18
54
38
29
67
24
20
33
24
19
14
Mon
Mon
Tue
Tue
Tue
Tue
Tue
Tue
Tue
Tue
Wed
Wed
Wed
Wed
Wed
Wed
Wed
Wed
Thu
Thu
Thu
Thu
Thu
Thu
Thu
Thu
Fri
Fri
Fri
Fri
Fri
Fri
Fri
Fri
Sat
Sat
Sat
Mon
Mon
Mon
Mon
Mon
Mon
Mon
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
Noon to 1
1 to 2
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
Noon to 1
1 to 2
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
Noon to 1
1 to 2
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
Noon to 1
1 to 2
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
9 to 10
10 to 11
11 to noon
Noon to 1
1 to 2
2 to 3
3 to 4
17
62
32
25
61
87
49
33
31
80
33
24
71
70
48
37
26
54
26
27
57
82
49
22
17
61
50
35
117
135
73
52
33
110
77
59
141
37
19
53
63
48
36
28
10
40
22
11
35
41
20
16
20
32
17
14
34
36
23
17
18
30
17
9
32
23
25
17
13
41
27
22
62
63
50
30
23
56
32
39
62
15
17
22
48
24
17
9
8
40
19
15
33
42
20
13
13
34
9
9
39
30
23
15
14
39
18
7
28
38
22
17
17
31
31
20
51
68
27
24
27
65
43
27
72
20
11
24
42
20
19
11
13
40
8
17
28
38
21
20
13
37
17
12
27
35
29
25
9
30
14
13
18
38
17
11
10
39
32
18
47
65
50
29
28
50
43
30
68
18
12
37
41
28
18
6
Mon
Tue
Tue
Tue
Tue
Tue
Tue
Tue
Tue
Wed
Wed
Wed
Wed
Wed
Wed
Wed
Wed
Thu
Thu
Thu
Thu
Thu
Thu
Thu
Thu
Fri
Fri
Fri
Fri
Fri
Fri
Fri
Fri
Sat
Sat
Sat
Mon
Mon
Mon
Mon
Mon
Mon
Mon
Mon
4 to 5
9 to 10
10 to 11
11 to noon
Noon to 1
1 to 2
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
Noon to 1
1 to 2
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
Noon to 1
1 to 2
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
Noon to 1
1 to 2
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
9 to 10
10 to 11
11 to noon
Noon to 1
1 to 2
2 to 3
3 to 4
4 to 5
70
42
23
65
71
43
35
20
52
22
15
61
67
38
36
22
68
29
20
52
46
57
25
29
64
60
33
110
139
75
61
30
95
85
65
140
33
16
65
75
50
30
30
70
32
15
20
23
43
27
16
13
30
19
8
34
28
24
9
5
47
20
11
24
44
24
11
17
29
36
17
43
71
37
32
18
48
47
32
68
13
9
28
30
27
17
14
30
39
18
14
32
39
22
23
12
32
13
10
36
38
36
23
10
36
16
7
22
49
21
16
12
34
38
25
46
49
57
32
20
52
52
28
61
10
5
26
28
27
20
13
32
39
12
10
29
43
27
21
19
25
13
8
29
31
21
16
9
28
15
15
23
44
30
13
14
29
31
25
62
45
45
29
14
50
40
30
67
21
12
34
35
13
17
9
47
Tue
Tue
Tue
Tue
Tue
Tue
Tue
Tue
Wed
Wed
Wed
Wed
Wed
Wed
Wed
Wed
Thu
Thu
Thu
Thu
Thu
Thu
Thu
Thu
Fri
Fri
Fri
Fri
Fri
Fri
Fri
Fri
Sat
Sat
Sat
9 to 10
10 to 11
11 to noon
Noon to 1
1 to 2
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
Noon to 1
1 to 2
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
Noon to 1
1 to 2
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
Noon to 1
1 to 2
2 to 3
3 to 4
4 to 5
9 to 10
10 to 11
11 to noon
25
21
56
71
37
39
24
60
24
24
58
71
48
31
26
57
28
20
48
80
46
32
22
63
59
53
102
126
76
59
27
91
87
59
158
18
17
29
28
23
17
11
32
14
12
37
31
21
14
13
26
13
14
25
37
13
16
13
27
28
12
48
53
50
29
21
64
27
26
73
22
11
34
45
14
16
12
33
24
13
31
36
22
16
11
41
16
11
29
40
17
18
9
37
19
19
44
60
39
29
17
59
38
34
68
13
16
36
33
25
11
15
29
16
14
20
35
35
25
8
41
7
8
31
36
22
15
8
38
22
23
50
60
40
19
27
68
50
39
64
number of patient
or consecutive hourly periods.
…
Purchase answer to see full
attachment












Other samples, services and questions:
When you use PaperHelp, you save one valuable — TIME
You can spend it for more important things than paper writing.