Summarising counts in a Table dataset

• Defining Datasets
• Table dataset

ADVANCED

Many tests involving a single categorical variable only require the count (frequency) of observations in each group, rather than the actual observations. The counts for the groups can be arranged using a table dataset. Separate columns are used for each group, as usual, then the count (frequency) rather than the actual observations are entered.

EXAMPLE  The table dataset below contains 3 groups, A, B & C , with the count (frequency) for each group in the row below. 

Using two Header rows

As in the case for the table dataset, using a single row of headers does not allow the names of the variables to be provided.

The solution is to use an additional header row to hold the name of the variable. The additional row is placed above the group names, with the name of the variable in the leftmost cell.

EXAMPLE  The table dataset below is the same as above except an additional row has been added to hold the variable names. The leftmost cell, above the first group A, contains the dependent variable name, Drug.

When the dataset is arranged on the Excel worksheet the next step is to define the range as a dataset.

To define the dataset:

1. Select a cell in the range containing the dataset.
2. Click Define Dataset on the Analyse-it tab/toolbar to show the Define Dataset wizard.
3. Click Next>.
   
4. Click 1-way table for the layout.
5. Click Next>.
6. Set the Header rows to 1 if a single row (called the headers) contains the names of the groups, or set to 2 if two rows contain the variable and group names.
7. Click Counts to indicate the dataset contains counts (frequencies).
8. Tick Apply Autoformat to apply cell formatting to the dataset to indicate the cells Analyse-it assumes contain variable names and the cells it assumes contain data. Clear the checkbox to leave your own formatting intact.
9. Click Next>.
10. Click Finish to close the Define Dataset wizard.