Answer Happy

The Honda Accord was named the best midsized car for resale value for 2018 by the Kelley Blue Book (Kelley Blue Book website). The file AutoResale contains mileage, age, and selling price for a sample of 33 Honda Accords. Click on the datafile logo to reference the data. DATA file a. Develop an estimated regression equation that predicts the selling price of a used Honda Accord given the mileage and age of the car (to 2 decimals). Enter negative value as negative number. Selling price = Mileage + Age b. Is multicollinearity an issue for this model? Find the correlation between the independent variables to answer this question (to 2 decimals). The correlation between age and mileage is I. Since the correlation between the independent variables is less than 0.70, we conclude that multicollinearity is an issue. II. Since the correlation between the independent variables is less than 0.70, we conclude that multicollinearity is not an issue. III. Since the correlation between the independent variables is greater than 0.70, we conclude that multicollinearity is an issue. IV. Since the correlation between the independent variables is greater than 0.70, we conclude that multicollinearity is not an issue. Select your answer - c. Use the F test to determine the overall significance of the relationship (to 2 decimals). What is your conclusion at the 0.05 level of significance? Use F table. Significance F value p-value at a = 0.05 Overall Model Select your answer - Select your answer - d. Use the t test to determine the significance of each independent variable (to 2 decimals). What is your conclusion at the 0.05 level of significance? Use t table. Enter negative value as negative number. Significance at a= 0.05 t value p-value Mileage Select your answer - Select your answer V Age Select your answer - Select your answer - V

Price Age 16998 mm 17599 3 15998 15998 4 11599 7 4 5 13998 14998 11599 12599 14998 9 8 6 4 15998 11599 10499 14599 10599 Mileage 35000 16000 42000 61000 102000 109000 60000 88000 58000 27000 32000 95000 123000 54000 68000 40000 7000 81000 70000 86000 92000 120000 20000 63000 70000 88000 86000 60000 45000 96000 60000 36000 45000 8 8 5 11 4 1 9 16998 20998 11599 12599 13599 11599 9599 a Noua 18998 12599 7 12599 10998 10 6 11998 12998 17599 9998 NO 11 11 9998 16998 17599 2 2