Letting Go of Excel: Hello Formula Editor

[#1]

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.

[markschahl]

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

[juna1]

thanks for sharing.

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

[markschahl]

Discovery Summit 2016 Resources

Discovery Summit 2016 is over, but it's not too late to participate in the conversation!

Below, you'll find papers, posters and selected video clips from Discovery Summit 2016.