Variable data examples:
Example 1:
Let's say the question for the table is in variable Q12 and has values 1-6: Q12 (1-6). This is the question and its response choices, with their logic (note that the final choice indicates that for calculating statistics, the value 8 will be used for 6):
INCLUDING YOURSELF, HOW MANY MEMBERS OF YOUR HOUSEHOLD READ AN AVERAGE ISSUE OF YOUR HOUSEHOLD'S COPY OF COMPUTER LIFE MAGAZINE?
ONE |
Q12 (1) |
TWO |
Q12 (2) |
THREE |
Q12 (3) |
FOUR |
Q12 (4) |
FIVE |
Q12 (5) |
SIX OR MORE |
Q12 (6) #6=8 |
You would want the following volumetric filter:
TOTAL IN HOUSEHOLD Q12 (1-6)
If you use Setup|Tables and choose Filter and Volumetric filter, you must specify the values across all variables that you want to sum. Volumetric filter cannot use the default TN for its filter. For Filter logic for our example, you would write: Q12 (1-6)
If you are including all values across all variables as your base, an easier way to achieve a volumetric filter is to not specify Volumetric filter in Filter. Instead, specify Sigma and leave the filter logic as the default TN. Sigma has the same effect as adding all values across all variables. For this example, you could use Sigma in place of Volumetric filter.
In Row Options in Setup|Tables, you would select Volumetric for the following rows:
ONE |
Q12 (1) |
TWO |
Q12 (2) |
THREE |
Q12 (3) |
FOUR |
Q12 (4) |
FIVE |
Q12 (5) |
SIX OR MORE |
Q12 (6) #6=8 |
Following are examples of how the results might appear on the Volumetric table and how they would appear on a regular Frequency table:
Volumetric Table |
|
|
|
Regular Frequency Table |
|
TOTAL IN HOUSEHOLD |
216 |
|
|
TOTAL IN HOUSEHOLD |
100 |
ONE |
23 |
23*1 |
|
ONE |
23 |
TWO |
110 |
55*2 |
|
TWO |
55 |
THREE |
33 |
11*3 |
|
THREE |
11 |
FOUR |
32 |
8*4 |
|
FOUR |
8 |
FIVE |
10 |
2*5 |
|
FIVE |
2 |
SIX OR MORE |
8 |
1*8 |
|
SIX OR MORE |
1 |
There are 100 respondents as reported in the regular Frequency table. There are a total of 216 in the households as reported in the Volumetric table. The numbers to the right of the Volumetric table illustrate that the number of responses (shown in the frequency table) are multiplied by the volume (shown in the Volumetric table); respondents are weighted by their volume. The Frequency table reports the count for the total respondents. The Volumetric table reports the volume of people in the households.
Example 2:
Example 2 is more complex. Say the question for the table is in variables CLASSA, CLASSB, CLASSC, CLASSD and CLASSE (all 2-column variables), each with values 1-99 (see the actual logic below). This is the question and its response choices, with associated logic:
WHAT IS THE TOTAL NUMBER OF TRUCKS FOR EACH OF THE FOLLOWING TYPES OF TRUCKS IN YOUR FLEET?
Class A Trucks |
CLASSA (1-99) |
Class B Trucks |
CLASSB (1-99) |
Class C Trucks |
CLASSC (1-99) |
Class D Trucks |
CLASSD (1-99) |
Class E Trucks |
CLASSE (1-99) |
You would want the following volumetric filter:
Total Trucks CLASSA S5 (1-99)
meaning, ‘Variable CLASSA, scan the next 4 variables (CLASSB, CLASSC, CLASSD, CLASSE) for values 1-99.’
For this table you would select Setup|Tables|Filter. For Filter title, you would write ‘TOTAL TRUCKS.’
If you specify Volumetric filter in Filter, you must specify the values across all variables that you want to sum. Volumetric filter cannot use the default TN for its filter. For Filter logic for this example, you would write: CLASSA S5 (1-99).
If you are including all values across all fields as your base, an easier way to achieve a volumetric filter is to not specify Volumetric filter in Filter. Instead, specify Sigma and leave the filter logic as the default TN. Sigma has the same effect as adding all values across all variables. For this example, you could use Sigma in place of Volumetric filter.
In Row Options in Setup|Tables, you would select Volumetric for the following rows:
Class A Trucks |
CLASSA (1-99) |
Class B Trucks |
CLASSB (1-99) |
Class C Trucks |
CLASSC (1-99) |
Class D Trucks |
CLASSD (1-99) |
Class E Trucks |
CLASSE (1-99) |
Following are examples of how the results might appear on the Volumetric table and how they would appear on a regular Frequency table.
Volumetric Table |
|
|
Regular Frequency Table |
|
Total Trucks |
3458 |
|
Total Trucks |
500 |
Class A Trucks |
546 |
|
Class A Trucks |
175 |
Class B Trucks |
143 |
|
Class B Trucks |
25 |
Class C Trucks |
1986 |
|
Class C Trucks |
200 |
Class D Trucks |
399 |
|
Class D Trucks |
56 |
Class E Trucks |
384 |
|
Class E Trucks |
44 |
There are 500 respondents, as reported in the regular Frequency table. There are a total of 3,458 trucks. The Frequency table reports the count for the total respondents. The Volumetric table reports the volume of trucks.
ASCII data examples:
Example 3:
Let's say the question for the table is in record 1, column 5 and has values 1-6: 1/5 (1-6). This is the question and its response choices, with their logic (note that the final choice indicates that for calculating statistics, the value 8 will be used for 6):
INCLUDING YOURSELF, HOW MANY MEMBERS OF YOUR HOUSEHOLD READ AN AVERAGE ISSUE OF YOUR HOUSEHOLD'S COPY OF COMPUTER LIFE MAGAZINE?
ONE |
1/5 (1) |
TWO |
1/5 (2) |
THREE |
1/5 (3) |
FOUR |
1/5 (4) |
FIVE |
1/5 (5) |
SIX OR MORE |
1/5 (6) #6=8 |
You would want the following volumetric filter:
TOTAL IN HOUSEHOLD 1/5 (1-6)
If you use Setup|Tables and choose Filter and Volumetric filter, you must specify the values across all fields that you want to sum. Volumetric filter cannot use the default TN for its filter. For Filter logic for our example, you would write: 1/5 (1-6)
If you are including all values across all fields as your base, an easier way to achieve a volumetric filter is to not specify Volumetric filter in Filter. Instead, specify Sigma and leave the filter logic as the default TN. Sigma has the same effect as adding all values across all fields. For this example, you could use Sigma in place of Volumetric filter.
In Row Options in Setup|Tables, you would select Volumetric for the following rows:
ONE |
1/5 (1) |
TWO |
1/5 (2) |
THREE |
1/5 (3) |
FOUR |
1/5 (4) |
FIVE |
1/5 (5) |
SIX OR MORE |
1/5 (6) #6=8 |
Following are examples of how the results might appear on the Volumetric table and how they would appear on a regular Frequency table.
Volumetric Table |
|
|
|
Regular Frequency Table |
|
TOTAL IN HOUSEHOLD |
216 |
|
|
TOTAL IN HOUSEHOLD |
100 |
ONE |
23 |
23*1 |
|
ONE |
23 |
TWO |
110 |
55*2 |
|
TWO |
55 |
THREE |
33 |
11*3 |
|
THREE |
11 |
FOUR |
32 |
8*4 |
|
FOUR |
8 |
FIVE |
10 |
2*5 |
|
FIVE |
2 |
SIX OR MORE |
8 |
1*8 |
|
SIX OR MORE |
1 |
There are 100 respondents as reported in the regular Frequency table. There are a total of 216 in the households as reported in the Volumetric table. The numbers to the right of the Volumetric table illustrate that the number of responses (shown in the frequency table) are multiplied by the volume (shown in the Volumetric table); respondents are weighted by their volume. The Frequency table reports the count for the total respondents. The Volumetric table reports the volume of people in the households.
Example 4:
Example 4 is more complex. Say the question for the table is in record 1, columns 55, 57, 59, 61 and 63 (all 2-column fields), each with values 1-99 (see the actual logic below). This is the question and its response choices, with associated logic:
WHAT IS THE TOTAL NUMBER OF TRUCKS OF EACH OF THE FOLLOWING TYPES OF TRUCKS IN YOUR FLEET?
Class A Trucks |
1/55:2 (1-99) |
Class B Trucks |
1/57:2 (1-99) |
Class C Trucks |
1/59:2 (1-99) |
Class D Trucks |
1/61:2 (1-99) |
Class E Trucks |
1/63:2 (1-99) |
You would want the following volumetric filter:
Total Trucks 1/55:2 S5 (1-99)
meaning, ‘record 1, column 55 and 56, scan the next 4 2-column fields (57-58, 59-60, 60-61, 63-64) for values 1-99.’
For this table you would select Setup|Tables|Filter. For Filter title, you would write ‘TOTAL TRUCKS.’
If you specify Volumetric filter in Filter, you must specify the values across all fields that you want to sum. Volumetric filter cannot use the default TN for its filter. For Filter logic for this example, you would write: 1/55:2 S5 (1-99).
If you are including all values across all fields as your base, an easier way to achieve a volumetric filter is to not specify Volumetric filter in Filter. Instead, specify Sigma and leave the filter logic as the default TN. Sigma has the same effect as adding all values across all fields. For this example, you could use Sigma in place of Volumetric filter.
In Row Options in Setup|Tables, you would select Volumetric for the following rows:
Class A Trucks |
1/55:2 (1-99) |
Class B Trucks |
1/57:2 (1-99) |
Class C Trucks |
1/59:2 (1-99) |
Class D Trucks |
1/61:2 (1-99) |
Class E Trucks |
1/63:2 (1-99) |
Following are examples of how the results might appear on the Volumetric table and how they would appear on a regular Frequency table.
Volumetric Table |
|
|
Regular Frequency Table |
|
Total Trucks |
3458 |
|
Total Trucks |
500 |
Class A Trucks |
546 |
|
Class A Trucks |
175 |
Class B Trucks |
143 |
|
Class B Trucks |
25 |
Class C Trucks |
1986 |
|
Class C Trucks |
200 |
Class D Trucks |
399 |
|
Class D Trucks |
56 |
Class E Trucks |
384 |
|
Class E Trucks |
44 |
There are 500 respondents, as reported in the regular Frequency table. There are a total of 3,458 trucks. The Frequency table reports the count for the total respondents. The Volumetric table reports the volume of trucks.
Related topics: