User Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • DownloadSemiconductor Toolkit: Tools to create wafer maps, add wafer geometry to graphics, explore die defects & compare wafers.
  • Discovery Summit 2026: Early User Edition - September 23-24.Register. It's free.
  • See how to design an experiment, explore factor-response relationships, assess tradeoffs, and ID best settings. Register for Sep. 11 Mastering JMP.

JMP Wish List

We want to hear your ideas for improving JMP. Share them here.
Choose Language Hide Translation Bar
0 Kudos

Excel formula plugin

Status: New Submitted by on ‎07-30-2021 02:56 AM
2 Comments (2 New)

MS Excel has a very intuitive and easy to use formula editor, where you can click on any cell in the table and give it a value of "=" + function. Thus, it is very easy to calculate for instance MEAN or STDEV of a selection of columns (i.e., A1:A10) or rows (i.e., A1:J1).

Would something like that be possible to implement in JMP? Or maybe it is already possible, but I don't know about.

 

2 Comments
Phil_Kay
Staff
Staff
‎07-30-2021 09:28 AM
‎07-30-2021 09:28 AM

Hi @ruskicar ,

Have you seen how easily you can create a formula column by right-clicking on column headers?

You can also set a column to "Group By" so that you can get summary statistics for one column grouped by categories in another column.

I would also refer you JMP is Not a Spreadsheet. There are really good reasons for why JMP works on column-wise basis and not cell-wise. If you need spreadsheet functionality, spreadsheet software will be a better solution.

I hope that is helpful.

Phil

ruskicar
Level III
‎07-30-2021 10:16 AM
‎07-30-2021 10:16 AM

Thanks for some useful links, I read through them quickly and it kind of opened my eyes.