Managing Employee Retention Essay

Data QualityIt is important to make sure the data you utilisation is valid. An outlier data point can dramatically reduce the fit of a model, so it is critical that bad data points be moved. In the cuticle of the Store24 data, we will assume that all conductors have some experience, so acquire whatsoever data points where the manager experience is zero.Regression AnalysisFirst, you should unthaw a full model for profit that includes both tenure and invest office related covariants. Tenure related variables are MTenure and CTenure. Site location related variables are population, number of competitors, street level visibility, pedestrian access, typewrite of neighborhood, and whether a store stays open 24 hours. These variables are to a fault defined on page 4 of the case Store24 (A).First you should keep an eye on if all variables contribute to our understanding of the model. Use the p- care for for each coefficient to decide (a value of 0.05 is typically used to decide whet her a variable should be included). If any variables are not significant, transcript the worksheet, remove the variable and run the statistical regression again. In your report you should develop how well the model fits (e.g. describes the factors that impact profit).It is not commonly understood how to evaluate the impact of the independent variables. The variables have to have a p-value that is significant (otherwise we cant say there is a relationship), but how small the p-value is does not tell us how important the variable is. A good way to understand the impact of the variable is to beget the range of values it can take, and then multiply that range by the value of the coefficient. That tells you the maximum impact that the variable can have on the problem.Next, you must address tomcat Harts hypothesis that manager tenure does not have a linear impact on profitabilitythat is, that there are diminishing returns to manager tenure. To test this, copy the worksheet, then add t he variable MTenure2. To do this, insert a mainstay next to the Tenure column, and then enter the formula =D22 in cell E2 and copy this formula to the rest of the cells. Now run a regression on this new set of variables and see if the MTenure2 variable is statistically significant.What to Submit You are to write a memo from Sarah Jenkins to Paul Doucette summarizing your results. You should explain your regression results* How well the model predicts store performance (r2, p-value of variables and their impact) * How your MTenure2 assesses Tom Harts hypothesis. Does it support his hypothesis? You should include a chart that shows contribution to profit of employee tenure over the range of values in the data set. The x-axis should be manager tenure, and the y-axis should be the predicted contribution to store profit.Finally, your memo should give Paul Doucette a concrete recommendation as to how some(prenominal) Store24 should invest in any new manager retention programs.