What are initial trends you notice in the correlation matrix?
What are initial trends you notice in the correlation matrix?
July 21, 2020 Comments Off on What are initial trends you notice in the correlation matrix? Uncategorized Assignment-helpThe first file is a CSV of the data itself. The second is a description and copyright information for the data file. This data file is slightly modified from the original file to better work with this assignment. Records with missing attributes were eliminated for our purposes. Import the CSV file into Excel and follow these instructions and answer these questions.Make sure you add titles and axis labels to the scatter plots as necessary so that it’s easier for me to see what’s what and to ensure I can easily find things to grade accordingly. Thanks.Create a correlation matrix of the all metrics in the cars data (leave out the binary fields). Use conditional formatting to highlight the differences in the correlation coefficients. What are initial trends you notice in the correlation matrix?10ptsWhich metric has the largest negative correlation on City MPG? What is the next metric that has the second largest negative correlation on City MPG?5ptsMake the following scatter plots and include the regression line, R^2, and the equation and describe the relationship (positive, negative, none) for:Suggested Retail and HorsePowerSuggested Retail and WeightWeight and CityMPG15ptsWhat is the forecasted Suggested Retail Price for a car with a horsepower of 335? Of 275?With this dataset are there any issues in forecasting the Suggested Retail Price based on a horsepower of 575+? Explain.10ptsOf the scatter plots you just created, which one has data points that best fit the regression line? How do you know this?


