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:


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

      Supply 2

      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.