cancel
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 jmp.com/mastering 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.

 

Resources:

 

 

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

 

Resources 

Recommended Articles