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'. (2 marks)
Identify the variable(s) 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 0.28 or more for insignificant variables. Highlight the variable(s) to be eliminated in red on the sheet. (3 marks)
Create a new sheet named 'SR_Significant' and paste the columns with the significant data into the sheet. (1 mark)
Standardise the values to increase the efficiency of the model. Update the 'SR_Significant' sheet to show the standardised values along with mean and standard deviation. (2 marks)
Create a sheet named 'Regression' to depict the final regression output using the 'SR_Significant' variables. (1 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 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 General Management Questions!