The examples in this section use the Companies.jmp sample data table. Before you continue, open this data table.
Note: Double-clicking in a cell is not the same as selecting a cell. A single click selects a cell. You can select more than one cell at the same time, and you can perform certain actions on selected cells. Double-clicking only lets you edit a cell. For more information about selecting rows, columns, and cells, see Selecting, Deselecting, and Finding Values.
1.
|
2.
|
Select the Type column by clicking once on the column heading.
|
3.
|
Select Cols > Utilities > Recode.
|
5.
|
4.
|
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, ...).
In a data table that has thousands or tens of thousands of rows, it can be difficult to locate a particular cell by scrolling through the table. If you are looking for specific information, use the Search feature to find it. If data is matches the search criteria, the cell is selected and the data grid scrolls to show it in the window. For example, the Companies.jmp data table contains information about a company that has total sales of $11,899. Use the Search feature to find that cell.
1.
|
Select Edit > Search > Find to launch the Search window.
|
2.
|
In the Find what box, enter 11899.
|
3.
|
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.
1.
|
2.
|
4.
|
Click OK.
|
JMP selects all of the rows that have Size Co equal to medium. There are seven.
To view or change column characteristics, double-click the column heading. Or, right-click the column heading and select Column Info. The Column Info window appears.
|
|||||||||||
|
|||||||||||
|
|||||||||||
The sample data table On-Time Arrivals.jmp reflects the percent of on-time arrivals for several airlines. The data was collected for March, June, and August of 1999.
2.
|
Right-click the column heading of the new column and select Formula. The Formula Editor window appears.
|
3.
|
From the Table Columns list, select March 1999.
|
4.
|
Click the button on the keypad.
|
5.
|
Select June 1999, followed by another sign.
|
6.
|
Select August 1999.
|
9.
|
10.
|
Click OK
|
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.
1.
|
2.
|
3.
|
4.
|
Click OK.
|
5.
|
From the red triangle menu for profit/emp, select Display Options > Horizontal Layout.
|
Distribution of profit/emp
6.
|
Turn on Automatic Recalc by selecting Script > Automatic Recalc from the red triangle menu for Distributions.
|
7.
|
8.
|
9.
|
10.
|
To filter out the Pharmaceutical companies from the Distribution results, and include only the Computer companies, click the Computer box in the Data Filter window.
|
Conversely, to change the Distribution results to include only the Pharmaceutical companies, click the Pharmaceutical button on the Data Filter window.