I have a table with column F1 to F10 which contains temperature in Fahrenheit, I would like to create another sets column C1 to C10 in Celsius within the same table. How can I do that?
Quite many options. There are addins (to my knowledge) which could do this, you could write a script or you could do it interactively in JMP by stacking your data, renaming columns, adding new column to calculate C and then splitting the data back.
Start data:
Stacked data with some cleanup (Recode columns to remove F from Label and new C column to perform calculations)
Split final data
