Variable name Wade Jo Yes IS Machine Machine Description Includes salary bonuses and profit sharing $) com 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 A score of 1-20 which is low to high of performance on machine H F Overall New Macht WA B 1 Wage Job Years 112 $35,134 10 3 327222 8 $37,435 13 Cases C D Shift Machine1 1 7 2 1 1 5 E Machine2 12 5 15 20 Thirrnin 22 What formula would you put in G2 (that could be copied down the column) to compute a Machine 1 score that retains the 1-10 scale, but where the best performance becomes a 1 and the worst performance becomes a 10? 23 You are interested in analyzing data only from people who need training on at least one machine for each machine training is needed it scores fall in the bottom 40% of the rating scale (A for Machine, -B for Machine2) What formula would you use in H2 (that could be Variable name Wade Jo Yes IS Machine Machine Description Includes salary bonuses and profit sharing $) com 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 A score of 1-20 which is low to high of performance on machine H F Overall New Macht WA B 1 Wage Job Years 112 $35,134 10 3 327222 8 $37,435 13 Cases C D Shift Machine1 1 7 2 1 1 5 E Machine2 12 5 15 20 Thirrnin 22 What formula would you put in G2 (that could be copied down the column) to compute a Machine 1 score that retains the 1-10 scale, but where the best performance becomes a 1 and the worst performance becomes a 10? 23 You are interested in analyzing data only from people who need training on at least one machine for each machine training is needed it scores fall in the bottom 40% of the rating scale (A for Machine, -B for Machine2) What formula would you use in H2 (that could be