Row level normalization using a column level median value

[#1]

Hello All,

Was wondering what is the approach to make a script that would do the following in JMP.

Let's say I have a column of values representing a population. I want to find the median of that population and then create a new column which takes each individual row value in the original column and divides it by the same median value for every row and saves it to the new column. In effect it is a normalization to the median value. 

I know I can use tabulate or the summary tables to find the median but was hoping to be able to put into a script button which would analyze same name columns across differently named sheets.

Thanks in advance.

[#2]

Col Median() gets you median of a column. One fairly easy way to create the column is to use New Formula Column shortcut

First create only Median column and then edit the column properties (name, formula format) to fit your needs

[#3]

Thanks for the suggestion. I will give the Col Median command a go