1. Treating Cost/Mile as the dependent variable, develop an estimated regression equation with FamilySedan and UpscaleSedan as the independent variables. Is this equation a statistically significant predictor of Cost/Mile with two significant independent variables? How do you support your statement? (One-two sentences.)
2. Treating Value Score as the dependent variable, develop an estimated regression equation using Cost/Mile, Road-Test Score, Predicted Reliability, Family-Sedan, and UpscaleSedan as the independent variables. (No explanation necessary, just the equation.)
3. Delete any independent variables that are not significant from the estimated regression equation developed in part 2 using a .05 level of significance. After deleting any independent variables that are not significant, develop a new estimated regression equation. (No explanation necessary, just the equation.)
4. Suppose someone claims that smaller cars provide better values than larger cars. For the data in this case, the Small Sedans represent the smallest type of car and the Upscale Sedans represent the largest type of car. What further analysis should you complete to answer this question? Is this claim supported by your analysis? (One paragraph answer with supporting statistics and/or equations.)
5. 

Bata - Alle Edit Links Get & Transform Data Queries & Connections S50 X ft B J I Value Score 1.99 1.94 1.89 1.82 1.64 1.51 1.32 1.30 1.25 1.24 1.18 0.96 0.91 1.75 1.73 1.73 1.70 1.62 1.60 1.58 1.55 1.48 1 Car Size 2 Toyota Corolla (base, manual) Small Sedan 3 Mazda3 i Touring (manual) Small Sedan 4 Toyota Corolla LE Small Sedan 5 Mazda3 i Touring Small Sedan 6 Hyundai Elantra GLS Small Sedan 7 Nissan Sentra 2.0 SL Small Sedan 8 Kia Forte Sedan EX Small Sedan 9 Ford Focus SE Small Sedan 10 Ford Fiesta SE Small Sedan 11 Volkswagen Jetta SE (2.5) Small Sedan 12 Volkswagen Jetta TDI Small Sedan 13 Chevrolet Cruze LS (1.8) Small Sedan 14 Chevrolet Cruze LT (1.4T) Small Sedan 15 Nissan Altima 2.5 S (4-cyl.) Family Sedan 16 Kia Optima LX (2.4) Family Sedan 17 Subaru Legacy 2.5i Premium Family Sedan 18 Ford Fusion Hybrid Family Sedan 19 Honda Accord LX-P (4-cyl.) Family Sedan 20 Mazda6 i Sport (4-cyl.) Family Sedan 21 Hyundai Sonata GLS (2.4) Family Sedan 22 Ford Fusion SE (4-cyl.) Family Sedan 23 Chevrolet Malibu LT (4-cyl.) Family Sedan 24 Kia Optima SX (2.0T) Family Sedan 25 Ford Fusion SEL (VO) Family Sedan 26 Nissan Altima 3.5 SR (VO) Family Sedan 27 Hyundai Sonata Limited (2.0T) Family Sedan 28 Honda Accord EX-L (V6) Family Sedan 29 Mazda6 s Grand Touring (V6) Family Sedan 30 Ford Fusion SEL (V6, AWD) Family Sedan 31 Subaru Legacy 3.6R Limited Family Sedan 32 Chevrolet Malibu LTZ (V6) Family Sedan 33 Chrysler 200 Limited (V6) Family Sedan 34 Chevrolet Impala LT (3.6) Family Sedan 35 Lexus ES 350 Upscale Sedan 36 Acura TL (base) Upscale Sedan 37 Lexus IS 250 Upscale Sedan 38 Infiniti G25 Journey Upscale Sedan 39 Lexus HS 250h Premium Upscale Sedan 40 Acura TSX (4-cyl.) Upscale Sedan 41 Infiniti G37 Journey Upscale Sedan 42 Toyota Avalon Limited Upscale Sedan 43 Hyundai Genesis 3.8 Upscale Sedan 44 Volvo S60 T5 Upscale Sedan 45 Nissan Maxima 3.5 SV Upscale Sedan 46 Buick Regal CXL (2.4) Upscale Sedan 47 Lincoln MKZ Upscale Sedan 48 BMW 328i Upscale Sedan 49 Audi A4 Premium Quattro Upscale Sedan 50 Ford Taurus Limited Upscale Sedan 51 Buick Regal CXL (turbo) Upscale Sedan 52 Mercedes-Benz C300 Sport Upscale Sedan 53 Volkswagen CC Luxury (2.0T) Upscale Sedan 54 Saab 9-3 2.0T Upscale Sedan 55 Buick LaCrosse CXS (VO) Upscale Sedan C D E F G H Road-Test Predicted Price ($) Cost/Mile FamilySedan UpscaleSedan Score Reliability 16,419 0.44 70 18,895 0.50 74 18,404 0.47 19,745 0.52 18,445 0.53 20,150 0.57 19,040 0.57 20,280 0.52 16,595 0.47 20,300 0.54 25,100 0.50 18,375 0.57 20,530 0.60 23,970 0.59 21,885 0.58 23,830 0.59 32,360 0.63 23,730 0.56 22,035 0.58 21,800 0.56 23,625 0.57 24.115 0.57 29,050 0.72 28,400 0.67 30,335 0.69 28,090 0.66 28,695 0.67 30,790 0.74 30,055 0.71 30,094 0.71 28,045 0.67 27,825 0.70 28,995 0.67 38,615 0.77 36,465 0.75 33,734 0.75 34,225 0.73 38,939 0.75 29,675 0.67 37,225 0.79 35,485 0.73 39,850 0.78 35,100 0.76 33,700 0.78 28,840 0.65 37,160 0.80 39,175 0.79 35,895 0.76 34,980 0.78 32,135 0.71 37,325 0.83 32,680 0.73 31,615 0.70 37,555 0.81 1.43 1.42 1.42 1.39 1.36 1.34 1.32 1.29 1.20 1.20 1.05 1.45 1.41 1.40 1.37 1.36 1.35 1.33 1.27 1.22 1.18 1.17 1.14 1.12 1.10 1.08 1.07 1.06 1.04 1.04 1.00 0.82 56 57 58 > Sheet1 Data Sheet2 Sheet3 + Enter Bata - Alle Edit Links Get & Transform Data Queries & Connections S50 X ft B J I Value Score 1.99 1.94 1.89 1.82 1.64 1.51 1.32 1.30 1.25 1.24 1.18 0.96 0.91 1.75 1.73 1.73 1.70 1.62 1.60 1.58 1.55 1.48 1 Car Size 2 Toyota Corolla (base, manual) Small Sedan 3 Mazda3 i Touring (manual) Small Sedan 4 Toyota Corolla LE Small Sedan 5 Mazda3 i Touring Small Sedan 6 Hyundai Elantra GLS Small Sedan 7 Nissan Sentra 2.0 SL Small Sedan 8 Kia Forte Sedan EX Small Sedan 9 Ford Focus SE Small Sedan 10 Ford Fiesta SE Small Sedan 11 Volkswagen Jetta SE (2.5) Small Sedan 12 Volkswagen Jetta TDI Small Sedan 13 Chevrolet Cruze LS (1.8) Small Sedan 14 Chevrolet Cruze LT (1.4T) Small Sedan 15 Nissan Altima 2.5 S (4-cyl.) Family Sedan 16 Kia Optima LX (2.4) Family Sedan 17 Subaru Legacy 2.5i Premium Family Sedan 18 Ford Fusion Hybrid Family Sedan 19 Honda Accord LX-P (4-cyl.) Family Sedan 20 Mazda6 i Sport (4-cyl.) Family Sedan 21 Hyundai Sonata GLS (2.4) Family Sedan 22 Ford Fusion SE (4-cyl.) Family Sedan 23 Chevrolet Malibu LT (4-cyl.) Family Sedan 24 Kia Optima SX (2.0T) Family Sedan 25 Ford Fusion SEL (VO) Family Sedan 26 Nissan Altima 3.5 SR (VO) Family Sedan 27 Hyundai Sonata Limited (2.0T) Family Sedan 28 Honda Accord EX-L (V6) Family Sedan 29 Mazda6 s Grand Touring (V6) Family Sedan 30 Ford Fusion SEL (V6, AWD) Family Sedan 31 Subaru Legacy 3.6R Limited Family Sedan 32 Chevrolet Malibu LTZ (V6) Family Sedan 33 Chrysler 200 Limited (V6) Family Sedan 34 Chevrolet Impala LT (3.6) Family Sedan 35 Lexus ES 350 Upscale Sedan 36 Acura TL (base) Upscale Sedan 37 Lexus IS 250 Upscale Sedan 38 Infiniti G25 Journey Upscale Sedan 39 Lexus HS 250h Premium Upscale Sedan 40 Acura TSX (4-cyl.) Upscale Sedan 41 Infiniti G37 Journey Upscale Sedan 42 Toyota Avalon Limited Upscale Sedan 43 Hyundai Genesis 3.8 Upscale Sedan 44 Volvo S60 T5 Upscale Sedan 45 Nissan Maxima 3.5 SV Upscale Sedan 46 Buick Regal CXL (2.4) Upscale Sedan 47 Lincoln MKZ Upscale Sedan 48 BMW 328i Upscale Sedan 49 Audi A4 Premium Quattro Upscale Sedan 50 Ford Taurus Limited Upscale Sedan 51 Buick Regal CXL (turbo) Upscale Sedan 52 Mercedes-Benz C300 Sport Upscale Sedan 53 Volkswagen CC Luxury (2.0T) Upscale Sedan 54 Saab 9-3 2.0T Upscale Sedan 55 Buick LaCrosse CXS (VO) Upscale Sedan C D E F G H Road-Test Predicted Price ($) Cost/Mile FamilySedan UpscaleSedan Score Reliability 16,419 0.44 70 18,895 0.50 74 18,404 0.47 19,745 0.52 18,445 0.53 20,150 0.57 19,040 0.57 20,280 0.52 16,595 0.47 20,300 0.54 25,100 0.50 18,375 0.57 20,530 0.60 23,970 0.59 21,885 0.58 23,830 0.59 32,360 0.63 23,730 0.56 22,035 0.58 21,800 0.56 23,625 0.57 24.115 0.57 29,050 0.72 28,400 0.67 30,335 0.69 28,090 0.66 28,695 0.67 30,790 0.74 30,055 0.71 30,094 0.71 28,045 0.67 27,825 0.70 28,995 0.67 38,615 0.77 36,465 0.75 33,734 0.75 34,225 0.73 38,939 0.75 29,675 0.67 37,225 0.79 35,485 0.73 39,850 0.78 35,100 0.76 33,700 0.78 28,840 0.65 37,160 0.80 39,175 0.79 35,895 0.76 34,980 0.78 32,135 0.71 37,325 0.83 32,680 0.73 31,615 0.70 37,555 0.81 1.43 1.42 1.42 1.39 1.36 1.34 1.32 1.29 1.20 1.20 1.05 1.45 1.41 1.40 1.37 1.36 1.35 1.33 1.27 1.22 1.18 1.17 1.14 1.12 1.10 1.08 1.07 1.06 1.04 1.04 1.00 0.82 56 57 58 > Sheet1 Data Sheet2 Sheet3 + Enter