Suppose that you would like to create a table that contains counts for how many people in a survey own Japanese, European, and American cars, broken down by the size of the car. You want the table to look Figure 8.83.
Figure 8.93 Table Showing Counts of Car Ownership
|
1.
|
|
2.
|
Select Analyze > Tabulate.
|
|
3.
|
Click country and drag it into the Drop zone for rows.
|
|
4.
|
Figure 8.94 Country and Size Added to the Table
Suppose that you would like to see the mean (average) and the standard deviation of the age of people who own each size of car. You want the table to look like Figure 8.95.
Figure 8.95 Table Showing Mean and Standard Deviation by Age
|
1.
|
|
2.
|
Click Mean and drag it over Sum.
|
|
3.
|
Click Std Dev and drag it below Mean.
|
Figure 8.96 Age, Mean, and Std Dev Added to the Table
Suppose that you would prefer size to be on top, showing a crosstab layout. You want the table to look like Figure 8.97.
Figure 8.97 Size on Top
|
1.
|
Start from Figure 8.96. Click on the size heading and drag it to the right of the table headings. See Figure 8.98.
|
Figure 8.98 Moving size
|
2.
|
Click on age and drag it under the Large Medium Small heading.
|
|
3.
|
Select both Mean and Std Dev, and then drag them under the Large heading.
|