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.
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.
When the dataset is arranged on the Excel worksheet the next step is to define the range as a dataset.
To define the dataset: