Arranging a List dataset

In its simplest form the list dataset uses a separate column for each variable, a separate row for each case or subject, and a single row of headers for the names of the variables.

EXAMPLE  The list dataset below contains 5 variables: ID, Sex, Drug, Before and After. The variable names are placed in the first row of the dataset, with observations for each variable in the column below.

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 List for the layout.
5. Click Next>.
6. Set Header rows to 1 to indicate a single row contains the names of the variables (called the headers).
7. 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.
8. Click Next>.
9. Click Finish to close the Define Dataset wizard.