0 Replies Latest reply on Nov 11, 2010 1:26 PM by James Baker

    Table Calculation: Fractional Rank

    James Baker
      Name:

      Fractional Rank

       



       

      Alternate names:

       

       



       

      Summary:

      This is a ranking function with ties.  Tied items have a rank of the mean of the Ordinal Rank of the tied items.

       



       

      Definition:



      ([Standard Rank] + [Modified Competition Rank]) / 2

       





       

      Compute Using: Table(Across/Down)

       

      Inputs and Setup:

      Standard Rank: An instance of Standard Rank computed using an "Advanced" field from best to worst rank.

      Modified Competition Rank:  An instance of Modified Competition Rank computed using an "Advanced" field from worst to best rank.

       



       

      Example:



      ([Standard Rank] + [Modified Competition Rank]) / 2

       



       

      Commentary:

      Note that the two component table calculations run in different directions. See http://en.wikipedia.org/wiki/Ranking for more details.  Values of 5, 3, 3, 2 would produce ranks 1, 2.5, 2.5, 4.