Question 4. Finding the Best Car Value

(55 points. For this question, please round all calculations to 2 decimal places)

When trying to decide what car to buy, real value is not necessarily determined by how much you spend on the initial purchase. Instead, cars that are reliable and don't cost much to own often represent the best values. But no matter how reliable or inexpensive a car may cost to own; it must also perform well.

To measure value,Consumer Reportsdeveloped a statistic referred to as a value score. A car with a value score of 1.0 is considered to be an "average-value" car. A car with a value score of 2.0 is considered to be twice as good a value as a car with a value score of 1.0; a car with a value score of 0.5 is considered half as good as average; and so on.

The attached Microsoft Excel spreadsheet named "CarValues" contains information on the following:

• Car (Toyota Corolla, Hyundai Elantra, etc.)
• Size (i.e., small sedan, family sedan)
• Price (in thousand US dollars)
• Road-test Score (based on a 100-point scale, with higher scores indicating better performance, comfort, convenience, and fuel economy)
• Predicted Reliability (based on a 5-point scale, with higher scores indicating better reliability)
• Value Score (higher scores indicating better value)

Using these data, answer the following questions:

Use the data:

Car	Size	Price ($1000)	Value Score	Road-Test Score	Predicted Reliability
Lexus HS 250h Premium	Family Sedan	38.939	1.36	83	4
Lincoln MKZ	Family Sedan	37.160	1.12	77	4
Chevrolet Malibu LT (4-cyl.)	Family Sedan	24.115	1.48	74	3
Acura TSX (4-cyl.)	Family Sedan	29.675	1.35	84	3
Nissan Altima 2.5 S (4-cyl.)	Family Sedan	23.970	1.75	91	4
Ford Taurus Limited	Family Sedan	34.980	1.07	73	3
Toyota Corolla Hatchback SE	Small Sedan	21.390	1.95	73	5
Nissan Maxima 3.5 S	Family Sedan	33.040	2.34	79	5
Chevrolet Spark LS	Small Sedan	13.400	1.25	62	2
Hyundai Genesis 3.8	Family Sedan	39.850	1.22	92	3
Audi A4 Premium Quattro	Family Sedan	35.895	1.08	76	3
Lexus ES 350	Family Sedan	38.615	1.45	91	5
Honda Accord LX-P (4-cyl.)	Family Sedan	23.730	1.62	80	4
Ford Fusion Hybrid	Family Sedan	32.360	1.70	84	5
Chrysler 200 Limited (V6)	Family Sedan	27.825	1.20	52	5
Kia Rio LX	Small Sedan	15.850	1.46	67	3
Kia Optima EX	Family Sedan	24.355	1.92	73	4
Chevrolet Cruze LS (1.8)	Small Sedan	18.375	0.96	67	1
Subaru Impreza 2.0i	Small Sedan	20.895	1.96	71	5
Honda Accord Sport	Family Sedan	27.430	2.1	79	4
Ford Fusion SEL (V6)	Family Sedan	28.400	1.42	80	4
BMW 328i	Family Sedan	39.175	1.10	77	3
Honda Civic EX	Small Sedan	22.050	1.98	75	5
Toyota Prius L Eco	Family Sedan	24.395	1.96	75	5
Acura TL (base)	Family Sedan	36.465	1.41	82	5
Hyundai Elantra SEL	Small Sedan	20.995	1.85	71	4
Mazda6 s Grand Touring (V6)	Family Sedan	30.790	1.34	81	4
Ford Fusion SEL (V6, AWD)	Family Sedan	30.055	1.32	75	4
Hyundai Ioniq Blue	Family Sedan	23.155	1.91	73	5
Mitsubishi Lancer ES	Small Sedan	17.795	1.6	68	3
Buick Regal CXL (2.4)	Family Sedan	28.840	1.14	77	2
Chevrolet Malibu LS	Family Sedan	21.680	1.83	72	4
Volkswagen Passat S	Family Sedan	23.845	1.96	75	4
Honda Civic LX	Small Sedan	19.050	1.81	73	4
Subaru Legacy 3.6R Limited	Family Sedan	30.094	1.29	88	3
Mercedes-Benz C300 Sport	Family Sedan	37.325	1.04	77	3
Buick Regal CXL (turbo)	Family Sedan	32.135	1.06	79	2
Honda Accord LX	Family Sedan	23.570	2.1	77	5
Kia Forte Sedan EX	Small Sedan	19.040	1.32	71	3
Ford Fusion Titanium	Family Sedan	34.450	2.17	76	4
Ford Focus SE	Small Sedan	20.280	1.30	68	2
Nissan Sentra 2.0 SL	Small Sedan	20.150	1.51	74	4
Lexus IS 250	Family Sedan	33.734	1.40	84	5
Infiniti G37 Journey	Family Sedan	37.225	1.33	95	4
Honda Insight LX	Family Sedan	23.130	1.89	74	4
Subaru Legacy 2.5i Premium	Family Sedan	23.830	1.73	83	4
Ford Taurus SEL	Family Sedan	26.570	1.85	71	3
Mazda3 i Touring (manual)	Small Sedan	18.895	1.94	74	5
Nissan Sentra SR	Small Sedan	21.650	1.88	72	4
Nissan Altima 2.5 SR	Family Sedan	25.200	1.96	76	4
Subaru Legacy 2.5i	Family Sedan	23.745	1.98	74	5
Infiniti G25 Journey	Family Sedan	34.225	1.37	86	4
Mazda3 i Touring	Small Sedan	19.745	1.82	70	5
Honda Fit LX	Small Sedan	19.910	1.96	72	4
Mazda6 Sport	Family Sedan	24.325	2.08	77	4
Hyundai Sonata Limited	Family Sedan	33.850	2.19	81	5
Toyota Yaris L	Small Sedan	15.650	1.71	65	3
Kia Optima SX	Family Sedan	31.990	2.09	78	4
Volkswagen CC Luxury (2.0T)	Family Sedan	32.680	1.04	82	2
Ford Fusion SE	Family Sedan	22.215	1.87	72	3
Chevrolet Cruze 1LT (1.4T)	Small Sedan	20.530	0.91	69	1
Mazda6 i Sport (4-cyl.)	Family Sedan	22.035	1.60	73	4
Buick LaCrosse CXS (V6)	Family Sedan	37.555	0.82	74	2
Chevrolet Cruze LT	Family Sedan	22.195	1.75	72	3
Toyota Avalon Limited 2.0	Family Sedan	42.700	2.37	82	5
Nissan Maxima Platinum	Family Sedan	42.220	2.32	81	5
Kia Niro LX	Family Sedan	25.710	1.92	74	4
Kia Optima SX (2.0T)	Family Sedan	29.050	1.43	84	4
Saab 9-3 2.0T	Family Sedan	31.615	1.00	69	3
Nissan Altima 2.5 S	Family Sedan	23.180	1.97	75	4
Toyota Avalon Limited	Family Sedan	35.485	1.27	86	3
Volkswagen Jetta TDI	Small Sedan	25.100	1.18	68	2
Chevrolet Malibu Premier	Family Sedan	34.195	2.13	77	5
Kia Optima LX (2.4)	Family Sedan	21.885	1.73	81	4
Hyundai Sonata SE	Family Sedan	22.650	2.05	76	5
Hyundai Accent SE	Small Sedan	16.395	1.53	68	3
Toyota Corolla (base, manual)	Small Sedan	16.419	1.99	70	4
Chevrolet Impala LT Premier	Family Sedan	28.895	2	75	4
Hyundai Sonata GLS (2.4)	Family Sedan	21.800	1.58	89	3
Toyota Avalon XLE	Family Sedan	35.945	2.45	81	5
Honda Accord EX-L (V6)	Family Sedan	28.695	1.36	90	3
Chrysler 200 LX	Family Sedan	20.295	1.62	69	3
Ford Fusion SE (4-cyl.)	Family Sedan	23.625	1.55	76	4
Ford Fiesta SE	Small Sedan	16.595	1.25	61	2
Nissan Maxima 3.5 SV	Family Sedan	33.700	1.17	83	3
Chevrolet Malibu LTZ (V6)	Family Sedan	28.045	1.20	83	3
Subaru Legacy Limited	Family Sedan	31.545	2.03	76	5
Nissan Altima 3.5 SR (V6)	Family Sedan	30.335	1.42	93	4
Chevrolet Impala Premier	Family Sedan	36.720	2.14	77	4
Dodge Dart SXT	Small Sedan	19.890	1.48	68	3
Hyundai Elantra GLS	Small Sedan	18.445	1.64	80	3
Volvo S60 T5	Family Sedan	35.100	1.18	77	4
Chevrolet Impala LT (3.6)	Family Sedan	28.995	1.05	63	3
Toyota Corolla LE	Small Sedan	18.404	1.89	71	4
Volkswagen Jetta SE (2.5)	Small Sedan	20.300	1.24	60	3
Volkswagen Jetta SE	Family Sedan	23.395	1.88	75	4
Toyota Camry XLE	Family Sedan	29.870	2.22	80	5
Toyota Camry LE	Family Sedan	24.970	2.09	78	5
Kia Forte GT-Line	Small Sedan	21.690	1.89	74	5
Hyundai Sonata Limited (2.0T Manual)	Family Sedan	28.090	1.39	89	3