14 Apr Download the data file Chapter 7 with performance 2014 2015 and Sick2014 ?. We are interested in understanding which factors may predict an employee’s performance rating in 2015. Can you find a goo
Instructions
- Download the data file “Chapter 7 with performance 2014 2015 and Sick2014”.
- We are interested in understanding which factors may predict an employee’s performance rating in 2015. Can you find a good three-factor prediction model?
- We are also interested in understanding which factors may predict the change of an employee’s performance rating from 2014 to 2015. Again, can you find a good three-factor prediction model?
Submission Guidelines
- Please feel free to use any statistical analysis software.
- The submitted file should be a report summarizing:
– the analysis you did,- why this analysis addresses the questions of interest,- your findings from the analysis, and- any statistical evidence (e.g., t-statistic, p-value, estimates and standard errors for regression coefficients) supporting your findings.There is no need to include the steps/script/code you ran on any statistical software or any screenshot of the software outputs.
- Please submit your answer as a PDF file. There is no need to include this page or repeat the instructions in your submitted file.
Sheet1
| ID | Gender | JobTenure2014 | POS2014 | DistJust2014 | ProcJust2014 | JOBSAT2014 | ValueFit2014 | JobStrain2014 | PerformanceRating2014 | PerformanceRating2015 | SickDays2014 |
| 1 | 1 | 8 | 2.25 | 3.00 | 3.25 | 5.18 | 3.67 | 1.67 | 0 | ||
| 2 | 2 | 15 | 2.25 | 3.00 | 3.00 | 4.18 | 3.67 | 3.67 | 0 | ||
| 3 | 1 | 20 | 2.75 | 2.00 | 2.75 | 3.27 | 2.67 | 2.00 | 0 | ||
| 4 | 0 | ||||||||||
| 5 | 1 | 4 | 3.50 | 3.00 | 3.25 | 4.27 | 4.67 | 2.00 | 0 | ||
| 6 | 1 | 8 | 4.25 | 4.00 | 5.00 | 6.82 | 4.33 | 1.33 | 4 | 3 | 0 |
| 7 | 2 | 6 | 3.50 | 4.00 | 4.00 | 5.55 | 4.00 | 4.00 | 0 | ||
| 8 | 1 | 4 | 1.50 | 2.33 | 3.25 | 4.27 | 3.67 | 3.67 | 4 | 3 | 0 |
| 9 | 1 | 7 | 4.25 | 5.00 | 4.50 | 6.73 | 4.67 | 1.00 | 3 | 3 | 0 |
| 10 | 4.75 | 4.67 | 3.25 | 6.45 | 5 | 5 | 0 | ||||
| 11 | 3 | 3 | 0 | ||||||||
| 12 | 2 | 2 | 3.00 | 2.67 | 2.25 | 4.73 | 3.00 | 3.67 | 0 | ||
| 13 | 1 | 6 | 5.00 | 5.00 | 5.00 | 7.00 | 5.00 | 1.00 | 0 | ||
| 14 | 1 | 10 | 1.00 | 1.00 | 1.50 | 2.55 | 3.00 | 5.00 | 4 | 5 | 0 |
| 15 | 2 | 13 | 3.50 | 4.00 | 3.75 | 6.27 | 3.67 | 2.00 | 5 | 2 | 5 |
| 16 | 1 | 6 | 4.25 | 3.00 | 3.75 | 6.00 | 4.00 | 3.00 | 5 | 5 | 0 |
| 17 | 0 | ||||||||||
| 18 | 1 | 7 | 3.50 | 4.00 | 4.00 | 6.00 | 3.33 | 4.00 | 4 | 3 | 0 |
| 19 | 1 | 16 | 3.00 | 3.00 | 3.50 | 4.73 | 3.00 | 3.33 | 3 | 3 | 3 |
| 20 | 1 | 20 | 3.50 | 4.00 | 4.00 | 5.82 | 4.00 | 1.00 | 0 | ||
| 21 | 2 | 8 | 4.00 | 4.00 | 4.00 | 5.82 | 4.00 | 2.00 | 3 | 1 | 28 |
| 22 | 1 | 1 | 4.50 | 2.00 | 4.25 | 6.09 | 5.00 | 1.67 | 4 | 5 | 0 |
| 23 | 1 | 2 | 3.50 | 3.67 | 3.75 | 6.00 | 4.00 | 2.00 | 0 | ||
| 24 | 0 | ||||||||||
| 25 | 2 | 3 | 4.00 | 2.00 | 4.00 | 5.27 | 4.00 | 4.33 | 5 | 5 | 2 |
| 26 | 2 | 5 | 2.25 | 2.00 | 3.75 | 3.91 | 4.33 | 4.00 | 5 | 3 | 0 |
| 27 | 2 | 2 | 4.00 | 3.00 | 3.25 | 6.18 | 4.00 | 2.33 | 3 | 3 | 0 |
| 28 | 2 | 3 | 0 | ||||||||
| 29 | 1 | 1 | 3.75 | 3.33 | 3.50 | 6.18 | 3.67 | 2.00 | 5 | 3 | 0 |
| 30 | 3 | 2 | 9 | ||||||||
| 31 | 1 | 20 | 2.50 | 2.00 | 3.25 | 3.55 | 4.00 | 3.33 | 1 | 3 | 0 |
| 32 | 1 | 10 | 2.00 | 2.33 | 2.25 | 4.00 | 4.00 | 2.00 | 0 | ||
| 33 | 1 | 1 | 4.00 | 2.33 | 4.00 | 5.18 | 3.67 | 2.67 | 4 | 3 | 0 |
| 34 | 1 | 5 | 4.00 | 4.00 | 4.00 | 5.64 | 4.00 | 2.00 | 0 | ||
| 35 | 4 | 3 | 0 | ||||||||
| 36 | 2 | 20 | 3.50 | 4.00 | 4.00 | 6.00 | 3.00 | 2.00 | 3 | 3 | 2 |
| 37 | 2 | 16 | 3.75 | 2.33 | 3.25 | 6.55 | 3.00 | 3.00 | 4 | 3 | 0 |
| 38 | 2 | 9 | 4.25 | 2.00 | 3.50 | 6.00 | 4.00 | 2.67 | 3 | 3 | 4 |
| 39 | 4 | 3 | 3 | ||||||||
| 40 | 3 | 2 | 0 | ||||||||
| 41 | 4 | 3 | 0 | ||||||||
| 42 | 2 | 3 | 0 | ||||||||
| 43 | 2 | 2 | 3.75 | 3.67 | 4.25 | 5.45 | 4.00 | 2.00 | 3 | 0 | |
| 44 | 4 | 3 | 1 | ||||||||
| 45 | 3 | 2 | 0 | ||||||||
| 46 | 3 | 3 | 1 | ||||||||
| 47 | 0 | ||||||||||
| 48 | 1 | 2 | 4.00 | 2.00 | 2.75 | 5.55 | 4.67 | 2.33 | 0 | ||
| 49 | 2 | 21 | 4.00 | 4.00 | 4.00 | 6.18 | 4.00 | 2.00 | 3 | 3 | 5 |
| 50 | 1 | 8 | 3.75 | 3.33 | 3.00 | 5.18 | 3.33 | 2.33 | 3 | 3 | 5 |
| 51 | 1 | 26 | 3.75 | 3.33 | 4.50 | 6.18 | 5.00 | 4.00 | 5 | 2 | 0 |
| 52 | 1 | 1 | 4.50 | 2.00 | 4.50 | 6.00 | 3.33 | 2.67 | 4 | 5 | 0 |
| 53 | 0 | ||||||||||
| 54 | 4.00 | 3.00 | 4.00 | 6.36 | 4.00 | 4 | 3 | 0 | |||
| 55 | 3 | 3 | 0 | ||||||||
| 56 | 2 | 6 | 4.25 | 4.00 | 4.00 | 6.27 | 5.00 | 1.00 | 3 | 3 | 0 |
| 57 | 1 | 10 | 4.00 | 3.33 | 4.00 | 5.91 | 4.33 | 3.00 | 4 | 3 | 0 |
| 58 | 2 | 4 | 3.75 | 4.00 | 4.00 | 6.00 | 3.67 | 1.00 | 3 | 2 | 4 |
| 59 | 1 | 2 | 4.00 | 3.33 | 4.00 | 5.73 | 4.00 | 2.00 | 4 | 3 | 3 |
| 60 | 2 | 5 | 3.25 | 3.33 | 3.75 | 5.73 | 4.00 | 2.67 | 5 | 0 | |
| 61 | 2 | 7 | 2.50 | 3.00 | 3.25 | 5.45 | 3.33 | 3.33 | 3 | 3 | 2 |
| 62 | 2 | 28 | 2.75 | 2.33 | 3.00 | 4.45 | 4.00 | 4.00 | 3 | 3 | 10 |
| 63 | 3.75 | 1.67 | 3.25 | 5.82 | 3.00 | 3 | 0 | ||||
| 64 | 1 | 3 | 1.50 | 2.67 | 3.50 | 4.91 | 3.67 | 4.00 | 3 | 3 | 0 |
| 65 |
