Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted
optoman
Level I

data normalization

Hi All,

I'm very new to JMP. I am using 9.0.3 version.

I want to normalize my data, using one of the cells in the same data set.

Is there a function/script to do this ?

Thanks for your help,

Ozan.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
ron_horne
Super User

Re: data normalization

Hi Ozran,

in the Formula Editor for a column you can get built in references to many typical values of a variable by selecting "statistical" group of functions (i.e. col mean, col median, col max, col min and so on).

if you want to give a reference to a specific cell that is not the a regular parameter of a variable you need to slowly click twice in formula so it becomes a script and ad the number of the row in [].

for example, this column formula will divide each cell of the column "60 min" by the 25th cell of "90 min"

:Name("60 min") / :Name("90 min")[25]

 

Remember though that JMP is Not a Spreadsheet

View solution in original post

3 REPLIES 3
Highlighted
ron_horne
Super User

Re: data normalization

Hi Ozran,

in the Formula Editor for a column you can get built in references to many typical values of a variable by selecting "statistical" group of functions (i.e. col mean, col median, col max, col min and so on).

if you want to give a reference to a specific cell that is not the a regular parameter of a variable you need to slowly click twice in formula so it becomes a script and ad the number of the row in [].

for example, this column formula will divide each cell of the column "60 min" by the 25th cell of "90 min"

:Name("60 min") / :Name("90 min")[25]

 

Remember though that JMP is Not a Spreadsheet

View solution in original post

Highlighted
optoman
Level I

Re: data normalization

Thanks Ron. It worked.

Highlighted
sbarnes
Level I

Re: data normalization

Thank you! That was a huge help.
Article Labels

    There are no labels assigned to this post.