The table below provides information about employees at a particular plant from the prior week. So looking at the first employee, Janet was paid $12/hour, and produced 65 units in 20 hours of time. Column E refers to cost/unit: the average cost of wages per unit produced in dollars. Column F refers to productivity: the average units produced per hour. Watch the row numbers, 50 employees exist, however, rows 5-49 were hidden to make the table smaller. So 50 employee names are shown in the range A2:A51. E Cost/Unit ($/unit) F Productivity (Units/hour) 1 Employee 2 Janet 3 Allison 4 Kurt 50 Rachel 51 Todd B Wage ($/hour) 12 13 12 11 10 Units Produced 65 110 115 80 85 D Hours Worked 20 40 40 25 30 Provide FORMULAS as requested below. In these formulas, reference cells or cell ranges where possible! So do not enter specific numbers if a cell or cell range can be referenced A. Formula for cell E2, in a manner that can be copied and pasted into E3 E51. B. Formula for cell F2 in a manner that can be copied and pasted into F3.F51. C. For the company overall (all employees combined), the Formula for average Productivity D. Using this plant as a sample to represent all company production employees, the Formula for the standard deviation of units produced