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?

Fig: 1