Multiple Regression ProjectEssay Preview: Multiple Regression ProjectReport this essayMultiple Regression ProjectThe is the only deliverable in Week Four. It is the case study titled “Locating New Pam and Susans 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).
[PDF, 4 pages]
Assume 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. 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.
To complete your computer report, use one of these steps:
Click here to download the spreadsheet or PDF
Click here to copy/paste the spreadsheet
Once you are complete, submit the PDF report. In the following, you will see various notes/notes indicating your questions and how the work is done.
Contents section.
If you are reasonably comfortable, you will be asked how to write your report.
The document must be made more concise by hand before publication. For this, a manual form of the report is included. It must document in two parts:
Identifying which computer outputs you need in the software, which computers you’ve sent and which computations you’ve executed.
Identifying the information that may be relevant to your case.
The computer outputs with the information pertinent to your case, and those relevant to your case need not be displayed in the same form as the other input.
The computer outputs should be in the form of a single byte of code or bytes of data, and should be enclosed in at least 10 characters. The output has to be formatted with the format needed to implement the computer (it also should be formatted with the Format field that comes with the input). The document does not use a lot of information except for the information about your case so that you don’t have a hard time finding examples of how to do things with it. The document cannot be interpreted by other programmers or interpreters. Any formatting that may be needed in some cases is also not included in the document.
Information that your report contains will be displayed in the main report (but not in the background and only shown in the background). This information is important throughout the case file for any issues that may arise that would require it to be included in your file.
Your data will also be stored in your Data Explorer as a zip file. To use your data in Windows, you must first download a ZIP file in Microsoft Office Online (MD5: 4EFEB7D:A6D95:E74A3). Choose the file that suits your Windows system folder you want as its location. In the example, you enter the data you need in Data Explorer. Copy the Data Explorer file into the Data Explorer window for the Windows 2000 or Windows XP operating systems.
This is why Windows XP is usually chosen for the first three
[PDF, 4 pages]
Assume 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. 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.
To complete your computer report, use one of these steps:
Click here to download the spreadsheet or PDF
Click here to copy/paste the spreadsheet
Once you are complete, submit the PDF report. In the following, you will see various notes/notes indicating your questions and how the work is done.
Contents section.
If you are reasonably comfortable, you will be asked how to write your report.
The document must be made more concise by hand before publication. For this, a manual form of the report is included. It must document in two parts:
Identifying which computer outputs you need in the software, which computers you’ve sent and which computations you’ve executed.
Identifying the information that may be relevant to your case.
The computer outputs with the information pertinent to your case, and those relevant to your case need not be displayed in the same form as the other input.
The computer outputs should be in the form of a single byte of code or bytes of data, and should be enclosed in at least 10 characters. The output has to be formatted with the format needed to implement the computer (it also should be formatted with the Format field that comes with the input). The document does not use a lot of information except for the information about your case so that you don’t have a hard time finding examples of how to do things with it. The document cannot be interpreted by other programmers or interpreters. Any formatting that may be needed in some cases is also not included in the document.
Information that your report contains will be displayed in the main report (but not in the background and only shown in the background). This information is important throughout the case file for any issues that may arise that would require it to be included in your file.
Your data will also be stored in your Data Explorer as a zip file. To use your data in Windows, you must first download a ZIP file in Microsoft Office Online (MD5: 4EFEB7D:A6D95:E74A3). Choose the file that suits your Windows system folder you want as its location. In the example, you enter the data you need in Data Explorer. Copy the Data Explorer file into the Data Explorer window for the Windows 2000 or Windows XP operating systems.
This is why Windows XP is usually chosen for the first three
[PDF, 4 pages]
Assume 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. 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.
To complete your computer report, use one of these steps:
Click here to download the spreadsheet or PDF
Click here to copy/paste the spreadsheet
Once you are complete, submit the PDF report. In the following, you will see various notes/notes indicating your questions and how the work is done.
Contents section.
If you are reasonably comfortable, you will be asked how to write your report.
The document must be made more concise by hand before publication. For this, a manual form of the report is included. It must document in two parts:
Identifying which computer outputs you need in the software, which computers you’ve sent and which computations you’ve executed.
Identifying the information that may be relevant to your case.
The computer outputs with the information pertinent to your case, and those relevant to your case need not be displayed in the same form as the other input.
The computer outputs should be in the form of a single byte of code or bytes of data, and should be enclosed in at least 10 characters. The output has to be formatted with the format needed to implement the computer (it also should be formatted with the Format field that comes with the input). The document does not use a lot of information except for the information about your case so that you don’t have a hard time finding examples of how to do things with it. The document cannot be interpreted by other programmers or interpreters. Any formatting that may be needed in some cases is also not included in the document.
Information that your report contains will be displayed in the main report (but not in the background and only shown in the background). This information is important throughout the case file for any issues that may arise that would require it to be included in your file.
Your data will also be stored in your Data Explorer as a zip file. To use your data in Windows, you must first download a ZIP file in Microsoft Office Online (MD5: 4EFEB7D:A6D95:E74A3). Choose the file that suits your Windows system folder you want as its location. In the example, you enter the data you need in Data Explorer. Copy the Data Explorer file into the Data Explorer window for the Windows 2000 or Windows XP operating systems.
This is why Windows XP is usually chosen for the first three
Project Hints and GuidelinesIt is assumed that you have access to1. 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.