Variable name Wage Job Years Shift Machine 1 Machine 2 Description Includes salary bonuses and profit sharing ($) combined NOT broken out Years of experience at current job Whether the employee works days (1) or nights (2) A score of 1-10 which is low to high of performance on machine 1 A score of 1-20 which is low to high of performance on machine2 G New Mach1 Overall H Cases 1 2 3 4 A B Wage Job Years $35 134 10 $27.222 8 $37 435 13 D Shift Machine 1 1 7 2 1 1 5 E Machine2 12 5 15 20 The spreadsheet above is typical of an Excel spreadsheet layout for statistical analysis. In a typical layout, rows represent and columns represent 21 What formula would you put in F2 (that could be copied down the column) to compute an overall performance score for each observation? This overall score would be an average of the two machine performance scores, equally weighted and on a 1-20 scale