2 Replies Latest reply on Nov 6, 2018 2:43 PM by Tony Fahd

    How to compare average of a group compared to the entire population?

    Tony Fahd

      so I am attaching a workbook where i have a list of locations. each location has members attributed to it and their cost. see below. i like to compare average of cost by location to the entire groups.

       

      this is the outcome i like to see. the average of the entire group in terms of cost is $25. so i like to compare that number to each location and do a variance calculations. and if possible add formatting to the variance (green where the group is below the average of the entire group and red where its higher. (not too worried for the formatting piece if it's hard)

       

      any help is appreciated as i am struggling with this one

       

      Desired outcome: