Conduct a correlation matrix using the Forbes 500 dataset. Determine which variables have a significant relationship.
Select an independent and dependent variables and run a regression analysis. What can you conclude from the findings?
This solution is comprised of a detailed explanation of the Correlation Matrix and Regression Analysis as per the situation and question provided. This solution mainly discussed the Correlation Matrix and Regression Analysis. A logical answer is given for every situation for better clarity on using the output generated by excel.
This posting provides interpretation of regression output including Rsquare, correlation matrix, multicollinearity, p-value etc
Please see the attached file.View Full Posting Details