1 Reply Latest reply on Feb 5, 2019 8:28 AM by Shinichiro Murakami

    Calculating Mode

    Mike Arnett

      Hello All,

       

      I am trying to calculate a mode (most commonly filled quantity) within my data set and have read through a few articles on how to do it, but am getting stumped.  Here is what I currently have:

       

      SupplyDateQuantity
      Supply 11/1/195
      Supply 11/1/1912
      Supply 11/2/195
      Supply 11/1/197

      Supply 2

      1/2/193
      Supply 21/2/192
      Supply 21/3/193
      Supply 21/3/193

       

      So with the very simple example above, my mode for Supply1 would be 5 and for Supply2 would be 3.

       

      What is the calculation to achieve this?

       

      Thanks in advance.