Shell Programming and Scripting

a b c 1.11112
d e f 4.5767
g h i 19.098
k i l 87.9999

Range of the column: 1.11112 to 87.9999
Total records between 1 and 10 - 2
Total records between 10 and 20 - 1
Total records between 20 and 30 -0
Total records between 30 and 40 -0
Total records between 40 and 50 -0
Total records between 50 and 60 -0
Total records between 60 and 70 -0
Total records between 70 and 80 -0
Total records between 80 and 90 -1

Range of the column: 1.11112 to 87.9999
Total records between 1 and 10.99 - 2
Total records between 11 and 20.99 - 1
Total records between 21 and 30.99 -0
Total records between 31 and 40.99 -0
Total records between 41 and 50.99 -0
Total records between 51 and 60.99 -0
Total records between 61 and 70.99 -0
Total records between 71 and 80.99 -0
Total records between 81 and 90.99 -1

[mute@geek ~/temp/jacobs.smith]$ awk 'NR==1{min=$4}$4<min{min=$4}$4>max{max=$4}{a[int($4/10)]++}END{printf("Range of the column: %f to %f\n",min,max);max=int(max/10);for(i=0;i<=max;i++)printf("Records between [%d, %d): %d\n",i*10,10+i*10,a[i])}' input
Range of the column: 1.111120 to 87.999900
Records between [0, 10): 2
Records between [10, 20): 1
Records between [20, 30): 0
Records between [30, 40): 0
Records between [40, 50): 0
Records between [50, 60): 0
Records between [60, 70): 0
Records between [70, 80): 0
Records between [80, 90): 1

#!/usr/bin/awk -f
NR==1{min=$4}$4<min{min=$4}$4>max{max=$4}{a[int(($4-1)/10)]++}
END{
        printf("Range of the column: %f to %f\n", min, max);
        max=int(max/10)
        for (i=0;i<=max;i++)
                printf("Records between %d and %.2f: %d\n",1+i*10,10.99+i*10,a[i])
}