Need help with data normalization

[#1]

I have a simple table and Im trying to normalize the Voltage for each SN. I want to divide the voltage data by the first voltage value for each SN.

For example,

for SN = A, Normalized Voltage = 26.75/26.75 = 1, 27.21/26.75, 27.57/26.75, 26.93/26.75,

for SN = B, Normalized Voltage = 26.52/26.52 = 1, 26.71/26.52 and so on.....

Is there a way to do this using the row and column functions in jmp? or is a jmp script required?

[#2 · Accepted solution]

If the first voltage is always first you can just use with byVar Col Min() (Column3) and if it isn't then a bit more complicated formula should work (Column4)

Column3:

:V / Col Min(:V, :S)

Column4:

:V / :V[Col Min(Row(), :S)]

[#3]

Jarmo.

Thanks for the feedback. The formula you shared works if the 1st data point is the minimum for the particular S. However if that is not the case, how would you approach the formula?

[#4]

Did you try both of the formulas?

[#5]

Jarmo,

The Formula for Column4 is the one that works! Thanks a lot for your inputs