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.
  • Use JMP Clinical with CDISC-compliant data. Review studies, ID safety and efficacy signals & communicate findings with interactive graphics. Register to see how. Aug. 27, 2 pm US ET.

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 (1510 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.png

 

JMP Pro 16.1.0

20230330_sample.csv
0 Kudos
0 REPLIES 0

Recommended Articles