cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
zoulanlan
Level I

how to get cumulative sum data?

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
louv
Staff (Retired)

Re: how to get cumulative sum data?

3586_Screen Shot 2013-05-20 at 8.52.47 AM.png

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

View solution in original post

3 REPLIES 3
louv
Staff (Retired)

Re: how to get cumulative sum data?

3586_Screen Shot 2013-05-20 at 8.52.47 AM.png

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

nac
nac
Level III

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? 

txnelson
Super User

Re: how to get cumulative sum data?

The formula specification for JMP 13.2.1 is:

Col Cumulative Sum( :weight )
Jim