nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

To label outliers and export to Excel spreadsheet

JohnP

Good day, can you help with a question in exporting/labeling ourliers?

As the screenshot, the Outliers were identified by using Analyze > Screening > Explore Outliers. They are excluded in the table. How can I export the data into an Excel spreadsheet with these Outliers identified, (for example in a new column)

Thank you.

Accepted answers

ian_jmp

Sorry to not be sufficiently clear.

Once you have made your 'Row State' column ('Column 3' in your case), did you actually move the current row states to this column using the 'star' icon mentioned above? From your screenshot, it looks like, for example, row 6 has been excluded, yet this row for 'Column 3' might be empty (shown as a '.') - But it's a bit hard to tell because the column name is truncated in the middle image . . .

All comments

ian_jmp

This script shows the steps:

NamesDefaultToHere(1);

// Get some data and make some 'outliers'
dt = Open("$SAMPLE_DATA/Big Class.jmp");
dt << selectRandomly(10) << Exclude;
dt << ClearSelect;

// Maake a new 'row state' column
oc = dt << NewColumn("Outliers", Row State);

// Copy the current row states to this column
oc << CopyFromRowStates;

// Export to the desktop
dt << Save("$DESKTOP/Big Class.xlsx");

Interactively, you need 'Cols > New Columns...', then click on the star next to the column name (in the Columns Panel) and 'Copy from Row States'.

JohnP

@ian_jmp , thank you!

but seems I don't have a star next to the column name?

ian_jmp

Change the 'Data Type' of the column to 'Row State' using the drop down list.

ledi_trutna

To add to Ian's reply, once you have the row state column and have copied the row states to that column using the red star in the columns panel and Copy from row states, you might want to make one more column that reads the row state column and returns a 1 or 0 based on the Excluded state.

The formula Excluded under the Rows State group in the formula editor will return a 1 or 0 based on the row state column having the Excluded option.

Otherwise, when I tried to copy JMP data back to Excel it gives a code of the color or the color and excluded property that was not as easy to interpret as a 1 and 0.