Tables and axes > Introduction to axes > Netting > Percentaging with nets
 
Percentaging with nets
When you request percentages on a table of nets, Quantum calculates the percentages against the number of respondents in the base rather than on the number of responses in the net. If you want percentages based on net figures there are a number of things you can do.
Using the base keyword
The first option is to place the keyword base on the net element. This flags the net element as a base and percentages for all elements that come after this net will be calculated using the net figure as a base. For example:
l opinion
n10Base
n03
net1Favorable Comments;base
fld c123 :2;Liked bottle=12;Liked label=13;Liked color=14;
+Tasted sweet=22;Tasted fizzy=23;Refreshing=24
n03
net1Unfavorable Comments;base
fld c123 :2;Too big=51;Not strong=52;Too thick=57;Too many bits=60
Here the two level 1 nets are flagged as bases. This means that the percentage for favorable responses about the bottle will be calculated using the number of respondents making favorable comments of any sort as a base, rather than against the total number of respondents in the axis. The same is true for unfavorable comments where, for example, the percentage for the comment ‘Too big’ is calculated against the number of people making unfavorable comments.
Here is the table itself:
Base Male Female

Base 126 59 67

Favorable Comments 74 45 29
Liked bottle 19 13 6
25.7% 28.9% 20.7%
Liked Label 15 5 10
20.3% 11.1% 34.5%
Liked Color 24 16 8
32.4% 35.6% 27.6%
Tasted sweet 15 10 5
20.3% 22.2% 17.2%
Tasted fizzy 10 7 3
13.5% 15.6% 10.3%
Refreshing 10 7 3
13.5% 15.6% 10.3%

Unfavorable Comments 51 26 25
Too Big 20 11 9
39.2% 42.3% 36.0%
Not strong 18 9 9
35.3% 34.6% 36.0%
Too thick 10 4 6
19.6% 15.4% 24.0%
Too many bits 8 6 2
15.7% 23.1% 8.0%
With this method you have percentages calculated against the net figures, but you have lost the percentages of the favorable and unfavorable comment nets against the table base.
Using op=126
An alternative is to create the table using op=126 and to place base on the net elements. With this method the net elements have percentages calculated against the table base, while other elements have two percentages, one calculated against the table base and the other calculated against the appropriate net.
Defining nonprinting base rows
A third choice is to define nonprinting base rows immediately after the net elements:
l opinion
n10Base
n03
net1Favorable Comments
net2;base;norow
fld c123 :2;Liked bottle=12;Liked label=13;Liked color=14;
+Tasted sweet=22;Tasted fizzy=23;Refreshing=24
n03
n11;base
net1Unfavorable Comments
net2;base;norow
fld c123 :2;Too big=51;Not strong=52;Too thick=57;Too many bits=60
This gives you one percentage for each row. The net rows are percentaged against the table base and the other elements are percentaged against the preceding net:
Base Male Female

Base 126 59 67

Favorable Comments 74 45 29
58.7% 76.3% 43.3%
Liked bottle 19 13 6
25.7% 28.9% 20.7%
Liked Label 15 5 10
20.3% 11.1% 34.5%
Liked Color 24 16 8
32.4% 35.6% 27.6%
Tasted sweet 15 10 5
20.3% 22.2% 17.2%
Tasted fizzy 10 7 3
13.5% 15.6% 10.3%
Refreshing 10 7 3
13.5% 15.6% 10.3%

Unfavorable Comments 51 26 25
40.5% 44.1% 37.3%
Too Big 20 11 9
39.2% 42.3% 36.0%
Not strong 18 9 9
35.3% 34.6% 36.0%
Too thick 10 4 6
19.6% 15.4% 24.0%
Too many bits 8 6 2
15.7% 23.1% 8.0%
See also
Netting