turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- JMP Discovery Summit Series
- :
- Discovery Summit 2016 Presentations
- :
- Letting Go of Excel: Hello Formula Editor

Aug 4, 2016 12:23 PM
(2976 views)

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.

Comments

10-05-2016
01:24 PM

- Mark as Read
- Mark as New
- Bookmark
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

10-05-2016
01:24 PM

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

07-26-2017
04:28 AM

- Mark as Read
- Mark as New
- Bookmark
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

07-26-2017
04:28 AM

thanks for sharing.

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

Article Labels

Article Tags

- Article History
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Email to a Friend
- Printer Friendly Page
- Report Inappropriate Content