turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Discussions
- :
- data normalization

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Apr 16, 2012 4:29 PM
(3111 views)

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.

Solved! Go to Solution.

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Apr 16, 2012 5:16 PM
(4966 views)

Solution

Hi Ozran,

in the function editor of 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]

2 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Apr 16, 2012 5:16 PM
(4967 views)

Hi Ozran,

in the function editor of 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]

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Apr 16, 2012 6:16 PM
(2483 views)