topic Re: Need help with data normalization in Discussions

Need help with data normalization

sumanthcb141977 — Sat, 10 Jun 2023 23:57:44 GMT

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?

Re: Need help with data normalization

jthi — Thu, 01 Dec 2022 19:35:52 GMT

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

sumanthcb141977 — Thu, 01 Dec 2022 19:46:07 GMT

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

jthi — Thu, 01 Dec 2022 20:10:13 GMT

Did you try both of the formulas?

Re: Need help with data normalization

sumanthcb141977 — Thu, 01 Dec 2022 20:20:06 GMT

Jarmo,

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