in reply to average of column
perl -MList::Util=sum -E '<>; say sum( map{ (split /\t/)[-1] } <>);' f +ile.tsv [download]