You are viewing documentation for the old version 2.30 of Analyse-it. If you are using version 3.00 or later we recommend you go to the latest documentation.

Arranging a 2-way Table dataset

ADVANCED

The 2-way table dataset is an extension of the table dataset with an additional factor on the rows of the dataset.

EXAMPLE  The two-way table dataset below contains a dependent variable: Weight classified by two factors, Drug: A, B & C, and Sex: M F. The groups for Drug are placed on first row of the dataset, the groups for the factor Sex on the first column of the dataset, and the data for the groups in the cells.

(click to enlarge)

When entering the group names for a factor, only the first cell where the group applies needs to be labelled. Any blank cells below or to the right will assume the same group name.

EXAMPLE  In the above example the group M on row 2 applies to row 3, and similarly F on row 4 applies to row 5.

Using two Header rows

As in the case for the table dataset, when a single row is used to name the groups Analyse-it cannot determine the names of the variables. In the example above it cannot determine what the groups A, B, & C and M & F represent and instead it assumes generic names.

The solution is to use an additional header row to hold the names of the variables. The name of the factor across the columns is placed in the cell above the first group on the columns, the name of the factor down the left of the rows is placed in the cell above the first row group, and the name of the observed variable is placed in the top-left cell of the dataset. Analyse-it will then pick-up the names of the variables.

EXAMPLE  The dataset below is the same as before except an extra row has been added to hold the variable names. The name of factor on the columns Drug is placed above the first group A, the name of the factor on the rows Sex is placed above the group M, and the name of the dependent variable Weight is placed in the top left cell.

(click to enlarge)

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 (click to enlarge) on the Analyse-it tab/toolbar to show the Define Dataset wizard.
  3. Click Next>.
  4. Click 2-way table for the layout.
  5. Click Next>.
  6. Set 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 Observations to indicate the dataset contains observations.
  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.

(click to enlarge)