Answer to the followings: (Ignore the textbook questions in Ch. 6.)
? Create the contingency table (=pivot-table) between type vs. cylinders. Plot the appropriate graph or chart to compare the cylinders among vehicle types. Describe your findings from the graph. (Hint: The relative frequency is more meaningful than the frequency.)
Cylinders * Type Crosstabulation
Count
Type
Total
Miniv
SUV
Sedan
Wagon
Cylinders
4
1
3
18
5
27
5
0
0
1
0
1
6
8
9
19
0
36
8
0
12
7
0
19
10
0
0
1
0
1
Total
9
24
46
5
84
From the above table and cluster bar chart it can be observed that sedan have high amount of efficiency among the other types of cylinders.
? Create the scatter plot between MSRP (in x-axis; unit of $1,000) & City Fuel Efficiency (in y-axis; unit of MPG). ...