Question Set 1. A hotel manager has tracked hours worked and orders processed as given below.
|
|
Cashier
|
|
Hours Worked
|
Jack
|
Wendy
|
Casey
|
Matt
|
Victoria
|
Susan
|
|
Sunday
|
6
|
5
|
|
5
|
|
|
|
Monday
|
|
8
|
8
|
7
|
7
|
7
|
|
Tuesday
|
8
|
|
|
8
|
8
|
8
|
|
Wednesday
|
6
|
8
|
7
|
|
|
8
|
|
Thursday
|
7
|
7
|
|
8
|
8
|
|
|
Friday
|
8
|
|
8
|
|
8
|
8
|
|
Saturday
|
|
|
6
|
|
7
|
5
|
|
|
Cashier
|
|
Orders Processed
|
Jack
|
Wendy
|
Casey
|
Matt
|
Victoria
|
Susan
|
|
Sunday
|
55
|
62
|
|
63
|
|
|
|
Monday
|
|
85
|
88
|
82
|
91
|
84
|
|
Tuesday
|
68
|
|
|
78
|
91
|
98
|
|
Wednesday
|
87
|
85
|
67
|
|
|
83
|
|
Thursday
|
82
|
91
|
|
79
|
85
|
|
|
Friday
|
88
|
|
93
|
|
75
|
79
|
|
Saturday
|
|
|
58
|
|
56
|
51
|
1. For each cashier, compute his or her overall productivity (in orders per hour) over Monday-Friday (including these two days). You should have one number per cashier.
2. For each cashier, compute his or her productivity (in orders per hour) over the weekends (Sunday and Saturday). Using the MAX function, find the highest productive cashier for the weekend among the cashiers.
3. For each cashier, computer his or her productivity (in orders per hour) over all 7 days. Using the MIN function, find the lowest productive cashier for all 7 days among the cashiers.
4. Is the overall productivity (in orders per hour) of the store lower on weekdays or on weekends?