The file named Employees.xlsx contains the rating (on a 0–10 scale) that each of 35 workers has given to three jobs. The file also gives the job to which each worker is assigned. Use a formula to compute each worker’s rating for the job to which the worker is assigned.

Transcribed Image Text:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 A B Rank C Assigned to 2 2 VINN 2 1 2 2 3 2 2 1 1 1 1 1 3 1 2 2 3 3 2 2 2 1 2 3 1 D Worker 1 2 3 4 5 6 7 8 9 9 10 11 12 13 14 15 16 17 18 19 20 DENIS 7 21 22 23 24 25 26 27 E 1 4 1 8 3 9 3 5 5 3 3 1 2 7 7 9504 10 0 5 10 6 10 8 ∞0 430 F Jobs 2 5 1 9 1 7 8 4 9 1 6 2 1 8 5 1 10 5 1 1 1 2 8 9 334 1 G 3 4 6 2 5 8 6 5 5 10 6 1 9 4 5 3 8 3 5 4 1 3 6 9 3 7 4 0 H