Using JMP • Enter and Edit Data • Organize Data • Exclude Rows
Previous
 • 
Next
Exclude Rows
Apply the Excluded row state to rows that you do not want to include in subsequent calculations. Plots are recalculated without the excluded rows. Note the following:
•
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 and 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, 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.
•
When you Exclude rows, a circle with a strikethrough () appears beside either the row number.
•
Rows remain excluded until you highlight the rows and select Exclude/Unexclude again.
To exclude one or more rows
1.
Select rows that you want to exclude.
2.
Do one of the following:
–
Right-click on the highlighted area next to the row numbers and select Exclude/Unexclude.
–
From the Rows menu, select Exclude/Unexclude.

Previous
 • 
Next
Help created on 9/19/2017