12 Mar Last year, your firm collected data on each of its 107 division managers. The data contain growth figures for each manager’s division, the manager’s tenure with the firm, and the manager’s score on a leadership test, which was administered firmwide. These data are contained in the file attached. Run a regression designed to determine the effect of manager tenure on division growth. What role, if any, can the manager’s leadership test score play in the regression you ran for Part a? Explain. DataSetActivity.xlsx
Last year, your firm collected data on each of its 107 division managers. The data contain growth figures for each manager's division, the manager's tenure with the firm, and the manager's score on a leadership test, which was administered firmwide. These data are contained in the file attached.
- Run a regression designed to determine the effect of manager tenure on division growth.
- What role, if any, can the manager's leadership test score play in the regression you ran for Part a? Explain.
Sheet1
| Growth | Tenure | Test Score |
| 4 | 6 | 14 |
| 6 | 7 | 63 |
| 3 | 16 | 19 |
| 5 | 4 | 48 |
| 9 | 26 | 100 |
| 3 | 25 | 13 |
| 5 | 9 | 86 |
| 2 | 9 | 89 |
| 4 | 17 | 13 |
| 1 | 24 | 83 |
| 3 | 4 | 41 |
| 11 | 16 | 59 |
| 7 | 26 | 107 |
| 4 | 10 | 91 |
| 5 | 9 | 79 |
| 9 | 25 | 27 |
| 7 | 11 | 96 |
| 10 | 4 | 46 |
| 0 | 14 | 32 |
| -1 | 13 | 40 |
| 2 | 1 | 11 |
| 9 | 26 | 98 |
| 5 | 30 | 91 |
| 3 | 2 | 6 |
| 6 | 12 | 8 |
| 5 | 23 | 66 |
| 4 | 10 | 42 |
| 12 | 20 | 102 |
| 3 | 19 | 50 |
| 4 | 19 | 18 |
| 7 | 19 | 46 |
| 2 | 7 | 41 |
| 7 | 21 | 40 |
| 9 | 8 | 74 |
| 7 | 24 | 54 |
| 3 | 22 | 13 |
| 2 | 15 | 60 |
| 3 | 14 | 58 |
| 9 | 24 | 33 |
| 0 | 5 | 20 |
| 6 | 15 | 107 |
| 5 | 11 | 24 |
| 7 | 8 | 67 |
| 7 | 4 | 54 |
| 9 | 21 | 56 |
| 5 | 13 | 57 |
| 6 | 13 | 64 |
| 1 | 5 | 9 |
| 6 | 25 | 94 |
| 1 | 22 | 11 |
| 4 | 9 | 28 |
| 4 | 18 | 97 |
| 6 | 16 | 41 |
| 12 | 27 | 77 |
| 10 | 25 | 73 |
| 9 | 27 | 78 |
| 8 | 18 | 70 |
| 3 | 15 | 75 |
| 1 | 14 | 14 |
| 11 | 13 | 60 |
| 11 | 27 | 104 |
| 8 | 19 | 54 |
| 1 | 13 | 20 |
| 7 | 21 | 61 |
| 5 | 12 | 34 |
| 3 | 5 | 6 |
| 7 | 11 | 55 |
| 6 | 29 | 66 |
| 7 | 20 | 47 |
| 8 | 10 | 20 |
| 9 | 8 | 90 |
| 7 | 11 | 100 |
| 2 | 2 | 25 |
| 7 | 18 | 85 |
| 7 | 18 | 101 |
| 9 | 7 | 99 |
| 7 | 30 | 95 |
| 5 | 10 | 52 |
| 7 | 12 | 67 |
| 7 | 8 | 55 |
| 3 | 17 | 17 |
| 9 | 17 | 92 |
| 10 | 23 | 104 |
| 8 | 24 | 36 |
| 5 | 6 | 27 |
| 9 | 22 | 67 |
| 6 | 26 | 99 |
| 12 | 22 | 94 |
| 5 | 24 | 75 |
| 6 | 5 | 30 |
| 4 | 28 | 101 |
| 2 | 10 | 88 |
| -2 | 6 | 9 |
| 11 | 24 | 81 |
| 9 | 7 | 101 |
| 2 | 21 | 11 |
| 5 | 28 | 51 |
| 2 | 11 | 102 |
| 2 | 21 | 60 |
| 1 | 2 | 11 |
| 10 | 11 | 101 |
| 10 | 24 | 79 |
| 9 | 19 | 100 |
| 6 | 13 | 94 |
| 14 | 18 | 107 |
| 2 | 25 | 58 |
| 2 | 6 | 72 |
