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 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