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
saitcopuroglu
Level IV

How to Cum Mean Row by Row

Hi all,

I have a column which displays the satisfaction percentage and I would like to have another column which takes the Cumulative Mean row by row. What is the script for it?

Many thanks in advance

8828_2015-05-23_14-12-23.png

1 ACCEPTED SOLUTION

Accepted Solutions
ms
Super User (Alumni) ms
Super User (Alumni)

Re: How to Cum Mean Row by Row

New Column("Moving Average",

    Numeric,

    Formula(

        If(Row() == 1,

            :CUSTOMER SATISFACTION INDEX,

            (:Moving Average[Row() - 1] * (Row() - 1) + :CUSTOMER SATISFACTION INDEX) / Row()

        )

    )

);

View solution in original post

3 REPLIES 3
ms
Super User (Alumni) ms
Super User (Alumni)

Re: How to Cum Mean Row by Row

New Column("Moving Average",

    Numeric,

    Formula(

        If(Row() == 1,

            :CUSTOMER SATISFACTION INDEX,

            (:Moving Average[Row() - 1] * (Row() - 1) + :CUSTOMER SATISFACTION INDEX) / Row()

        )

    )

);

saitcopuroglu
Level IV

Re: How to Cum Mean Row by Row

Thank you!

saitcopuroglu
Level IV

Re: How to Cum Mean Row by Row

Hi MS,

Would you please show me how to add "by variable" to the script above?

CSI by Year,

CSI by Year by Agency

CSI By Year by Agency by Month...

Many thanks in advance