You can use the JMP Add In for Excel to transfer a worksheet from Excel to the following JMP destinations:
• a data table
• Graph Builder
• Distribution platform
• Fit Y by X platform
• Fit Model platform
• Time Series platform
• Control Chart platform
You can also create models for profiling in JMP. See “Excel Profiler” in Profilers.
To transfer data from Excel to a JMP data table and platform
1. In your Excel worksheet, show the JMP add-in on the ribbon.
2. Click the Preferences button.
3. Accept the default Data Table Name (File name_Worksheet name) or type a name.
4. Select Use the first rows as column names if the first row in the worksheet contains column headers.
5. If you selected to use the first rows a column headers, type the number of rows used.
6. Select Transfer Hidden Rows if the worksheet contains hidden rows to be included in the JMP data table.
7. Select Transfer Hidden Columns if the worksheet contains hidden columns to be included in the JMP data table.
8. Click OK to save your preferences.
9. Select the cells to transfer into JMP, including any cells that you want to use as column names.
If you are using cells as column names, they need to be the first rows in your selection.
If only one cell (or no cell) is selected, the entire Excel worksheet is transferred to JMP.
10. Select the JMP destination from the toolbar:
– Data Table
– Graph Builder
– Distribution platform
– Fit Y by X platform
– Fit Model platform
– Time Series platform
– Control Chart platform
JMP opens, and the selected data is placed in a new JMP data table and the selected launch window appears.
Notes:
• Empty cells are imported as missing data, and dates, numbers, and strings are recognized correctly.
• Your JMP windows might be hidden behind your Excel window, especially if you maximize Excel.
For more information about using the various JMP platforms, refer to the proper JMP documentation.