spreadsheet

6-AutomobileStudy.xlsx

Home >Computer Science homework help >spreadsheet

Scatter Plot

Scatter Plot of MPG based on Weight (in Lbs) of Vehicle

MPG 4595 4015 4085 3705 3305 4115 4505 5465 3920 3485 3785 3885 4505 4065 5025 3170 5100 3565 4095 4085 5810 4730 4000 3680 2560 2920 3280 3880 3265 3710 5935 5715 4830 4420 4105 4720 3350 3335 4755 3185 3895 5150 4600 3950 4340 3480 4540 3605 6325 4905 3480 3585 4420 2810 3505 3650 2370 4615 4510 2855 4940 2590 3835 2945 4345 3345 3800 4610 3635 3890 3880 3860 3890 5245 3380 4690 3575 4550 3870 3430 2615 3660 4725 4310 2875 3750 5705 3670 3915 4825 3510 4515 4235 3870 4620 3625 6245 4415 2000 4025 4585 2510 3085 2830 3480 3355 4060 3845 5575 4845 4490 4235 3315 4180 3320 2690 3345 4195 3430 3925 3640 3215 5715 3555 4190 4875 4550 3010 2780 4480 3540 3630 2925 3000 3305 3015 3370 3545 3335 5015 3065 3915 2890 3120 3260 3540 3545 4280 2840 3650 2995 4190 4345 3600 3280 3620 2595 4350 4490 2950 3485 4550 2410 3155 3330 3465 3245 3465 3850 3555 4950 17 18 18 23 25 21 17 15 20 24 22 19 18 19 17 26 15 18 19 17 13 16 18 17 27 23 21 18 23 20 14 14 15 18 16 16 20 23 17 22 17 12 16 19 16 15 16 19 13 15 20 20 16 31 21 21 34 19 17 25 14 28 19 27 18 23 18 17 19 19 19 19 19 13 22 14 20 15 18 23 28 21 17 15 28 18 13 23 20 15 24 21 19 21 16 20 13 17 29 18 16 27 18 30 23 23 18 21 15 16 17 17 21 16 23 30 23 17 23 19 20 25 13 21 19 15 18 26 29 17 22 20 23 27 20 22 23 21 20 16 24 17 26 23 22 18 21 16 27 18 22 17 16 22 24 21 29 17 18 44 23 18 34 25 24 24 23 22 20 20 16

PlotData

	Weight (lb)	MPG
	4595	17
	4015	18
	4085	18
	3705	23
	3305	25
	4115	21
	4505	17
	5465	15
	3920	20
	3485	24
	3785	22
	3885	19
	4505	18
	4065	19
	5025	17
	3170	26
	5100	15
	3565	18
	4095	19
	4085	17
	5810	13
	4730	16
	4000	18
	3680	17
	2560	27
	2920	23
	3280	21
	3880	18
	3265	23
	3710	20
	5935	14
	5715	14
	4830	15
	4420	18
	4105	16
	4720	16
	3350	20
	3335	23
	4755	17
	3185	22
	3895	17
	5150	12
	4600	16
	3950	19
	4340	16
	3480	15
	4540	16
	3605	19
	6325	13
	4905	15
	3480	20
	3585	20
	4420	16
	2810	31
	3505	21
	3650	21
	2370	34
	4615	19
	4510	17
	2855	25
	4940	14
	2590	28
	3835	19
	2945	27
	4345	18
	3345	23
	3800	18
	4610	17
	3635	19
	3890	19
	3880	19
	3860	19
	3890	19
	5245	13
	3380	22
	4690	14
	3575	20
	4550	15
	3870	18
	3430	23
	2615	28
	3660	21
	4725	17
	4310	15
	2875	28
	3750	18
	5705	13
	3670	23
	3915	20
	4825	15
	3510	24
	4515	21
	4235	19
	3870	21
	4620	16
	3625	20
	6245	13
	4415	17
	2000	29
	4025	18
	4585	16
	2510	27
	3085	18
	2830	30
	3480	23
	3355	23
	4060	18
	3845	21
	5575	15
	4845	16
	4490	17
	4235	17
	3315	21
	4180	16
	3320	23
	2690	30
	3345	23
	4195	17
	3430	23
	3925	19
	3640	20
	3215	25
	5715	13
	3555	21
	4190	19
	4875	15
	4550	18
	3010	26
	2780	29
	4480	17
	3540	22
	3630	20
	2925	23
	3000	27
	3305	20
	3015	22
	3370	23
	3545	21
	3335	20
	5015	16
	3065	24
	3915	17
	2890	26
	3120	23
	3260	22
	3540	18
	3545	21
	4280	16
	2840	27
	3650	18
	2995	22
	4190	17
	4345	16
	3600	22
	3280	24
	3620	21
	2595	29
	4350	17
	4490	18
	2950	44
	3485	23
	4550	18
	2410	34
	3155	25
	3330	24
	3465	24
	3245	23
	3465	22
	3850	20
	3555	20
	4950	16

SLRData

Weight (lb)	MPG
4595	17
4015	18
4085	18
3705	23
3305	25
4115	21
4505	17
5465	15
3920	20
3485	24
3785	22
3885	19
4505	18
4065	19
5025	17
3170	26
5100	15
3565	18
4095	19
4085	17
5810	13
4730	16
4000	18
3680	17
2560	27
2920	23
3280	21
3880	18
3265	23
3710	20
5935	14
5715	14
4830	15
4420	18
4105	16
4720	16
3350	20
3335	23
4755	17
3185	22
3895	17
5150	12
4600	16
3950	19
4340	16
3480	15
4540	16
3605	19
6325	13
4905	15
3480	20
3585	20
4420	16
2810	31
3505	21
3650	21
2370	34
4615	19
4510	17
2855	25
4940	14
2590	28
3835	19
2945	27
4345	18
3345	23
3800	18
4610	17
3635	19
3890	19
3880	19
3860	19
3890	19
5245	13
3380	22
4690	14
3575	20
4550	15
3870	18
3430	23
2615	28
3660	21
4725	17
4310	15
2875	28
3750	18
5705	13
3670	23
3915	20
4825	15
3510	24
4515	21
4235	19
3870	21
4620	16
3625	20
6245	13
4415	17
2000	29
4025	18
4585	16
2510	27
3085	18
2830	30
3480	23
3355	23
4060	18
3845	21
5575	15
4845	16
4490	17
4235	17
3315	21
4180	16
3320	23
2690	30
3345	23
4195	17
3430	23
3925	19
3640	20
3215	25
5715	13
3555	21
4190	19
4875	15
4550	18
3010	26
2780	29
4480	17
3540	22
3630	20
2925	23
3000	27
3305	20
3015	22
3370	23
3545	21
3335	20
5015	16
3065	24
3915	17
2890	26
3120	23
3260	22
3540	18
3545	21
4280	16
2840	27
3650	18
2995	22
4190	17
4345	16
3600	22
3280	24
3620	21
2595	29
4350	17
4490	18
2950	44
3485	23
4550	18
2410	34
3155	25
3330	24
3465	24
3245	23
3465	22
3850	20
3555	20
4950	16

SLR

Simple Linear Regression Analysis		of MPG by Weight of Vehicle							Calculations
									b1, b0 Coefficients	-0.0049	39.0902
Regression Statistics									b1, b0 Standard Error	0.0002	0.9786
Multiple R	0.8357								R Square, Standard Error	0.6984	2.5757
R Square	0.6984								F, Residual df	391.3038	169.0000
Adjusted R Square	0.6966								Regression SS, Residual SS	2595.9892	1121.1804
Standard Error	2.5757
Observations	171								Confidence level	95%
									t Critical Value	1.9741
ANOVA									Half Width b0	1.9318
	df	SS	MS	F	Significance F				Half Width b1	0.0005
Regression	1	2595.9892	2595.9892	391.3038	0.0000
Residual	169	1121.1804	6.6342
Total	170	3717.1696
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95%	Upper 95%
Intercept	39.0902	0.9786	39.9457	0.0000	37.1584	41.0221	37.1584	41.02207
Weight (lb)	-0.0049	0.0002	-19.7814	0.0000	-0.0054	-0.0044	-0.0054	-0.00439

DataCopy3

Weight (lb)
4595
4015
4085
3705
3305
4115
4505
5465
3920
3485
3785
3885
4505
4065
5025
3170
5100
3565
4095
4085
5810
4730
4000
3680
2560
2920
3280
3880
3265
3710
5935
5715
4830
4420
4105
4720
3350
3335
4755
3185
3895
5150
4600
3950
4340
3480
4540
3605
6325
4905
3480
3585
4420
2810
3505
3650
2370
4615
4510
2855
4940
2590
3835
2945
4345
3345
3800
4610
3635
3890
3880
3860
3890
5245
3380
4690
3575
4550
3870
3430
2615
3660
4725
4310
2875
3750
5705
3670
3915
4825
3510
4515
4235
3870
4620
3625
6245
4415
2000
4025
4585
2510
3085
2830
3480
3355
4060
3845
5575
4845
4490
4235
3315
4180
3320
2690
3345
4195
3430
3925
3640
3215
5715
3555
4190
4875
4550
3010
2780
4480
3540
3630
2925
3000
3305
3015
3370
3545
3335
5015
3065
3915
2890
3120
3260
3540
3545
4280
2840
3650
2995
4190
4345
3600
3280
3620
2595
4350
4490
2950
3485
4550
2410
3155
3330
3465
3245
3465
3850
3555
4950

CompleteStatistics3

Weight
	Weight (lb)
Mean	3886.7251461988
Median	3800
Mode	3480
Minimum	2000
Maximum	6325
Range	4325
Variance	641611.5652
Standard Deviation	801.0066
Coeff. of Variation	20.61%
Skewness	0.5476
Kurtosis	0.3268
Count	171
Standard Error	61.2545

DataCopy2

Asia or Europe	US
17	15
18	18
18	19
23	17
25	13
21	16
17	18
15	17
20	27
24	23
22	21
19	18
18	23
19	20
17	14
26	14
31	15
21	18
21	16
34	16
19	20
17	23
25	17
28	22
19	17
27	12
18	16
23	19
18	16
17	15
19	16
19	19
19	13
19	15
19	20
18	20
23	16
28	14
21	13
17	22
15	14
28	20
18	15
23	13
20	16
15	20
24	13
21	17
19	16
21	23
29	22
18	20
16	23
27	27
18	23
30	21
23	20
23	16
18	24
21	17
15	23
16	22
17	20
17	20
21	16
30
23
17
23
19
20
25
13
21
19
15
18
26
29
17
20
22
26
23
22
18
21
16
27
18
22
17
16
22
24
21
29
17
18
44
23
18
34
25
24
24

CompleteStats 2 Gps

MPG by Origin of Vehicle
	Asia or Europe	US
Mean	21	18
Median	21	18
Mode	18	16
Minimum	13	12
Maximum	44	27
Range	31	15
Variance	23.9842	12.7341
Standard Deviation	4.8974	3.5685
Coeff. of Variation	22.99%	19.59%
Skewness	1.4408	0.3862
Kurtosis	3.6098	-0.4992
Count	106	65
Standard Error	0.4757	0.4426

DataCopy

MPG
17
18
18
23
25
21
17
15
20
24
22
19
18
19
17
26
15
18
19
17
13
16
18
17
27
23
21
18
23
20
14
14
15
18
16
16
20
23
17
22
17
12
16
19
16
15
16
19
13
15
20
20
16
31
21
21
34
19
17
25
14
28
19
27
18
23
18
17
19
19
19
19
19
13
22
14
20
15
18
23
28
21
17
15
28
18
13
23
20
15
24
21
19
21
16
20
13
17
29
18
16
27
18
30
23
23
18
21
15
16
17
17
21
16
23
30
23
17
23
19
20
25
13
21
19
15
18
26
29
17
22
20
23
27
20
22
23
21
20
16
24
17
26
23
22
18
21
16
27
18
22
17
16
22
24
21
29
17
18
44
23
18
34
25
24
24
23
22
20
20
16

CompleteStats

MPG
	MPG
Mean	20
Median	19
Mode	18
Minimum	12
Maximum	44
Range	32
Variance	21.8657
Standard Deviation	4.6761
Coeff. of Variation	23.23%
Skewness	1.3054
Kurtosis	3.5781
Count	171
Standard Error	0.3576

FiveNumbers

MPG
Five-Number Summary
Minimum	12
First Quartile	17
Median	19
Third Quartile	23
Maximum	44

BoxPlot

MPG

12 12 12 0.5 1 1.5 17 17 17 0.5 1 1.5 19 19 19 0.5 1 1.5 23 23 23 0.5 1 1.5 44 44 44 0.5 1 1.5 12 44 1 1 17 23 0.5 0.5 17 23 1.5 1.5

ForBoxPlot

12	0.5
12	1
12	1.5
17	0.5
17	1
17	1.5
19	0.5
19	1
19	1.5
23	0.5
23	1
23	1.5
44	0.5
44	1
44	1.5
12	1
44	1
17	0.5
23	0.5
17	1.5
23	1.5

FiveNumbers 2 Gps

MPG based on Origin of Vehicle
Five-Number Summary
	Asia or Europe	US
Minimum	13	12
First Quartile	18	16
Median	20.5	18
Third Quartile	24	20.5
Maximum	44	27

BoxPlot 2 Gps

MPG based on Origin of Vehicle

Asia or Europe

13 13 13 0.5 1 1.5 18 18 18 0.5 1 1.5 20.5 20.5 20.5 0.5 1 1.5 24 24 24 0.5 1 1.5 44 44 44 0.5 1 1.5 13 44 1 1 18 24 0.5 0.5 18 24 1.5 1.5

12 12 12 2 2.5 3 16 16 16 2 2.5 3 18 18 18 2 2.5 3 20.5 20.5 20.5 2 2.5 3 27 27 27 2 2.5 3 12 27 2.5 2.5 16 20.5 2 2 16 20.5 3 3

ForBoxPlot2

13	0.5	12	2
13	1	12	2.5
13	1.5	12	3
18	0.5	16	2
18	1	16	2.5
18	1.5	16	3
20.5	0.5	18	2
20.5	1	18	2.5
20.5	1.5	18	3
24	0.5	20.5	2
24	1	20.5	2.5
24	1.5	20.5	3
44	0.5	27	2
44	1	27	2.5
44	1.5	27	3
13	1	12	2.5
44	1	27	2.5
18	0.5	16	2
24	0.5	20.5	2
18	1.5	16	3
24	1.5	20.5	3

FiveNumbers3

Weight
Five-Number Summary
Minimum	2000
First Quartile	3335
Median	3800
Third Quartile	4480
Maximum	6325

BoxPlot3

Weight

Weight (lb)

2000 2000 2000 0.5 1 1.5 3335 3335 3335 0.5 1 1.5 3800 3800 3800 0.5 1 1.5 4480 4480 4480 0.5 1 1.5 6325 6325 6325 0.5 1 1.5 2000 6325 1 1 3335 4480 0.5 0.5 3335 4480 1.5 1.5

ForBoxPlot3

2000	0.5
2000	1
2000	1.5
3335	0.5
3335	1
3335	1.5
3800	0.5
3800	1
3800	1.5
4480	0.5
4480	1
4480	1.5
6325	0.5
6325	1
6325	1.5
2000	1
6325	1
3335	0.5
4480	0.5
3335	1.5
4480	1.5

DataCopy4

Origin

Asia or Europe

Bar Chart

Origin of Vehicle

Total Asia or Europe US 106 65

Origin

OneWayTable

Origin of Vehicle
Count of Origin
Origin	Total
Asia or Europe	106
US	65
Grand Total	171

SideBySide

Auto Type by Origin of Vehicle

4 Door Hatchback Asia or Europe US 6 1 4 Door SUV Asia or Europe US 33 27 Coupe Asia or Europe US 17 6 Minivan Asia or Europe US 4 3 Sedan Asia or Europe US 40 25 Wagon Asia or Europe US 6 3

TwoWayTable

Origin and Auto Type
Count of Origin	Type Auto
Origin	4 Door Hatchback	4 Door SUV	Coupe	Minivan	Sedan	Wagon	Grand Total
Asia or Europe	6	33	17	4	40	6	106
US	1	27	6	3	25	3	65
Grand Total	7	60	23	7	65	9	171

Variable INFO

Automobile features taken from a sample of 171 car models
Source
Berenson, Levine, Krehbiel Basic Business Statistics: Concepts and Applications (12 ed.), Pearson
Variables
Make/Model
MPG	Miles Per Gallon
Length
CargoWidth	Cargo storage width in inches
Height
WheelBase	Wheel base distance in inches
Weight
MaxLoad	Maximum car load in pounds
CargoVol	Volume of trunk space in cubic inches	feet
HP	Horsepower
Accto60	Time in seconds to accelerate to 60 miles per hour
Breakfr60	Distance in feet to stop vehicle when applying the breaks at 60 miles per hour
TrngCirc	Distance in feet to turn the vehicle 360 degrees
Origin	US, Asia or Europe
TypeAuto	Type of automobile
Transmission	Type of transmission

DATA

	Automobile comparison studey data
Make/Model	MPG	Length (in)	CargoWidth (in)	Height (in)	WheelBase (in)	Weight (lb)	MaxLoad (lb)	CargoVol(cuft)	HP	Accto60(sec)	Breakfr60(ft)	TrngCirc(ft)	Origin	Type Auto	Transmission
Acura MDX	17	191	79	66	108	4595	1160	36	300	8	139	40	Asia or Europe	4 Door SUV	Auto 5
Acura RDX	18	181	74	65	104	4015	870	30	240	7.4	145	41	Asia or Europe	4 Door SUV	Auto 5
Acura RL	18	194	73	57	110	4085	850	13	300	6.9	148	43	Asia or Europe	Sedan	Auto 5
Acura TL	23	195	74	57	109	3705	850	13	270	6.7	138	42	Asia or Europe	Sedan	Auto 5
Audi A3	25	169	77	56	102	3305	990	20	200	7.3	149	35	Asia or Europe	4 Door Hatchback	Seq 6
Audi A6	21	194	71	57	112	4115	1100	16	255	7.7	144	40	Asia or Europe	Sedan	Auto 6
Audi A8	17	204	75	57	121	4505	1210	18	330	7.6	140	41	Asia or Europe	Sedan	Auto 6
Audi Q7	15	200	78	68	118	5465	1325	37	350	8.2	146	40	Asia or Europe	4 Door SUV	Auto 6
Audi S4	20	181	72	56	104	3920	1145	13	340	5.3	140	38	Asia or Europe	Sedan	Man 6
BMW 3 Series sedan 328i 6-cyl	24	178	72	56	109	3485	1060	11	215	7.4	142	37	Asia or Europe	Wagon	Auto 6
BMW 5 Series	22	191	73	58	114	3785	1100	14	300	5.8	149	39	Asia or Europe	Sedan	Auto 6
BMW 6 Series	19	190	73	54	109	3885	840	13	360	5.6	133	40	Asia or Europe	Coupe	Auto 6
BMW 7 Series	18	204	75	59	123	4505	1060	18	325	6.9	154	42	Asia or Europe	Sedan	Auto 6
BMW X3	19	180	73	66	110	4065	1005	33	260	7.9	140	39	Asia or Europe	4 Door SUV	Auto 6
BMW X5	17	191	76	70	116	5025	1350	36	260	8.6	142	42	Asia or Europe	4 Door SUV	Auto 6
BMW Z4	26	161	70	50	98	3170	550	2	225	6	126	33	Asia or Europe	Coupe	Man 6
Buick Enclave	15	201	78	70	119	5100	1335	44	275	8.9	153	43	US	4 Door SUV	Auto 6
Buick LaCrosse	18	198	73	57	111	3565	915	16	200	9	160	40	US	Sedan	Auto 4
Buick Lucerne	19	203	74	58	116	4095	925	17	197	9.2	175	44	US	Sedan	Auto 4
Cadillac DTS	17	208	75	58	116	4085	1095	19	275	7.6	180	46	US	Sedan	Auto 4
Cadillac Escalade	13	203	79	75	116	5810	1330	47	403	7.5	181	42	US	4 Door SUV	Auto 6
Cadillac SRX	16	195	73	68	116	4730	1285	37	255	8.3	152	42	US	4 Door SUV	Auto 5
Cadillac STS	18	196	73	58	116	4000	890	14	255	7.1	146	40	US	Sedan	Auto 5
Cadillac XLR	17	178	72	50	106	3680	400	4	320	6.4	145	41	US	Coupe	Auto 5
Chevrolet Aveo hatchback 1LT 4-cyl	27	154	66	59	98	2560	860	7	103	11.2	146	35	US	Sedan	Man 5
Chevrolet Cobalt sedan LT 4-cyl	23	180	68	57	103	2920	890	14	145	8.8	152	37	US	Sedan	Auto 4
Chevrolet Corvette convertible Base V8 MT	21	175	73	49	106	3280	390	11	400	5	145	42	US	Coupe	Man 6
Chevrolet Equinox	18	189	71	69	113	3880	1115	37	185	9.1	153	43	US	4 Door SUV	Auto 5
Chevrolet HHR	23	176	69	65	104	3265	820	30	172	9.2	159	41	US	4 Door SUV	Auto 4
Chevrolet Impala	20	200	73	59	111	3710	945	19	242	7.8	155	41	US	Sedan	Auto 4
Chevrolet Suburban	14	222	79	77	130	5935	1460	61	320	9.1	165	45	US	4 Door SUV	Auto 4
Chevrolet Tahoe LT V8	14	202	79	77	116	5715	1580	51	320	9	168	42	US	4 Door SUV	Auto 4
Chevrolet TrailBlazer	15	192	75	75	113	4830	1020	39	291	9.1	159	39	US	4 Door SUV	Auto 4
Chevrolet Uplander	18	205	72	72	121	4420	1410	51	240	8.8	153	43	US	Minivan	Auto 4
Chrysler 300 C V8	16	197	74	58	120	4105	865	16	340	6.4	139	41	US	Sedan	Auto 5
Chrysler Pacifica	16	199	79	67	116	4720	1000	36	253	8.6	146	42	US	4 Door SUV	Auto 6
Chrysler PT Cruiser	20	169	67	61	103	3350	865	32	180	8.1	165	41	US	Sedan	Auto 4
Chrysler Sebring sedan Touring 4-cyl	23	191	73	59	109	3335	825	13	173	10.2	156	40	US	Sedan	Auto 4
Chrysler Town & Country	17	203	77	69	121	4755	1150	62	251	8.8	172	42	US	Minivan	Auto 6
Dodge Caliber SXT 4-cyl CVT	22	174	69	60	104	3185	865	20	172	10.3	157	39	US	4 Door Hatchback	CVT
Dodge Charger SXT V6	17	200	75	58	120	3895	865	16	340	6	134	41	US	Sedan	Auto 5
Dodge Durango	12	201	76	74	119	5150	1455	45	335	7.6	167	43	US	4 Door SUV	Auto 5
Dodge Grand Caravan	16	203	77	69	121	4600	1150	62	197	10.3	182	42	US	Minivan	Auto 6
Dodge Magnum	19	198	74	58	120	3950	865	30	250	8.8	166	41	US	Wagon	Auto 4
Dodge Nitro	16	179	73	69	109	4340	1150	40	210	9.1	167	39	US	4 Door SUV	Auto 4
Dodge Viper	15	176	75	48	99	3480	465	6	510	4.2	130	43	US	Coupe	Man 6
Ford Edge	16	186	76	67	111	4540	910	36	265	8.3	159	39	US	4 Door SUV	Auto 6
Ford Escape	19	175	70	70	103	3605	1000	38	200	10.5	215	40	US	4 Door SUV	Auto 4
Ford Expedition	13	221	79	77	131	6325	1570	73	300	9.1	166	45	US	4 Door SUV	Auto 6
Ford Explorer XLT V6	15	193	74	73	114	4905	1275	48	210	9.7	163	38	US	4 Door SUV	Auto 5
Ford Fusion SEL V6	20	190	72	56	107	3480	850	16	221	8	143	42	US	Sedan	Auto 6
Ford Mustang coupe GT Premium V8 MT	20	188	74	55	107	3585	720	13	300	5.5	144	39	US	Coupe	Man 5
Ford Taurus X	16	200	75	67	113	4420	1150	38	263	8.5	152	42	US	Sedan	Auto 6
Honda Civic sedan EX 4-cyl	31	177	69	57	106	2810	850	13	140	8.6	136	39	Asia or Europe	Sedan	Man 5
Honda CR-V	21	178	72	66	103	3505	850	26	166	10.6	139	39	Asia or Europe	4 Door SUV	Auto 5
Honda Element	21	170	72	70	101	3650	675	47	166	10.4	162	36	Asia or Europe	4 Door SUV	Auto 5
Honda Fit Sport 4-cyl MT	34	162	67	60	98	2370	850	24	109	9.9	144	36	Asia or Europe	4 Door Hatchback	Man 5
Honda Odyssey	19	201	77	69	118	4615	1320	67	255	8.6	144	40	Asia or Europe	Minivan	Auto 5
Honda Pilot	17	191	79	73	109	4510	1320	48	255	8.2	157	40	Asia or Europe	4 Door SUV	Auto 5
Honda S2000	25	162	69	51	95	2855	400	5	240	5.8	134	36	Asia or Europe	Coupe	Man 6
Hummer H3	14	187	75	74	112	4940	940	38	220	11.5	170	37	US	4 Door SUV	Auto 4
Hyundai Accent GLS 4-cyl	28	169	67	58	98	2590	850	12	110	12.5	153	36	Asia or Europe	Sedan	Auto 4
Hyundai Azera	19	193	73	59	109	3835	860	17	263	7.1	144	41	Asia or Europe	Sedan	Auto 5
Hyundai Elantra GLS 4-cyl	27	177	70	58	104	2945	850	14	138	10.4	152	37	Asia or Europe	Sedan	Auto 4
Hyundai Santa Fe	18	184	74	68	106	4345	1120	38	242	8.5	139	39	Asia or Europe	4 Door SUV	Auto 5
Hyundai Sonata GLS 4-cyl	23	189	72	58	107	3345	860	16	162	10.5	133	39	Asia or Europe	Sedan	Auto 4
Hyundai Tucson	18	170	71	66	104	3800	860	31	173	10.1	143	39	Asia or Europe	4 Door SUV	Auto 4
Hyundai Veracruz	17	191	77	69	110	4610	1160	42	260	8.6	154	41	Asia or Europe	4 Door SUV	Auto 6
Infiniti G sedan Journey V6	19	187	70	57	112	3635	900	14	306	2.2	132	38	Asia or Europe	Sedan	Auto 5
Infiniti M M35 V6	19	193	71	59	114	3890	860	13	275	6.9	141	39	Asia or Europe	Sedan	Auto 5
Jaguar S-Type	19	192	72	56	115	3880	905	14	294	6.3	142	40	Asia or Europe	Sedan	Auto 6
Jaguar XJ	19	200	73	57	119	3860	880	17	294	7.1	143	41	Asia or Europe	Sedan	Auto 6
Jaguar XK	19	189	82	52	108	3890	705	10	300	7	138	38	Asia or Europe	Coupe	Auto 6
Jeep Commander	13	189	75	72	110	5245	1100	39	330	7.3	160	41	US	4 Door SUV	Auto 5
Jeep Compass	22	173	69	65	104	3380	925	27	172	10.1	163	38	US	4 Door SUV	CVT
Jeep Grand Cherokee	14	186	73	67	109	4690	1050	33	235	8.8	159	40	US	4 Door SUV	Auto 5
Jeep Patriot	20	174	69	64	104	3575	925	30	172	10.8	168	38	US	4 Door SUV	CVT
Jeep Wrangler	15	173	74	71	116	4550	850	35	205	10.7	172	43	US	4 Door SUV	Auto 4
Kia Amanti	18	197	73	59	110	3870	860	16	200	9.1	160	41	Asia or Europe	Sedan	Auto 5
Kia Optima EX V6	23	186	71	58	107	3430	825	15	162	9.2	142	39	Asia or Europe	Sedan	Auto 5
Kia Rio sedan LX 4-cyl	28	167	67	58	98	2615	850	9	110	12.8	150	35	Asia or Europe	Sedan	Auto 4
Kia Rondo	21	179	72	65	106	3660	825	33	182	9.6	163	39	Asia or Europe	Wagon	Auto 5
Kia Sedona	17	202	78	69	119	4725	1155	65	244	9	152	43	Asia or Europe	Minivan	Auto 5
Kia Sorento	15	181	73	68	107	4310	880	32	192	9.5	155	39	Asia or Europe	4 Door SUV	Auto 4
Kia Spectra EX 4-cyl	28	176	68	58	103	2875	850	12	138	9.5	153	37	Asia or Europe	Sedan	Man 5
Kia Sportage	18	170	71	66	104	3750	860	31	173	11.3	172	38	Asia or Europe	4 Door SUV	Auto 4
Land Rover LR3	13	191	75	74	114	5705	1475	52	300	9.1	145	39	US	4 Door SUV	Auto 6
Lexus ES	23	191	72	57	109	3670	900	15	272	6.4	140	39	Asia or Europe	Sedan	Auto 6
Lexus GS 300 V6	20	190	72	57	112	3915	815	13	245	7.4	147	38	Asia or Europe	Sedan	Auto 6
Lexus GX	15	188	74	73	110	4825	1225	40	235	8	136	41	Asia or Europe	4 Door SUV	Auto 5
Lexus IS	24	180	71	56	108	3510	825	13	204	7.7	134	35	Asia or Europe	Sedan	Auto 6
Lexus LS	21	203	74	58	122	4515	825	18	380	6.2	153	40	Asia or Europe	Sedan	Auto 8
Lexus RX 350 V6	19	186	73	66	107	4235	925	33	270	7.3	141	40	Asia or Europe	4 Door SUV	Auto 5
Lexus SC	21	179	72	53	103	3870	645	8	288	6.5	144	38	Asia or Europe	Coupe	Auto 6
Lincoln MKX	16	187	76	67	111	4620	910	37	265	8.2	162	41	US	4 Door SUV	Auto 6
Lincoln MKZ	20	191	72	57	107	3625	875	16	263	6.9	135	42	US	Sedan	Auto 6
Lincoln Navigator	13	208	79	78	119	6245	1525	57	300	8.8	167	42	US	4 Door SUV	Auto 6
Lincoln Town Car	17	215	78	59	118	4415	1100	21	239	8.7	154	42	US	Sedan	Auto 4
Lotus Elise	29	149	68	44	91	2000	550	4	190	4.6	132	37	Asia or Europe	Coupe	Man 6
Mazda CX-7	18	184	74	65	108	4025	850	28	244	9.1	140	41	Asia or Europe	4 Door SUV	Auto 6
Mazda CX-9	16	200	76	68	113	4585	1190	38	263	3.2	161	40	Asia or Europe	4 Door SUV	Auto 6
Mazda MX-5 Miata	27	157	68	49	92	2510	340	5	170	6.7	138	33	Asia or Europe	Coupe	Man 6
Mazda RX-8	18	174	70	53	106	3085	680	8	238	6.7	130	38	Asia or Europe	Coupe	Man 6
Mazda Mazda3 sedan i 4-cyl MT	30	178	69	58	104	2830	850	11	148	8.6	140	36	Asia or Europe	Sedan	Man 5
Mazda Mazda5	23	182	69	64	108	3480	1020	39	157	10.3	154	37	Asia or Europe	Wagon	Auto 4
Mazda Mazda6	23	187	70	57	105	3355	850	15	160	9.6	145	41	Asia or Europe	Sedan	Auto 4
Mercedes-Benz CLS	18	194	74	55	112	4060	915	16	302	6.1	133	38	Asia or Europe	Sedan	Auto 7
Mercedes-Benz E-Class sedan E350 V6	21	190	72	58	112	3845	1010	16	268	6.5	152	38	Asia or Europe	Sedan	Auto 7
Mercedes-Benz GL-Class	15	200	76	72	121	5575	1210	46	335	7.4	154	42	Asia or Europe	4 Door SUV	Auto 7
Mercedes-Benz M-Class	16	189	75	70	115	4845	1165	41	268	7.8	143	38	Asia or Europe	4 Door SUV	Auto 7
Mercedes-Benz S-Class	17	205	73	58	125	4490	1135	16	382	6	154	40	Asia or Europe	Sedan	Auto 7
Mercedes-Benz SL	17	179	72	51	101	4235	570	10	382	5.3	132	36	Asia or Europe	Coupe	Auto 7
Mercedes-Benz SLK	21	161	70	51	96	3315	525	10	268	6.2	130	34	Asia or Europe	Coupe	Man 6
Mercury Grand Marquis	16	212	78	57	115	4180	1100	21	239	8	151	42	US	Sedan	Auto 4
Mercury Milan Base 4-cyl	23	191	72	56	107	3320	850	16	160	9.5	144	40	US	Sedan	Auto 5
Mini Cooper	30	146	66	55	97	2690	815	6	172	7.2	154	37	Asia or Europe	Coupe	Man 6
Mitsubishi Eclipse hatchback GS 4-cyl MT	23	180	72	54	101	3345	660	16	162	9.3	149	42	Asia or Europe	Coupe	Man 5
Mitsubishi Endeavor	17	190	74	70	108	4195	970	40	215	8.2	147	41	Asia or Europe	4 Door SUV	Auto 4
Mitsubishi Galant ES 4-cyl	23	190	72	58	108	3430	825	13	160	9.1	148	43	Asia or Europe	Sedan	Auto 4
Mitsubishi Outlander XLS V6	19	183	71	66	105	3925	1155	34	220	8.3	142	38	Asia or Europe	4 Door SUV	Auto 6
Nissan 350Z	20	169	72	52	104	3640	450	4	287	6.2	130	37	Asia or Europe	Coupe	Man 6
Nissan Altima sedan 2.5 S 4-cyl CVT	25	190	71	58	109	3215	900	16	175	8.1	142	39	Asia or Europe	Sedan	CVT
Nissan Armada	13	208	79	76	123	5715	1375	59	317	7.2	140	44	Asia or Europe	4 Door SUV	Auto 5
Nissan Maxima	21	191	73	58	109	3555	900	14	255	6.8	150	44	Asia or Europe	Sedan	CVT
Nissan Murano	19	189	74	67	111	4190	900	31	245	8	146	40	Asia or Europe	4 Door SUV	CVT
Nissan Pathfinder	15	188	73	70	112	4875	1125	48	270	8	172	43	Asia or Europe	4 Door SUV	Auto 5
Nissan Quest	18	204	78	70	124	4550	1205	60	235	8.4	153	45	Asia or Europe	Minivan	Auto 5
Nissan Sentra 2.0 S 4-cyl CVT	26	180	71	60	106	3010	850	13	140	9.6	164	38	Asia or Europe	Sedan	CVT
Nissan Versa hatchback 1.8 S 4-cyl MT	29	169	67	60	102	2780	860	18	122	9.5	187	37	Asia or Europe	Sedan	Man 6
Nissan Xterra	17	179	73	75	106	4480	920	46	261	7.7	158	40	Asia or Europe	4 Door SUV	Auto 5
Pontiac G6 sedan GT V6	22	189	71	57	112	3540	890	14	169	9.4	156	42	US	Sedan	Auto 4
Pontiac Grand Prix	20	198	72	56	111	3630	915	16	200	8.3	169	41	US	Sedan	Auto 4
Pontiac Solstice	23	157	71	50	95	2925	355	4	177	7.2	148	36	US	Coupe	Man 5
Pontiac Vibe	27	173	70	61	102	3000	850	24	126	10.7	150	38	US	Wagon	Auto 4
Porsche 911	20	176	71	52	93	3305	660	5	355	4.4	127	37	Asia or Europe	Coupe	Man 6
Porsche Boxster	22	172	70	51	95	3015	420	9	240	6.5	123	37	Asia or Europe	Coupe	Man 5
Saab 9-3 sedan 2.0T 4-cyl	23	182	68	57	105	3370	930	15	210	8	136	37	US	Sedan	Auto 5
Saab 9-5	21	190	71	57	106	3545	930	16	260	7.2	139	40	US	Sedan	Auto 5
Saturn Aura XE 4-cyl	20	190	70	58	112	3335	915	16	224	8.1	160	42	US	Sedan	Auto 4
Saturn Outlook	16	201	78	70	119	5015	1320	49	275	8.8	162	42	US	4 Door SUV	Auto 6
Saturn Sky	24	161	71	50	95	3065	425	4	260	6.2	156	37	US	Coupe	Man 5
Saturn Vue	17	180	73	67	107	3915	915	28	257	8.2	162	42	US	4 Door SUV	Auto 6
Scion tC	26	174	69	56	106	2890	865	13	160	8.8	147	37	Asia or Europe	Coupe	Man 5
Scion xB	23	167	69	64	102	3120	850	34	158	9.4	148	37	Asia or Europe	Wagon	Auto 4
Subaru Forester 2.5X 4-cyl	22	177	68	65	99	3260	900	32	173	10	142	38	Asia or Europe	4 Door SUV	Auto 4
Subaru Legacy	18	186	68	56	105	3540	850	11	250	3.1	151	38	Asia or Europe	Sedan	Auto 5
Subaru Outback wagon 2.5i 4-cyl	21	189	70	63	105	3545	900	31	168	11.8	158	38	Asia or Europe	Wagon	Auto 4
Subaru Tribeca	16	192	74	66	108	4280	1155	36	256	8.6	162	40	Asia or Europe	4 Door SUV	Auto 5
Suzuki Forenza	27	177	68	57	102	2840	875	12	126	9.5	157	36	Asia or Europe	4 Door Hatchback	Man 5
Suzuki Grand Vitara	18	177	71	67	104	3650	905	25	185	9.5	147	38	Asia or Europe	4 Door SUV	Auto 5
Suzuki SX4 Sport 4-cyl	22	163	69	63	98	2995	815	16	143	12.2	150	37	Asia or Europe	4 Door Hatchback	Auto 4
Suzuki XL-7	17	197	72	69	112	4190	1190	37	252	7.7	147	44	Asia or Europe	4 Door SUV	Auto 5
Toyota 4Runner	16	189	74	72	110	4345	1035	45	239	8.2	146	40	Asia or Europe	4 Door SUV	Auto 4
Toyota Avalon	22	197	73	59	111	3600	875	14	280	6.7	155	41	Asia or Europe	Sedan	Auto 5
Toyota Camry LE 4-cyl	24	189	72	58	109	3280	900	15	158	9.6	151	38	Asia or Europe	Sedan	Auto 5
Toyota Camry Solara	21	193	72	56	107	3620	755	14	225	7.5	138	39	Asia or Europe	Coupe	Auto 5
Toyota Corolla Base 4-cyl MT	29	178	67	58	102	2595	860	14	130	9.8	151	38	Asia or Europe	Sedan	Auto 4
Toyota FJ Cruiser	17	184	75	72	106	4350	1190	34	239	8	157	44	Asia or Europe	4 Door SUV	Auto 5
Toyota Highlander Limited V6	18	188	75	69	110	4490	1200	38	270	8	151	42	Asia or Europe	4 Door SUV	Auto 5
Toyota Prius Base 4-cyl CVT	44	175	68	58	106	2950	825	16	110	10.5	152	37	Asia or Europe	4 Door Hatchback	CVT
Toyota RAV4 Base 4-cyl	23	181	72	66	105	3485	825	39	166	9.8	139	37	Asia or Europe	4 Door SUV	Auto 4
Toyota Sienna XLE AWD V6	18	201	77	69	119	4550	1050	71	266	7.7	147	39	Asia or Europe	Minivan	Auto 5
Toyota Yaris hatchback Base 4-cyl	34	151	67	60	97	2410	845	9	106	9.3	186	34	Asia or Europe	Sedan	Man 5
Volkswagen GTI	25	166	69	58	102	3155	960	15	200	6.7	141	36	Asia or Europe	4 Door Hatchback	Man 6
Volkswagen Jetta 2.5 5-cyl	24	179	69	58	102	3330	970	16	150	9.4	146	36	Asia or Europe	Sedan	Auto 6
Volkswagen Passat	24	188	72	58	107	3465	975	14	200	7.7	145	38	Asia or Europe	Wagon	Auto 6
Volvo S40	23	176	70	57	104	3245	950	14	168	9.4	148	37	US	Sedan	Auto 5
Volvo S60	22	180	71	56	107	3465	890	14	208	7.9	145	42	US	Sedan	Auto 5
Volvo S80	20	191	73	59	112	3850	905	15	235	8.6	158	39	US	Sedan	Auto 6
Volvo V50	20	178	70	57	104	3555	800	28	218	8.5	153	36	US	Wagon	Auto 5
Volvo XC90	16	189	75	70	113	4950	1210	38	311	7.6	138	42	US	4 Door SUV	Auto 6

12	0.5
12	1
12	1.5
17	0.5
17	1
17	1.5
19	0.5
19	1
19	1.5
23	0.5
23	1
23	1.5
44	0.5
44	1
44	1.5
12	1
44	1
17	0.5
23	0.5
17	1.5
23	1.5

12	0.5
12	1
12	1.5
17	0.5
17	1
17	1.5
19	0.5
19	1
19	1.5
23	0.5
23	1
23	1.5
44	0.5
44	1
44	1.5
12	1
44	1
17	0.5
23	0.5
17	1.5
23	1.5

12	0.5
12	1
12	1.5
17	0.5
17	1
17	1.5
19	0.5
19	1
19	1.5
23	0.5
23	1
23	1.5
44	0.5
44	1
44	1.5
12	1
44	1
17	0.5
23	0.5
17	1.5
23	1.5