Hello,
I will like to calculate the decile (1,2,3,....10) for this list of data 100 rows , I know that I need to order the value then process the formula ((100+1)* n / 10) where n represent the decile ( 1, 2, 3,....10).
After finding the rank for example the first decile will be "10.1" I need to go check the value of the 10 and 11 rank ( because 10.1 is a double) and process this formula : "value of rank 10" + 0,1 * ("value of 11" - "value of rank 10") = value of decile 1
How to implement this formula and calculate all decile value from 1 to 10
I upload a sample data of the 100 rows
Thanks in advance for your help