23994_en-US

liliconcom

Letting Go of Excel: Hello Formula Editor

Mark Chahl MarkSChahl, Senior Staff Engineer, ExxonMobil Chemical    
Jerry Cooper jerry.cooper , JMP Systems Engineer, SAS

 

JMP has a very powerful, easy-to-use Formula Editor, but can be a daunting transition from the world of Excel formulae. So daunting that I used JMP for 16 years before really learning how to use the Formula Editor to do complex calculations six years ago. This beginner-level demo workshop will showcase creating formulas without Formula Editor; Formula Editor basics; use of local variables and parameters; statistical functions; row functions; efficient conditional formula writing and testing; using column properties in formulas; and test functions.

 

 

Data ExplorationRe: Letting Go of Excel: Hello Formula Editor

thanks for sharing.

it`s great topic, but it`s pity that vidoe quality is bad to read

Re: Letting Go of Excel: Hello Formula Editor<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

Erratum / Apology:

During the discussion of using the Loc Sorted() function, I attributed it to Jeff Perkinson. I should have thanked Brady Brady - see post. My sincere apologies to Brady