4 Replies Latest reply: Jun 2, 2016 4:21 PM by Onno van Knotsenburg RSS

    Averaging excluding outliers

    Martin Hommes

      Hi,

       

      I am trying to average a variable called "Days Past Due for Loans" but only taking into account values that are less than 361 days.

       

      The variable is called: [Final Current DPD status]

       

      I am trying to do this through an If statement:

      IF([Final Current DPD status]<361, Avg([Final Current DPD status]),' ')

       

      Is this the best way to take out the outliers from the calculation?