Monday November 25, 2013,HW#9 Multiple Regression

Remaining Class Schedule

1. Monday November 25, 2013 - Prerecorded Class
2. Wednesday November 27, 2013 - No Class - Holiday
3. Monday December 2, 2013 and Wednesday December 4, 2013 - Traditional Class

Prerecorded Class Video 

http://youtu.be/QCsxll6PpHA

How to use Excel for Multiple Regression and what you will need for the exam.

http://youtu.be/FEFXp0iilsU

HW#9 - Multiple Regression

Multiple Regression is a statistically model used to analyze the relationship between two or more independent variables and one dependent variable. If differs from linear regression in that is takes more than one independent variable into the model.

Assignment

1. Download Excel Spreadsheet (here)
2. Watch videos below
3. Take Exam #9 (Monday November 25, 2013  thru Sunday December 1, 2013 at midnight)

First, for window users, make sure you have the multiple regression option available.

Step 1

Switch to the "Data" tab in the Microsoft Excel ribbon and locate the "Data Analysis" at far right on ribbon. Click on the "Data Analysis" item to bring up the dialog box of the same name.

Step 2

Scroll through the list of Analysis Tools until you locate "Regression". Click on it to select it, and then click on the "OK" button at the right to open its dialog box.

Here is a quick video:

http://youtu.be/DoAckgj-jUk

If you do not see "Data Analysis" under "Data" Tab, then to add that option see steps below:

Step 1

Launch Microsoft Excel and click on the "File" tab in the ribbon. Select "Options" to open the Excel Options dialog box.

Step 2

Click the "Add-Ins" item in the list on the left side of the dialog box. You will see "Analysis ToolPak" in the list of Inactive Application Add-Ins. Set the Manage drop-down menu to "Excel Add-Ins," and click on the "Go" button at the bottom of the dialog box to open the Add-Ins dialog box.

Step 3

Tick the check box in front of "Analysis ToolPak" in the list of available add-ins. Click the "OK" button on the right side of the Add-Ins dialog box to turn on the Analysis ToolPak once you have selected it in the list of options.

Here is a video to help explain those three steps above:

http://youtu.be/IN_VHhHqClI

For Mac users, Excel 2011 go to this link. Excel 2011 does Not have multiple regression. You will need to add some software from the link.

Here is an example for MAC (EXCEL 2011) using additional Software

h
ttp://youtu.be/dpLqJJfse1Y

Click Here on how to download software add-on discussed above

If you have Excel 2007, click here to get short (6 page .pdf file) file on how to set it up.



Understanding Output (pdf file link)

Older Version of Excel - but explanation good

http://youtu.be/ECXeUj8I6w8