Data analysis

profileshangtou
citympgproject04data_1.xlsx
Home>Information Systems homework help>Data analysis

Car Data

Vehicle Fuel Economy, Size, and Weight (systematic sample of n = 43 vehicles)
Obs Page Vehicle City MPG Length (in) Width (in) Weight (lbs)
1 40 Acura CL 20 192 69 3450
2 45 Accura TSX 23 183 59 3320
3 50 BMW 3-Series 19 176 69 3390
4 55 Buick Century 20 195 73 3350
5 60 Buick Rendezvous 18 187 74 4230
6 65 Cadillac Seville 18 201 75 4050
7 70 Chevrolet Corvette 19 180 74 3255
8 75 Chevrolet Silverado 1500 14 228 79 4935
9 80 Chevrolet TrailBlazer 15 192 75 4660
10 85 Chrysler Pacifica 17 199 79 4660
11 90 Dodge Caravan 18 201 79 4210
12 95 Dodge Ram 1500 13 228 80 5300
13 100 Ford Expedition 13 206 79 5900
14 105 Ford Focus 26 168 67 2760
15 110 GMC Envoy 15 192 75 4660
16 115 Honda Accord 21 190 72 3390
17 120 Honda Odyssey 18 201 76 4315
18 125 Hyundai Elantra 24 177 68 2880
19 130 Infiniti FX 16 189 77 4295
20 135 Isuzu Ascender 15 208 76 4965
21 140 Jaguar XJ8 18 200 83 3805
22 145 Kia Rio 25 166 66 2295
23 150 Land Rover Freelander 17 175 71 3640
24 155 Lexus IS300 18 177 68 3390
25 160 Lincoln Aviator 13 193 76 5000
26 165 Mazda MPV 18 187 72 3925
27 170 Mazda6 19 187 70 3355
28 175 Mercedes-Benz S-Class 17 203 73 4195
29 180 Mercury Sable 20 200 73 3340
30 185 Mitsubishi Galant 20 188 69 3285
31 190 Nissan 350Z 20 170 72 3345
32 195 Nissan Pathfinder 15 183 72 4270
33 200 Nissan Xterra 16 178 70 4315
34 205 Pontiac Grand Am 25 186 70 3095
35 210 Pontiac Vibe 28 172 70 2805
36 215 Saturn Ion 24 185 67 2855
37 220 Suburu Baja 21 193 70 3575
38 225 Suzuki Vitara /XL-7 17 184 70 3590
39 230 Toyota Celica 23 170 68 2570
40 235 Toyota Matrix 26 171 70 2985
41 240 Toyota Sienna 19 200 77 4120
42 245 Volkswagen Jetta 34 172 68 3045
43 250 Volvo C70 20 186 72 3690

Source Consumer Reports New Car Buying Guide 2003-2004 (Consumers Union, 2003). Sampling methodology was to select the vehicle on every 5th page starting at page 40. Data are intended for purposes of statistical education and should not be viewed as a guide to vehicle performance.

Extra Sheet