Question: 2. (8 points) Construct a correlation matrix for all the variables, including MEDV. The best way to accomplish this task is to use the data

 2. (8 points) Construct a correlation matrix for all the variables,

2. (8 points) Construct a correlation matrix for all the variables, including MEDV. The best way to accomplish this task is to use the data analysis add-in (the same add-in used to run regressions), and select \"Correlation\" from the list of options in the initial window. The result will be a table that gives the correlation of all pairwise combinations of variables, formatted as follows (example provided for 3 variables): x1 _2 x2 CORREL(x2x1) _ x3 CORREL(x3,x1) CORREL(x3,x2) _ Multicollinearity exists if there is high correlation between independent (X) variables. Use a threshold of i0.7 for high correlation between independent (x) variables. Does multicollinearity exist in the dataset? If so, between which variables? (Do not include correlation with MEDV here; we want a high correlation with the y- variable.) Include the correlation table in the Word le with your answers

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!