Sometimes you want to exclude some rows of data in your dataset. This might be because:
- There is something wrong with the data (you can see from the values that it's been typed in wrong, like if a person's height was set to 12 feet, but you don't know what the right value should have been).
- You want to show just a subset of your data on the graph (you collected data from three classes, but only want to show for two of them)
The Excluded checkbox at the end of each row in the table will exclude a row from the dataset:
Excluded rows are removed from all functions in the tool - graphing, calculations, everything. It's like they weren't there.
Excluding multiple rows
If you need to exclude a lot of rows at once, you can:
- Use a Filter to set the exclude checkboxes dependent on the contents of one or more columns. See this article for details.
- Select all the rows in a range (drag down the left border to select the rows, you can also click on the first row and then shift-click on the final row) and then click any Exclude checkbox in the range to exclude or de-exclude them all at once.
- Or, you can exclude by value of a Categorical column. Open the Values dialog for the column and use the Exclude tools there.