Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The organization wants to use a combination of interview scores (x 1 ), scores from a role playing exercise (x 2 ), and personality test
The organization wants to use a combination of interview scores (x1), scores from a role playing exercise (x2), and personality test scores (x3) 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.
- 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)
- Copy the summary output (Regression Statistics Table, ANOVA Table, and Coefficient Table) into a Word document.
- Are the results significant? Explain your response.
- Should all predictors be included in the least squares regression line? Should any predictors be excluded? Why or why not?
- Use the summary output to find the least square regression line: y = ax1+ ax2+ ax3+b
- Estimate the y (performance) for the following two candidates (show your work):
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started