Hi,
I am trying to use an statistical formula. I tried in excel, but I get different values when I use calculator.
The formula is
(1/n) |x - mean|
n=no. of observations
x=each individual expression value
mean is median of all observations
I have a file with 1000 rows.. So it needs to calculate the MAD for each row..
input:
12.8165 12.86361 12.65535 12.75554 12.88999 13.12837 13.05147 13.18671 13.2494 13.2906 13.16096 13.04806 12.49505 13.27213 13.13943
12.93171 13.41074 12.16979 13.01464 13.10369 13.78584 13.36401 13.3254 13.20534 13.16263 13.32761 13.27332 13.39617 13.44481 13.3401
I want to give it a try in awk
Thanks,