2:59 1 Search FamilySedans.xlsx Data Sheet2 Sheet3 Road-Test Predicted Value Car Price ($) Cost/Mi Score Reliability Score Nissan Altima 2.5 S (4-cyl.) 23,970.00 0.59 91 4 1.75 Kia Optima LX (2.4)...



  1. Use regression analysis to develop an estimated regression equation that could be used to predict the value score given the road-test score.

  2. Use regression analysis to develop an estimated regression equation that could be used to predict the value score given the predicted-reliability.

  3. What conclusions can you derive from your analysis?


2:59<br>1 Search<br>FamilySedans.xlsx<br>Data<br>Sheet2<br>Sheet3<br>Road-Test Predicted<br>Value<br>Car<br>Price ($) Cost/Mi<br>Score<br>Reliability<br>Score<br>Nissan Altima 2.5 S (4-cyl.)<br>23,970.00<br>0.59<br>91<br>4<br>1.75<br>Kia Optima LX (2.4)<br>Subaru Legacy 2.5i Premium<br>Ford Fusion Hybrid<br>Honda Accord LX-P (4-cyl.)<br>Mazda6 i Sport (4-cyl.)<br>Hyundai Sonata GLS (2.4)<br>Ford Fusion SE (4-cyl.)<br>Chevrolet Malibu LT (4-cyl.)<br>21,885.00<br>0.58<br>81<br>4<br>1.73<br>23,830.00<br>0.59<br>83<br>4<br>1.73<br>32,360.00<br>0.63<br>84<br>1.70<br>23,730.00<br>0.56<br>80<br>4<br>1.62<br>22,035.00<br>0.58<br>73<br>4<br>1.60<br>21,800.00<br>0.56<br>89<br>3<br>1.58<br>23,625.00<br>0.57<br>76<br>4<br>1.55<br>24,115.00<br>0.57<br>74<br>3<br>1.48<br>Kia Optima SX (2.0T)<br>Ford Fusion SEL (V6)<br>Nissan Altima 3.5 SR (V6)<br>29,050.00<br>0.72<br>84<br>4<br>1.43<br>28,400.00<br>0.67<br>80<br>4<br>1.42<br>30,335.00<br>0.69<br>93<br>4<br>1.42<br>Hyundai Sonata Limited (2.0T) 28,090.00<br>Honda Accord EX-L (V6)<br>Mazda6 s Grand Touring (V6) 30,790.00<br>Ford Fusion SEL (V6, AWD)<br>Subaru Legacy 3.6R Limited<br>Chevrolet Malibu LTZ (V6)<br>Chrysler 200 Limited (V6)<br>Chevrolet Impala LT (3.6)<br>0.66<br>89<br>3<br>1.39<br>28,695.00<br>0.67<br>90<br>3<br>1.36<br>0.74<br>81<br>4<br>1.34<br>30,055.00<br>0.71<br>75<br>4<br>1.32<br>30,094.00<br>0.71<br>88<br>3<br>1.29<br>28,045.00<br>0.67<br>83<br>3<br>1.20<br>27,825.00<br>0.70<br>52<br>1.20<br>28,995.00<br>0.67<br>63<br>3<br>1.05<br>

Extracted text: 2:59 1 Search FamilySedans.xlsx Data Sheet2 Sheet3 Road-Test Predicted Value Car Price ($) Cost/Mi Score Reliability Score Nissan Altima 2.5 S (4-cyl.) 23,970.00 0.59 91 4 1.75 Kia Optima LX (2.4) Subaru Legacy 2.5i Premium Ford Fusion Hybrid Honda Accord LX-P (4-cyl.) Mazda6 i Sport (4-cyl.) Hyundai Sonata GLS (2.4) Ford Fusion SE (4-cyl.) Chevrolet Malibu LT (4-cyl.) 21,885.00 0.58 81 4 1.73 23,830.00 0.59 83 4 1.73 32,360.00 0.63 84 1.70 23,730.00 0.56 80 4 1.62 22,035.00 0.58 73 4 1.60 21,800.00 0.56 89 3 1.58 23,625.00 0.57 76 4 1.55 24,115.00 0.57 74 3 1.48 Kia Optima SX (2.0T) Ford Fusion SEL (V6) Nissan Altima 3.5 SR (V6) 29,050.00 0.72 84 4 1.43 28,400.00 0.67 80 4 1.42 30,335.00 0.69 93 4 1.42 Hyundai Sonata Limited (2.0T) 28,090.00 Honda Accord EX-L (V6) Mazda6 s Grand Touring (V6) 30,790.00 Ford Fusion SEL (V6, AWD) Subaru Legacy 3.6R Limited Chevrolet Malibu LTZ (V6) Chrysler 200 Limited (V6) Chevrolet Impala LT (3.6) 0.66 89 3 1.39 28,695.00 0.67 90 3 1.36 0.74 81 4 1.34 30,055.00 0.71 75 4 1.32 30,094.00 0.71 88 3 1.29 28,045.00 0.67 83 3 1.20 27,825.00 0.70 52 1.20 28,995.00 0.67 63 3 1.05

Jun 10, 2022
SOLUTION.PDF
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?