Next Class

Class Complete

Have a Good Summer

Tuesday, April 22, 2014

Wednesday April 23, 2014 - HW #9 Linear Regression

Define Linear Regression
To describe the linear association between quantitative variables, a statistical procedure called regression often is used to construct a model. Regression is used to assess the contribution of one or more independent variables  to one dependent variable. 

It also can be used to predict the value of one variable based on the values of others. When there is only one independent variable and when the relationship can be expressed as a straight line, the procedure is called simple linear regression. 

If there are more than one independent variable, then its called multiple regression 
(See HW#10).

As a business major, you will see both linear and multiple regression again, possibly many time in future classes. Homework #9 and #10 will provide a simple introduction and more importantly how to use Excel to solve problems. Again you will see this again.

HW #9 Data for Student Exam

HW#8 Steps:

  1. Watch the video(s) below (there are both PC & MAC videos)
  2. Download the excel file for HW#9
  3. Take Exam on classmarker.com (Thursday 9 am until Sunday midnight)


Excel 2010 Windows






Excel 2011 - MAC

2 comments:

  1. The thought of Google Fiber, and achieving 1000Mbps has me excited for the future and what it has in store for us. It is similar to how we used to be content with Dial-up, until we experienced DSL. I am ready for all US Internet Service Providers to step their game up and give their customers what we deserve, compared to trying to squeeze our pockets for a short-term profit.

    ReplyDelete
  2. I remember using the regression equation in high school, so I have proof of its validity in my life. This reassures that I will use it in the future to make financial predictions as I get older.

    ReplyDelete