Shell Programming and Scripting

name	a1	a2	a3
g1	0.8	0.4	0.2
g2	-0.2	-0.6	-0.7
g3	0.1	0.6	0.8
g4	0.1	0	0
g5	-0.2	-0.2	-0.2
g6	-0.1	-0.9	-0.9
g7	0	0	0.2

awk '{ sum+=$2} END {print sum}' rm
0.5

awk '{ sum+=$3} END {print sum}' rm
-0.7

awk '{ sum+=$4} END {print sum}' rm
-0.6

(1/3)*100=33.33% (positive corr)
(2/3)*100=66.66% (negative corr)

$ awk ' NR > 1 { for(i=1;i<=NF;i++) arr[i]+=$i }
> END { for(i=1;i<=NF;i++) { sub("-","",arr[i]); if( arr[i] > 0.5) print "Col"i ":" arr[i] } } ' file
Col2:0.5
Col3:0.7
Col4:0.6

a1:0.5
a2:-0.7
a3:-0.6

$ awk ' NR == 1 { for(i=1;i<=NF;i++) a[i]=$i }
> NR > 1 { for(i=1;i<=NF;i++) arr[i]+=$i }
> END { for(i=1;i<=NF;i++) { if( arr[i] > 0 ? arr[i] : -1 * arr[i] > 0.5) print a[i] ":" arr[i] } } ' file
a1:0.5
a2:-0.7
a3:-0.6