Construct a cross-tabulation describing the fleet using


The 30 vehicles operated by a taxi service have been listed according to their engine (1 = diesel, 2 = gasoline), transmission (1 = manual, 2 = automatic), and whether they have air conditioning (1 no air conditioning, 2 = air conditioning). These characteristics, along with the miles per gallon (mpg) achieved by each vehicle during the past month, are listed here. The data are also provided in file XR02048.

a. Construct a simple tabulation in which the counts are according to the type of engine.

b. Construct a cross-tabulation describing the fleet, using type of engine and type of transmission as the categorization variables.

c. Construct a display showing the average mpg according to type of engine and type of transmission. Do the categorization variables seem to be related to mpg? If so, how?

Engine

Trans

AC

mpg

Engine

Trans

AC

mpg

1

1

1

36.4

1

1

2

38.6

1

1

1

37.7

1

1

2

34.8

1

1

1

38.2

1

2

2

30.8

1

1

1

41.8

1

2

2

26.4

1

1

1

34.8

1

2

2

31.6

1

2

1

35.4

1

2

2

28.3

1

2

1

31.3

1

2

2

29.5

1

2

1

32.2

2

1

2

23.0

2

1

1

26.2

2

1

2

21.5

2

1

1

25.5

2

1

2

19.5

2

1

1

27.7

2

2

2

18.3

2

2

1

22.0

2

2

2

19.1

2

2

1

23.3

2

2

2

20.8

1

1

2

34.8

2

2

2

21.8

1

1

2

34.0

2

2

2

18.4

Request for Solution File

Ask an Expert for Answer!!
Basic Statistics: Construct a cross-tabulation describing the fleet using
Reference No:- TGS02199941

Expected delivery within 24 Hours