Please use regression analysis on the Excel dataset that accompanies this case to answer the following

questions. Add supporting statistical evidence.

1. Is employee tenure a driver of store-level financial performance?

2. Does employee tenure matter equally for the manager versus the crew as a driver of store-level

financial performance?

3. How important are the manager's and crew's tenure relative to site location factors in determining

store-level financial performance? Please answer separately for the manager tenure and the crew

tenure.

4. Does the relationship between tenure and performance vary with tenure level? Please answer

separately for the manager tenure and the crew tenure.

5. Based on your analysis, what type of employee retention program do you recommend for Store

24?