2 Replies Latest reply on Jul 24, 2018 7:31 PM by Zhouyi Zhang

    Quartile Analysis on One Column with Counts of Occurrences in Another Column

    mike.pantoliano

      Hi there,

       

      Long time lurker, first time poster.

       

      I'm trying to do quartile analysis on a set of values in one column, but there's a 2nd column that counts the number of instances of the value in the first. Therefore, the value in column A should count X (column B) number of times in the quartile analysis.

       

      Example:

       

      ValueCount
      1881

      400

      5
      10154
      651554
      65111158
      8972
      11109
      1155
      982
      12333
      44448

       

      Apologies if this has been asked already, I can't seem to find the right search terms to find it!