The organization wants to use a combination of interview scores (x₁), scores from a role playing exercise (x₂), and personality test scores (x₃) to predict performance (y) in the employee development program. An I/O psychologist collected data on the 32 employees who have already participated in the program. The employee data are presented in Week 6 Data file. Open the file to the Employee Summary tab.

1. Run a multiple regression analysis in Excel (Note: See the video in the Week 6 course resources for information regarding how to run multiple regression in Excel)
2. Copy the summary output (Regression Statistics Table, ANOVA Table, and Coefficient Table) into a Word document.
3. Are the results significant? Explain your response.
4. Should all predictors be included in the least squares regression line? Should any predictors be excluded? Why or why not?
5. Use the summary output to find the least square regression line: y = ax₁+ ax₂+ ax₃+b
6. Estimate the y (performance) for the following two candidates (show your work):

7. Based on these results which candidate would you select into the employee development program?

Interview Role Personality Score Play Test Score Score 4 45 Laura 5 40 Gary 4 5