QUESTION 5: 10 Points 2.5 points each 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/unitthe 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. A 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