Frequency and Volumetric table examples

Example 1

Let’s say the question for the table is in variable Q1 and has values 1-6: Q1 (1-6). This is the question and its response choices, with the 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?

You would want the following volumetric filter:

TOTAL IN HOUSEHOLD Q1 (1-6)

Using Setup|Tables and choosing both 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: Q1 (1-6)

If you’re 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:

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

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. Let's say the question for the table is in Q2A through Q2E, each with values 1-99 (see the actual logic below). This is the question and its response choices, with their logic:

WHAT IS THE TOTAL NUMBER OF TRUCKS OF EACH OF THE FOLLOWING TYPES OF TRUCKS IN YOUR FLEET?

Class A Trucks Q2A (1-99)

Class B Trucks Q2B (1-99)

Class C Trucks Q2C (1-99)

Class D Trucks Q2D (1-99)

Class E Trucks Q2E (1-99)

You would want the following volumetric filter:

Total Trucks Q2A S5 (1-99)

meaning, ‘starting with Q2A, scan the next 5 variables (Q2A, Q2B, Q2C, Q2D, Q2E) 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 our example, you would write: Q2A 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 Q2A (1-99)

Class B Trucks Q2B (1-99)

Class C Trucks Q2C (1-99)

Class D Trucks Q2D (1-99)

Class E Trucks Q2E (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

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:

 Table types