Newer
Older
BEGIN{
sum = 0
count = 0
}
function compute()
{
sumsq = 0
avg = sum / count
for( x = 0; x < count; x++){
sumsq += ((array[x]-(sum/(count)))^2)
}
print S " " fix1 " " fix2 " " avg " " sqrt(sumsq/(count))
}
{
if($1 == S){
sum += $2
array[count] = $2
count = count + 1
} else {
compute()
count = 0
sum = $2
delete array
array[count] = $2
count = count + 1
S = $1
}
}
END{
compute()
}