Question

Use the data in the table below for this week’s assignment

	Production (millions of vehicles)
MANUFACTURER	Year 1	Year 2	Year 3	Year 4	Year 5
TOYOTA	8.04	8.53	9.24	7.23	8.56
GM	8.97	9.35	8.28	6.46	8.48
VOLKSWAGEN	5.68	6.27	6.44	6.07	7.34
HYUNDAI	2.51	2.62	2.78	4.65	5.76

Instructions:

1. Input the data into an SPSS work sheet. Make sure that all your variables are labelled appropriately (Need to show how to properly set up the variables for charting purposes)
2. Construct a line graph for the time series data 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
3. What does the line chart indicate about vehicle production amounts from years 1 through 5?
4. Construct a clustered-bar chart showing vehicles produced by automobile manufacturers using the year 1 through 5 data. Represent the years of production along the horizontal axis, and cluster the production amounts for the manufacturers in each year.
5. Which company is the leading manufacturer in each year?
6. Save all your commands to a syntax file

Answer 1

The SPSS worksheet set up is as follows:

The line graph for all four manufacturers is:

The line chart indicates that vehicle production amounts from years 1 through 5 is fluctuating from year to year and brand to brand.

The clustered-bar chart is:

GM is the leading manufacturer in year 1.

TOYOTA is the leading manufacturer in year 2.

TOYOTA is the leading manufacturer in year 3.

GM is the leading manufacturer in year 4.

GM is the leading manufacturer in year 5.

The SPSS syntax is:

WEIGHT BY Production.
GRAPH
/LINE(SIMPLE)=MEAN(Production) BY Manufacturer
/PANEL ROWVAR=Year ROWOP=CROSS.

WEIGHT BY Production.
GRAPH
/BAR(GROUPED)=COUNT BY Manufacturer BY Production
/PANEL ROWVAR=Year ROWOP=CROSS.