Question

eBook KExercise 3.11 (Algorithmic) In automobile mileage and gasoline-consumption testing, 13 automobiles were road tested for 300 miles in both city and highway driving conditions. The following data were recorded for miles-per-gallon performance. City: 19.5 20 19.2 17.7 16.5 18.6 20.1 19.3 19.4 18.6 18.5 18.6 19.5 Highway: 22.9 24.1 21.8 22.1 22.7 20.9 20.7 22.1 22.5 24.6 22.9 22 22.2 Calculate the mean, median, and mode for City and High way gasoline consumption (to 1 decimal). City Highway Mean Median Mode Select your answer The mode is 18.3 The mode is 22.9 The mode is 22.1 The data are bimodal: 22.1 and 22.9 Make a statement about the difference in gasoline consumption between both driving conditions Select your answer

Answer 1

a)

	city	highway	excel function
mean	18.88	22.42	AVERAGE
median	19.20	22.20	MEDIAN
mode	18.60	22.90	MODE

b)

The mean median and mode mileages are all better on highway than in the City

excel sheet: replace " =" by "="

city	highway			city	highway	excel function
19.5	22.9		mean	=AVERAGE(A2:A14)	=AVERAGE(B2:B14)	AVERAGE
20	24.1		median	=MEDIAN(A2:A14)	=MEDIAN(B2:B14)	MEDIAN
19.2	21.8		mode	=MODE(A2:A14)	=MODE(B2:B14)	MODE
17.7	22.1
16.5	22.7
18.6	20.9		The mean median and mode mileages are all better on highway than in the City
20.1	20.7
19.3	22.1
19.4	22.5
18.6	24.6
18.5	22.9
18.6	22
19.5	22.2