I've a VERY novice JMP script writer trying to write a command to average a set of columns into a new column with the averages. This is equivalent to highlighting the columns, then selecting New Formula Column > Combine > Average. However, I can't find anything in the script library or online that lets me do this. Anyone have any suggestions?
To add an additional complication, I want the script to take columns 2-11, 12-21, 22-31, etc. and average each column group. The columns do not have set names, so I can't just put the column names into the script (it's not possible to make the names consistent because the column names are sample names and I need to keep them that way). The number of column groups in each JMP file is not consistent because the number of samples in each JMP file can vary widely. Is there a simple way to do this?
I'm using JMP 17.0.0 on a Mac if that's helpful. Any help is appreciated!
