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

- JMP User Community
- :
- Discussions
- :
- Re: how to get cumulative sum data?

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

Highlighted

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

May 19, 2013 6:24 PM
(17447 views)

How do I use JMP9 to get cumulative sum data? That is, I want to accumulate data from column COUNT in a new column called SUM,

COUNT SUM

0 0

0 0

1 1

1 2

0 2

Thank you for your help!!

1 ACCEPTED SOLUTION

Accepted Solutions

Highlighted

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

Created:
May 20, 2013 5:55 AM
| Last Modified: Oct 18, 2016 1:11 PM
(20431 views)
| Posted in reply to message from zoulanlan 05-19-2013

Use the Column Formula and enter the above expression using the Statistical>Summation, Row and Column of interest with subscript i

3 REPLIES 3

Highlighted

Use the Column Formula and enter the above expression using the Statistical>Summation, Row and Column of interest with subscript i

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

Created:
May 20, 2013 5:55 AM
| Last Modified: Oct 18, 2016 1:11 PM
(20432 views)
| Posted in reply to message from zoulanlan 05-19-2013

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

Re: how to get cumulative sum data?

Hi

I have difficulty to understand at the attached formula. Could you please explain what calculation is done by using this formula with an example?

Highlighted
##

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

Re: how to get cumulative sum data?

The formula specification for JMP 13.2.1 is:

`Col Cumulative Sum( :weight )`

Jim

Article Labels

There are no labels assigned to this post.