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 Table dataset


In contrast to the list dataset, where separate columns are used for each variable, the table dataset uses separate columns for the observations from each group of a factor. The data presented as a table dataset can always be re-arranged as a list dataset, although the table layout is often easier to read.

EXAMPLE  The table dataset below contains a dependent variable: Weight observed for a factor Drug with groups A, B, & C. Group names are placed on the first row of the dataset, with the data for each group in the column below.

(click to enlarge)

Using two Header rows

The example above shows the simplest form of table dataset, where the names of the groups are placed on a single worksheet row. The only limitation with this layout is Analyse-it cannot determine the names of the variables in the dataset and instead it assumes generic names.

The solution is to use an additional header row to hold the names of the variables. The additional row is placed above the group names, with the leftmost cell containing the name of the variable, followed by the word " by ", followed by the name of the factor. Analyse-it will then pick-up the names of the variables.

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, Weight, followed by the word " by ", followed by the factor name, Drug.

(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 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 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)