Hi All

I like to know how can we calculate the number of rows and the average of the values present in the file. I will not know what will be the rowcount, which will be dynamic in nature of the file.

eg.

29
33
48
30
28

awk '{ sum+=$1
         rowcnt++}
       END {printf("average: %.2f  rowcount:%d", sum, rowcnt) }' inputfile

This is untested code..

nawk 'NR==1{k=0;Sum=0}{print $1; k=k+1; Sum=Sum+$1}END{print "Raws=" k " AVG.= "Sum/k} inputfile

Thanks...This works
awk 'NR==1{k=0;Sum=0}{print $1; k=k+1; Sum=Sum+$1}END{print "Raws=" k " AVG.= "Sum/k}' input File

But what iam looking for is
Output

<Name of the service> <AverageValue> <Number of Rows>

could you provide us with example.... I dont really understand your request.. what do u mean by name of the service...

Hi Jim, what does %.2f mean?

display two places after decimal point