Use the Excel Profiler to visualize models (or formulas) stored in Excel worksheets. You can choose to install the Excel Add-In when you install JMP. Profiling in the Excel Add-In is a two-step process:
1. Click the Create/Edit Model button (Excel 2016 through 2021) to enter information about the model that JMP needs. This needs to be done only once per model. For more information, click Help in the Create/Edit Model window.
2. Click the Run Model button (Excel 2016 through 2021) to launch the JMP Profiler and run the Excel model. See Run the Excel Profiler.
Notes:
• The Preferences, Data Table, Graph Builder, Distribution, Fit Y by X, Fit Model, Time Series, and Control Chart buttons are not needed to profile an Excel model. For more information about these features, see “Import Data Using the Excel Add-In” in Using JMP.
• A JMP ribbon is added to Microsoft Excel when the add-in is installed. If there is no JMP ribbon, install the add-in by double-clicking the JMP installer, selecting Modify, selecting Excel Add-In, and clicking Next.