
Forums  Search Forums  Register  Forum Rules  Man Pages  Albums  FAQ  Members  Calendar  Search  Today's Posts  Mark Forums Read 
Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here. 

Thread Tools  Search this Thread  Display Modes 
#1




How to calculate what percentage of X value is there in the file?
Input File: Code:
5081 2058 175 8282 2358 7347 6612 3459 END OF INPUT FILE I need to know how to calculate minimum,maximum,average of the values in the file and also what percentage is the values over some user defined value for example 1000 and what percentage of value is over 5000. By using the following command mentioned below i was able to find the minimum ,maximum and average but having problem in calculatung perctangae. Code:
awk 'NR==1{min=$1;max=$1;sum+=$1;next}{if ($1<min) min=$1;if ($1>max) max=$1;sum+=$1}END{print "min: "min", max: "max",NR: "NR", avg: "sum/NR}' INPUT FILE
Last edited by Scott; 12172012 at 02:39 PM.. Reason: Code tags! 
Sponsored Links  

#2




Code:
awk ' BEGIN { max=sum=0; th=fv=0; } NR==1 { min=$1; } { val=$1; sum+=val; if(val<min) { min=val; } if(val>max) { max=val; } if(val>1000) { th++; } if(val>5000) { fv++; } } END { printf "Min: %d Max: %d Avg: %d 1000 per: %d 5000 per: %d\n", min, max, (sum/NR), (th/NR * 100), (fv/NR * 100); } ' filename 
Sponsored Links  

#3




Here is a version where you can Set limits for F1 and F2 on the command line: Code:
awk vF1=1000 vF2=5000 'FNR==1 {min=$1} { sum+=$1; if($1<min) min=$1 if($1>max) max=$1 th+=($1>F1) fv+=($1>F2) } END { printf "Min: %d Max: %d Avg: %d above %d: %d%% above %d: %d%%\n", min, max, sum/NR, F1, th/NR*100, F2, fv/NR * 100 } ' infile 
Sponsored Links  

Thread Tools  Search this Thread 
Display Modes  
More UNIX and Linux Forum Topics You Might Find Helpful  
Thread  Thread Starter  Forum  Replies  Last Post 
Script shell, how to calculate percentage?  likeaix  Shell Programming and Scripting  3  08042011 10:30 AM 
Need an AWK script to calculate the percentage  bobprabhu  Shell Programming and Scripting  8  11072008 04:42 AM 
How can i calculate percentage ??  bobprabhu  Shell Programming and Scripting  6  10312008 09:37 AM 
How to calculate the percentage for the values in column  saleru_raja  Shell Programming and Scripting  3  08292008 03:15 AM 
how do I calculate percentage ?  the_learner  Programming  6  04182007 04:40 PM 
