Can this be done with formula or do I need to write script?

[#1]

I got this data for 3 batches with 72 runs in each batch and maximum absorption is given at time point. I want to make a chart showing what percentage of batch 1, 2 and 3 have absorption less than 10, 10-99.99,100-249.99 like this. Can this be done with a formula or do I need to write JSL for this? Data is attached and below is the table I want.

Absorption       % of batch 1       % of batch 2        %of batch 3

less than 10

10-99.99

100-249.99

[#2 · Accepted solution]

Hi,

This can be done with a formula column using the Conditional and Comparison functions, but there is also a great add-in for creating binning columns that can be found here (https://community.jmp.com/t5/JMP-Add-Ins/Interactive-Binning-V2/ta-p/22495).  I used that to create the bins in your data, and then used tabulate to create the table you wanted (see attached data table below).

[#3]

@HadleyMyers Thank you Hadley for the response. This works and this add-in is really helpful. Appreciate your help.