Case Problem. Finding the Best Car Value When trying to decide what car to buy, real value is not necessarily determined by how much you spend on the initial purchase. Instead, cars that are reliable and dont cost much to own often represent the best values. But no matter how reliable or inexpensive a car may be to own, it must also perform well. To measure value, Consumer Reports developed a statistic referred to as a value score. The value score is based upon five-year owner costs, overall road-test scores, and predicted- reliability ratings. Five-year owner costs are based upon the expenses incurred in the first five years of ownership, including depreciation, fuel, maintenance and repairs, and so on. Using a national average of 12,000 miles per year, an average cost per mile driven is used as the measure of five-year owner costs. Road-test scores are the results of more than 50 tests and evaluations and are based on a 100-point scale, with higher scores indicating better performance, comfort, convenience, and fuel economy. The highest road-test score obtained in the tests conducted by Consumer Reports was a 99 for a Lexus LS 460L. Predicted- reliability ratings (1 = Poor, 2 = Fair, 3 = Good, 4 = Very Good, and 5 = Excellent) are based upon data from Consumer Reports Annual Auto Survey. A car with a value score of 1.0 is considered to be an average-value car. A car with a value score of 2.0 is considered to be twice as good a value as a car with a value score of 1.0; a car with a value score of 0.5 is considered half as good as average; and so on. The data for three sizes of cars (13 small sedans, 20 family sedans, and 21 upscale sedans), including the price ($) of each car tested, are contained in the file CarValues (Consumer Reports website). Think about the following four questions, and incorporate them into the managerial report. (1) Treating Cost/Mile as the dependent variable, develop an estimated regression with the size of the car as the independent variables. Discuss your findings. (2) Treating Value Score as the dependent variable, develop an estimated regression equation using Cost/Mile, Road-Test Score, Predicted Reliability, size as the independent variables. (3) Delete any independent variables that are not significant from the estimated regression equation developed in part 2 using a .05 level of significance. After deleting any independent variables that are not significant, develop a new estimated regression equation. Evaluating the model from checking the assumption, significant test, (adj) R-sqaure and SE, and explain it) (4) Suppose someone claims that smaller cars provide better values than larger cars. For the data in this case, the Small Sedans represent the smallest type of car and the Upscale Sedans represent the largest type of car. Does your analysis support this claim?