Hello,
I am hoping to get some help on the following:
Attached JMP file with the following table.
![pkl_jmp_0-1694450384560.png pkl_jmp_0-1694450384560.png](https://community.jmp.com/t5/image/serverpage/image-id/56478iA993A9308E8F9346/image-dimensions/746x155?v=v2)
My typical/starting data set contain:
1. an identifier "Type"
2. a set of unknown number of columns with same prefix and various number suffix, e.g. A num1, A num2, A num3...
3. a second set of the same number of columns as in #2 above, with same prefix and matching suffix as in #2, e.g. B num1, B num2, B num3...
May I get some help to write a jsl script to generate the columns to pair up the set A and set B column to calculate:
Formula( (:B 1.0 - :B 0.5) / (:A 1.0 - :A 0.5) ) ),
Formula( (:B 1.3 - :B 0.5) / (:A 1.3 - :A 0.5) ) ),
Formula( (:B 1.3 - :B 1.0) / (:A 1.3 - :A 1.0) ) ),
Then, generate an Average column ("B/A Avg") to take the mean of all columns created. Noted that the generate columns above may be any number. It could be 3, or 2, or 6...
At the end of the day, I am mostly interested to get the final column of "B/A Avg", the interim columns are optional if that simplify the script.
Please let me know if I may clarify anything in my questions. Thanks a lot in advance.