Please access the Excel file for this assignment and answer the following questions.

Currently, PIP uses the unstructured interview and the work sample to choose candidates that they think will ultimately perform well, contribute to guest satisfaction, and come to work when scheduled.

1. Calculate and interpret the correlation between the Unstructured Interview and:

a. job performance

b. guest satisfaction

c. absenteeism

2. Calculate and interpret the correlation between Work Sample Time 1 and:

a. job performance

b. guest satisfaction

c. absenteeism

3. Conduct a regression for Work Sample Time 1 predicting job performance

a. Is Work Sample a statistically significant predictor of job performance? Explain why you know this and what this means.

b. Is Work Sample a practically significant predictor of job performance? Explain.

c. Write the regression equation

d. If a candidate scores 22 on the work sample, what is her predicted job performance score?

Applicant / Employee ID Absenteeism 1 2 3 4 5 3 0 0 0 4 0 6 0 0 9 0 0 16 0 0 3 3 3 Unstructured Work SampleScore Work Sample Score Job Guest Interview Time 1 Time 2 Performance Satisfaction 5 85 83 3 50 5 92 97 4 38 3 78 83 3 7 5 94 93 4 15 5 91 90 5 36 5 98 99 5 46 5 80 77 5 10 4 80 90 4 47 4 83 87 5 35 4 91 85 4 9 4 85 85 4 13 4. 94 93 4. 38 4 88 80 3 49 4 82 78 3 8 4 83 90 4 12 4 82 82 4 50 4. 54 78 4. 30 4 69 71 4 20 4 78 82 4 48 4 88 85 4 47 3 100 99 3 37 3 91 90 3 17 3 82 83 3 8 3 95 91 3 39 2 69 64 2 47 4 78 71 2 44 3 78 78 3 34 3 80 77 3 14 3 73 75 3 6 3 75 79 3 38 3 82 69 3 50 3 68 68 3 48 3 91 78 3 38 3 76 76 4 11 3 74 79 3 10 2 45 44 2 35 2 60 63 2 48 2 75 75 2 50 2 80 76 5 38 2 60 68 1 17 2 68 64 2 5 2 90 89 2 36 2 68 62 2 48 2 65 62 2 10 2 52 60 2 46 1 53 50 1 36 1 35 40 1 15 1 25 30 1 7 1 50 55 5 38 2 70 73 3 50 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 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 mm OOOOOOOOOON 11 mmm 1 O NOOOOOOWNNN 10 10 Notes: Work Sample Scored from 1 to 100 Interview is unstructured but scored 15 based on interviewer's assessment of exchange with candidate Job Performance measured using employee appraisal: Scored from 1 to 5 Guest Satisfaction measured using Guest Sassfaction sessments given to guess re: maintenance services: Scored from 5 to 50 Absenteeism refers to number of workdays absent within 1 year