60.1K

Verified Solution

Link Copied!

Car Price ($) Cost/M Road- ile Test Score Predicted Reliability Value Score 1) ) 4 Use the analysis tool pack to run an regression analysis to estimate price for cost/mile, road test score, predicted reliability, and value score Show output results, line fit plot, and residual plot 4 4 5 91 81 83 84 80 73 89 76 4 2) 4 3 0.59 0.58 0.59 0.63 0.56 0.58 0.56 0.57 0.57 0.72 0.67 0.69 0.66 0.67 What are the p-value for each of the model? Cost/Mile p-value Road Test Score p-value Predicted Reliability p-value Value Score p-value 4 3 Nissan Altima 2.5 S (4-cyl.) $23,970 Kia Optima LX (2.4) $21,885 Subaru Legacy 2.5i Premium $23,830 Ford Fusion Hybrid $32,360 Honda Accord LX-P (4-cyl.) $23,730 Mazda6 i Sport (4-cyl.) $22,035 Hyundai Sonata GLS (2.4) $21,800 Ford Fusion SE (4-cyl.) $23,625 Chevrolet Malibu LT (4-cyl.) $24,115 Kia Optima SX (2.0T) $29,050 Ford Fusion SEL (V6) $28,400 Nissan Altima 3.5 SR (16) $30,335 Hyundai Sonata Limited (2.0T) $28,090 Honda Accord EX-L (VO) $28,695 Mazda6 s Grand Touring (16) $30,790 Ford Fusion SEL (V6, AWD) $30,055 Subaru Legacy 3.6R Limited $30,094 Chevrolet Malibu LTZ (16) $28,045 Chrysler 200 Limited (16) $27,825 Chevrolet Impala LT (3.6) $28,995 4 1.75 1.73 1.73 1.70 1.62 1.60 1.58 1.55 1.48 1.43 1.42 1.42 1.39 1.36 1.34 1.32 1.29 1.20 1.20 1.05 4 3) 74 84 80 93 89 90 81 75 88 83 52 63 4 3 3 4 What are the coefficient of determination for each of the models? Cost/Mile Road Test Score Predicted Reliability Value Score 0.74 4 4) 0.71 0.71 0.67 0.70 0.67 3 3 5 3 How many outliers are you seeing by looking at the fit line plot and residual plot? Cost/Mile Road Test Score Predicted Reliability Value Score 5) Rank, 1 to 4, the models best at predicting price? Results should match answers in questions 2 and 3 Cost/Mile Road Test Score Predicted Reliability Value Score Car Price ($) Cost/M Road- ile Test Score Predicted Reliability Value Score 1) ) 4 Use the analysis tool pack to run an regression analysis to estimate price for cost/mile, road test score, predicted reliability, and value score Show output results, line fit plot, and residual plot 4 4 5 91 81 83 84 80 73 89 76 4 2) 4 3 0.59 0.58 0.59 0.63 0.56 0.58 0.56 0.57 0.57 0.72 0.67 0.69 0.66 0.67 What are the p-value for each of the model? Cost/Mile p-value Road Test Score p-value Predicted Reliability p-value Value Score p-value 4 3 Nissan Altima 2.5 S (4-cyl.) $23,970 Kia Optima LX (2.4) $21,885 Subaru Legacy 2.5i Premium $23,830 Ford Fusion Hybrid $32,360 Honda Accord LX-P (4-cyl.) $23,730 Mazda6 i Sport (4-cyl.) $22,035 Hyundai Sonata GLS (2.4) $21,800 Ford Fusion SE (4-cyl.) $23,625 Chevrolet Malibu LT (4-cyl.) $24,115 Kia Optima SX (2.0T) $29,050 Ford Fusion SEL (V6) $28,400 Nissan Altima 3.5 SR (16) $30,335 Hyundai Sonata Limited (2.0T) $28,090 Honda Accord EX-L (VO) $28,695 Mazda6 s Grand Touring (16) $30,790 Ford Fusion SEL (V6, AWD) $30,055 Subaru Legacy 3.6R Limited $30,094 Chevrolet Malibu LTZ (16) $28,045 Chrysler 200 Limited (16) $27,825 Chevrolet Impala LT (3.6) $28,995 4 1.75 1.73 1.73 1.70 1.62 1.60 1.58 1.55 1.48 1.43 1.42 1.42 1.39 1.36 1.34 1.32 1.29 1.20 1.20 1.05 4 3) 74 84 80 93 89 90 81 75 88 83 52 63 4 3 3 4 What are the coefficient of determination for each of the models? Cost/Mile Road Test Score Predicted Reliability Value Score 0.74 4 4) 0.71 0.71 0.67 0.70 0.67 3 3 5 3 How many outliers are you seeing by looking at the fit line plot and residual plot? Cost/Mile Road Test Score Predicted Reliability Value Score 5) Rank, 1 to 4, the models best at predicting price? Results should match answers in questions 2 and 3 Cost/Mile Road Test Score Predicted Reliability Value Score

Answer & Explanation Solved by verified expert

See Answer