Monday November 17, 2014 - HW#9 - Multiple Regression

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 analysis more than one independent variable.

Directions:

1. Watch Class Video
2. Download Excel Spreadsheet (here) File name has HW #9.
3. Watch the Windows or MAC videos below
4. See "Understanding Output" video at the end of this post.
5. Take Exam #9 on Classmarker (Tuesday November 18, 2014  thru Sunday November 23, 2014 at midnight)

#1 - Class Video

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) File name has HW #9.
2. Watch the Windows or MAC videos below
3. See "Understanding Output" video at the end of this post.
4. Take Exam #9 (Tuesday November 18, 2014  thru Sunday November 23, 2014 at midnight)

------------------------------------------------------------------------------------------------------------

#3 - WINDOW USERS
make sure you have the multiple regression option available. If under Step #1 below, you do not see "Data Analysis", then skip to Step 1A.

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 1A

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

Step 2A

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 3A

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

--------------------------------------------------------------------------------------------------------
#3 - MAC USERS
Excel 2011 does NOT have multiple regression built in. You will need to add some software from this link. This software is free. The software is called: STATPLUS LE

Here are two videos on how to install Statplus LE

http://youtu.be/uBHo7EVlGW0

http://youtu.be/LRZTvAFfKEU

Here is an example for MAC (EXCEL 2011) using Statplus LE

http://youtu.be/BIlbRHW1DUk

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

------------------------------------------------------------------------------------------------------------

#4 - Understanding Output (pdf file link)

 An Older Version of Excel - but explanation good

http://youtu.be/ECXeUj8I6w8