3 Replies Latest reply: Dec 14, 2011 6:12 AM by fabio+paolo Mazzone RSS

    analysis for six sigma

      Hello Everyone,

      I'm performing a six sigma like analysis on a set of data.

       

      What I want to do is:

      - given a sample as:

      month      value   

      1               4

      1               9

      1               88

      1               99

      2               100

      2               40

      2               500

      etc

       

      I want to count the "value" out of the 3 sigma and mean limit.

       

      I create a simple chart, a straight table:

      - dimension is "month"

      - "ctlimit" is :    avg(value) + 3*stdev(value)

      so far so good

       

      counting against a fixed value is good, e.g.

      - count({$<value= {'<=100'}>} value)

      it works fine

       

      BUT.. if I add a dynamic control the expression does not work anymore

      count({$<value= {'<=ctlimit'}>} value)

       

      what's wrong???

      thank you in advance

       

            f.