Do NOT name the cells...use cell references in the format of (ColumnRow, e.g. B10)

E. Write the Excel function to determine population standard deviation for total "good" product for the week for the operators. F. Use VLOOKUP to find the number of good pizzas for Carlos on the 12th of September. G. Using an Excel function, create a list of names in a single cell for all those employees who had good pizzas greater than the average for the entire crew for the 13th of September. H. If the employees have an average weekly productivity of at least 4.5, then they get donuts. If they are below 4.5 but at or above 3.2, they get a granola bar. Write the logic to test this and put the answer (true returns = "Donuts" or "Granola bar" and false return = "No treats) in cell A18. A B D E F G . K L 1 Frozen Pizza Pack Line 2 EMPLOYEE 9-Sep-19 Pass 10-Sep-19 Pass 11-Sep-19 Pass 13-Sep-19 Pass Fail Fail 12-Sep-19 Pass 45 Fail Fail Fail 48 40 2 43 0 1 2 48 49 Weekly Average Productivity (pizzas/hr) 5.60 6.30 5.50 5.70 52 51 1 51 2 49 41 1 43 3 James 4 Rehab 5 Katrina 6 Sara 7 Carlos 8 Michelle 9 Wong 1 40 52 48 42 2 2 48 45 47 42 3 Ho Holl on oll00 44 47 48 0 48 45 5.80 48 No ollow 45 41 3 46 48 5.70 46 41 47 0 43 47 5.60 326 9 9 5.74 11 TOTALS 12 Percent Good 316 97.23% 320 97.26% 324 97.30% 322 97.58% 98.19% Daily Productivity 13 (pizzas/employee/hour) 5.17 5.02 5.08 5.14 5.11 E. Write the Excel function to determine population standard deviation for total "good" product for the week for the operators. F. Use VLOOKUP to find the number of good pizzas for Carlos on the 12th of September. G. Using an Excel function, create a list of names in a single cell for all those employees who had good pizzas greater than the average for the entire crew for the 13th of September. H. If the employees have an average weekly productivity of at least 4.5, then they get donuts. If they are below 4.5 but at or above 3.2, they get a granola bar. Write the logic to test this and put the answer (true returns = "Donuts" or "Granola bar" and false return = "No treats) in cell A18. A B D E F G . K L 1 Frozen Pizza Pack Line 2 EMPLOYEE 9-Sep-19 Pass 10-Sep-19 Pass 11-Sep-19 Pass 13-Sep-19 Pass Fail Fail 12-Sep-19 Pass 45 Fail Fail Fail 48 40 2 43 0 1 2 48 49 Weekly Average Productivity (pizzas/hr) 5.60 6.30 5.50 5.70 52 51 1 51 2 49 41 1 43 3 James 4 Rehab 5 Katrina 6 Sara 7 Carlos 8 Michelle 9 Wong 1 40 52 48 42 2 2 48 45 47 42 3 Ho Holl on oll00 44 47 48 0 48 45 5.80 48 No ollow 45 41 3 46 48 5.70 46 41 47 0 43 47 5.60 326 9 9 5.74 11 TOTALS 12 Percent Good 316 97.23% 320 97.26% 324 97.30% 322 97.58% 98.19% Daily Productivity 13 (pizzas/employee/hour) 5.17 5.02 5.08 5.14 5.11