conduct an analysis using the appropriate data analysis tool in Excel HLE Emily Smith decides to buy a fuel-efficient used car. Here are several vehicles she is considering, with the estimated cost to purchase and the age of the vehicle. a. Create a scatter plot of the data. What do you observe? b. Calculate the correlation coefficient. What does it indicate about the relationship between cost and age? c. Complete a regression analysis of the relationship. Report and interpret the coefficient of determination. d. Write the regression equation that predicts cost. e. Is the slope of the regression line significantly different from zero? Why? f. Estimate the cost of a 5-year-old car.