The examples in this section use the sample data table. Before you continue, open this data table.
Select Help > Sample Data Library and open
Select the Type column by clicking once on the column heading.
Select Cols > Utilities > Recode.
Click Done and select the In Place option from the list.
Recode Window
Select Fill > Repeat sequence to end of table.
To continue a pattern instead of repeating it (1, 2, 3, 4, 5, 6, ...), select Continue sequence to end of table. This command can also be used to generate patterns like (1, 1, 1, 2, 2, 2, 3, 3, 3, ...).
Deselecting Rows
Deselecting Columns
Select Edit > Search > Find to launch the Search window.
In the Find what box, enter 11899.
Click Find. JMP finds the first cell that has 11,899 in it, and selects it.
If multiple cells meet the search criteria, click Find again to find the next cell that matches the search term.
Select Rows > Row Selection > Select Where to open the Select rows window.
Select Rows Window
JMP selects all of the rows that have Size Co equal to medium. There are seven.
Column Info Window
Numeric specifies the column values as numbers.
Character specifies the column values as non-numeric, such as letters or symbols.
Row State specifies the column values as row states. This is an advanced topic. See Using JMP.
Continuous values are numeric only.
Ordinal values are either numeric or character, and are ordered categories.
Nominal values are either numeric or character, but not ordered.
Best lets JMP choose the best display format.
Fixed Dec specifies the number of decimal places that appear.
Date specifies the syntax for date values.
Time specifies the syntax for time values.
Currency specifies the type of currency and decimal points that are used for currency values.
The sample data table On-Time reflects the percent of on-time arrivals for several airlines. The data was collected for March, June, and August of 1999.
Right-click the column heading of the new column and select Formula. The Formula Editor window appears.
Formula Editor
Click the button on the keypad.
Select June 1999, followed by another sign.
Select August 1999.
Sum of the Months
Entire Formula Selected
Completed Formula
The Formula Editor has many built-in arithmetic and statistical functions. For example, another way to calculate the average on-time arrival percentage is to use the Mean( ) function in the Statistical functions list. For details about all of the Formula Editor functions, see Using JMP.
Use the Data Filter to interactively select complex subsets of data, hide these subsets in plots, or exclude them from analyses. For example, look at profit per employee for computer and pharmaceutical companies.
Select Help > Sample Data Library and open
Select Analyze > Distribution.
Select profit/emp and click Y, Columns.
From the red triangle menu for profit/emp, select Display Options > Horizontal Layout.
Distribution of profit/emp
Turn on Automatic Recalc by selecting Script > Automatic Recalc from the red triangle menu for Distributions.
In the data table, select Rows > Data Filter.
Select Type and click Add.
Clear Select and select Include.
Filter for Computer Companies