Answer Happy

Suppose that you were provided with data on worldwide vehicle production by manufacturer. The table below shows vehicle production numbers for four different manufacturers for five years. Data are in millions of vehicles. Click on the datafile logo to reference the data. DATA file MANUFACTURER TOYOTA GM VOLKSWAGEN HYUNDAI (i) (ii) Production (millions Production (millions of vehicles) 10 9 8 3 2 10 (a) Construct a line chart in Excel for the time series data for years 1 through 5 showing the number of vehicles manufactured by each automotive company. Show the time series for all four manufacturers on the same graph. Choose the correct graph below. 9 2 Year 1 0 2.51 5.68 8.97 8.04 Production (millions of vehicles) Year 2 Year 3 Year 4 1 2.62 6.27 9.35 8.53 TOYOTA <-- GM 2 2.78 6.44 8.28 9.24 2 4.65 6.07 6.46 7.23 -- VOLKSWAGEN 3 Year TOYOTA <--- GM -- VOLKSWAGEN 3 Year Year 5 5.76 7.34 8.48 8.56 4 HYUNDAI 5 HYUNDAI 5
(iii) (iv) Production (millions of vehicles) Production (millions of vehicles) 35 20 15 5 35 30 25 20 15 10 5 0 1 TOYOTA 1 2 ... VOLKSWAGEN 3 Year GM ... VOLKSWAGEN 3 Year HYUNDAI HYUNDAI 5 - Select your answer - (b) What does the line chart indicate about vehicle production amounts from years 1 through 5? Discuss. - Select your answer - produced the greatest number of vehicles in Years 1 and 2, but was passed in Year 3 by - Select your answer - ✓ seen the most increases in vehicle production in Years 4 and 5. By Year 5, Select your answer ✓ were producing approximately the same number of vehicles. Select your answer - has
(c) Construct a clustered-bar chart in Excel showing vehicles produced by automobile manufacturer using the year 1 through year 5 data. Represent the years of production along the horizontal axis, and cluster the production amounts for the four manufacturers in each year. Choose the correct graph below. (i) (ii) Production (millions of vehicles) Production (millions of vehicles) 35 ■TOYOTA GM VOLKSWAGEN ■HYUNDAI ■TOYOTA GM 3 Year VOLKSWAGEN 3 Year 4 HYUNDAI 5
(iii) (iv) Production (millions of vehicles) Production 35 Year 3: 30 Year 4: Year 5: 25 20 15 10 5 -- TOYOTA 100% 90% 80% 70% 60% 50% 40% 30% 20% 10% 0% 1 1 - Select your answer - ✓ 2 GM .... VOLKSWAGEN ➡➡HYUNDAI 3 Year TOYOTA GM VOLKSWAGEN HYUNDAI 2 Which company is the leading manufacturer in each year? Year 1: - Select your answer - ✓ Year 2: - Select your answer - V Select your answer - Select your answer V Select your answer 3 Year 4 5