In: Statistics and Probability
Question: Please open “PERFORMANCE” data. Data is about a survey result of manager who is planning to make a research on influence of competence and motivation on employees’ performance. However; he suspects whether there is a multicollinearity or not in his regression model he is planning to construct and he requested your help. Please support him with implementing multi collinearity analysis and report your findings. Your report must contain scatter plot matrix, correlation matrix, and a regression output including the VIF values. (Please perform it on spss)
No | Competence | Motivation | Performance |
1 | 32 | 34 | 36 |
2 | 35 | 37 | 39 |
3 | 38 | 45 | 49 |
4 | 31 | 41 | 41 |
5 | 36 | 40 | 38 |
6 | 32 | 38 | 36 |
7 | 33 | 39 | 37 |
8 | 31 | 40 | 41 |
9 | 30 | 37 | 40 |
10 | 35 | 37 | 43 |
11 | 31 | 34 | 36 |
12 | 34 | 32 | 35 |
13 | 31 | 42 | 34 |
14 | 25 | 36 | 40 |
15 | 35 | 42 | 40 |
16 | 36 | 41 | 44 |
17 | 30 | 38 | 32 |
18 | 34 | 41 | 41 |
19 | 34 | 41 | 44 |
20 | 22 | 27 | 26 |
21 | 27 | 26 | 33 |
22 | 30 | 30 | 35 |
23 | 30 | 35 | 37 |
24 | 37 | 39 | 44 |
25 | 29 | 35 | 36 |
26 | 31 | 35 | 29 |
27 | 31 | 45 | 41 |
28 | 29 | 30 | 32 |
29 | 29 | 35 | 36 |
30 | 31 | 37 | 37 |
31 | 36 | 45 | 42 |
32 | 32 | 44 | 39 |
33 | 27 | 26 | 31 |
34 | 33 | 39 | 35 |
35 | 20 | 25 | 28 |
36 | 30 | 36 | 39 |
37 | 27 | 37 | 39 |
38 | 25 | 39 | 36 |
39 | 32 | 38 | 38 |
40 | 32 | 38 | 35 |