1. Home
  2. Frequency Tables

Frequency Tables

Select menu: Stats | Summary Statistics | Frequency Tables

Watch our video on summarizing categorical data with frequency tables.

This dialog produces frequency counts for grouped data. The data comes from one or more factors, and the frequency counts are then the number of units in each factor combination. You can also produce tables classified by multiple response factors.

  1. After you have imported your data, from the menu select 
    Stats | Summary Statistics | Frequency Tables.
    OR
    Stats | Survey Analysis | Frequency Tables.
  2. Fill in the fields as required then click Run.

Available data

This lists data structures appropriate to the current input field. The contents will change as you move from one field to the next, displaying either variates or factors. Double-click a name to copy it to the current input field or type the name.

Groups

The groups are specified by one or more factors, each of which must have the same length. The button allows multiple selections to be copied from Available data.

Weights

A variate specifying weights to be used in the tabulation.

Display table as percentage of margin

This allows the body of the table to be expressed as percentages of the corresponding values of the selected margin. Select the required factor from the dropdown list to specify the margin to be used as the denominator list.

Set margin

Specifies whether the tables should include margins (counts over all levels of each factor).

Save frequencies

Lets you save the frequency counts into a table data structure.

Display frequencies in a spreadsheet

When selected the table of frequency counts will be displayed within a spreadsheet. The format of the spreadsheet can be controlled by the choices in the dropdown list.

Page Format Each table is displayed on a single page in a separate spreadsheet. The last specified classifying factor indexes the columns in the spreadsheet.
Parallel Format The tables occupy a single column but multiple tables can be put in a single spreadsheet. This is the default for a table with a single classifying factor.
Tabbed Format For a table with three or more classifying factors, the table will be displayed as a tabbed-table with the first classifying factor’s groups indexing the tabs in the book.

Graphics

Opens a menu which can be used to plot the table currently specified by the factors in the Graphics list.

Multiple-response tables

Displays two additional options for producing frequency count tables classified by multiple response factors. For more details on multiple response factors see Form Multiple-Response Factors.

Pointer to factors defining multiple-responses

A pointer to factors defining the multiple responses in the table. You can form a pointer to factors for a multiple-response table using Form Multiple-Response Factors.

Name for factors to index multiple responses

This generates an ordinary factor to classify the dimension of the table corresponding to the multiple responses. You can specify identifier names for these factors in the space provided.

Action Icons

Pin Controls whether to keep the dialog open when you click Run. When the pin is down  the dialog will remain open, otherwise when the pin is up  the dialog will close.
Restore Restore names into edit fields and default settings.
Clear Clear all fields and list boxes.
Help Open the Help topic for this dialog.

See also

Updated on May 3, 2019

Was this article helpful?