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