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? Note: Once you have completed #1 and #2, you've calculated criterion-related validity. Woohoo! You are looking at how well the predictor correlates with each criterion. This is r. Applicant Employer ID Unstructured Interview + 1 2 3 4 WS E 16 188096 5 $ 16 7 5 + 06 7 6 6 16 $ Work Sample See Work Sample Score Source Go Time! Time 2 Satisfact Absentism 5 35 50 5 38 3 7 3 7 0 3 95 4 15 o 5 91 36 5 5 6 4 5 5 10 NO 47 6 4 5 35 0 4 35 4 0 + 4 3 4 93 4 38 0 + 1 49 0 4 3 4 3 o 4 50 3 4 54 30 3 4 6 71 4 1 4 4 4 35 47 3 100 3 37 3 17 0 1 3 3 0 10 11 12 13 14 15 16 17 IN 19 20 0 1 1 + 1 BR250R 6 22 16 24 E S6 16 66 0 64 71 47 44 RE 26 27 0 0 11 MC TU NO 73 O 77 75 2 4 3 1 1 1 3 3 1 3 29 10 31 32 0 D SE 2 2 3 3 3 1 3 3 3 4 1 0 E 2 EE 16 14 6 35 30 48 38 11 10 35 48 SO 1 34 35 36 76 74 45 2 2 2 3 LE 09 2 2 2 73 1 75 3RRRRRUR RE 0 0 2 2 17 5 16 2 $ 1 1 2 2 2 2 0 O E NT 38 39 40 41 42 43 44 45 46 47 45 49 50 O 2338 39 ARR 2 2 1 0939399 52 60 1 10 2 4 7 6 1 1 10 46 36 15 7 38 50 1 25 50 70 1 1 5 3 30 55 75 5 2 10 Net Work Sandro www.ad bald wie Jose Powders Sweet Get Stiften.de where we will 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? Note: Once you have completed #1 and #2, you've calculated criterion-related validity. Woohoo! You are looking at how well the predictor correlates with each criterion. This is r. Applicant Employer ID Unstructured Interview + 1 2 3 4 WS E 16 188096 5 $ 16 7 5 + 06 7 6 6 16 $ Work Sample See Work Sample Score Source Go Time! Time 2 Satisfact Absentism 5 35 50 5 38 3 7 3 7 0 3 95 4 15 o 5 91 36 5 5 6 4 5 5 10 NO 47 6 4 5 35 0 4 35 4 0 + 4 3 4 93 4 38 0 + 1 49 0 4 3 4 3 o 4 50 3 4 54 30 3 4 6 71 4 1 4 4 4 35 47 3 100 3 37 3 17 0 1 3 3 0 10 11 12 13 14 15 16 17 IN 19 20 0 1 1 + 1 BR250R 6 22 16 24 E S6 16 66 0 64 71 47 44 RE 26 27 0 0 11 MC TU NO 73 O 77 75 2 4 3 1 1 1 3 3 1 3 29 10 31 32 0 D SE 2 2 3 3 3 1 3 3 3 4 1 0 E 2 EE 16 14 6 35 30 48 38 11 10 35 48 SO 1 34 35 36 76 74 45 2 2 2 3 LE 09 2 2 2 73 1 75 3RRRRRUR RE 0 0 2 2 17 5 16 2 $ 1 1 2 2 2 2 0 O E NT 38 39 40 41 42 43 44 45 46 47 45 49 50 O 2338 39 ARR 2 2 1 0939399 52 60 1 10 2 4 7 6 1 1 10 46 36 15 7 38 50 1 25 50 70 1 1 5 3 30 55 75 5 2 10 Net Work Sandro www.ad bald wie Jose Powders Sweet Get Stiften.de where we will