Log and awk

When using the log function of awk, then what we get as a result is the natural logarithmic of the input, like: …$ awk ‘BEGIN{print log(100)}’ …$ 4.60517 So in order to obtain the logarithm of base 10 (or any other base), we just need to divide the result with …

Mean value and standard deviation of a column using awk

In order to get the mean value of column 1 (or any other) you type: $ awk ‘BEGIN{s=0;}{s=s+$1;}END{print s/NR;}’ file In order to get the standard deviation of column 1 you type: $ awk ‘{sum+=$1; sumsq+=$1*$1} END {print sqrt(sumsq/NR – (sum/NR)^2)}’ file or $ awk ‘{delta = $1 – avg; …