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
- :
- Can you "do math" in a data table?

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

Jan 6, 2016 12:17 PM
(5160 views)

So far, I haven't found anything in the tutorials that tells me I can, but I thought I'd ask anyway.

If I have imported a csv file into a data table, can I add the values of cells together, or set a cell equal to another cell like I can with excel?

Solved! Go to Solution.

2 ACCEPTED SOLUTIONS

Accepted Solutions

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

Jan 6, 2016 1:32 PM
(9620 views)

Solution

natalie_,

The answer is yes. JMP has many functions that you can invoke for summing rows, columns, etc. It is is little different if you want to, for example, add cells that are in different rows but it still can be done. In the simple example below, I created Column 1 as a list 1 through 9.

Then I used one of the many built-in functions available in the Formula Editor to square Column 1.

You can add, subtract disparate cells in JMP but it's a little different than Excel. I add the first rows of Column 1 and Column 2 in the Sum Column by typing directing in the JMP file: =:Column1 + :Column 2 (i.e, 1+1=2). To demonstrate addition of non contiguous cells I typed in Row 3 of the Sum column the following formula: =Column 1[2] + :Column 2[4]. This last example adds the element in the second row in the Column 1 to the fourth element of Column 2.

Hope this helps. There are many ways to 'do math' in JMP.

Dave

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

Jan 6, 2016 1:41 PM
(5448 views)

Solution

JMP data tables are more structured than a spreadsheet. Each row is assumed to be independent of every other row. So, formulas (math) are applied to an entire column, not an individual cell.

You create a formula column using the Formula Editor.

-Jeff

6 REPLIES

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

Jan 6, 2016 1:32 PM
(9621 views)

natalie_,

The answer is yes. JMP has many functions that you can invoke for summing rows, columns, etc. It is is little different if you want to, for example, add cells that are in different rows but it still can be done. In the simple example below, I created Column 1 as a list 1 through 9.

Then I used one of the many built-in functions available in the Formula Editor to square Column 1.

You can add, subtract disparate cells in JMP but it's a little different than Excel. I add the first rows of Column 1 and Column 2 in the Sum Column by typing directing in the JMP file: =:Column1 + :Column 2 (i.e, 1+1=2). To demonstrate addition of non contiguous cells I typed in Row 3 of the Sum column the following formula: =Column 1[2] + :Column 2[4]. This last example adds the element in the second row in the Column 1 to the fourth element of Column 2.

Hope this helps. There are many ways to 'do math' in JMP.

Dave

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

Jan 6, 2016 1:39 PM
(4810 views)

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

Jan 6, 2016 1:46 PM
(4810 views)

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

May 29, 2018 1:45 PM
(644 views)

Can you pls share how you were able to multiply different rows of a column?

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

Jan 6, 2016 1:36 PM
(4810 views)

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

Jan 6, 2016 1:41 PM
(5449 views)

JMP data tables are more structured than a spreadsheet. Each row is assumed to be independent of every other row. So, formulas (math) are applied to an entire column, not an individual cell.

You create a formula column using the Formula Editor.

-Jeff