Percentages

Percentages express the count or sum of a numeric variable as a percentage of the base for the column, row, or table. Expressing figures as percentages can make it easier to interpret and compare the data in a table.

Table showing counts and column percentages

The following table shows both counts and column percentages.

In this table, the first figure in each cell is the count and the second is the column percentage. The count in the Base column of the Base row shows that 304 respondents were asked both of the questions that the variables in the table are based on. These respondents form the sample base for the table.

The counts in the first row after the Base row show that 118 people described their expectation as General knowledge and education, and of these people, 25 hold a biology qualification and 93 do not. The column percentages show that 39% of the respondents in the table describe their expectation as General knowledge and education. A higher percentage of those who do not have a biology qualification (41%) expected to gain general knowledge than those with such a qualification (32%).

Sometimes, rounding means that the percentages for single response variables do not always add up to 100%. For example, the percentages in the No column in the preceding table add up to 101%. This is because UNICOM Intelligence Reporter performs all calculations using the maximum possible accuracy and only performs rounding immediately before it displays figures in a table. See Rounding in UNICOM Intelligence Reporter for more information.

You can use Adjust rounding so that percentages add up to 100% in the Display tab of the Table Properties dialog to force the percentages to add up to 100%.

Table showing counts and column percentages with rounding adjusted to add up to 100%

Here is the table after the rounding has been adjusted. The percentages in the No column now add up to 100%:

The biology and expect variables are both single response variables. In multiple response variables, percentages do not usually add up to 100% and adjusting the figures to do so would not make sense.

Table showing counts and cumulative column percentages

In the following table, the column percentages are shown as cumulative percentages.

In this table, the column percentages are shown with two decimal places. In all other respects the column percentages in the first row after the Base row are the same as those shown in the column percentages table shown earlier. However, the percentages in the subsequent rows differ. This is because the column percentages for each successive row are added to those of the previous rows to make a cumulative percentage, so the cumulative percentage for the final row is 100%.

The column percentages are not shown in the Base row. This has been achieved by deselecting Show 100% in base rows/columns in the Display tab of the Table Properties dialog.

Table showing counts and row and total percentages

The following table shows counts, and row and total percentages.

In this table the first figure in each cell is the count, the second is the row percentage, and the third is the total percentage. Row percentages show the percentage of the respondents in each row fall in each column. For example, the General knowledge and education row shows that 21% of the respondents in the row hold a biology qualification, and 79% of them do not.

Similarly, total percentages show the percentage of the total number of respondents in the table fall in each cell of the table. Looking at the General knowledge and education row again, you can see that respondents in the row who hold a biology qualification make up 8% of the respondents in the table and those in the same row without a biology qualification make up 31% of the total for the table.

Notes

▪If you have a table that contains only percentage values, you can display the table without any percentage signs: clear Display percent signs on the Display tab of the Table Properties dialog.

▪If a table is set to display only column percentages as the cell content, the base row displays counts, and the rest of the table rows displays the percentage.

See also