Learn JMP

Data Blending and Cleanup

• Hide Unused Menus (Windows)

  If there are certain menus that you do not use, you can hide them from the menu toolbar. Select File > Preferences > Menu.Deselect the menus that you want to hide.Click OK. Menu Preferences  

  ruthhummel

  JMP Tips |

  Oct 11, 2023 1:34 PM

  332 views | 0 replies

• Hide Unused Menus (macOS)

  If there are certain menus that you do not use, you can hide them from the menu toolbar. Select JMP > Preferences > Menu.Deselect the menus that you want to hide.Click OK. Menu Preferences  

  ruthhummel

  JMP Tips |

  Oct 11, 2023 1:34 PM

  320 views | 0 replies

• Keyboard Shortcuts for Tools

  To access JMP tools, press the following keys: Arrow tool = aHelp tool = ?Selection tool = sScroller tool = rGrabber (Hand) tool = hBrush tool = bLasso tool = lMagnifier (Zoom) tool = zCrosshairs tool = cRuler tool = d(Text) Annotate tool = tLine, Polygon, and Simple Shape tool = no shortcuts Note: The letter can be lowercase or capitalized.

  ruthhummel

  JMP Tips |

  Oct 11, 2023 1:34 PM

  398 views | 0 replies

• Locate Selected Rows (Windows)

  It is sometimes tedious to scroll through large data tables to find selected cells. To quickly locate the next selected row, press F7. To quickly locate the previous selected row, press F6. These correspond to commands on the Rows menu: Next Selected and Previous Selected. Next Selected Menu

  ruthhummel

  JMP Tips |

  Oct 11, 2023 1:33 PM

  466 views | 0 replies

• Locate Selected Rows (macOS)

  It is sometimes tedious to scroll through large data tables to find selected cells. To quickly locate the next selected row, press both command and }. To quickly locate the previous selected row, press both command and {. These correspond to commands on the Rows menu: Next Selected and Previous Selected. Next Selected Menu

  ruthhummel

  JMP Tips |

  Oct 11, 2023 1:33 PM

  379 views | 0 replies

• Change Multiple Columns Simultaneously

  Apply attributes and properties (such as formulas) to several columns at once: Select the column with the attributes that you want to copy.Select Cols > Standardize Attributes.Click the Attributes button and select the attribute name that you want to copy to the destination columns.Click the button next to Format and select the format that you want to use and any additional options.In the data t...

  ruthhummel

  JMP Tips |

  Oct 11, 2023 1:33 PM

  315 views | 0 replies

• Resize Graphs (Windows)

  To resize several similar graphs in the same window simultaneously, hold the Ctrl key and resize one graph. All the graphs are resized to match the one that you changed. Resizing Graphs Resizing Graphs

  ruthhummel

  JMP Tips |

  Oct 11, 2023 1:32 PM

  488 views | 0 replies

• Resize Graphs (macOS)

  To resize several similar graphs in the same window simultaneously, hold the Command key and resize one graph. All the graphs are resized to match the one that you changed. Resizing Graphs Resizing Graphs

  ruthhummel

  JMP Tips |

  Oct 11, 2023 1:32 PM

  249 views | 0 replies

• Capture a JMP Workflow

  If you find yourself doing the same steps over and over in JMP, capture your steps with Workflow Builder. It is like an advanced macro that records your actions in JMP so that you can replay them or share them with others. Select File > New > Workflow.Click Record to start recording.Perform your steps in JMP, like opening a data table and performing analyses. As you complete an analysis, close the...

  ruthhummel

  JMP Tips |

  Oct 11, 2023 1:32 PM

  510 views | 0 replies

• Preview Updates to Data

  When making changes to your data, you can preview changes before committing them. Preview is available for most of the tasks in the Tables menu. Open a data table.Click Tables and choose a task (Summary, Subset, and so on).Under Preview, make sure Auto Refresh is selected.Select columns and assign them to roles. The preview appears at right.When you are happy with the preview, click OK to perform ...

  ruthhummel

  JMP Tips |

  Oct 11, 2023 1:32 PM

  393 views | 0 replies

• Search JMP

  If you are not sure where to find a statistical procedure, do a search across JMP. Results are tailored to the window that you launch the search from, such as a data table or report. Click Help > Search JMP. Or, press Ctrl+comma on Windows, ^+comma on Mac.Enter your search text.Click the result that contains the procedure that you want. On the right, you can see a description and the location of t...

  ruthhummel

  JMP Tips |

  Oct 11, 2023 1:31 PM

  359 views | 0 replies

• Creating Formulas Hands-on Activities

  These hands-on activities allow you to practice creating formulas using the formula editor inJMP. The data files for the activity are in the zip file attached to this post. Extract the data in Formulas Hands-on Activity.zip for use in the following activities. Click this link for the solutions. A PDF file of these activities and solutions (in English) is attached to this post. 1. A book publisher ...

  Di_Michelson

  Hands-On Activities |

  Jul 24, 2023 11:27 AM

  1164 views | 0 replies

• Creating Formulas Hands-on Activities Solutions

  These hands-on activities allow you to practice creating formulas using the formula editor in JMP. This post contains the creating formulas hands-on activities, the data, and a PDF file of these solutions in English. 1. A book publisher wishes to know if there are more defective books printed on Monday or Friday. Open the Publishing data table and add two formula columns to create the following gr...

  Di_Michelson

  Hands-On Activities |

  Jul 24, 2023 11:26 AM

  551 views | 0 replies

• Powerful Tools for Data Management

  In any analysis problem, most of your time is spent preparing the data for analysis. JMP makes this process easy with powerful data manipulation capabilities. See how to use JMP 17 or JMP Pro 17 to import data from PDF, JSON and text files; add spec limits as a column property; rearrange data; recode problematic values; and filter and graph data. Mac demo: (view in My Videos) This is part of the G...

  Laura_Higgins

  Learning Center |

  Jun 20, 2023 2:37 PM

  1876 views | 0 replies

• Binning Data Using Conditional IF-THEN Statements

  Learn more in our free online course:
  Statistical Thinking for Industrial Problem Solving
  
  (view in My Videos)   In this video, you learn how to create an IF-THEN formula to bin continuous data using the file Measles.jmp.   This data table includes data on the incidence of measles in the United States from 1928 to 2011. In this scenario, we want to create a new variable that groups data into three ...

  julian

  Statistical Thinking for Industrial Problem Solving |

  Jun 8, 2022 8:22 PM

  8273 views | 1 replies

• Getting Started with JMP

  This is an ideal introduction to JMP for the new user or as a refresher for the infrequent user. This topic covers the basics of the JMP interface and data tables, getting data into JMP, doing basic summary analysis and charting, saving and sharing your work, and where to get help on JMP.   (view in My Videos)   Additional details can be found in the JMP Documentation - Discovering JMP.    This ...

  Chris_Kirchberg

  Learning Center |

  May 16, 2022 11:52 AM

  7793 views | 0 replies

• Get Going with JMP: Essentials for Using JMP

  These videos provide JMP essentials for new users and those who want a refresher.    Overviews Getting Started With JMPNEW! JMP Tips and Tricks (JMP 18)Better JSL Smoother Migration: How To Fix Your Own Code​   Automating Your Analysis WorkflowWhat’s New in JMP 17 Data Preparation NEW!  From Excel to JMP: Importing, Consolidating and Maximizing the Value of Excel Data Using Formulas to Get the Mos...

  Laura_Higgins

  Learning Center |

  May 11, 2022 10:30 AM

  8883 views | 0 replies

• Interactive Binning - New in JMP 16

  In this video, see how to create a new categorical variable from a continuous variable.  The capabilities are available on Mac and Windows.  View the demo for the operating system of your choice. Windows Demo: (view in My Videos)   Mac Demo: (view in My Videos) Use the Cols menu, after selecting a column, to launch the Binning Interface.   Interactive Binning lets us create and move cutpoints i...

  Laura_Higgins

  Learning Center |

  Sep 13, 2021 6:40 AM

  3656 views | 0 replies

• Comparing Data Tables - New in JMP 16

    Beginning with JMP 16, JMP offers the ability to interactively compare data tables by comparing columns with different names showing the results in a table.   Highlights    Compare Data Tables utility has a more flexible interface with increased functionality to align rows with a key rather than automatically matching rows and compare columns with different names.Comparison results are shown ...

  ryandewitt

  Learning Center |

  May 3, 2021 6:03 AM

  4037 views | 0 replies

• Creating Formulas in JMP

  (view in My Videos)   This page describes two methods for creating formulas in JMP. Formulas are used to create transformed or derived variables using built-in functions, constants and/or existing variables.     Method 1 (Create Formula With Formula Editor) From an open JMP data table, select Cols > New Column.Under Column Name, assign a name for the column. In this example, we name the column %p...

  julian

  Learning Center |

  Jul 2, 2020 1:27 PM

  19265 views | 0 replies

• Transforming Data

  Learn more in our free online course:
  Statistical Thinking for Industrial Problem Solving
  
  (view in My Videos)   In this video, you learn two methods for transforming data: using virtual columns in analyses and using New Formula Column from the data table.   For this video, we use the file Queue Time.jmp. This file includes information about queue times for 100 batches of parts in a machining opera...

  julian

  Statistical Thinking for Industrial Problem Solving |

  Jun 10, 2020 9:29 AM

  9869 views | 0 replies

• Joining Data Tables

  Learn more in our free online course:
  Statistical Thinking for Industrial Problem Solving
  
  (view in My Videos)   In this video, you learn how to join two files together using a matching column.   The file Rejects.jmp has information about rejected parts by order number, item number, and reject code. This is your working data table.   The reject codes are two-digit codes, but they’re not descriptive...

  julian

  Statistical Thinking for Industrial Problem Solving |

  Jun 10, 2020 9:27 AM

  6252 views | 0 replies

• Concatenating Data Tables

  Learn more in our free online course:
  Statistical Thinking for Industrial Problem Solving (view in My Videos) In this video, you see how to concatenate two data tables.   The working file, with reject data over the previous four months of the year, is stored in Rejects Data.jmp.   You would like to add new data, stored in Rejects Data New.jmp, to your original data table.   Because the two files h...

  julian

  Statistical Thinking for Industrial Problem Solving |

  Jun 10, 2020 9:26 AM

  3362 views | 0 replies

• Stacking and Splitting Data

  Learn more in our free online course:
  Statistical Thinking for Industrial Problem Solving
  
  (view in My Videos)   In this video, you learn how to stack data for analysis using the file Particles.jmp.   In this scenario, you have particle data for five samples per polymer, and your data for the polymers are stored in separate columns in a data table.   You want to stack the data so that the polymer l...

  julian

  Statistical Thinking for Industrial Problem Solving |

  Jun 10, 2020 9:25 AM

  4527 views | 0 replies

• Using Recode

  Learn more in our free online course:
  Statistical Thinking for Industrial Problem Solving
  
  (view in My Videos)   In this video, you learn how to use Recode to clean supplier names in the file Components.jmp.   First, let’s take a look at the supplier names using the Distribution platform from the Analyze menu. You can see that there are 10 levels (or categories) of supplier, and that 10 observation...

  julian

  Statistical Thinking for Industrial Problem Solving |

  Jun 10, 2020 9:24 AM

  4275 views | 0 replies