# Multiple Linear Regression Tutorial

### From Socr

m |
|||

Line 5: | Line 5: | ||

'''Data:''' We will be using the [http://wiki.stat.ucla.edu/socr/index.php/SOCR_Data_LA_Neighborhoods_Data#Data_Source LA Neighborhoods Data] for this tutorial. | '''Data:''' We will be using the [http://wiki.stat.ucla.edu/socr/index.php/SOCR_Data_LA_Neighborhoods_Data#Data_Source LA Neighborhoods Data] for this tutorial. | ||

- | '''Goal:''' Our goal is to predict the median income using multiple explanatory variables by using SOCR. In this example, we will predict median income using age, proportion of homeowners, and proportion | + | '''Goal:''' Our goal is to predict the median income using multiple explanatory variables by using SOCR. In this example, we will predict median income using age, proportion of homeowners, and proportion of whites in population. |

''Step 1:'' First, we will import the data into the SOCR Simple Regression Analysis Activity. Head to [http://wiki.stat.ucla.edu/socr/index.php/SOCR_Data_LA_Neighborhoods_Data#Data_Source LA Neighborhoods Data]and find the table with the data. Select all of the data, and press Ctrl+C (Command+C on Macs) to copy it. | ''Step 1:'' First, we will import the data into the SOCR Simple Regression Analysis Activity. Head to [http://wiki.stat.ucla.edu/socr/index.php/SOCR_Data_LA_Neighborhoods_Data#Data_Source LA Neighborhoods Data]and find the table with the data. Select all of the data, and press Ctrl+C (Command+C on Macs) to copy it. |

## Revision as of 06:11, 29 July 2011

## SOCR_EduMaterials_AnalysesActivities - Multiple Linear Regression Tutorial

**Multiple Linear Regression Tutorial Using LA Neighborhoods Data**

**Data:** We will be using the LA Neighborhoods Data for this tutorial.

**Goal:** Our goal is to predict the median income using multiple explanatory variables by using SOCR. In this example, we will predict median income using age, proportion of homeowners, and proportion of whites in population.

*Step 1:* First, we will import the data into the SOCR Simple Regression Analysis Activity. Head to LA Neighborhoods Dataand find the table with the data. Select all of the data, and press Ctrl+C (Command+C on Macs) to copy it.

*Step 2:*Next, head to http://socr.ucla.edu/htmls/SOCR_Analyses.html, and find the Simple Regression Analysis Activity in the drop-down menu.

*Step 3:*Now Click the “PASTE” button under the drop down menu. You should now see the data in the window.

*Step 4:*You should now see the data in the window. Click on the “MAPPING” tab. This is where we define our dependent and independent variables. The dependent variable is the one we want to make a prediction on, and the independent variables are the ones which we will use to make the prediction. In this example, we add “Income” to the dependent variables list and “Age”, “Homes” and “White” to the independent variables list.

*Step 5:*Click “CALCULATE”. You will now be taken to the “RESULTS” tab. Here you can see the regression equation and

*R*

^{2}, among others.

*Step 6:*Click “GRAPH”. Here you will see scatterplots of the Income variable against each of the three chosen explanatory variables, as well as the residual plots and the Normal QQ Plot.

*Step 7:* We want to check that the assumptions of linear regression, and make sure that they are met.

Assumption 1: There is a linear relationship between the independent (age) and dependent variable (income).

- How to check: Make a scatter plot of income and age
- How to fix: Transformations (for example Log(y) vs x), or the relationship is not linear.

**Linear model fits the data moderately well**

Assumption 2: The variance is constant

- How to check: Look at plot of residuals vs. predicted values ( ). Make sure there is not a pattern, such as the residuals getting larger as the predicted values increase.
- How to fix: Logging of variables, fixing underlying independence or linearity causes.

**Slight increase in residuals at the top range of exploratory variables**

Assumption 3: Errors are normally distributed.

- How to check: Normal QQ Plot (Should lie close to straight line)
- How to fix: Take out outliers, if applicable. Non-linear transformation may be needed

**Assumptions met**

**Conclusions**

No major violation of linear regression assumptions, we proceed with our analysis:

We can see from the "Results" tab that the regression equation is:

Income = -21139.729 +1347.656*Age +49806.135*White +53726.649*Homes + E

The “E” is the error term. “Income” is the predicted value, and “Homes”, “Age”, and “White” are the explanatory variables.

This model states that for every 100 percent increase in homeowner proportion, and everything else held constant, the median household income will increase by $53726.65. For every 1 year increase in median age, and everything else held constant, the median household income will increase by $1,347.66. For every 100 percent increase in the proportion of whites in the population, with everything else held constant, the median household income will increase by $49806.14.

Translate this page: