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
- :
- How do I divide data on one variable column by val...

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

Sep 16, 2016 1:30 PM
(1170 views)

1 ACCEPTED SOLUTION

Accepted Solutions

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

Sep 16, 2016 1:48 PM
(1508 views)

Solution

Add a new column by either double clicking on the empty column header area to the right of the last column in your data table, or by using the Column pull down menu and selecting "new Column".

Then, right mouse click on the new columns header and select formula. The formula editor will open up. In the column display area in the formula editor, double click on the column you want to be the numerator in your formula. Then click on the divide by symbol, then click on the column that you want to be the denominator. Finally, click on "Apply".

Jim

2 REPLIES

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

Sep 16, 2016 1:48 PM
(1509 views)

Add a new column by either double clicking on the empty column header area to the right of the last column in your data table, or by using the Column pull down menu and selecting "new Column".

Then, right mouse click on the new columns header and select formula. The formula editor will open up. In the column display area in the formula editor, double click on the column you want to be the numerator in your formula. Then click on the divide by symbol, then click on the column that you want to be the denominator. Finally, click on "Apply".

Jim

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

Sep 19, 2016 8:17 AM
(1100 views)