Mean & Std Deviationc

I am trying to calculate the Mean and STDV for a table.  I know that the the "Math Formula" is the correct node to use, but my table is quite large.  I am having trouble doing this in a loop.  

Ideally I would like to go from a table like this 

          Col1   Col2   Col3

Row1    1        4        6

Row2     2       5        8

Row3     2       4        1

to:- 

        Col1   Col2   Col3

Row1    1        4        6

Row2     2       5        8

Row3     2       4        1

Mean   1.67  4.33   5.00

STDV   0.58   0.58   3.61

is there any easy way to do this?
at the moment the math formula node is appended to a new column so the results look like this:

        Col1   Col2   Col3  Mean  STDV

Row1    1        4        6  1.67     ?

Row2     2       5        8   ?       ?

Row3     2       4        1    ?        ?

I cannot get the loop to work to complete this

I would welcome any suggestions.

Stephen

 

 

 

Hello,

Would the Transpose node be a solution for you?

HTH,

Fred

Just use the GroupBy node. This is very powerful for this type of analysis, just dont choose a column to GroupBy, go straight to the second tab in the node.

 

Simon.

Thanks Simon

I did not realise the the 'GroupBy Node' is so powerful.  This trick has saved me countless hours of messing around with loops.

Thanks again.

Stephen