Classes are over















NEXT CLASS

Semester Over
It was Fun and I hope
you learned something
in this class. Review this blog in 2033
and see if we were right.


Wednesday, April 24, 2013

Wednesday April 24, 2013 Leadnet Pro & HW#9 Multiple Regression

Leadnet Pro

One of the powerful benefits of the internet is finding business leads, nurturing those leads and turning those leads into sales.

There are companies that a businessowner can sign up with that will sell you leads.

Leadnetpro is a cloud-based business-to-business lead generator.





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 (Friday April 26, 2013 @ noon thru Sunday April 28, 2013 at midnight)


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

What I should have discussed in class. Example, please view.

Step 1

Switch to the "Data" tab in the Microsoft Excel ribbon and locate the "Analysis" group. 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.



If you do not see "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 OF THE THREE STEPS ABOVE




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




No comments:

Post a Comment