average max min bash

bishop2001 · 01-22-2016, 10:52 AM

Greetings
im trying to get the average, max and min of a list of numbers although im seeing something strange. For very example i have the following values in a file and im running the following command: Although im getting the result with a non whole number which seems strange. Suggestions please ?
Thanks

Result:
average max min
0.151515 1 0

command:
awk '{if(min==""){min=max=$1}; if($1>max) {max=$1}; if($1<min) {min=$1}; total+=$1; count+=1} END {print total/count, max, min}'

file:
0
0
1
1
1
0
0
0
0
0
0
0
0
1
0
0

grail · 01-22-2016, 10:59 AM

With the exact same data and command I receive the following:

Code:

$ awk '{if(min==""){min=max=$1}; if($1>max) {max=$1}; if($1<min) {min=$1}; total+=$1; count+=1} END {print total/count, max, min}' file
0.25 1 0

So my questions would be to you:

1. Confirm that the data file has exactly those lines and no blanks?

2. What does awk point to on your computer? (for me it is gawk)

rtmistler · 01-28-2016, 07:52 AM

I concur with grail. My awk is /usr/bin/awk by the way, but the command works.

Debug a bit, not that the logic has any problems with it. But you can print out total and count. I'd check the file. I created my copy just using vi