Removing top 5 and bottom 5 values

[#1]

Hi,

   I need to find the average of overall experience values every month. The trick is that the average is done by reoving the top5 and bottom 5 values. Eg, if we have 100 values we need to average from 6 to 95. Any ideas on how to do it? Either in scripting or chart expression is appreciated.Thanks in Advance.

[lironbaram]

hei

attach is an example

the text box contains the formula that you asked

[rwunderlich]

See the Qikview Cookbook example "Removing outlier values from a chart dimension." for some options.

-Rob

http://robwunderlich.com