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: 
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • Your voice matters! Tell us how you prefer to receive JMP updates, so we can tailor our communication to your needs. Take short survey.
  • See how to access JMP Marketplace - and - find, create & share add-ins to extend your JMP. Watch video.

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 (1493 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