I have some data in excel, which represent the % Performance of 5 different teams over past one year. I am trying to figure out a method by which I can classify the % Performance into 5 different categories, as follows -
I have tried to visually represent the same idea in this image -
Suppose, for some date, Team A had performance of -8 % and Team B had performance of 22 %, then how would I tell if it is best, average or worst performance for those respective teams ?
Can you please suggest some ideas which can be used for such classification ? How would you DEFINE Best, Average and Worst Performance etc. ? Which method to use for such work ?
I am using the following software versions -
Microsoft SQL Server Management Studio version- 12.0.2000.8,
Microsoft Office 2016 x64
and Windows 7 x64
I have attached the Excel File having the data -
Thanks and regards