AnsweredAssumed Answered

Can you summarize a table by one field and the find median value of another?

Question asked by shopk on Apr 11, 2013
Latest reply on Apr 15, 2013 by shopk
I have a table of values collected at various monitoring stations. There's a row for each value with the station where and date when this value was recorded . I am trying to find a way to select all the values that fall within a certain date range and summarize them so there is only one value per station based on the median value. The "Summary Statistic" tool would work if I needed a sum or mean, but it does not have 'median' functionality. I was wondering if there was a python script that acts like the "Summary Statistic" tool but with the ability to find medians.

I'm using 10.0 at the ArcInfo level, any help is appreciated.

Outcomes