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
- :
- how to script a new normalized column

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
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Dec 16, 2009 4:27 PM
(914 views)

New Window( "Distribution",

V List Box(

Distribution(

Continuous Distribution(

Column( :Name( "Brain ChE" ) ),

Histogram( 0 ),

Vertical( 1 ),

Outlier Box Plot( 0 )

),

Where( :Name( "Dose mg/kg" ) == 0 )

),

)

);

2 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Dec 17, 2009 1:37 PM
(840 views)

:Y / Col Mean(If(:Group == "c", :Y, Empty()))

In scripting you can create a new column and make the new column have this formula. See page 124 of the scripting docs for examples of creating a new column with a formula.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Dec 23, 2009 10:10 PM
(840 views)

For data with numerical values (as I have) for the controls, here is my revision of your one-liner, where dose=0 identifies the control group.

:Brain / Col Mean( If( :dose == 0, :Brain, Empty() ) )