What I Learned Today
Passing Variables to awk in a script

To pass bash variables to an awk script, use -v to turn them into awk variables first:

awk -v var=$var '{print $1 + var}'
Averaging all columns with AWK

From here

Very handy for processing data files:

awk '{for(i=1; i<=NF; i++){sum[i]+=$i}} END {for(i=1; i<=NF; i++){printf sum[i]/NR "\t"}}' file