3 Replies Latest reply on Dec 9, 2018 5:15 PM by Yinglu Wang

    How can I create bell curve

    Yinglu Wang

      Hello,

       

      I have difficulty in creating bell curve to fit my chart.

       

      I have a calculated field: [compensation_bin]={ FIXED [Employee Identifier]: SUM([Total Compensation])}, and created a bin based on this calculated field.

       

      And I used the bin as x-axis and number of employees as y-axis. See below:

      Screen Shot 2018-12-07 at 15.08.49.png

       

      Is there a way to generate the bell curve? I did some research online but it didn't work for me.

       

      I created another calculated field called Curve:

      (1 / ([St Dev] * SQRT(2*PI()))) *

      EXP(-((ATTR([compensation_bin])-[Mean])^2

      / (2*[St Dev]^2)))

      * 27000

      * TOTAL ([Number of Employees])

       

      But it didn't work for me.

       

      Any insight will be helpful!

       

      Thanks,

      Yinglu