2 Replies Latest reply on Jan 7, 2017 6:02 AM by Jim Dehner

    Structuring / Organizing the Data based on Predefined Parameters

    Henry Wong

      Hi,

       

      I have a data set that I'm trying to find an approximate range to where the data gets structured.

       

      Potentially this might be best represented in a bar chart or histogram but I'm not sure how to approach it.

       

      For example on the X axis - bar 1 would be <1, bar 2 would be between 1-3, bar 3 would be between 3-5, bar 4 would be between 5-7, bar 5 would be between 7-9 and bar 6 would be >10

       

      Y Axis would be the # of records

       

      Any idea how I would approach this? Attached is an Excel Data set - I'm looking for [ABSOLUTE GAP SIZE] to be plotted via a structured bar chart or histogram

       

      Thank you,

      Henry