Variance caclul on each group

[Anonymous]

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.

[Anonymous]

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.

[Anonymous]

Hi @Anonymous ,

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

Best Regards,

Jay