8 Replies Latest reply on Jan 10, 2019 5:52 AM by Christian Setzkorn

    Mean/Averages not calculated correctly

    Christian Setzkorn

      My data is as follows:

       

      UserCombinationValueCatX
      MO1C110a1
      MO1C112a1
      MO2C15a2
      MO2C17a2
      MO2C113a2
      MO3C120a3
      MO1C210a1
      MO1C212a1
      MO1C212a1
      MO3C220a3
      MO3C220a3
      MO3C220a3
      MO3C220a3
      _targetC110b4
      _targetC213b

      4

       

      My current solution is also attached and this is a screenshot:

      Capture.PNG

      The blue line should be the mean of the value column of category (Cat column) = a and the red line the mean of the value column of category (Cat column) = b depending on the choice of Combination (either C1 or C2). This seem to work fine for Cat=b but not Cat=a.

       

      The expected values should be:

       

      Choice C1 => 11.16666667

      Choice C2 => 16.28571429

       

      rather than:

       

      Choice C1 => 13.11

      Choice C2 => 15.667

       

      Can anyone see something wrong please? Thanks.