standard deviation (rangestdev) for my values

[#1]

Dear community,

I am trying to calculate the standard deviation for my values but whatever I try (also with this community) it is not workin.

I guess I need to change the table into a crosstable to use the function rangestdev, but I am not quite sure how to do it.

For each month (1.2011, 2.2011) I need the standard deviation.

attached you will find the excel table.

Thanks a lot in advanced

Thomas

[nagaiank · Accepted solution]

The following script works:

Data:

LOAD ArtNum,

     month,

     value

FROM

TB02_20130109_165037.xls

(biff, embedded labels, table is Tabelle1$);

Data2:

NoConcatenate

LOAD month

          , Stdev(value) as StdDev

          Resident Data Group By          month;

Alternatively after loading the Data table, create a straight table chart with name as Dimension and stdev(value) as expression, which also displays the standard deviation.

[#3]

Thank you very much. I did not found this function Stdev but only rangestdev