Chris Smith is a sports car enthusiast with a particular love for Mini Coopers. He downloaded data from eBay on completed auctions of Mini Coopers and used it to create the data set in file Dat9-19.xlsx showing the selling prices, age, mileage, and location of Mini Cooper automobiles. He would like to use this data to build a regression model to predict the estimated selling price of Mini Coopers.

a. Prepare scatter plots showing the relationship between selling price and each of the independent variables. What sort of relationship does each plot suggest?

b. Using only the variables in this data set, what regression model has the highest R2 value, and what is its R2 value?

c. Using only the variables in this data set, what regression model has the highest adjusted R2 value, and what is its adjusted R2 value?

d. Which of the cars in this data set appear to be the best bargains relative to their estimated prices using the model identified in part c?

e. What other variables, if available, might help Chris to build a more accurate regression model for this problem?