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

    Structuring / Organizing the Data based on Predefined Parameters

    Henry Wong



      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,