Filtered columns in grid tables
The specification for the sample table uses n00 statements in the side section of the axis to define additional filters for groups of row elements. Columns in grid axes can be filtered using c= as you do in ordinary axes. The example below is of a product test in which filtering of columns is quite common.
In the survey respondents are asked to test two products, A and B. One group tests them in the order A then B, while the other tries B then A, but neither group knows which product is which. When respondents are asked about these products, they are referred to as ‘the product tried first’ or ‘the product tried second’. The interviewer answers the question about the order in which the products were tried.
Here are two sample questions and their responses:
Q3 Order in which products tried
A then B ....... 1 (C123)
B then A ....... 2 |
Q9 Likelihood of buying each product
First product tried: (C146) Second product tried: (C147)
Definitely buy it ...... 1 Definitely buy it ....... 1
Probably buy it ........ 2 Probably buy it ......... 2
Might/might not buy it . 3 Might/might not buy it .. 3
Probably not buy it .... 4 Probably not buy it ..... 4
Definitely not buy it .. 5 Definitely not buy it ... 5 |
Suppose the client wants a table to show how likely people would be to buy each product, and whether this varies according to the order in which the products were tried.
The grid axis for the table is:
l gax01
n01A;col(a)=146;c=c123'1'
n01B;col(a)=147;c=c123'1'
n01A;col(a)=147;c=c123'2'
n01B;col(a)=146;c=c123'2'
g Tried A First Tried B First
g A B A B
g------- ------- ------- -------
p x x x x
side
ttlQ9. Purchase Intent
col a00;Base;Definitely would buy;Probably would buy;
+Might or might not buy;Probably would not buy;
+Definitely would not buy
The finished table is shown below.
Table 10
Q9. Purchase Intent absolutes/col percents
Tried A First Tried B First
A B A B
------- ------- ------- -------
Base 150 150 | 180 180
Definitely would buy 16 10 | 12 21
11% 7% | 7% 12%
Probably would buy 32 14 | 29 49
21% 9% | 16% 27%
Might or might not buy 44 36 | 53 67
29% 24% | 29% 37%
Probably would not buy 27 50 | 50 25
18% 33% | 28% 14%
Definitely would not buy 31 40 | 36 18
21% 27% | 20% 10% |
The first cell of the leftmost column contains people who have the condition c123’1’.and.c146’1’; that is, people who tried brand A first and who would definitely buy it. The bottom cell of the right-most column contains respondents who satisfy the condition c=c123’2’.and.c146’5’; that is, those who tried brand B first and would definitely not buy it.
See also