seventh phase of the business strategy formulation

In the seventh phase of the business strategy formulation, 

decide to study the effect of employees’ time spent in a managerial role to the growth of the division they manage. 

*To begin your study, you collected data on each of your 107 division managers (contained in a separate Excel spreadsheet). 

*The data contains growth figures for each manager’s division, the manager’s tenure with the organization, and the manager’s score on a leadership test. 

*This was all administered throughout the organization. 

Provide your answers to the following questions and prompts: 

1. Run a regression designed to determine the effect of manager tenure on division growth. 

2. What role, if any, can the manager’s leadership test score play in the regression you ran for #1? 

Provide analysis to support your answer. 

This assignment should be at least 500 words in length and submitted as a Microsoft Word document.