You are to develop a linear regression model to assist Don in his analysis.
1.Op
You are to develop a linear regression model to assist Don in his analysis.
1.Open the MS Excel file WB5.xlsx.
2.Using the Correlation capability, create a matrix showing how the five variables correlate with one another.
3.Create a Word file and write your conclusions from the item above.
4.Create a single linear regression model using the variable with the highest correlation coefficient.
5.Interpret the results, including the weight of each coefficient, and summarize your findings in the Word file.