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.
JMP Pro 16.1.0