Server User Guides > Survey Tabulation > Cell contents > Counts and unweighted counts
 
Counts and unweighted counts
Counts show the number of cases that satisfy the row and column conditions for each cell after any weighting defined for the table has been applied. Counts are the basic values that are shown in the cells of a table. Unweighted counts show the number of cases that satisfy the row and column conditions for each cell before any weighting defined for the table has been applied. In an unweighted table, the counts and unweighted counts are identical.
The following table shows both weighted and unweighted counts in all of the cells apart from those formed from the unweighted base elements. By default, an unweighted base element is added to all weighted tables. See The unweighted base in weighted tables for more information.
Table showing counts and unweighted counts
This graphic is described in the surrounding text.
In this table, the first figure in the cells is the count (which is weighted) and the second is the unweighted count. The table is weighted using the genbalance weighting variable, which uses non-integer sample weights to weight the sample to an equal balance between the two genders. More males than females were interviewed in the survey, so the genbalance weighting variable inflates the responses from female respondents and deflates the responses from male respondents.
If you look at the unweighted counts in the Enjoyment row, you can see that of the people who selected this category, 14 have a biology qualification and 31 don't. The unweighted counts are always whole numbers because a respondent either does or does not select each category. If you look at the weighted counts in the same row, you can see that the figures are 14.48 and 31.12, respectively. The weighted counts are non-integers because they represent the unweighted counts multiplied by the appropriate weights, which in this example are non-integer values. See Weighting for more information.
In practice, counts are generally shown as whole numbers. You can specify this by setting the number of decimal places to zero: see To define cell contents for a table.
See also
Cell contents