topic Row level normalization using a column level median value in Discussions

Row level normalization using a column level median value

Ekarshalev — Thu, 08 Jun 2023 16:39:01 GMT

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.

Re: Row level normalization using a column level median value

jthi — Thu, 02 Feb 2023 18:20:23 GMT

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

Re: Row level normalization using a column level median value

Ekarshalev — Fri, 03 Feb 2023 17:14:42 GMT

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