Brilliant Answer

hottboy561
CovenantHospitaldatafile.xlsx
Home>Business & Finance homework help>Brilliant Answer

Source

This is fictitious data.

Data

Day Hour Clinic 1 Clinic 2 Clinic 3 Clinic 4
Mon 9 to 10 29 20 20 18
Mon 10 to 11 26 13 13 12
Mon 11 to noon 57 28 26 29
Mon Noon to 1 68 30 31 41
Mon 1 to 2 60 18 35 15
Mon 2 to 3 35 23 14 22
Mon 3 to 4 23 12 11 4
Mon 4 to 5 69 32 37 30
Tue 9 to 10 35 14 13 15
Tue 10 to 11 22 9 11 10
Tue 11 to noon 50 30 38 34
Tue Noon to 1 82 22 39 34
Tue 1 to 2 52 28 24 18
Tue 2 to 3 36 19 14 20
Tue 3 to 4 20 15 17 11
Tue 4 to 5 69 25 37 23
Wed 9 to 10 31 13 19 15
Wed 10 to 11 22 10 13 15
Wed 11 to noon 71 20 30 27
Wed Noon to 1 70 35 36 29
Wed 1 to 2 36 26 26 24
Wed 2 to 3 27 15 17 23
Wed 3 to 4 19 11 10 14
Wed 4 to 5 77 26 33 29
Thu 9 to 10 36 11 16 13
Thu 10 to 11 25 17 11 12
Thu 11 to noon 52 30 30 21
Thu Noon to 1 67 41 43 44
Thu 1 to 2 49 22 17 24
Thu 2 to 3 39 14 17 18
Thu 3 to 4 23 13 15 12
Thu 4 to 5 65 20 32 35
Fri 9 to 10 45 41 30 27
Fri 10 to 11 44 25 22 19
Fri 11 to noon 94 66 48 47
Fri Noon to 1 129 64 61 71
Fri 1 to 2 85 37 42 44
Fri 2 to 3 57 35 29 30
Fri 3 to 4 43 33 30 17
Fri 4 to 5 110 56 59 48
Sat 9 to 10 86 38 30 32
Sat 10 to 11 47 27 30 27
Sat 11 to noon 135 76 79 71
Mon 9 to 10 38 16 24 19
Mon 10 to 11 22 17 16 13
Mon 11 to noon 62 25 36 19
Mon Noon to 1 96 37 41 35
Mon 1 to 2 41 33 26 21
Mon 2 to 3 35 15 23 19
Mon 3 to 4 22 15 7 12
Mon 4 to 5 79 45 29 28
Tue 9 to 10 26 20 20 15
Tue 10 to 11 18 15 12 9
Tue 11 to noon 56 25 25 33
Tue Noon to 1 61 36 29 33
Tue 1 to 2 45 22 25 23
Tue 2 to 3 37 13 19 17
Tue 3 to 4 34 7 15 16
Tue 4 to 5 74 28 29 52
Wed 9 to 10 34 17 16 16
Wed 10 to 11 19 12 19 7
Wed 11 to noon 48 31 22 17
Wed Noon to 1 70 46 43 22
Wed 1 to 2 44 25 23 20
Wed 2 to 3 32 21 9 22
Wed 3 to 4 21 13 17 9
Wed 4 to 5 58 32 36 30
Thu 9 to 10 26 12 19 18
Thu 10 to 11 26 9 10 9
Thu 11 to noon 64 28 27 38
Thu Noon to 1 58 44 44 39
Thu 1 to 2 50 17 23 23
Thu 2 to 3 30 19 18 27
Thu 3 to 4 27 5 12 13
Thu 4 to 5 69 48 33 35
Fri 9 to 10 53 34 29 30
Fri 10 to 11 32 15 20 22
Fri 11 to noon 96 53 52 51
Fri Noon to 1 108 73 60 63
Fri 1 to 2 88 37 45 48
Fri 2 to 3 56 30 27 31
Fri 3 to 4 33 25 27 20
Fri 4 to 5 83 74 57 62
Sat 9 to 10 83 39 40 39
Sat 10 to 11 41 32 20 37
Sat 11 to noon 123 70 76 74
Mon 9 to 10 39 12 11 20
Mon 10 to 11 22 6 11 12
Mon 11 to noon 57 20 32 31
Mon Noon to 1 60 40 32 39
Mon 1 to 2 47 31 26 16
Mon 2 to 3 22 20 17 18
Mon 3 to 4 25 12 20 6
Mon 4 to 5 70 30 42 33
Tue 9 to 10 35 22 17 13
Tue 10 to 11 13 15 14 16
Tue 11 to noon 51 28 26 20
Tue Noon to 1 74 30 36 33
Tue 1 to 2 52 26 28 27
Tue 2 to 3 38 21 13 17
Tue 3 to 4 28 16 7 10
Tue 4 to 5 60 32 22 25
Wed 9 to 10 41 15 23 21
Wed 10 to 11 26 10 10 12
Wed 11 to noon 64 32 23 35
Wed Noon to 1 84 33 34 41
Wed 1 to 2 62 25 26 28
Wed 2 to 3 29 25 14 16
Wed 3 to 4 22 6 13 12
Wed 4 to 5 61 37 37 29
Thu 9 to 10 41 12 12 15
Thu 10 to 11 24 10 14 14
Thu 11 to noon 51 20 27 35
Thu Noon to 1 62 34 30 27
Thu 1 to 2 60 29 16 30
Thu 2 to 3 30 21 17 21
Thu 3 to 4 28 11 12 9
Thu 4 to 5 57 27 27 29
Fri 9 to 10 53 38 42 30
Fri 10 to 11 35 18 21 26
Fri 11 to noon 105 47 49 51
Fri Noon to 1 125 68 46 69
Fri 1 to 2 80 51 42 39
Fri 2 to 3 46 27 34 27
Fri 3 to 4 42 23 26 27
Fri 4 to 5 109 59 47 54
Sat 9 to 10 75 45 36 37
Sat 10 to 11 56 29 24 31
Sat 11 to noon 138 61 64 73
Mon 9 to 10 26 17 9 13
Mon 10 to 11 21 14 3 15
Mon 11 to noon 56 28 31 26
Mon Noon to 1 64 41 38 32
Mon 1 to 2 50 25 29 21
Mon 2 to 3 30 16 13 16
Mon 3 to 4 19 8 9 15
Mon 4 to 5 63 28 30 23
Tue 9 to 10 30 8 24 15
Tue 10 to 11 18 14 13 19
Tue 11 to noon 64 32 22 36
Tue Noon to 1 82 48 30 35
Tue 1 to 2 50 21 22 22
Tue 2 to 3 39 14 14 20
Tue 3 to 4 25 16 9 11
Tue 4 to 5 66 46 27 39
Wed 9 to 10 40 17 17 18
Wed 10 to 11 23 12 12 5
Wed 11 to noon 65 32 31 41
Wed Noon to 1 70 32 33 31
Wed 1 to 2 51 18 21 28
Wed 2 to 3 26 21 8 21
Wed 3 to 4 28 12 9 10
Wed 4 to 5 78 36 33 33
Thu 9 to 10 34 17 16 22
Thu 10 to 11 24 12 13 8
Thu 11 to noon 55 28 31 33
Thu Noon to 1 78 28 24 32
Thu 1 to 2 48 25 23 17
Thu 2 to 3 27 19 14 16
Thu 3 to 4 25 9 16 7
Thu 4 to 5 60 36 32 34
Fri 9 to 10 52 21 26 32
Fri 10 to 11 42 23 24 31
Fri 11 to noon 105 42 39 66
Fri Noon to 1 126 53 70 50
Fri 1 to 2 75 59 61 49
Fri 2 to 3 69 34 27 29
Fri 3 to 4 39 22 20 24
Fri 4 to 5 117 49 56 47
Sat 9 to 10 72 46 39 45
Sat 10 to 11 54 38 30 33
Sat 11 to noon 131 66 66 70
Mon 9 to 10 42 18 18 17
Mon 10 to 11 27 11 18 12
Mon 11 to noon 61 25 31 29
Mon Noon to 1 71 26 42 36
Mon 1 to 2 59 23 28 26
Mon 2 to 3 37 18 21 11
Mon 3 to 4 19 17 13 16
Mon 4 to 5 69 36 39 37
Tue 9 to 10 25 17 13 24
Tue 10 to 11 27 10 14 11
Tue 11 to noon 56 29 34 31
Tue Noon to 1 76 41 36 41
Tue 1 to 2 63 27 21 22
Tue 2 to 3 35 12 9 20
Tue 3 to 4 21 10 9 6
Tue 4 to 5 78 31 34 40
Wed 9 to 10 30 9 15 10
Wed 10 to 11 20 14 12 11
Wed 11 to noon 66 30 30 45
Wed Noon to 1 77 35 36 37
Wed 1 to 2 51 25 27 22
Wed 2 to 3 33 14 20 17
Wed 3 to 4 23 11 11 8
Wed 4 to 5 65 27 32 32
Thu 9 to 10 25 13 17 20
Thu 10 to 11 26 17 12 12
Thu 11 to noon 56 30 29 19
Thu Noon to 1 70 38 40 37
Thu 1 to 2 54 27 24 30
Thu 2 to 3 28 25 16 18
Thu 3 to 4 28 11 14 13
Thu 4 to 5 56 31 28 30
Fri 9 to 10 57 35 29 24
Fri 10 to 11 46 23 16 23
Fri 11 to noon 107 49 51 45
Fri Noon to 1 120 55 67 56
Fri 1 to 2 80 43 50 47
Fri 2 to 3 55 29 18 29
Fri 3 to 4 44 17 15 18
Fri 4 to 5 123 54 64 66
Sat 9 to 10 93 37 47 32
Sat 10 to 11 67 33 22 22
Sat 11 to noon 125 67 77 74
Mon 9 to 10 43 19 14 18
Mon 10 to 11 24 13 19 19
Mon 11 to noon 54 28 22 37
Mon Noon to 1 73 37 36 32
Mon 1 to 2 39 21 21 25
Mon 2 to 3 44 15 20 10
Mon 3 to 4 29 7 11 7
Mon 4 to 5 69 35 41 30
Tue 9 to 10 27 16 18 16
Tue 10 to 11 20 10 14 8
Tue 11 to noon 55 30 26 20
Tue Noon to 1 77 32 49 43
Tue 1 to 2 53 25 19 18
Tue 2 to 3 37 17 8 8
Tue 3 to 4 31 14 14 13
Tue 4 to 5 61 29 24 25
Wed 9 to 10 26 15 15 16
Wed 10 to 11 28 9 13 8
Wed 11 to noon 55 44 23 38
Wed Noon to 1 66 34 40 49
Wed 1 to 2 46 17 23 26
Wed 2 to 3 29 18 23 24
Wed 3 to 4 26 14 12 8
Wed 4 to 5 59 34 34 37
Thu 9 to 10 29 21 14 16
Thu 10 to 11 22 8 10 14
Thu 11 to noon 59 32 27 23
Thu Noon to 1 58 49 32 42
Thu 1 to 2 34 24 25 30
Thu 2 to 3 19 17 18 12
Thu 3 to 4 22 8 12 15
Thu 4 to 5 78 26 31 36
Fri 9 to 10 60 26 27 32
Fri 10 to 11 40 24 23 25
Fri 11 to noon 90 46 43 54
Fri Noon to 1 102 64 70 62
Fri 1 to 2 88 37 25 31
Fri 2 to 3 54 31 39 26
Fri 3 to 4 43 27 20 16
Fri 4 to 5 114 69 62 46
Sat 9 to 10 79 43 40 37
Sat 10 to 11 48 30 29 17
Sat 11 to noon 134 87 59 56
Mon 9 to 10 32 23 13 13
Mon 10 to 11 22 12 10 13
Mon 11 to noon 66 27 22 32
Mon Noon to 1 75 38 39 47
Mon 1 to 2 47 27 30 25
Mon 2 to 3 22 11 23 23
Mon 3 to 4 21 9 11 17
Mon 4 to 5 50 37 27 30
Tue 9 to 10 34 21 15 17
Tue 10 to 11 21 12 11 12
Tue 11 to noon 48 28 30 28
Tue Noon to 1 82 39 55 30
Tue 1 to 2 33 24 30 27
Tue 2 to 3 31 13 8 16
Tue 3 to 4 24 13 15 9
Tue 4 to 5 66 39 36 37
Wed 9 to 10 37 13 15 12
Wed 10 to 11 26 6 21 12
Wed 11 to noon 78 27 31 33
Wed Noon to 1 91 39 39 24
Wed 1 to 2 55 15 39 24
Wed 2 to 3 31 19 14 16
Wed 3 to 4 18 13 9 10
Wed 4 to 5 78 34 30 38
Thu 9 to 10 41 14 18 16
Thu 10 to 11 24 5 14 19
Thu 11 to noon 54 27 39 27
Thu Noon to 1 69 47 38 32
Thu 1 to 2 58 30 22 25
Thu 2 to 3 32 19 25 15
Thu 3 to 4 24 11 10 15
Thu 4 to 5 85 29 32 38
Fri 9 to 10 58 26 24 33
Fri 10 to 11 40 17 16 11
Fri 11 to noon 121 52 44 37
Fri Noon to 1 124 65 71 66
Fri 1 to 2 72 46 43 50
Fri 2 to 3 59 26 27 37
Fri 3 to 4 38 20 23 18
Fri 4 to 5 118 50 71 54
Sat 9 to 10 84 49 35 38
Sat 10 to 11 65 27 25 29
Sat 11 to noon 128 70 68 67
Mon 9 to 10 22 17 20 24
Mon 10 to 11 21 11 9 20
Mon 11 to noon 53 32 22 33
Mon Noon to 1 70 44 37 24
Mon 1 to 2 43 21 17 19
Mon 2 to 3 23 21 19 14
Mon 3 to 4 17 10 8 13
Mon 4 to 5 62 40 40 40
Tue 9 to 10 32 22 19 8
Tue 10 to 11 25 11 15 17
Tue 11 to noon 61 35 33 28
Tue Noon to 1 87 41 42 38
Tue 1 to 2 49 20 20 21
Tue 2 to 3 33 16 13 20
Tue 3 to 4 31 20 13 13
Tue 4 to 5 80 32 34 37
Wed 9 to 10 33 17 9 17
Wed 10 to 11 24 14 9 12
Wed 11 to noon 71 34 39 27
Wed Noon to 1 70 36 30 35
Wed 1 to 2 48 23 23 29
Wed 2 to 3 37 17 15 25
Wed 3 to 4 26 18 14 9
Wed 4 to 5 54 30 39 30
Thu 9 to 10 26 17 18 14
Thu 10 to 11 27 9 7 13
Thu 11 to noon 57 32 28 18
Thu Noon to 1 82 23 38 38
Thu 1 to 2 49 25 22 17
Thu 2 to 3 22 17 17 11
Thu 3 to 4 17 13 17 10
Thu 4 to 5 61 41 31 39
Fri 9 to 10 50 27 31 32
Fri 10 to 11 35 22 20 18
Fri 11 to noon 117 62 51 47
Fri Noon to 1 135 63 68 65
Fri 1 to 2 73 50 27 50
Fri 2 to 3 52 30 24 29
Fri 3 to 4 33 23 27 28
Fri 4 to 5 110 56 65 50
Sat 9 to 10 77 32 43 43
Sat 10 to 11 59 39 27 30
Sat 11 to noon 141 62 72 68
Mon 9 to 10 37 15 20 18
Mon 10 to 11 19 17 11 12
Mon 11 to noon 53 22 24 37
Mon Noon to 1 63 48 42 41
Mon 1 to 2 48 24 20 28
Mon 2 to 3 36 17 19 18
Mon 3 to 4 28 9 11 6
Mon 4 to 5 70 32 39 39
Tue 9 to 10 42 15 18 12
Tue 10 to 11 23 20 14 10
Tue 11 to noon 65 23 32 29
Tue Noon to 1 71 43 39 43
Tue 1 to 2 43 27 22 27
Tue 2 to 3 35 16 23 21
Tue 3 to 4 20 13 12 19
Tue 4 to 5 52 30 32 25
Wed 9 to 10 22 19 13 13
Wed 10 to 11 15 8 10 8
Wed 11 to noon 61 34 36 29
Wed Noon to 1 67 28 38 31
Wed 1 to 2 38 24 36 21
Wed 2 to 3 36 9 23 16
Wed 3 to 4 22 5 10 9
Wed 4 to 5 68 47 36 28
Thu 9 to 10 29 20 16 15
Thu 10 to 11 20 11 7 15
Thu 11 to noon 52 24 22 23
Thu Noon to 1 46 44 49 44
Thu 1 to 2 57 24 21 30
Thu 2 to 3 25 11 16 13
Thu 3 to 4 29 17 12 14
Thu 4 to 5 64 29 34 29
Fri 9 to 10 60 36 38 31
Fri 10 to 11 33 17 25 25
Fri 11 to noon 110 43 46 62
Fri Noon to 1 139 71 49 45
Fri 1 to 2 75 37 57 45
Fri 2 to 3 61 32 32 29
Fri 3 to 4 30 18 20 14
Fri 4 to 5 95 48 52 50
Sat 9 to 10 85 47 52 40
Sat 10 to 11 65 32 28 30
Sat 11 to noon 140 68 61 67
Mon 9 to 10 33 13 10 21
Mon 10 to 11 16 9 5 12
Mon 11 to noon 65 28 26 34
Mon Noon to 1 75 30 28 35
Mon 1 to 2 50 27 27 13
Mon 2 to 3 30 17 20 17
Mon 3 to 4 30 14 13 9
Mon 4 to 5 70 30 32 47
Tue 9 to 10 25 18 22 13
Tue 10 to 11 21 17 11 16
Tue 11 to noon 56 29 34 36
Tue Noon to 1 71 28 45 33
Tue 1 to 2 37 23 14 25
Tue 2 to 3 39 17 16 11
Tue 3 to 4 24 11 12 15
Tue 4 to 5 60 32 33 29
Wed 9 to 10 24 14 24 16
Wed 10 to 11 24 12 13 14
Wed 11 to noon 58 37 31 20
Wed Noon to 1 71 31 36 35
Wed 1 to 2 48 21 22 35
Wed 2 to 3 31 14 16 25
Wed 3 to 4 26 13 11 8
Wed 4 to 5 57 26 41 41
Thu 9 to 10 28 13 16 7
Thu 10 to 11 20 14 11 8
Thu 11 to noon 48 25 29 31
Thu Noon to 1 80 37 40 36
Thu 1 to 2 46 13 17 22
Thu 2 to 3 32 16 18 15
Thu 3 to 4 22 13 9 8
Thu 4 to 5 63 27 37 38
Fri 9 to 10 59 28 19 22
Fri 10 to 11 53 12 19 23
Fri 11 to noon 102 48 44 50
Fri Noon to 1 126 53 60 60
Fri 1 to 2 76 50 39 40
Fri 2 to 3 59 29 29 19
Fri 3 to 4 27 21 17 27
Fri 4 to 5 91 64 59 68
Sat 9 to 10 87 27 38 50
Sat 10 to 11 59 26 34 39
Sat 11 to noon 158 73 68 64

These show the number of patient arrivals for consecutive hourly periods.