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.
Re: Count If Condition, Standard Deviation ,Average
Please see attached. I calculate the average and standard deviation on import, then classify each employee based on how their score compares to the classification system (top performer, bottom performer, etc.)