cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Don’t miss your chance to experience Discovery Summit Europe at our best available rate! Early bird registration through 31 Oct.
  • Image to Table JMP extension imports single or batch images as data tables. Useful to extract curves from pictures or convert image data to curve data to use in analyses like Functional Data Explorer. Download and install the extension.

Discussions

Solve problems, and share tips and tricks with other JMP users.
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

Recommended Articles