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.

      Regards

      Anurag Gupta