3 Replies Latest reply: Dec 24, 2013 1:30 PM by Gysbert Wassenaar RSS

    Average Excluding Outliers

      I have a very basic function calculating the average. 

       

      Avg ([Dictation Time])

          

      The issue is I want to throw out the top 5% highest values.
      For instance if I had :

       

      12

      15

      18

      19

      106

      17

      54

      89

      20

      87

      78

      65

      98

      15

      63

      32

      65

      89

      899

      999

       

      We would discard 899 and 999 as outliers and calculate the average
      of the remaining items. Any thoughts on how to do this?