Question Set 1. A manager has tracked days worked and Donuts sold as given below. Winter Jan Feb 31 28 Spring Mar Apr 29 20 Winter Dec Days Worked Summer Jun Jul Aug 12 19 May 2 12 6 Seasons Cashier Linda Bob Gene Tina Louise Teddy 15 Autumn Sep Oct Nov 8 13 18 19 21 17 19 22 19 15 19 24 20 26 11 26 31 23 23 12 15 Winter Jan Feb 378 701 Spring Mar Apr 124 572 Winter Dec Seasons Cashier Linda Bob Gene Tina Louise Teddy May 23 289 38 412 Donuts Sold Summer Jun Jul Aug 215 388 447 414 72 136 Autumn Sep Oct Nov 162 294 545 276 139 264 296 252 276 27 434 345 396 278 572 264 45 1. For each cashier, compute his or her overall productivity (in Donuts sold per day) for spring and summer. You should have one number per cashier. (3pts) 2. For each cashier, compute his or her productivity (in Donuts sold per day) for autumn. Using the MAX function, find the highest productive cashier for the autumn among the cashiers. (3pts) 3. Compute the overall productivity for each cashier (in Donuts sold per day) for the entire year. Use the MIN function to find the lowest productive cashier for the year among the cashiers. (2 pts) 4. Which month has the lowest overall productivity? (2 pts)