I have a data set which has got Two Columns, named - Product and Value % Change, respectively.
I am looking for some DIFFERENT METHODS which could be used for Ranking this data from 1 to 100, in such a manner that the Highest Positive Value gets the Highest Score i.e. 100 and the Lowest Value " it would be negative value in this data set" should get the Lowest Score of 0.
Can you please provide me some ideas in this regards. What could be various methods that could be used for such ranking purpose.
Any ideas are most welcome. If you could provide any links where such methods are described, then that would be a great help too.
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.