Is it really so complicated

Since one week I try to calculate the arithmetic mean, Standard Deviation and Variation of coefficient for data structured in Excel file like this:

Name Value 1 Value 2 Value 3 Value 4 Value 5
A 15 7 12 37 2
B 11 1 19 2 22
C 10 20 25 17 12
D 3 5 5 39 30
E 20 38 29 33

40

           

 Output should be like this:

 

            Vallues 2+4+5
Name Value 1 Value 2 Value 3 Value 4 Value 5 MW STABW CV%
A 15 7 12 37 2 13,5 1,5 11,1111111
B 11 1 19 2 22 15 4 26,6666667
C 10 20 25 17 12 17,5 7,5 42,8571429
D 3 5 5 39 30 4 1 25
E 20 38 29 33 40 24,5 4,5 18,3673469

Can anybody send me a workflow?

Thank You

Hi, I am not sure how you would like your values to be calculated. What is MW? It is not the mean?

Did you try using the column aggregator node, it can calculate statistics over rows?

Alternatively you can use the math formula node for arbitrary calculations as well.

Best regards, Iris 

Hello Iris,

I try to calculate arithmetic mean, standard deviation and variation of coefficient. In the column aggregator node I haven't such Options. In the math formula node also I have the Problem to use higher mathematic calculations like the Standard Deviation.

 

Best regards werner

Column aggregator allows for mean and StDev. variation of coefficient in my understanding is just StDev/Mean which you can calculate in the Math Fomula node.

Thanks. I had one column of string type. Therfore mean etc. wasn't displayed.