Our World Statistics Day conversations have been a great reminder of how much statistics can inform our lives. Do you have an example of how statistics has made a difference in your life? Share your story with the Community!
Choose Language Hide Translation Bar
Community Manager Community Manager

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



Article Tags

Use Videos and Resources to Practice JMP, JMP Pro, JMP Clinical and JMP Genomics.

1-hour live Mastering JMP webinars occur most Fridays from January through October. After each session, we hope you will use the video and resources shared by the presenting JMP Systems Engineers to practice what you saw.

Mastering JMP Videos are available here.