In JMP, data points are organized into rows and columns referred to as the data table. A data table has two parts: the data table panels at left and the data grid at right.
•
|
Change the default size and font for names and values selecting File > Preferences > Fonts. (On the Macintosh, select JMP > Preferences > Fonts.)
|
These panels are located on the left of the data grid. They contain information about the table and its contents. Each panel has interactive areas. See Interacting with the Data Table Panels.
Creates a new table variable, which can be text or any other constant character value that you always want to be available in the data table. Table variables are normally used to document tables. Using the Formula Editor, you can incorporate table variables into formulas or JSL scripts. See Use Table Variables in Enter and Edit Data for more information.
Creates a JSL script to save with the data table. Using the Formula Editor, you can incorporate these scripts into formulas. After selecting this command, name the script and type in the value (the JSL commands). After you click OK, the new script is listed in the Table panel and you can click its red triangle menu to run, edit, or delete it. See Create and Save Scripts in Enter and Edit Data.
Locks the data table so that data and column properties cannot be edited or added. You can still run analyses, assign characteristics, add rows and columns, and so on. See Lock Tables in Enter and Edit Data.
Compresses the data table when it is saved. After the data table is saved, a compressed file icon appears next to the data table name in the table panel. See Compress Tables in Enter and Edit Data.
Tip: You can also configure JMP to always use GZ compression when saving tables by selecting Preferences > General > Save Data Table Columns GZ Compressed.
Note: The Compress file when saved option only decreases the file size. This command does not affect the memory required to analyze the data. To reduce both the file size and memory required for analyzing, use Cols > Utilities > Compress Selected Columns. See Compress Selected Columns in Enter and Edit Data.
•
|
Column options (same options as the Cols menu)
|
•
|
•
|
Indicates that points on plots corresponding to the column are labeled by the value instead of the row number. See Label Rows and Columns in Enter and Edit Data.
Indicates that the column is excluded from the calculations. See Exclude Rows and Columns in Enter and Edit Data.
Indicates that the column is not included in graphs. See Hide Rows and Columns in Enter and Edit Data.
Can be X or Y. Indicates that the column has been assigned the preselected role of x or y. See Assign a Preselected Analysis Role in The Column Info Window.
Indicates that the values in the column result from a formula. When formula evaluation is suppressed, the icon appears gray. Double-click to view and edit the formula. See Use Formula Editor Options in Formula Editor.
Indicates that the range check or the list check option is turned on. Click to view and edit the range or list. See Range Check in The Column Info Window and List Check in The Column Info Window.
Indicates that the column has been assigned the preselected role of weight. See Assign a Preselected Analysis Role in The Column Info Window.
Indicates that the column has been assigned the preselected role of frequency. See Assign a Preselected Analysis Role in The Column Info Window.
•
|
Row options (same options as the Rows menu)
|
Right-click the categories in the Rows panel to select rows, clear the selection, or to create a data view.
A data view creates a linked subset of the main data table. For example, if several rows are marked hidden, you might want to open a window that shows you only the hidden rows. Right-click Hidden in the Rows panel and select Data View.
The data grid is the main part of the data table that contains your data. Interacting with the Data Grid illustrates how to interact with the data grid. See also Select Rows in Enter and Edit Data.
Assigns the same attributes or properties to all of the selected columns. See Standardize Attributes and Properties Across Columns in The Column Info Window.
Contains a list of column properties. Select one to open the Column Info window and apply it to the column. This list is also available from the Column Info window. See Column Properties in The Column Info Window.
Contains a list of modeling types. Select one to apply it to the column. See About Data Types and Modeling Types in The Column Info Window.
Contains a list of roles. Select one to apply it to the column. See Assign a Preselected Analysis Role in The Column Info Window.
Converts the column to a formula column. See Make New Formula Column in Enter and Edit Data for details.
(Applicable only if the Value Labels property is set) Shows or hides value labels in the data table.
Labels or unlabels selected columns in all plots. See Label Rows and Columns in Enter and Edit Data.
Scroll lock locks a column in place so that when you scroll horizontally, the column remains visible. See Lock Columns in Place in Enter and Edit Data.
Hides or shows selected columns in all plots and graphs. See Hide Rows and Columns in Enter and Edit Data.
Excludes or includes selected columns from analyses. See Exclude Rows and Columns in Enter and Edit Data.
Pastes all of the copied column properties into the selected adjacent or non-adjacent columns. For example, select column one and column two and then select Copy Multi Column Properties. Select column three and column five and then select Paste Multi Column Properties. Column one properties are pasted into column three. Column two properties are pasted into column five.
Hides the selected rows in all plots and graphs and excludes them from analyses. See Hide and Exclude Rows in Enter and Edit Data.
Excludes or includes selected rows from analyses. See Exclude Rows and Columns in Enter and Edit Data.
Hides or shows selected rows in all plots and graphs. See Hide Rows and Columns in Enter and Edit Data.
Provides a color palette. Select a color to apply it to the selected rows. The color is used in plots and graphs. See Assign a Color to Rows in Enter and Edit Data.
Provides a palette of markers or symbols. Select a marker to apply it to the selected rows. The marker is used in plots and graphs instead of points. See Add Markers to Rows in Enter and Edit Data.
Colors the row the same as the current row state color. For more details, see Assign Colors or Markers to Rows Based on Column Values in Enter and Edit Data.
Removes all selected rows from the data table. Use the Undo command on the Edit menu to undo an accidental deletion. See Delete Rows and Columns in Enter and Edit Data.
‒
|
The cursor changes form when you move the mouse over values in columns that have data validation in effect. It becomes a small, downward-pointing arrow on a column with list checking. When you click, the value is highlighted and the cursor becomes the I-beam. Enter or edit data as usual with any values defined as valid text or valid numbers. See List Check in The Column Info Window, for details.