For this assessment, you will consider historical data from a selection system. This includes two measures of job knowledge, Test1 and Test2, which have been designed to be equivalent measures of a required body of job knowledge; structured interview ratings from two interviewers, Int1 and Int2, working in- dependently but under the same structured interview protocol; and a valid and reliable composite measure of work performance, called WP. Each case in the data file corresponds to an applicant who was hired in the past year. Additional files posted in a directory on the course site in Brightspace include the data file THAf20.xls and a fillable form for your responses. Each of the following five numbered questions is worth 3 points, for a combined total of 15 points. Remember to use the form for your submission, to the labelled drop-box on the course site. 1. Report the mean, standard deviation, and intercorrelations of all the vari- ables in the data file. 2. Standardize the variable WP, and report the mean and standard deviation of this new variable. What is the validity of Int1 with respect to both these forms of WP? 3. From Q1, report the correlation between Test1 and Test2. What form of reliability is this? Based on the standards for interpretation provided in the text, what is the meaning of this result? How will you respond to this result, as an HRM manager working within this system? 4. From Q1, report the correlation between Int1 and Int2. What form of reliability is this? Based on the standards for interpretation provided in the text, what is the meaning of this result? How will you respond to this result, as an HRM manager working within this system? 5. Consider the validity coefficients that you provided in your response to Q1. Which predictor is the most valid, and which is the least valid? How will you respond to these results, as an HRM manager working within this system? A2 A C D E F 1 ID Test1 Test2 Int1 Int2 WP 1 4.5 4.5 9.8 9.8 0.92 3 4 4.5 9.7 9.8 0.76 3.5 9.65 9.7 0.72 3.5 2.5 9.5 9.65 0.8 2 3 9.34 9.6 0.65 7 4.5 9.1 9.6 0.9 8 7 3 4 9 9.5 0.75 9 8 4 8.87 9.4 0.68 10 9. 2 1.5 8.8 9.34 0.5 11 10 3.5 8.7 9.2 0.45 12 11 3.5 4 8.67 9.1 0.52 13 12 4 4.5 8.6 0.84 14 13 4 4.5 8.5 8.87 0.78 15 14 4 3 8.4 8.8 0.62 16 15 3.5 2 8.4 8.8 0.61 17 16 3.5 2.5 8.3 8.7 0.54 18 17 4 3 8.21 8.67 0.66 19 18 4 3 8.2 8.6 0.65 20 19 4 3 8.2 8.5 0.63 21 20 3.5 8 8.4 0.62 22 21 3 8 8.4 0.64 23 22 8.4 0.7 24 23 8.3 0.94 25 24 4.5 7.9 8.3 0.95 26 25 4 3.5 7.9 8.21 0.97 27 26 4.5 4.5 7.5 8.2 0.94 28 27 4.5 3.5 7.2 8.2 0.76 29 28 1.5 2.5 7.5 8.1 0.44 30 29 2 2 6.9 8 0.46 31 30 1.5 2 7 8 0.54 32 31 3 9.4 8 0.65 33 32 4 4 9.2 8 0.74 34 33 4.5 8.4 8 0.91 35 34 4 4 8.3 7.9 0.9 36 35 4 8.1 7.9 0.94 37 36 7.8 7.8 0.88 38 37 4 4 7.7 7.7 0.64 39 38 7.5 7.5 0.58 40 39 1.5 7.3 7.5 0.52 41 40 3.5 7.2 7.3 0.48 00 00 N