topic Re: How to Cum Mean Row by Row in Discussions https://community.jmp.com/t5/Discussions/How-to-Cum-Mean-Row-by-Row/m-p/12491#M11883 <HTML><HEAD></HEAD><BODY><P>Thank you!</P></BODY></HTML> Sat, 23 May 2015 16:41:40 GMT saitcopuroglu 2015-05-23T16:41:40Z How to Cum Mean Row by Row https://community.jmp.com/t5/Discussions/How-to-Cum-Mean-Row-by-Row/m-p/12489#M11881 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>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?</P><P>Many thanks in advance</P><P></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="8828_2015-05-23_14-12-23.png" style="width: 123px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/1584i4B0CF3FE864DADFB/image-size/medium?v=v2&amp;px=400" role="button" title="8828_2015-05-23_14-12-23.png" alt="8828_2015-05-23_14-12-23.png" /></span></P></BODY></HTML> Tue, 18 Oct 2016 23:22:19 GMT https://community.jmp.com/t5/Discussions/How-to-Cum-Mean-Row-by-Row/m-p/12489#M11881 saitcopuroglu 2016-10-18T23:22:19Z Re: How to Cum Mean Row by Row https://community.jmp.com/t5/Discussions/How-to-Cum-Mean-Row-by-Row/m-p/12490#M11882 <HTML><HEAD></HEAD><BODY><P style="font-family: Courier; color: #942193;"><SPAN style="color: #032ce4;">New Column</SPAN><SPAN style="color: #000000;"><STRONG>(</STRONG></SPAN>"Moving Average"<SPAN style="color: #011993;">,</SPAN></P><P style="font-family: Courier;">&nbsp;&nbsp;&nbsp; Numeric<SPAN style="color: #011993;">,</SPAN></P><P style="font-family: Courier;">&nbsp;&nbsp;&nbsp; Formula<STRONG>(</STRONG></P><P style="font-family: Courier;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #032ce4;">If</SPAN><STRONG>(</STRONG><SPAN style="color: #032ce4;">Row</SPAN><STRONG>()</STRONG> <SPAN style="color: #011993;">==</SPAN> <SPAN style="color: #009193;"><STRONG>1</STRONG></SPAN><SPAN style="color: #011993;">,</SPAN></P><P style="font-family: Courier;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #011993;">:</SPAN>CUSTOMER SATISFACTION INDEX<SPAN style="color: #011993;">,</SPAN></P><P style="font-family: Courier;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>(</STRONG><SPAN style="color: #011993;">:</SPAN>Moving Average<STRONG>[</STRONG><SPAN style="color: #032ce4;">Row</SPAN><STRONG>()</STRONG> <SPAN style="color: #011993;">-</SPAN> <SPAN style="color: #009193;"><STRONG>1</STRONG></SPAN><STRONG>]</STRONG> <SPAN style="color: #011993;">*</SPAN> <STRONG>(</STRONG><SPAN style="color: #032ce4;">Row</SPAN><STRONG>()</STRONG> <SPAN style="color: #011993;">-</SPAN> <SPAN style="color: #009193;"><STRONG>1</STRONG></SPAN><STRONG>)</STRONG> <SPAN style="color: #011993;">+</SPAN> <SPAN style="color: #011993;">:</SPAN>CUSTOMER SATISFACTION INDEX<STRONG>)</STRONG> <SPAN style="color: #011993;">/</SPAN> <SPAN style="color: #032ce4;">Row</SPAN><STRONG>()</STRONG></P><P style="font-family: Courier;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>)</STRONG></P><P style="font-family: Courier;">&nbsp;&nbsp;&nbsp; <STRONG>)</STRONG></P><P style="font-family: Courier;"><STRONG>)</STRONG><SPAN style="color: #011993;">;</SPAN></P></BODY></HTML> Sat, 23 May 2015 15:03:58 GMT https://community.jmp.com/t5/Discussions/How-to-Cum-Mean-Row-by-Row/m-p/12490#M11882 ms 2015-05-23T15:03:58Z Re: How to Cum Mean Row by Row https://community.jmp.com/t5/Discussions/How-to-Cum-Mean-Row-by-Row/m-p/12491#M11883 <HTML><HEAD></HEAD><BODY><P>Thank you!</P></BODY></HTML> Sat, 23 May 2015 16:41:40 GMT https://community.jmp.com/t5/Discussions/How-to-Cum-Mean-Row-by-Row/m-p/12491#M11883 saitcopuroglu 2015-05-23T16:41:40Z Re: How to Cum Mean Row by Row https://community.jmp.com/t5/Discussions/How-to-Cum-Mean-Row-by-Row/m-p/12492#M11884 <HTML><HEAD></HEAD><BODY><P>Hi MS,</P><P></P><P>Would you please show me how to add "by variable" to the script above?</P><P>CSI by Year,</P><P>CSI by Year by Agency</P><P>CSI By Year by Agency by Month...</P><P></P><P>Many thanks in advance</P></BODY></HTML> Mon, 08 Jun 2015 14:33:05 GMT https://community.jmp.com/t5/Discussions/How-to-Cum-Mean-Row-by-Row/m-p/12492#M11884 saitcopuroglu 2015-06-08T14:33:05Z