Problem 03-15 (Charts) Question 2 of 10 Check My Work (2 remaining) An automotive company is considering the introduction of a new model of sports car that will be available in four-cylinder and six-cylinder engine types. A sample of customers who were interested in this new model were asked to indicate their preference for an engine type for the new model of automobile. The customers were also asked to indicate their preference for exterior color of the automobile from four choices: red, black, green, and white. Consider the following data regarding the customer responses. Click on the datafile logo to reference the data. DATA file Four Cylinders Six Cylinders Red 143 857 Black 200 800 Green 321 679 White 420 580 (a) Construct a clustered-column chart in Excel with exterior color as the horizontal variable. Choose the correct chart below. (1) Four Cinder Cylinders 500 000 700 600 500 100 100 200 100 C JILI fr Red Wh Cater Color (11) Four Cylinders Six Cylinders Frequency 900 800 700 600 500 400 300 200 100 0 Red Black Green White Exterior Color Four Cylinders Six Cylinders Frequency 900 800 700 600 500 400 300 200 100 LLLL 0 Red Black Green White Exterior Color