Tips for Pam and Sue
Multiple Regression Project
The is the only deliverable in Week Four. It is the case study titled “Locating New Pam and Susan’s Stores,” described at the end of Chapter 12 of your textbook.
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.
Assuming that you are reasonably comfortable with using Excel and its Analysis ToolPak add-in, you should expect to spend approximately 2-3 hours on computer work, and another 3-4 hours on writing the report. It is a good idea not to wait until the last day to do the entire project and write the report. Content of the report consists of your answers to the case questions, plus computer output(s) to support your answers. Please keep the entire report - including computer outputs - under 8 printed pages. Thus, your write up should be concise, and you need to be selective in deciding which computer outputs to include. You can use your discretion in formatting your write up, but use good writing practices and try to make it look professional (more on the report format below).
Project Hints and Guidelines
It is assumed that you have access to
1. Microsoft Excel with Analysis ToolPak (do NOT use stepwise regression for this project even if it runs on your computer).
2. Data file named pamsue.xls in the DataSets.zip folder.
Basic Excel skills you need are the ability to construct histograms and scatterplots, to create dummy variables, copying or moving columns of data in a spreadsheet, and the ability to use the Correlation and Regression facilities under Data Analysis (available when Analysis ToolPak has been added in). Remember that Analysis ToolPak requires contiguous ranges of data for correlation or regression.
1.
The is the only deliverable in Week Four. It is the case study titled “Locating New Pam and Susan’s Stores,” described at the end of Chapter 12 of your textbook.
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.
Assuming that you are reasonably comfortable with using Excel and its Analysis ToolPak add-in, you should expect to spend approximately 2-3 hours on computer work, and another 3-4 hours on writing the report. It is a good idea not to wait until the last day to do the entire project and write the report. Content of the report consists of your answers to the case questions, plus computer output(s) to support your answers. Please keep the entire report - including computer outputs - under 8 printed pages. Thus, your write up should be concise, and you need to be selective in deciding which computer outputs to include. You can use your discretion in formatting your write up, but use good writing practices and try to make it look professional (more on the report format below).
Project Hints and Guidelines
It is assumed that you have access to
1. Microsoft Excel with Analysis ToolPak (do NOT use stepwise regression for this project even if it runs on your computer).
2. Data file named pamsue.xls in the DataSets.zip folder.
Basic Excel skills you need are the ability to construct histograms and scatterplots, to create dummy variables, copying or moving columns of data in a spreadsheet, and the ability to use the Correlation and Regression facilities under Data Analysis (available when Analysis ToolPak has been added in). Remember that Analysis ToolPak requires contiguous ranges of data for correlation or regression.
1.