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.
Table showing counts and unweighted counts
The following table shows both weighted and unweighted counts in all of the cells apart from those formed from the unweighted bases. By default, an unweighted base is added to all weighted tables. For more information, see
Showing the unweighted base in weighted tables.
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.
The unweighted counts in the Enjoyment row show that of the people who selected this category, 14 have a biology qualification and 31 do not. The unweighted counts are always whole numbers because a respondent either does or does not select each category.
The weighted counts in the same row shows 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. For more information, see
Applying weighting.
In practice, counts are generally shown as whole numbers. You can specify this by setting the number of decimal places to zero. For more information, see
Adding and removing cell contents.
See also