Volumetric and Frequency tables examples

 

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:

Volumetric tables