Question Set 1. A manager has tracked days worked and Donuts sold as given below. Winter Jan Feb 24 Mar 22 Spring Apr 20 Days Worked Summer May Jun Jul Aug 13 12 19 19 9 19 24 Winter Dec Seasons Cashier Liz Jack Tracy Jenna Kenneth Pete 18 15 Autumn Sep Oct Nov 8 13 18 12 21 17 14 22 17 15 20 25 11 26 28 13 25 12 15 Seasons Cashier Liz Winter Jan Feb 378 761 Winter Dec Spring Mar Apr 124 572 May 3 Donuts Sold Summer Jun Jul Aug 285 388 437 414 72 289 36 Autumn Sep Oct Nov 162 494 545 276 139 264 296 252 276 27 Jack Tracy Jenna Kenneth Pete 8 414 412 345 396 378 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. (3 pts) 4. Which month has the lowest overall productivity? (2 pts)