1 Reply Latest reply on Aug 14, 2013 8:40 PM by Joshua Milligan

    Calculating the overall average, then create bins based on that average

    Alan Kwan

      Hi all,

       

      Supposed my data looks like this:

      GroupReading Time (s)
      A300
      B100
      C200
      D300
      A200
      F26
      E15
      R54
      D12

       

      I want to find out the overall average of the reading time across the groups, then create a histogram which bins out how many rows are below average or above average, so that I can identify what % the outliers are.  Additionally, I want a quick filter that I can select for the groups so that I can look at each group specifically against the total average.

       

      How to do this ?

       

      Thanks,

      Alan