Purchase Solution

Calucation of Multiple Regression Model

Not what you're looking for?

Ask Custom Question

Please help me solve this problem. All the data is in the file pamsue.xls, find attached also the Table A & B that is referred to in question 2 & 3.

This 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.

Problem 1
Use the final regression equation in the last step to predict sales at the two sites under consideration. (Attached document called "hints" can be used for this)

Question 1
How would you describe the type of location sites that are likely to have higher sales?

Question 2
A group within the planning department had previously developed a subjective approach in which potential sites are classified according to an assessment of the "competitive type" of the trading zone. Below in table A, the 7 "competitive types" are defined. How good is this classification method at predicting sales? How can you quantify this?

Question 3
Two sites, A and B, are currently under consideration for the next new store opening. Characteristics of the two sites are provided below in table B. Which site would you recommend? Justify you choice and give the best sales forecasts you can. You may use the subjective classifications from question 2 along with any other variables you think will give the best forecast. Give some estimates of the accuracy of the forecasting method you use and any other limitations of the forecasting method.

Question 4
Two of the variables in the data base are under managerial control: the size of the store (square feet of selling area) and the percentage hard goods stocked in the store. Margins on hard goods (house wares, appliances, stationary, drugs) are different from margins on soft goods (clothing, for example). Do either of these factors appear linked to sales? If so, describe the link you observe and the managerial implications.

Questions 5
Technical: After developing your regression model, check to make sure the technical assumptions are satisfied. Comment on any points that would concern you based on the diagnostics.

Attachments
Purchase this Solution
Solution Summary

The solution provides step by step method for the calculation of multiple regression analysis. Formula for the calculation and Interpretations of the results are also included.

Purchase this Solution
Free BrainMass Quizzes
Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

View More Free Quizzes
Related BrainMass Solutions

  • Multiple regression: City MPG

    If the full multiple regression needs modification, perform a stepwise regression and select the final model. Briefly note why you selected your final model. Interpret the coefficients of the final model only.

  • Develop a multiple linear regression model & compare

    414052 Develop a multiple linear regression model and explain how does this compare with simple regression. Develop a multiple linear regression model.

  • Multiple regression analysis for production cost

    F test of a multiple regression model A company that manufactures computer chips wants to use a multiple regression model to study the effect that different variables have on y, the total daily production cost (in thousands of dollars).

  • Multiple regression model

    248635 F test of a multiple regression model F test of a multiple regression model To help schedule staffing and equipment needs, a large hospital uses a multiple regression model to predict its 'bed census' , the number of beds occupied at the end

  • Sales of product influenced by salesperson's characteristics

    Thank you Multiple Regression Model Sales of a product are influenced by the salesperson's level of education and gender, as well as consumer income, ethnicity, and wealth.

  • Model Equation

    You are to provide not only the output of the regression procedure but also the model equation. See the work in regression output sheet of excel file 1.

  • Multiple Regression Model and Prediction of Graduation

    512165 Multiple Regression Model and Prediction of Graduation Use the data in the spreadsheet "HW #3" to answer the following. 1. Develop a multiple regression model for predicting Graduation % as a function of the other variables. 2.

  • Statistic Multiple Regression Model. Explain how to further optimize the model

    44474 Statistic Multiple Regression Model.

  • Multiple regression analysis

    228333 Multiple regression analysis Answer one of your choice: A, B, C, or D A. (a) List two limitations of bivariate regression (in respect to multiple regression.)

View More Related Solutions