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 sc
Need help with this assignment?Get an original answer from a qualified tutor — from $10/page.
Get it written →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 |
Get a plagiarism-free answer to this question
Send us your instructions and we’ll match you with the best writer in your subject.
- 100% human-written, zero AI
- Turnitin report included
- Confidential — we never share your data
- Free revisions & refunds