This script will make a new formula column for each selected column in your data table. The formula will be the mean of the column minus 3s.
initdata = Current Data Table();
sc = initdata << Get Selected Columns();
scn = initdata << Selected Column Names();
for(i=1,i<=length(sc),i++,
values = sc[ i ] << Get as Matrix;
m = mean(values);
s = stddev(values);
tmp = "initdata << New Column(\!"Mean of " || Char(sc[ i ]) || " - 3s\!", Formula(" || Char(m) || " - 3*" || Char(s) || "));";
Eval(Parse(tmp));
);
Message was edited by: mewing