Example:

// loop A,B for 4 goups: A,B, C,D, E,F, G,H

LOOPBEGIN(A,B: A,B, C,D, E,F, G,H)

    var max = avg([A10.response, B10.response]);         // average of A10 and B10 response
    var low = avg([A11.response, B11.response]);         // average of A11 and B11 response

    var diff = max – low;

    A10.mean = diff;                                     // set A10 mean (C10, E10, and G10)

    A10.result =  100*diff/diff;                         // set A10 result (C10, E10, and G10)

 

    // loop I from column 1 to 0

    LOOPBEGIN(I:1,2,3,4,5,6,7,8,9)

        AI.mean = avg([AI.response, BI.response]) – low; // calculate mean from column 1 to 9

        AI.sd = stdev([AI.response, BI.response]);       // calculate stdev

        AI.result = 100*AI.mean/diff;                    // calculate result

        AI.se = 100*AI.sd_od/diff;                       // calculate se

    LOOPEND

 

    // round all data

    round(2);

LOOPEND

 

Supported API:

  • avg: Average of an array
  • stdev: Standard Deviation of an array
  • rsd: Relative Standard Deviation of an array
  • sum: Sum of an array
  • max: The maximum value of an array
  • min: The minimum value of an array
  • round: round all values
  • LOOPBEGIN(var:list)
  • LOOPEND