The above table shows the scores for each of the tests. Note that they were on different measurement scales (e.g., 1 to 10, 1 to 100). Thus, your job now is to (1) standardize those scores (i.e., from the five tests you have chosen in Q1) into z-scores and (2) calculate overall scores (i.e., average) for each of the eight candidates, and (3) choose the one who will receive a job offer. Please use the Excel spreadsheet used in class (see Files) and submit it (20 pts).

You are an HR manager of Chern's department store, and are seeking to hire ONE new sales associate for your flagship store in NJ. Due to the budget constraint, you are considering to choose five employment tests out of the nine tests available (see the first row of the table below). Given the company's business strategy focusing to deliver differentiated, superior customer experiences, you are trying to assess various qualities of the following eight applicants in terms of their abilities to contribute to improved customer experiences. Vocational Cognitive Personality Personality Job NAME ability (conscientiousness) (agreeableness) (sales) Technology Work Integrity Structured simulation test interest knowledge test skills test interview test test test test Maria 125 5 4 5 60 45 60 5 3 Cruz Sharon 120 6 8 70 40 45 Simmons Alex 115 5 55 45 50 Turing Parvathi 110 4 65 35 55 Naryan Vera 100 2 60 40 35 Levitt Chris 115 50 25 30 Prender Julia McKnight 110 60 35 Ben Hirsch 105 45 30 5 5 4 4 3 3 4 9 A 4 4 3 4 3 4 2 35 40 4 4 3 3 4 2 3 9 10 6 10 2 2 8 7