575963_en-US

liliconcom

Need help with data normalization

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?

 

 

Automation and ScriptingConsumer and Market ResearchMass CustomizationQuality and Process EngineeringRe: Need help with data normalization

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)]

Re: Need help with data normalization

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?

Re: Need help with data normalization

Did you try both of the formulas?

Re: Need help with data normalization

Jarmo,

 

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