Question: Questions You just learned how to use multiple linear regression analysis to understand the potential factors/variables that predict performance in a particular job. Next, using

 Questions You just learned how to use multiple linear regression analysis

Questions

You just learned how to use multiple linear regression analysis to understand the potential factors/variables that predict performance in a particular job. Next, using a different dataset, you will determine which personality dimensions (Agreeableness, Extraversion, Neuroticism, Conscientiousness) are predictive of performance on a particular job. Using data found in the Practice sheet of the Excel workbook, do and respond to the following:

1.Run a multiple linear regression analysis with Performance as the outcome variable and Agreeableness, Extraversion, Neuroticism, and Conscientiousness as the predictor variables.

2.Based on this sample of employees and this particular job, which personality dimension(s) is/are significantly associated with performance? Did the results align with your expectations? Why or why not?

Chapter 9 - Excel Extension.xlsx - Excel E O of File Data Review View Developer Tell me... Sign in & Share Conditional Formatting pe a Home Insert Page Layout Formulas Calibri - 11 BIU- A A DA- Font Alignment Custom $ % ) Format as Table Paste Cells Editing 0.00 000 17 Cell Styles Styles Clipboard Number A1 3 f SUMMARY OUTPUT A B D E F G H 1 min 1 SUMMARY OUTPUT 2 Regression Statistics 4 Multiple R .798 5 R Square .636 6 Adjusted R Square .539 7 Standard Error .589 8 Observations 20.000 9 10 ANOVA 11 df SS MS 12 Regression 4.000 9.109 2.277 13 Residual 15.000 5.208 .347 14 Total 19.000 14.317 15 16 Coefficientandard Errt Stat 17 Intercept 2.232 1.810 1.233 18 Product knowledge .122 .234 .520 19 Extraversion .136 -2.574 20 Time Management .026 .225 .116 21 Cooperativeness .580 .216 2.686 F gnificance F 6.559 .003 P-value Lower 95%Upper 95%ower 95.0%pper 95.0% .237 -1.627 6.090 -1.627 6.090 .611 -378 .622 -.378 .622 .021 -.638 -.060 -.638 -.060 .909 -.454 .507 -.454 .507 .017 .120 1.041 .120 1.041 - 349 Regression Tutorial Practice + Bauer, Human Resource Management First Publishing 20706% Ready

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!