Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Variance caclul on each group

Hi all

 

In order to build control maps, I would like to calculate the different variances according to the different groups.

In reality it will be after each intervention to recalculate on certain graphs the new variances.

The unwinding of control limits will therefore take place in the form of a staircase.

What I tried:

 

 

Unfortunately, it doesn't work.

Can you help me?

 

Thank you in advance.

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous ,

     

    Please share some sample data so that we could test the formula.

     

    Best Regards,

    Jay

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hello,

     

    You will find following this link the pbix: Test welding handy gauge 412B FF.pbix
    I want to calculate for each group, a variance.

    In this case I would like to calculate the variance of "L1100 RH GAP" of the table [Datas] according to the groups [1;2;...; ...; ...] generated in the table [Henkaten] corresponding to "L1100 RH".

     

    The pbix is not finalized, because without this calculation this pbix would not be useful.

    Thank you in advance for your help.

     

    Kind regards.