文档下载 文档下载导航
设为首页 | 加入收藏
搜索 请输入内容:  
 导航当前位置: 文档下载 > 所有分类 > 资格考试/认证 > 其它考试 > Doucette wants to decide whether or not to put an …
侵权投诉

Doucette wants to decide whether or not to put an …

The data required for these cases is in the file Store24AB.xls.

Definitions of the different variables in the data are provided in the case itself. Briefly discuss the summary statistics presented in Exhibit 3 in Store24A and Exhibit 2 in Store24B. Use a maximum of 2 slides for this discussion. In your opinion, what do the summary statistics tell us about Store24?

Doucette wants to decide whether or not to put an employee retention program in place. But first, he wants Sarah Jenkins to check whether manager tenure and crew tenure are related to store profit. Accordingly, run the three regression models per instructions given below; data for these 3 models is in the worksheet labeled Data for Case A. variables are MTenure and CTenure. Site location related variables are population, number of competitors, street level visibility, pedestrian access, type of neighborhood, and whether a store stays open 24 hours. These variables are also defined on page 4 of the case Store24 (A).

Interpret the coefficients for MTenure and CTenure in model 1. Which of the two variables contributes more to profits (i.e. which one has a greater $ impact)?

A common way of determining the relative importance of two independent variables is by assessing the incremental r-squared attributable to that variable. The following two models (Models 2 and 3) allow us determine the relative importance of manager and crew tenure in predicting profits at Store24.

The difference between the adjusted r-squared values for Models 1 and 2 is the incremental adjusted r-squared attributable to manager tenure.

difference between the adjusted r-squared values for Models 1 and 3 is the incremental adjusted r-squared attributable to crew tenure.

Based on your work on models 2 and 3, whose tenure is more important in predicting profit at Store24 – manager or crew?

available in Case B, namely, ServQual, MgrSkill and CrewSkill. These new variables are in the worksheet labeled Data for Case B. Before running this model, see important notes 1 and 2 below.

Is model 4 the best model in terms of predicting profits (relative to other models you have run up to this point)? Also, please identify variables in Model 4 that do not contribute significantly in predicting profit.

In the data for part B, the variable MgrSkill has some missing values for some individuals. Regression analysis in EXCEL cannot handle missing values. So, you will have to remove individuals with missing values before running your models.

第1页

你可能喜欢

热门文档

相关文档

站点地图 | 文档上传 | 侵权投诉 | 手机版
本站所有资源均来自互联网,本站只负责收集和整理,均不承担任何法律责任,如有侵权等其它行为请联系我们.
文档下载 Copyright 2013 doc.guandang.net All Rights Reserved.  -  email