Question: Create a correlation matrix of the variables into a new sheet named 'Correlation Matrix'. ( 2 marks ) Identify the variable ( s ) that
Create a correlation matrix of the variables into a new sheet named 'Correlation Matrix'. marks
Identify the variables that can be eliminated based on the correlation matrix. The business requirement is to go with variables with the least collinearity. Due to this restriction, consider a correlation of or more for insignificant variables. Highlight the variables to be eliminated in red on the sheet. marks
Create a new sheet named SRSignificant' and paste the columns with the significant data into the sheet. mark
Standardise the values to increase the efficiency of the model. Update the SRSignificant' sheet to show the standardised values along with mean and standard deviation. marks
Create a sheet named 'Regression' to depict the final regression output using the SRSignificant' variables. marks
Based on the regression output, suggest which variables should FreeCell focus more on as compared with the others, based on the coefficients.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
