Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
Based on the Teaching case Store24 (A): Managing Employee Retention by Frei and Campbell (2005). Please read the case (available on Blackboard) and analyse the
Based on the Teaching case Store24 (A): Managing Employee Retention by Frei and Campbell (2005). Please read the case (available on Blackboard) and analyse the given dataset. Notice that the dataset is different from the original dataset provided by the authors.
- Consider just the people factors (i.e., the tenures of manager and crew), what will be the dashboard summary (numerical and/or visual) of the data to highlight the possible relationship between tenures of manager and crew and store financial performance. What do you find?
- Conduct a multiple regression analysis with both people and locational factors (Eight independent variables in total). Show and interpret the regression results.
- Do you want to keep Visibility in your model? Why or why not? Refine your model if needed and show your results.
- Are the regression results consistent with your findings in Question 1 about people factors? Explain why the regression approach provides more reliable results comparing to the dashboard summary.
- Can we conclude that people factors lead to a store's financial success? What are some potential problems of your regression analysis?As the top management of Store24, what can you do to help your analytics team to solve these problems?
- Based on your latest regression model, estimate the annual profit of a store with the following attributes:
MTenure | 6 months |
CTenure | 25 months |
Pop | 12,500 |
Comp | 3 |
PedCount | 3 |
Res | Residential area |
Hr24 | No |
Visibility | 3 |
For this particular store, it is estimated that the cost will increase by roughly $50,000 per year if it opens 24/7. Will you advise the store to switch to 24/7? Why?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started