5 Replies Latest reply on Aug 10, 2017 5:36 AM by Vincent C

    How to calculate Min,Max,Avg of  different bins

    pinki sharma

      Hi All,

       

      I have a column rfactor with range -100 to +100 with difference of 10. Which means  i have 20 columns of rfactor like shown below

      rf -91 to -100rf -81 to -90 ......, rf -11 to 0rf 0 to 10 , rf 11 to 20 ....., rf 91 to 100

      I know , we can calculate different max,min,avg of all bins but i want to calculate  a single min,max,avg of all rfactor bins.

       

      Rf_11-20,Rf_21-30,Rf_31-40,Rf_41-50,Rf51-60,Rf_N51-N60,Rf_N41-N50,Rf_N31-N40

      1,3,4,7,44,33,22,67

      8,12,45,345,78,123,67,90

       

      according to above data

      min = 1  , max = 345 , avg = (first calculate avg  per bin then decide single avg)

       

      Sample book is attached. Please help me to achieve this.

      Quick help will be much appreciated.

       

      Regards,

      Pinki Sharma