Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

manufact model sales resale type price engine_s horsepow wheelbas width length curb_wgt fuel_cap mpg lnsales Acura Integra 16.919 16.360 0 21.500 1.8 140 101.2 67.3

manufact model sales resale type price engine_s horsepow wheelbas width length curb_wgt fuel_cap mpg lnsales
Acura Integra 16.919 16.360 0 21.500 1.8 140 101.2 67.3 172.4 2.639 13.2 28 2.83
Acura TL 39.384 19.875 0 28.400 3.2 225 108.1 70.3 192.9 3.517 17.2 25 3.67
Acura CL 14.114 18.225 0 #NULL! 3.2 225 106.9 70.6 192.0 3.470 17.2 26 2.65
Acura RL 8.588 29.725 0 42.000 3.5 210 114.6 71.4 196.6 3.850 18.0 22 2.15
Audi A4 20.397 22.255 0 23.990 1.8 150 102.6 68.2 178.0 2.998 16.4 27 3.02
Audi A6 18.780 23.555 0 33.950 2.8 200 108.7 76.1 192.0 3.561 18.5 22 2.93
Audi A8 1.380 39.000 0 62.000 4.2 310 113.0 74.0 198.2 3.902 23.7 21 0.32
BMW 323i 19.747 #NULL! 0 26.990 2.5 170 107.3 68.4 176.0 3.179 16.6 26 2.98
BMW 328i 9.231 28.675 0 33.400 2.8 193 107.3 68.5 176.0 3.197 16.6 24 2.22
BMW 528i 17.527 36.125 0 38.900 2.8 193 111.4 70.9 188.0 3.472 18.5 25 2.86
Buick Century 91.561 12.475 0 21.975 3.1 175 109.0 72.7 194.6 3.368 17.5 25 4.52
Buick Regal 39.350 13.740 0 25.300 3.8 240 109.0 72.7 196.2 3.543 17.5 23 3.67
Buick Park Avenue 27.851 20.190 0 31.965 3.8 205 113.8 74.7 206.8 3.778 18.5 24 3.33
Buick LeSabre 83.257 13.360 0 27.885 3.8 205 112.2 73.5 200.0 3.591 17.5 25 4.42
Cadillac DeVille 63.729 22.525 0 39.895 4.6 275 115.3 74.5 207.2 3.978 18.5 22 4.15
Cadillac Seville 15.943 27.100 0 44.475 4.6 275 112.2 75.0 201.0 #NULL! 18.5 22 2.77
Cadillac Eldorado 6.536 25.725 0 39.665 4.6 275 108.0 75.5 200.6 3.843 19.0 22 1.88
Cadillac Catera 11.185 18.225 0 31.010 3.0 200 107.4 70.3 194.8 3.770 18.0 22 2.41
Cadillac Escalade 14.785 #NULL! 1 46.225 5.7 255 117.5 77.0 201.2 5.572 30.0 15 2.69
Chevrolet Cavalier 145.519 9.250 0 13.260 2.2 115 104.1 67.9 180.9 2.676 14.3 27 4.98
Chevrolet Malibu 135.126 11.225 0 16.535 3.1 170 107.0 69.4 190.4 3.051 15.0 25 4.91
Chevrolet Lumina 24.629 10.310 0 18.890 3.1 175 107.5 72.5 200.9 3.330 16.6 25 3.20
Chevrolet Monte Carlo 42.593 11.525 0 19.390 3.4 180 110.5 72.7 197.9 3.340 17.0 27 3.75
Chevrolet Camaro 26.402 13.025 0 24.340 3.8 200 101.1 74.1 193.2 3.500 16.8 25 3.27
Chevrolet Corvette 17.947 36.225 0 45.705 5.7 345 104.5 73.6 179.7 3.210 19.1 22 2.89
Chevrolet Prizm 32.299 9.125 0 13.960 1.8 120 97.1 66.7 174.3 2.398 13.2 33 3.48
Chevrolet Metro 21.855 5.160 0 9.235 1.0 55 93.1 62.6 149.4 1.895 10.3 45 3.08
Chevrolet Impala 107.995 #NULL! 0 18.890 3.4 180 110.5 73.0 200.0 3.389 17.0 27 4.68
Chrysler Sebring Coupe 7.854 12.360 0 19.840 2.5 163 103.7 69.7 190.9 2.967 15.9 24 2.06
Chrysler Sebring Conv. 32.775 14.180 0 24.495 2.5 168 106.0 69.2 193.0 3.332 16.0 24 3.49
Chrysler Concorde 31.148 13.725 0 22.245 2.7 200 113.0 74.4 209.1 3.452 17.0 26 3.44
Chrysler Cirrus 32.306 12.640 0 16.480 2.0 132 108.0 71.0 186.0 2.911 16.0 27 3.48
Chrysler LHS 13.462 17.325 0 28.340 3.5 253 113.0 74.4 207.7 3.564 17.0 23 2.60
Chrysler Town & Country 53.480 19.540 1 #NULL! #NULL! #NULL! #NULL! #NULL! #NULL! #NULL! #NULL! #NULL! 3.98
Chrysler 300M 30.696 #NULL! 0 29.185 3.5 253 113.0 74.4 197.8 3.567 17.0 23 3.42
Dodge Neon 76.034 7.750 0 12.640 2.0 132 105.0 74.4 174.4 2.567 12.5 29 4.33
Dodge Avenger 4.734 12.545 0 19.045 2.5 163 103.7 69.1 190.2 2.879 15.9 24 1.55
Dodge Stratus 71.186 10.185 0 20.230 2.5 168 108.0 71.0 186.0 3.058 16.0 24 4.27
Dodge Intrepid 88.028 12.275 0 22.505 2.7 202 113.0 74.7 203.7 3.489 17.0 #NULL! 4.48
Dodge Viper 0.916 58.470 0 69.725 8.0 450 96.2 75.7 176.7 3.375 19.0 16 -0.09
Dodge Ram Pickup 227.061 15.060 1 19.460 5.2 230 138.7 79.3 224.2 4.470 26.0 17 5.43
Dodge Ram Wagon 16.767 15.510 1 21.315 3.9 175 109.6 78.8 192.6 4.245 32.0 15 2.82
Dodge Ram Van 31.038 13.425 1 18.575 3.9 175 127.2 78.8 208.5 4.298 32.0 16 3.44
Dodge Dakota 111.313 11.260 1 16.980 2.5 120 131.0 71.5 215.0 3.557 22.0 19 4.71
Dodge Durango 101.323 #NULL! 1 26.310 5.2 230 115.7 71.7 193.5 4.394 25.0 17 4.62
Dodge Caravan 181.749 12.025 1 19.565 2.4 150 113.3 76.8 186.3 3.533 20.0 24 5.20
Ford Escort 70.227 7.425 0 12.070 2.0 110 98.4 67.0 174.7 2.468 12.7 30 4.25
Ford Mustang 113.369 12.760 0 21.560 3.8 190 101.3 73.1 183.2 3.203 15.7 24 4.73
Ford Contour 35.068 8.835 0 17.035 2.5 170 106.5 69.1 184.6 2.769 15.0 25 3.56
Ford Taurus 245.815 10.055 0 17.885 3.0 155 108.5 73.0 197.6 3.368 16.0 24 5.50
Ford Focus 175.670 #NULL! 0 12.315 2.0 107 103.0 66.9 174.8 2.564 13.2 30 5.17
Ford Crown Victoria 63.403 14.210 0 22.195 4.6 200 114.7 78.2 212.0 3.908 19.0 21 4.15
Ford Explorer 276.747 16.640 1 31.930 4.0 210 111.6 70.2 190.7 3.876 21.0 19 5.62
Ford Windstar 155.787 13.175 1 21.410 3.0 150 120.7 76.6 200.9 3.761 26.0 21 5.05
Ford Expedition 125.338 23.575 1 36.135 4.6 240 119.0 78.7 204.6 4.808 26.0 16 4.83
Ford Ranger 220.650 7.850 1 12.050 2.5 119 117.5 69.4 200.7 3.086 20.0 23 5.40
Ford F-Series 540.561 15.075 1 26.935 4.6 220 138.5 79.1 224.5 4.241 25.1 18 6.29
Honda Civic 199.685 9.850 0 12.885 1.6 106 103.2 67.1 175.1 2.339 11.9 32 5.30
Honda Accord 230.902 13.210 0 15.350 2.3 135 106.9 70.3 188.8 2.932 17.1 27 5.44
Honda CR-V 73.203 17.710 1 20.550 2.0 146 103.2 68.9 177.6 3.219 15.3 24 4.29
Honda Passport 12.855 17.525 1 26.600 3.2 205 106.4 70.4 178.2 3.857 21.1 19 2.55
Honda Odyssey 76.029 19.490 1 26.000 3.5 210 118.1 75.6 201.2 4.288 20.0 23 4.33
Hyundai Accent 41.184 5.860 0 9.699 1.5 92 96.1 65.7 166.7 2.240 11.9 31 3.72
Hyundai Elantra 66.692 7.825 0 11.799 2.0 140 100.4 66.9 174.0 2.626 14.5 27 4.20
Hyundai Sonata 29.450 8.910 0 14.999 2.4 148 106.3 71.6 185.4 3.072 17.2 25 3.38
Infiniti I30 23.713 19.690 0 29.465 3.0 227 108.3 70.2 193.7 3.342 18.5 25 3.17
Jaguar S-Type 15.467 #NULL! 0 42.800 3.0 240 114.5 71.6 191.3 3.650 18.4 21 2.74
Jeep Wrangler 55.557 13.475 1 14.460 2.5 120 93.4 66.7 152.0 3.045 19.0 17 4.02
Jeep Cherokee 80.556 13.775 1 21.620 4.0 190 101.4 69.4 167.5 3.194 20.0 20 4.39
Jeep Grand Cherokee 157.040 18.810 1 26.895 4.0 195 105.9 72.3 181.5 3.880 20.5 19 5.06
Lexus ES300 24.072 26.975 0 31.505 3.0 210 105.1 70.5 190.2 3.373 18.5 23 3.18
Lexus GS300 12.698 32.075 0 37.805 3.0 225 110.2 70.9 189.2 3.638 19.8 23 2.54
Lexus GS400 3.334 #NULL! 0 46.305 4.0 300 110.2 70.9 189.2 3.693 19.8 21 1.20
Lexus LS400 6.375 40.375 0 54.005 4.0 290 112.2 72.0 196.7 3.890 22.5 22 1.85
Lexus LX470 9.126 #NULL! 1 60.105 4.7 230 112.2 76.4 192.5 5.401 25.4 15 2.21
Lexus RX300 51.238 #NULL! 1 34.605 3.0 220 103.0 71.5 180.1 3.900 17.2 21 3.94
Lincoln Continental 13.798 20.525 0 39.080 4.6 275 109.0 73.6 208.5 3.868 20.0 22 2.62
Lincoln Town car 48.911 21.725 0 43.330 4.6 215 117.7 78.2 215.3 4.121 19.0 21 3.89
Lincoln Navigator 22.925 #NULL! 1 42.660 5.4 300 119.0 79.9 204.8 5.393 30.0 15 3.13
Mitsubishi Mirage 26.232 8.325 0 13.987 1.8 113 98.4 66.5 173.6 2.250 13.2 30 3.27
Mitsubishi Eclipse 42.541 10.395 0 19.047 2.4 154 100.8 68.9 175.4 2.910 15.9 24 3.75
Mitsubishi Galant 55.616 10.595 0 17.357 2.4 145 103.7 68.5 187.8 2.945 16.3 25 4.02
Mitsubishi Diamante 5.711 16.575 0 24.997 3.5 210 107.1 70.3 194.1 3.443 19.0 22 1.74
Mitsubishi 3000GT 0.110 20.940 0 25.450 3.0 161 97.2 72.4 180.3 3.131 19.8 21 -2.21
Mitsubishi Montero 11.337 19.125 1 31.807 3.5 200 107.3 69.9 186.6 4.520 24.3 18 2.43
Mitsubishi Montero Sport 39.348 13.880 1 22.527 3.0 173 107.3 66.7 178.3 3.510 19.5 20 3.67
Mercury Mystique 14.351 8.800 0 16.240 2.0 125 106.5 69.1 184.8 2.769 15.0 28 2.66
Mercury Cougar 26.529 13.890 0 16.540 2.0 125 106.4 69.6 185.0 2.892 16.0 30 3.28
Mercury Sable 67.956 11.030 0 19.035 3.0 153 108.5 73.0 199.7 3.379 16.0 24 4.22
Mercury Grand Marquis 81.174 14.875 0 22.605 4.6 200 114.7 78.2 212.0 3.958 19.0 21 4.40
Mercury Mountaineer 27.609 20.430 1 27.560 4.0 210 111.6 70.2 190.1 3.876 21.0 18 3.32
Mercury Villager 20.380 14.795 1 22.510 3.3 170 112.2 74.9 194.7 3.944 20.0 21 3.01
Mercedes-Benz C-Class 18.392 26.050 0 31.750 2.3 185 105.9 67.7 177.4 3.250 16.4 26 2.91
Mercedes-Benz E-Class 27.602 41.450 0 49.900 3.2 221 111.5 70.8 189.4 3.823 21.1 25 3.32
Mercedes-Benz S-Class 16.774 50.375 0 69.700 4.3 275 121.5 73.1 203.1 4.133 23.2 21 2.82
Mercedes-Benz SL-Class 3.311 58.600 0 82.600 5.0 302 99.0 71.3 177.1 4.125 21.1 20 1.20
Mercedes-Benz SLK 7.998 #NULL! 0 38.900 2.3 190 94.5 67.5 157.9 3.055 15.9 26 2.08
Mercedes-Benz SLK230 1.526 #NULL! 0 41.000 2.3 185 94.5 67.5 157.3 2.975 14.0 27 0.42
Mercedes-Benz CLK Coupe 11.592 #NULL! 0 41.600 3.2 215 105.9 67.8 180.3 3.213 16.4 26 2.45
Mercedes-Benz CL500 0.954 #NULL! 0 85.500 5.0 302 113.6 73.1 196.6 4.115 23.2 20 -0.05
Mercedes-Benz M-Class 28.976 #NULL! 1 35.300 3.2 215 111.0 72.2 180.6 4.387 19.0 20 3.37
Nissan Sentra 42.643 8.450 0 13.499 1.8 126 99.8 67.3 177.5 2.593 13.2 30 3.75
Nissan Altima 88.094 11.295 0 20.390 2.4 155 103.1 69.1 183.5 3.012 15.9 25 4.48
Nissan Maxima 79.853 15.125 0 26.249 3.0 222 108.3 70.3 190.5 3.294 18.5 25 4.38
Nissan Quest 27.308 15.380 1 26.399 3.3 170 112.2 74.9 194.8 3.991 20.0 21 3.31
Nissan Pathfinder 42.574 17.810 1 29.299 3.3 170 106.3 71.7 182.6 3.947 21.0 19 3.75
Nissan Xterra 54.158 #NULL! 1 22.799 3.3 170 104.3 70.4 178.0 3.821 19.4 18 3.99
Nissan Frontier 65.005 #NULL! 1 17.890 3.3 170 116.1 66.5 196.1 3.217 19.4 18 4.17
Oldsmobile Cutlass 1.112 11.240 0 18.145 3.1 150 107.0 69.4 192.0 3.102 15.2 25 0.11
Oldsmobile Intrigue 38.554 #NULL! 0 24.150 3.5 215 109.0 73.6 195.9 3.455 18.0 #NULL! 3.65
Oldsmobile Alero 80.255 #NULL! 0 18.270 2.4 150 107.0 70.1 186.7 2.958 15.0 27 4.39
Oldsmobile Aurora 14.690 19.890 0 36.229 4.0 250 113.8 74.4 205.4 3.967 18.5 22 2.69
Oldsmobile Bravada 20.017 19.925 1 31.598 4.3 190 107.0 67.8 181.2 4.068 17.5 19 3.00
Oldsmobile Silhouette 24.361 15.240 1 25.345 3.4 185 120.0 72.2 201.4 3.948 25.0 22 3.19
Plymouth Neon 32.734 7.750 0 12.640 2.0 132 105.0 74.4 174.4 2.559 12.5 29 3.49
Plymouth Breeze 5.240 9.800 0 16.080 2.0 132 108.0 71.0 186.3 2.942 16.0 27 1.66
Plymouth Voyager 24.155 12.025 1 18.850 2.4 150 113.3 76.8 186.3 3.528 20.0 24 3.18
Plymouth Prowler 1.872 #NULL! 0 43.000 3.5 253 113.3 76.3 165.4 2.850 12.0 21 0.63
Pontiac Sunfire 51.645 13.790 0 21.610 2.4 150 104.1 68.4 181.9 2.906 15.0 27 3.94
Pontiac Grand Am 131.097 10.290 0 19.720 3.4 175 107.0 70.4 186.3 3.091 15.2 25 4.88
Pontiac Firebird 19.911 17.805 0 25.310 3.8 200 101.1 74.5 193.4 3.492 16.8 25 2.99
Pontiac Grand Prix 92.364 14.010 0 21.665 3.8 195 110.5 72.7 196.5 3.396 18.0 25 4.53
Pontiac Bonneville 35.945 13.225 0 23.755 3.8 205 112.2 72.6 202.5 3.590 17.5 24 3.58
Pontiac Montana 39.572 #NULL! 1 25.635 3.4 185 120.0 72.7 201.3 3.942 25.0 23 3.68
Porsche Boxter 8.982 41.250 0 41.430 2.7 217 95.2 70.1 171.0 2.778 17.0 22 2.20
Porsche Carrera Coupe 1.280 60.625 0 71.020 3.4 300 92.6 69.5 174.5 3.032 17.0 21 0.25
Porsche Carrera Cabriolet 1.866 67.550 0 74.970 3.4 300 92.6 69.5 174.5 3.075 17.0 23 0.62
Saab 9-5 9.191 #NULL! 0 33.120 2.3 170 106.4 70.6 189.2 3.280 18.5 23 2.22
Saab 9-3 12.115 #NULL! 0 26.100 2.0 185 102.6 67.4 182.2 2.990 16.9 23 2.49
Saturn SL 80.620 9.200 0 10.685 1.9 100 102.4 66.4 176.9 2.332 12.1 33 4.39
Saturn SC 24.546 10.590 0 12.535 1.9 100 102.4 66.4 180.0 2.367 12.1 33 3.20
Saturn SW 5.223 10.790 0 14.290 1.9 124 102.4 66.4 176.9 2.452 12.1 31 1.65
Saturn LW 8.472 #NULL! 0 18.835 2.2 137 106.5 69.0 190.4 3.075 13.1 27 2.14
Saturn LS 49.989 #NULL! 0 15.010 2.2 137 106.5 69.0 190.4 2.910 13.1 28 3.91
Subaru Outback 47.107 #NULL! 0 22.695 2.5 165 103.5 67.5 185.8 3.415 16.9 25 3.85
Subaru Forester 33.028 #NULL! 1 20.095 2.5 165 99.4 68.3 175.2 3.125 15.9 24 3.50
Toyota Corolla 142.535 10.025 0 13.108 1.8 120 97.0 66.7 174.0 2.420 13.2 33 4.96
Toyota Camry 247.994 13.245 0 17.518 2.2 133 105.2 70.1 188.5 2.998 18.5 27 5.51
Toyota Avalon 63.849 18.140 0 25.545 3.0 210 107.1 71.7 191.9 3.417 18.5 26 4.16
Toyota Celica 33.269 15.445 0 16.875 1.8 140 102.4 68.3 170.5 2.425 14.5 31 3.50
Toyota Tacoma 84.087 9.575 1 11.528 2.4 142 103.3 66.5 178.7 2.580 15.1 23 4.43
Toyota Sienna 65.119 #NULL! 1 22.368 3.0 194 114.2 73.4 193.5 3.759 20.9 22 4.18
Toyota RAV4 25.106 13.325 1 16.888 2.0 127 94.9 66.7 163.8 2.668 15.3 27 3.22
Toyota 4Runner 68.411 19.425 1 22.288 2.7 150 105.3 66.5 183.3 3.440 18.5 23 4.23
Toyota Land Cruiser 9.835 34.080 1 51.728 4.7 230 112.2 76.4 192.5 5.115 25.4 15 2.29
Volkswagen Golf 9.761 11.425 0 14.900 2.0 115 98.9 68.3 163.3 2.767 14.5 26 2.28
Volkswagen Jetta 83.721 13.240 0 16.700 2.0 115 98.9 68.3 172.3 2.853 14.5 26 4.43
Volkswagen Passat 51.102 16.725 0 21.200 1.8 150 106.4 68.5 184.1 3.043 16.4 27 3.93
Volkswagen Cabrio 9.569 16.575 0 19.990 2.0 115 97.4 66.7 160.4 3.079 13.7 26 2.26
Volkswagen GTI 5.596 13.760 0 17.500 2.0 115 98.9 68.3 163.3 2.762 14.6 26 1.72
Volkswagen Beetle 49.463 #NULL! 0 15.900 2.0 115 98.9 67.9 161.1 2.769 14.5 26 3.90
Volvo S40 16.957 #NULL! 0 23.400 1.9 160 100.5 67.6 176.6 2.998 15.8 25 2.83
Volvo V40 3.545 #NULL! 0 24.400 1.9 160 100.5 67.6 176.6 3.042 15.8 25 1.27
Volvo S70 15.245 #NULL! 0 27.500 2.4 168 104.9 69.3 185.9 3.208 17.9 25 2.72
Volvo V70 17.531 #NULL! 0 28.800 2.4 168 104.9 69.3 186.2 3.259 17.9 25 2.86
Volvo C70 3.493 #NULL! 0 45.500 2.3 236 104.9 71.5 185.7 3.601 18.5 23 1.25
Volvo S80 18.969 #NULL! 0 36.000 2.9 201 109.9 72.1 189.8 3.600 21.1 24 2.94

Dataset, carsales:

An automotive industry group keeps track of the sales for a variety of personal motor vehicles. In an effort to identify over-and underperforming models, you want to establish a relationship between vehicle sales and vehicle characteristics, that is, you would like to predict which characteristics are most important for driving sales of vehicles. For example you are trying to ascertain if Fuel efficiency, price, engine size are significant contributors for sales of vehicles. Dataset coding: manufact: Manufacturer model= Model sales= Sales in thousands resale= 4-year resale value type= Vehicle type. 0 = automobile, 1= truck price= Price in thousands engine_s= Engine size horsepow= Horsepower wheelbas= Wheel base width= Width length= Length curb_wgt= Curb weight fuel_cap= Fuel capacity mpg= Fuel efficiency Insales= Log-transformed sales

Question: Using SPSS software and the appropriate statistical test, predict which characteristics are most important for influencing sales of vehicles

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Calculus With Applications

Authors: Margaret L Lial, Raymond N Greenwell, Nathan P Ritchey

10th Edition

0321831101, 9780321831101

More Books

Students also viewed these Mathematics questions

Question

Do Problem 8.6 using refrigerant R-134a instead of R-22.

Answered: 1 week ago

Question

What is job rotation ?

Answered: 1 week ago

Question

The number of new ideas that emerge

Answered: 1 week ago

Question

Technology

Answered: 1 week ago