Wednesday April 30, 2014 - HW#10 - Multiple Regression

Last Class for the semester.

Multiple Regression 

How to use Excel for Multiple Regression and what you will need for the exam. This is my video from last year. Sorry that the Homework number is off. It was #9 in the past but it is #10 now.

http://youtu.be/FEFXp0iilsU

HW#10 - 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 but it is for HW #10, this semester.
2. Watch the Windows or MAC videos below
3. See "Understanding Output" video at the end of this post.
4. Take Exam #10 (Thursday May 1, 2014  thru Sunday May 4, 2014 at midnight)

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

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

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

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

Understanding Output (pdf file link)

Older Version of Excel - but explanation good

http://youtu.be/ECXeUj8I6w8