Hi all,

I have a data range as follow:

28
33
42
12
9
68
81
55
6
47

Since I want to create Box & Whisker Plot, I need to calculate the median, first quartile and third quartile of above data using AWK.( so far I can only writing a code for determine smallest value & largest value using AWK)

Anyone can help me...Please..

Thanks

Hi,

I would like to know how can I calculate mean, median and standard deviation of some numbers in a file.

Example file:
a 102 abc
b 301 adc
c 222 adc

I would like to calculate the mean, median and standard deviation of the numbers in the 2nd column of the example file.

Thanks in advance

Maybe you should use awk instead of calculator to get the results. It would be much easier to grab the 2nd field an do the math on those.

this will find the mean of numbers

awk '{mean += $2}END{print "mean ="mean/NR}' filename

For the median, you can the answer in this post to your problem. In this case, you will want to change "$NF" to "$2".