# compute sum, average, var, std dev, min and max BEGIN { FS=";"; nbr = 0 } /^#/ { print "comment", $0 } /^[+|-]?[1-9]+[.]?[0-9]*?/{ my_array[++nbr] = $1; } END { print "there are ", nbr, "elements" sum = 0; min = max = my_array[1] for (i in my_array) { value = my_array[i] print i, value sum += value if (value < min) min = value if (value > max) max = value } avg = sum / nbr var = 0 for (i in my_array) { var += (my_array[i] - avg) * (my_array[i] - avg) } std = sqrt(var / nbr) print "---------------" print nbr, ";", sum, ";", avg, ";", var, ";", std, ";", min, ";", max }