Print basic statistics for numeric data input to stdin

stats.sh

#!/bin/sh
# thanks to http://unix.stackexchange.com/a/13779/62529
sort -n | awk '
  BEGIN {
    c = 0;
    sum = 0;
  }
  $1 ~ /^[0-9]*(\.[0-9]*)?$/ {
    a[c++] = $1;
    sum += $1;
  }
  END {
    ave = sum / c;
    if( (c % 2) == 1 ) {
      median = a[ int(c/2) ];
    } else {
      median = ( a[c/2] + a[c/2-1] ) / 2;
    }
    OFS="\t";
    print sum, c, ave, median, a[0], a[c-1];
  }
'
echo -e "sum\tn\tmean\tmedian\tmin\tmax"

Example

Analysing results from Jmeter's "Simple Data Writer"...

$ awk -F, '{print $2}' FPE1_50K_60tpm.csv | stats.sh
1195856 57604   20.7599 19      13      2710
sum     n       mean    median  min     max

Superseded by istats