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.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
tsandidge
tsandidge
Level III

How do I get percentage difference by function within JMP platform?

Created: Mar 30, 2023 02:09 PM  |  Last Modified: Jun 8, 2023 5:59 PM (1528 views)

I'm working with a large dataset with a single continuous number column and then multiple nominal columns. I need to understand the % delta (or % difference) in the number column as a result of toggles in the nominal columns.

With the Fit Y by X platform, I can readily add a function to provide the raw difference (as with the t test function), but I can find nothing for the % delta I'm needing. And it seems like this should exist already.

Any platform will work for a solution, but I have too much data to manually create %delta columns in my data table after splitting the number column.

 

Attaching an example chart of what I can produce to find the raw difference as well as attaching a sample dataset.

tsandidge_0-1680199625555.pngtsandidge_0-1680199625555.png

 

JMP Pro 16.1.0

20230330_sample.csv
0 Kudos
0 REPLIES 0

Recommended Articles