Skip to main content
Mail a PDF copy of this page to:
(Your email address will not be added to a mailing list)
Show menu

Exclude & Include

Next selectExclude (Include)


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

To include data that have been excluded, you:

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

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

Mark cases for exclusion

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

Mark cases for exclusion

See also