Business Analytics AG2

profileChrisyanqu
CH7.xlsx
Home>Business & Finance homework help>Business Analytics AG2

Sheet1

Customer Waiting time Type of service Special Needs Time of the day Age Walk-in/Appointment Number of working staff Number of waiting customers
1 43 DL Returning NO Morning 42 Walk-in 8 133
2 53 DL Returning NO Morning 16 Walk-in 8 132
3 67 Vehicle Registration NO Morning 16 Walk-in 7 156
4 67 DL FirstTime NO Morning 58 Walk-in 7 161
5 68 Vehicle Registration NO Morning 28 Walk-in 6 118
6 76 DL Returning YES Afternoon 83 Walk-in 6 124
7 31 Vehicle Registration YES Afternoon 50 Appointment 5 99
8 55 DL Returning NO Afternoon 41 Walk-in 10 140
9 59 Vehicle Registration YES Afternoon 20 Walk-in 5 104
10 73 Vehicle Registration YES Afternoon 50 Walk-in 12 152
11 65 DL FirstTime NO Morning 16 Walk-in 11 113
12 49 DL Returning NO Afternoon 42 Walk-in 10 229
13 82 Vehicle Registration YES Morning 33 Walk-in 12 109
14 65 DL Returning YES Afternoon 23 Walk-in 6 62
15 28 DL Returning NO Afternoon 66 Appointment 12 94
16 65 DL Returning YES Afternoon 25 Walk-in 10 227
17 64 DL Returning NO Afternoon 67 Walk-in 7 212
18 25 DL Returning NO Morning 26 Appointment 7 92
19 34 DL Returning NO Morning 73 Appointment 6 206
20 26 DL Returning NO Morning 22 Appointment 6 67
21 38 Vehicle Registration YES Afternoon 86 Appointment 7 167
22 52 DL Returning NO Morning 52 Walk-in 9 90
23 16 DL Returning NO Afternoon 58 Appointment 8 106
24 38 Vehicle Registration NO Morning 54 Walk-in 8 103
25 65 DL Returning NO Morning 16 Walk-in 12 233
26 74 DL FirstTime YES Afternoon 81 Appointment 5 248
27 22 DL Returning NO Morning 43 Appointment 10 244
28 50 DL Returning NO Afternoon 58 Walk-in 5 246
29 47 DL Returning YES Afternoon 22 Appointment 9 65
30 89 Vehicle Registration YES Afternoon 47 Walk-in 10 94
31 43 Vehicle Registration NO Afternoon 85 Walk-in 10 143
32 79 DL Returning NO Afternoon 31 Walk-in 5 228
33 73 DL Returning YES Morning 79 Walk-in 9 70
34 59 Vehicle Registration NO Morning 68 Walk-in 9 225
35 64 DL Returning NO Morning 54 Walk-in 10 197
36 77 DL Returning NO Morning 22 Walk-in 12 176
37 41 DL Returning NO Morning 40 Walk-in 10 153
38 37 DL Returning NO Afternoon 29 Walk-in 8 131
39 47 DL Returning NO Afternoon 32 Walk-in 7 125
40 50 DL Returning NO Afternoon 47 Walk-in 5 51
41 22 Vehicle Registration NO Morning 16 Walk-in 7 76
42 37 DL Returning NO Afternoon 86 Walk-in 6 57
43 64 DL Returning NO Afternoon 73 Walk-in 10 185
44 29 Vehicle Registration YES Afternoon 41 Appointment 10 115
45 53 DL FirstTime NO Morning 16 Walk-in 8 227
46 49 DL Returning NO Morning 35 Walk-in 6 138
47 34 DL Returning YES Afternoon 16 Appointment 12 87
48 67 DL FirstTime NO Afternoon 71 Walk-in 8 114
49 83 DL FirstTime YES Afternoon 51 Walk-in 11 79
50 11 DL Returning NO Afternoon 16 Appointment 8 196
51 61 DL FirstTime NO Morning 80 Walk-in 7 247
52 10 Vehicle Registration NO Afternoon 16 Appointment 7 131
53 73 DL Returning YES Morning 61 Walk-in 9 184
54 28 DL FirstTime NO Afternoon 16 Appointment 11 176
55 44 DL Returning NO Morning 30 Walk-in 12 104
56 53 DL FirstTime NO Morning 16 Walk-in 5 224
57 22 DL Returning NO Morning 16 Appointment 9 144
58 13 Vehicle Registration NO Morning 32 Appointment 8 71
59 29 DL Returning NO Morning 17 Walk-in 7 171
60 64 DL FirstTime YES Afternoon 53 Walk-in 9 168
61 11 DL FirstTime NO Morning 16 Appointment 9 209
62 59 DL FirstTime NO Morning 32 Walk-in 11 189
63 25 DL FirstTime NO Morning 21 Appointment 8 207
64 14 Vehicle Registration NO Afternoon 41 Appointment 12 60
65 56 DL FirstTime NO Morning 75 Walk-in 11 229
66 28 DL Returning NO Morning 33 Appointment 6 107
67 58 DL Returning YES Afternoon 60 Walk-in 9 165
68 71 DL FirstTime YES Morning 65 Walk-in 6 129
69 58 DL FirstTime NO Morning 86 Walk-in 6 68
70 37 DL FirstTime NO Morning 28 Walk-in 9 186
71 58 DL Returning NO Morning 30 Walk-in 8 166
72 53 DL Returning NO Afternoon 55 Walk-in 10 95
73 20 DL FirstTime NO Morning 16 Appointment 11 166
74 22 DL Returning NO Afternoon 31 Appointment 10 150
75 8 DL Returning NO Afternoon 75 Appointment 12 147
76 28 DL Returning YES Afternoon 65 Appointment 11 234
77 10 DL Returning NO Afternoon 64 Appointment 9 79
78 71 DL FirstTime YES Afternoon 20 Walk-in 5 57
79 26 DL Returning NO Afternoon 46 Appointment 9 205
80 14 DL Returning NO Afternoon 24 Appointment 10 241
81 44 DL Returning NO Afternoon 81 Walk-in 5 151
82 38 DL Returning NO Afternoon 85 Walk-in 12 166
83 41 DL Returning NO Afternoon 36 Walk-in 12 130
84 46 DL Returning NO Afternoon 61 Walk-in 6 198
85 41 DL Returning YES Morning 16 Appointment 11 221
86 53 DL Returning NO Afternoon 74 Walk-in 10 194
87 34 DL Returning NO Morning 45 Walk-in 12 116
88 26 DL Returning NO Afternoon 44 Appointment 9 125
89 8 Vehicle Registration NO Morning 57 Appointment 9 61
90 31 DL Returning YES Morning 55 Appointment 5 119
91 16 Vehicle Registration NO Afternoon 16 Appointment 6 168
92 22 DL Returning NO Morning 47 Appointment 12 201
93 43 DL Returning NO Afternoon 84 Walk-in 8 210
94 55 DL Returning NO Morning 24 Walk-in 11 109
95 55 DL Returning NO Afternoon 80 Walk-in 10 207
96 80 DL Returning YES Morning 67 Walk-in 5 194
97 47 DL FirstTime NO Morning 16 Walk-in 11 67
98 32 Vehicle Registration NO Morning 62 Walk-in 6 203
99 47 DL Returning YES Afternoon 16 Walk-in 9 229
100 55 DL Returning NO Afternoon 29 Walk-in 12 164
101 46 DL FirstTime NO Morning 39 Walk-in 11 71
102 28 DL Returning NO Afternoon 69 Appointment 6 194
103 49 DL Returning YES Morning 73 Walk-in 10 86
104 13 Vehicle Registration NO Afternoon 16 Appointment 11 153
105 68 DL FirstTime YES Morning 74 Walk-in 12 81
106 11 Vehicle Registration NO Afternoon 61 Appointment 5 170
107 82 DL Returning YES Afternoon 49 Walk-in 5 200
108 53 DL FirstTime NO Morning 47 Walk-in 7 141
109 17 DL Returning NO Afternoon 29 Appointment 11 193
110 37 DL Returning NO Afternoon 28 Walk-in 5 64
111 47 DL Returning NO Afternoon 16 Walk-in 9 233
112 52 DL Returning NO Afternoon 16 Walk-in 7 231
113 22 DL Returning NO Afternoon 39 Appointment 5 98
114 13 Vehicle Registration NO Morning 16 Appointment 5 124
115 11 DL FirstTime NO Afternoon 41 Appointment 12 247
116 58 DL FirstTime NO Morning 58 Walk-in 5 60
117 14 Vehicle Registration NO Morning 16 Appointment 7 67
118 38 DL FirstTime NO Morning 21 Walk-in 11 208
119 68 DL FirstTime YES Afternoon 61 Walk-in 5 193
120 56 DL Returning NO Morning 74 Walk-in 9 154
121 59 DL Returning NO Afternoon 16 Walk-in 6 141
122 64 DL FirstTime NO Morning 16 Walk-in 6 245
123 50 DL FirstTime NO Morning 80 Walk-in 10 198
124 29 DL FirstTime NO Morning 85 Walk-in 12 127
125 47 DL Returning NO Afternoon 85 Walk-in 6 94
126 17 Vehicle Registration NO Morning 16 Appointment 7 125
127 55 DL Returning NO Morning 16 Walk-in 11 73
128 43 DL FirstTime YES Morning 42 Walk-in 7 185
129 67 DL FirstTime YES Morning 21 Walk-in 10 74
130 41 DL FirstTime NO Morning 16 Walk-in 8 91
131 41 DL FirstTime NO Afternoon 27 Walk-in 7 195
132 13 Vehicle Registration NO Afternoon 16 Appointment 7 111
133 55 DL Returning NO Afternoon 55 Walk-in 9 132
134 50 DL FirstTime NO Morning 74 Walk-in 9 227
135 32 DL Returning NO Afternoon 16 Walk-in 12 52
136 49 DL FirstTime NO Afternoon 16 Walk-in 9 138
137 13 Vehicle Registration NO Morning 46 Appointment 12 164
138 10 Vehicle Registration NO Morning 54 Appointment 5 163
139 17 Vehicle Registration NO Morning 79 Appointment 5 181
140 32 Vehicle Registration NO Morning 44 Walk-in 10 194
141 46 Vehicle Registration NO Morning 16 Walk-in 5 184
142 41 DL Returning NO Afternoon 36 Walk-in 12 173
143 11 Vehicle Registration NO Afternoon 69 Appointment 7 54
144 50 Vehicle Registration NO Afternoon 16 Walk-in 9 196
145 26 DL FirstTime NO Morning 30 Appointment 7 174
146 53 DL Returning NO Afternoon 16 Walk-in 9 58
147 11 DL FirstTime NO Morning 55 Appointment 7 156
148 23 Vehicle Registration NO Afternoon 59 Appointment 9 233
149 40 Vehicle Registration YES Morning 52 Appointment 6 184
150 32 DL Returning NO Afternoon 86 Walk-in 5 54