The Honda Accord was named the best midered car for resale value for 2015 by the Kelley e Book (Keley Blue Book website). The me Autolesale contains mage, age, and selling price for a sample of 33 Honda Accords Click on the datate logo to reference the data DATA file - Develop an estimated regression equation that predicts the seting price of a ved Honda Accord given the mileage and age of the car (to 2 decimals) Enter negative value as negative cumber. Selling price 20385.2504 -0.03799 Mileage + +686.33668 Age ble multicolinearity an issue for this model? Find the correlation between the Independent variables to answer this question to 2 decimal) The correlation between age and mileage is 1. Since the correlation between the independent variables is less than 0.70, we condude that multicolinearty is an 11. Since the correlation between the independent variables is less than 0.70, we conclude that multicolinearity is not an issue II. Since the correlation between the independent variables is greater than 0.70, we conduite that multicolinearity as an 1. Since the correlation between the independent variables is greater than 0.70, we conclude that multicolinearity is not an issue 11 c. Une the Pist to determine the overal on cance of the relation (12 decimal). What is your conclusionet e 0.05 level of significance? Use Plable Significance P-value at 0.05 Overall Model than 01 significan d. Use the test to determine the rificance of each independent able to deus) What is your conclusion of the 0.05 level of significance! Use table. Enter negative e as negativen Significance value between 0 and 0.10 significant va value Mirage B c 1 Age 3 2 3 mm 4 4 5 7 6 7 4 1 8 5 9 u o 9 8 6 1 4 10 11 12 13 14 15 16 8 11 DN 17 Price 16998 17599 15998 15998 11599 13998 14998 11599 12599 14998 15998 11599 10499 14599 10599 16998 20998 11599 12599 13599 11599 9599 18998 12599 12599 10998 11998 12998 17599 9998 9998 16998 17599 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 4 18 Novun 00 19 0 5 wN 10 un 6 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 2 10 O 6 6 2 mm 11 11 2 NN M 2 The Honda Accord was named the best midered car for resale value for 2015 by the Kelley e Book (Keley Blue Book website). The me Autolesale contains mage, age, and selling price for a sample of 33 Honda Accords Click on the datate logo to reference the data DATA file - Develop an estimated regression equation that predicts the seting price of a ved Honda Accord given the mileage and age of the car (to 2 decimals) Enter negative value as negative cumber. Selling price 20385.2504 -0.03799 Mileage + +686.33668 Age ble multicolinearity an issue for this model? Find the correlation between the Independent variables to answer this question to 2 decimal) The correlation between age and mileage is 1. Since the correlation between the independent variables is less than 0.70, we condude that multicolinearty is an 11. Since the correlation between the independent variables is less than 0.70, we conclude that multicolinearity is not an issue II. Since the correlation between the independent variables is greater than 0.70, we conduite that multicolinearity as an 1. Since the correlation between the independent variables is greater than 0.70, we conclude that multicolinearity is not an issue 11 c. Une the Pist to determine the overal on cance of the relation (12 decimal). What is your conclusionet e 0.05 level of significance? Use Plable Significance P-value at 0.05 Overall Model than 01 significan d. Use the test to determine the rificance of each independent able to deus) What is your conclusion of the 0.05 level of significance! Use table. Enter negative e as negativen Significance value between 0 and 0.10 significant va value Mirage B c 1 Age 3 2 3 mm 4 4 5 7 6 7 4 1 8 5 9 u o 9 8 6 1 4 10 11 12 13 14 15 16 8 11 DN 17 Price 16998 17599 15998 15998 11599 13998 14998 11599 12599 14998 15998 11599 10499 14599 10599 16998 20998 11599 12599 13599 11599 9599 18998 12599 12599 10998 11998 12998 17599 9998 9998 16998 17599 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 4 18 Novun 00 19 0 5 wN 10 un 6 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 2 10 O 6 6 2 mm 11 11 2 NN M 2
