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 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
Get step-by-step solutions from verified subject matter experts
