Add Percents to a Table

There are optional percentages available for each value set in a table. To create percentages, use the Tally Attributes for a Variable dialog.

To bring up the Tally Attributes for a Variable Dialog, right-click on the variable in the table and choose Tally Attributes (<variable>).

To add percents to the variable, select "Percents" in the list of available calculations on the left-hand side of the dialog and click the "Add" button.

There are two options for "Percents" which can be set by clicking the "Options" button while the "Percents" are selected:

Type

• Total – Percents are based on total cell for the table (% cell = (associated cell value * 100) / total of all the cells in the table).

• Row – Percents are based on total for the row (%cell = (associated cell value * 100) / total of all the cells in the row).

• Column – Percents are based on total for the column (%cell = (associated cell value * 100) / total of all the cells in column).

Interleaved/Separate

By default, percents and counts are interleaved; that is, for each value in the value set, the frequency for that value is listed in the column/row directly preceding or following the percent for that value. Percents may also be separate, in which case all the frequencies are grouped together and all the percents are grouped together.

Interleaved Percents

Separate Percents

For percents to be interleaved, the percents must directly follow or directly precede the counts in the list of selected calculations in the tally attributes dialog.

You can change the position of the percents relative to the other selected calculations (including the counts) by selecting the percents in the list on the right-hand side of the dialog and clicking the "Up" or "Down" buttons.

To show percents only (percents without counts), add the percents as described above and set the options to "Separate". Then select the counts in the list of selected calculations on the right-hand side of the dialog and click the "Remove" button to delete the counts. Finally, do the same to remove the "Total".

To show percents only with a number row, add the percents and remove the counts as above, but do not remove the "Total".

The Defaults are set in the Preferences and Default Formats.

By default, data in rows and columns containing percents will be displayed with one decimal place (e.g., 12.3). To change the number of decimal places see Change the Number of Decimal Places Displayed.

You can also show the percentage of the counts for a subset of the values in a value set (e.g., percent of people with age between 15 and 49) using proportions. See the section on proportions under Tally Attributes for Variable for more information.