Autorama Case

4. For the questions 1-3 we found out a couple different cost functions that could be useful for Delta when predicting salaries for 2003 and 2004. The multiple regressions may be most reliable considering it uses multiple variables, but the single R square is better than multiple regressions.

Use the sales forecaster’s prediction to describe a normal probability distribution that can be used to approximate the demand distribution. Sketch the distribution and show its mean and standard deviation.

Exercises 12.17, 12.21, and 12.43 require the use of the “Regression” function within the Data Analysis menu in Excel. Refer to Appendix E12 for instructions on using Excel for these exercises.

The case involves the decision to locate a new store at one of two candidate sites. The decision will be based on estimates of sales potential, and for this purpose, you will need to develop a multiple regression model to predict sales. Specific case questions are given in the textbook, and the necessary data is in the file named pamsue.xls.

Pam and Susan’s department stores are in the process of opening a new business unit. There are two locations that are being considered for the new store and decision is based upon estimates of sales for both of them. My job is to use data gathered from each store as well census data in store’s trading zones to predict sales at both of the sites that are being consider for their newest store.

5) Graph the equation you wrote in step four superimposed over the original data. Comment on how well or how poorly the equation fits the data.

Table 6.1.1 displays the matlab output of beta, standard error, t-statistic and p-value for the two independent variables during 10-year period. It is found that beta of X1 is 0.2750 which indicates there is a positive relationship between the utilities excess return and the healthcare excess return. This positive relationship is statistically significant as the p-value is close to 0 which is much less than the significance level of 5%. In addition, the standard error of X1 is 0.0300 which represents the average distance that the observed values fall from the regression line. This indicates that the model fits the data. In contrast, it is found that the material excess return is negatively

AJ DAVIS is a department store chain, which has many credit customers. A sample of 50 credit customers is selected with data collected on location, income, credit balance, number of people and years lived in the house

12) The following data show the list price, x, in thousands of dollars, and the dealer invoice price, y, also in

AutoZone as a vision defined clearly by a man named J. R. “Pitt” Hyde III. He received his undergraduate degree in economics from the University of North, Carolina, where he started working at Malone & Hyde, Inc., a wholesale food company founded by Hyde’s grandfather. Pitt initiated and developed Malone & Hyde specialty retailing division, starting with drug stores and expansions to include sporting goods stores and supermarkets (“Our History and Timeline,” n. d.).

Using MINITAB perform the regression and correlation analysis for the data on SALES (Y) and CALLS (X), by answering the following questions:

In this particular case, Randy will need to assign the correct numbers to the correct category. For the purposes of this case study, assume T will equal 1 to make the equation represent one year of employment in one of the ice cream shops. For following variables, Nn will equal 50 as there will be 50 applicants total selected to be hired, rxy will represent .30 in one equation representing the interview and job performance and in the other equation, it will represent .50 which will represent the work sample predictor and job performance, SDy will be chosen to represent .20, Ẑs will be .80 because it will be the predictor score of the selected applicants, Na will represent 100, as that is the total number of applicants that submitted applications, and Cy will represent the cost per applicant in the interview and job performance in one equation as 100 and it will represent 150 in the other equation for work sample and job

It might not be in the retailer’s best interest to perform such upgrade, as the new system will replace three of the existing legacy systems in terms of ordering and fulfillment. The IS department will perceive such upgrade as a radical move and is expected to show high resistance in response to it. Even though Zara has a decentralized decision making process, the retailer’s IS department exercises absolute autonomy on the IT infrastructure and design. The fact that “only one person had left the department” in the past 10 years further confirms that the retailer is suffering from cognitive and action inertia, and thus creating a huge barrier for such

2. Use simple regression to estimate the salary cost function for Delta Airlines. Comment on the statistical validity and significance of your results. What are the

Run the regression Report your answer in the format of equation 5.8 (Chapter 5, p. 152) in the textbook including and the standard error of the regression (SER). Interpret the estimated slope parameter for LOT. In the interpretation, please note that PRICE is measured in thousands of dollars and LOT is measured in acres.