9 Replies Latest reply: Jan 5, 2015 6:55 PM by matthew thompson RSS

    Count If Condition, Standard Deviation ,Average

      Hi All,


      I am facing a challenge to write expression involving count if, standard deviation and average.  I have the list of employees along with their test scores. I need to club the employees based on their score after normalization.


      Employees Receiving more then [Average Score+ Standard Deviation of Score]  will be Top  Performers


      Employees Receiving less then [Average Score-Standard Deviation of Score]  will be Bottom  Performers


      Employees Receiving in the range of [Average Score-Standard Deviation of Score,Average Score+ Standard Deviation of Score ]  will be Average Performers.


      I have attached the list of sample calculation done on excel.


      Thanks in Advance.


      Anurag Gupta