Exclude Rows

JMP Support 800.450.0135 (US)

Documentation Feedback
Your feedback is important to us. us any comments about our documentation.

Using JMP • Enter and Edit Data • Organize Data • Exclude Rows

•

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 on 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 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, 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.

•

Help created on 7/12/2018