Exclude & Include

Command: Tools
Next selectExclude (Include)

Description

If you need to exclude data from statistical analysis, then you:

  • Select the data to exclude in the spreadsheet; the selection may either be a range of cells, or one or more complete rows (cases).
  • Select the Exclude command in the Tools menu.

To include data that have been excluded, you:

  • Select the data to include in the spreadsheet; the selection may either be a range of cells, or one or more complete rows (cases).
  • Select the Include command in the Tools menu.

Data that have been marked as excluded in the spreadsheet will be displayed in red, but you can select a different color in the Format spreadsheet box.

The Exclude and Include commands are also available in the spreadsheet shortcut menu (after right-clicking).

Exclude - Include data

In the following example the age for case 4 has been excluded. In addition, cases 6 and 7 are entirely excluded.

Exclude - Include data

See also

This site uses cookies to store information on your computer. More info...