The purpose of this assignment is to apply simple regression techniques to find factors that determine the car values. Open the dataset of FamilySedans (attached) and read the case entitled “Finding...


The purpose of this assignment is to apply simple regression techniques to find factors that determine the car values.



  1. Open the dataset of FamilySedans (attached) and read the case entitled “Finding the Best Car Value” in its entirety at the end of Chapter 14.

  2. Use descriptive statistics to summarize the data and make comments on them.

  3. Use regression analysis to develop an estimated regression equation that could be used to predict the value score given the price of the car.

  4. Use regression analysis to develop an estimated regression equation that could be used to predict the value score given the five-year owner costs.

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

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

  7. What conclusions can you derive from your analysis?


11:29<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>21,885.00 0.58<br>81<br>4<br>1.73<br>Subaru Legacy 2.5i Premium<br>Ford Fusion Hybrid<br>Honda Accord LX-P (4-cyl.)<br>Mazda6 i Sport (4-cyl.)<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>Hyundai Sonata GLS (2.4)<br>Ford Fusion SE (4-cyl.)<br>Chevrolet Malibu LT (4-cyl.)<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>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>Nissan Altima 3.5 SR (V6)<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>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>Mazda6 s Grand Touring (V6) 30,790.00<br>Ford Fusion SEL (V6, AWD)<br>81<br>4<br>1.34<br>30,055.00<br>0.71<br>75<br>4<br>1.32<br>Subaru Legacy 3.6R Limited<br>30,094.00<br>0.71<br>88<br>3<br>1.29<br>Chevrolet Malibu LTZ (V6)<br>Chrysler 200 Limited (V6)<br>Chevrolet Impala LT (3.6)<br>28,045.00<br>0.67<br>83<br>3<br>1.20<br>27,825.00<br>0.70<br>52<br>5<br>1.20<br>28,995.00<br>0.67<br>63<br>3<br>1.05<br>

Extracted text: 11:29 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) 21,885.00 0.58 81 4 1.73 Subaru Legacy 2.5i Premium Ford Fusion Hybrid Honda Accord LX-P (4-cyl.) Mazda6 i Sport (4-cyl.) 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 Hyundai Sonata GLS (2.4) Ford Fusion SE (4-cyl.) Chevrolet Malibu LT (4-cyl.) 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) 29,050.00 0.72 84 4 1.43 28,400.00 0.67 80 4 1.42 Nissan Altima 3.5 SR (V6) 30,335.00 0.69 93 4 1.42 Hyundai Sonata Limited (2.0T) 28,090.00 Honda Accord EX-L (V6) 0.66 89 3 1.39 28,695.00 0.67 90 3 1.36 0.74 Mazda6 s Grand Touring (V6) 30,790.00 Ford Fusion SEL (V6, AWD) 81 4 1.34 30,055.00 0.71 75 4 1.32 Subaru Legacy 3.6R Limited 30,094.00 0.71 88 3 1.29 Chevrolet Malibu LTZ (V6) Chrysler 200 Limited (V6) Chevrolet Impala LT (3.6) 28,045.00 0.67 83 3 1.20 27,825.00 0.70 52 5 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?