Exclude Rows in Data Tables
Apply the Excluded row state to rows that you do not want to include in subsequent calculations. Statistics are recalculated without the excluded rows.
To exclude one or more rows, follow these steps:
1. Select rows that you want to exclude.
2. Do one of the following:
– Right-click the highlighted area next to the row numbers and select Exclude/Unexclude.
– From the Rows menu, select Exclude/Unexclude.
Notes:
• In most cases, when a row is represented by a point or an individual plot element, excluding the row does not hide it in plots.
• In Graph Builder, when a plot element is represented by a group of rows, the plot is reconstructed using only the unexcluded rows. The plot also does not display plot elements corresponding to the excluded rows. Excluded rows are treated as if they are both hidden and excluded.
• Plots found under the Graph menu (with the exception of Profilers, Parallel Plot, and Scatterplot Matrix) are immediately recalculated to reflect excluded rows.
• For many platforms, reports and plots are not updated immediately to reflect excluded observations. You need to rerun the analysis to recalculate plots and analysis results.
• When you Exclude rows, they are excluded in all open plots and reports that are updated immediately.
• A circle with a strikethrough (
) appears beside the row number of an excluded row.
• Rows remain excluded until you highlight the rows and select Exclude/Unexclude again.