topic percentage calculation from each 10 row in Discussions
https://community.jmp.com/t5/Discussions/percentage-calculation-from-each-10-row/m-p/62690#M33802
<P>Dear all,</P><P> </P><P>I try to calculate percentage of each row from dividing the mean of each 10 row values. For example at the attached jmp file;</P><P>I try to calculate the percentage of columns written on "Equipment 1 Result (mcg/dose)" such as row 2 value: 43,16 is divided to the mean of the first 10 dose result which is 43,83 and 43,16/43,83*100=98 calculation can be shown on column "Equipment 1 Result (%)" For the second 10 row mean is used for percentage calculation of individual results of second 10 rows. The samething also needed for Equipment 2 results (mcg/dose) and Equipment 2 Result(%). </P><P> </P><P>Each 10 row percentages calculated seperately. </P><P>Is there a way applying this?</P><P>Thanks</P>Fri, 13 Jul 2018 06:54:21 GMTnac2018-07-13T06:54:21Zpercentage calculation from each 10 row
https://community.jmp.com/t5/Discussions/percentage-calculation-from-each-10-row/m-p/62690#M33802
<P>Dear all,</P><P> </P><P>I try to calculate percentage of each row from dividing the mean of each 10 row values. For example at the attached jmp file;</P><P>I try to calculate the percentage of columns written on "Equipment 1 Result (mcg/dose)" such as row 2 value: 43,16 is divided to the mean of the first 10 dose result which is 43,83 and 43,16/43,83*100=98 calculation can be shown on column "Equipment 1 Result (%)" For the second 10 row mean is used for percentage calculation of individual results of second 10 rows. The samething also needed for Equipment 2 results (mcg/dose) and Equipment 2 Result(%). </P><P> </P><P>Each 10 row percentages calculated seperately. </P><P>Is there a way applying this?</P><P>Thanks</P>Fri, 13 Jul 2018 06:54:21 GMThttps://community.jmp.com/t5/Discussions/percentage-calculation-from-each-10-row/m-p/62690#M33802nac2018-07-13T06:54:21ZRe: percentage calculation from each 10 row
https://community.jmp.com/t5/Discussions/percentage-calculation-from-each-10-row/m-p/62889#M33824
<P>Attached is a copy of your data table, with a new calculated version of your Results 1 column. The formula I used is</P>
<PRE><CODE class=" language-jsl">base = Modulo( Row(), 10 );
If( base == 0, base = 10 );
base = (Row() - base) + 1;
:Name( "Equipment 1 Result(mcg/dose)" ) /
Mean( :Name( "Equipment 1 Result(mcg/dose)" )[Index( base, base + 9 )] );</CODE></PRE>
<P>Please note, I did not multiply the result by 100, but rather, left it as a percent, and used a persent format to display the value. JMP will use this format in all of the platforms, making the graphs/reports more readable. If you don't want it used that way, simply add back in the *100, and change the format for the column back to "Best".</P>
<P>I did not include the Equipment 2 calculated column....It is just a very simple change from the fomula listed above.</P>
<P> </P>Fri, 13 Jul 2018 18:00:05 GMThttps://community.jmp.com/t5/Discussions/percentage-calculation-from-each-10-row/m-p/62889#M33824txnelson2018-07-13T18:00:05Z