Answered step by step
Verified Expert Solution
Link Copied!

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.

  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 = ax1+ ax2+ ax3+b
  6. Estimate the y (performance) for the following two candidates (show your work):

image text in transcribed
Interview Role Personality Score Play Test Score Score 4 45 Laura 5 40 Gary 4 5

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Differential Geometry And Continuum Mechanics

Authors: Gui Qiang G Chen, Michael Grinfeld, R J Knops

1st Edition

331918573X, 9783319185736

More Books

Students also viewed these Mathematics questions

Question

2. Develop a good and lasting relationship

Answered: 1 week ago

Question

1. Avoid conflicts in the relationship

Answered: 1 week ago