Showing results for 
Show  only  | Search instead for 
Did you mean: 

Practice JMP using these webinar videos and resources. We hold live Mastering JMP Zoom webinars with Q&A most Fridays at 2 pm US Eastern Time.See the list and register. Local-language live Zoom webinars occur in the UK, Western Europe and Asia. See your country site.

Choose Language Hide Translation Bar
Using Formulas to Get the Most from Your Data


See how to:

  • Develop familiarity with foundational column formula concepts
    • Expression that dynamically computes values stored in a column, often based on other columns' values
    • Part of Column Properties
    • Specified in Column, not in each cell
  • Understand sequence for creating formulas
    • Standard formulas available: Right click >New Formula
    • Formula Editor (calculator) available for building custom formulas
    • Specify formula in formula box where you can create w/ point-and-click or double-click to type manually
    • Blue highlight shows selection scope
    • Column List shows available columns and red triangle lets you filter
    • Keypad gives common mathematical operations and formula editing actions
    • Function List groups functions by type and is browsable, searchable, customizable
  • ·Envision how you can use column formulas with your data – what formulas can help you do – using Population Data Case Study


Note: Q&A is included at times 24:07, 24:41, 43:06, 43:49, 44:18 and 44:40.





See how to:

  • Create formulas interactively without using Formula Editor
  • Use the Formula Editor, hover help, common numeric and character functions, and interactive formula function filters
  • Use a combination of JSL and Add-Ins to extend JMP formula functionality 
  • Use formulas in a case study of fluid levels measured at one minute intervals where the goal is to automatically determine the vessel state (filling, emptying, or holding) at any given time
  • Change formulas and see auto recompute
  • Use local and table variables in formulas



Recommended Articles