Calculate Decile (Distribution of Data)

[Tommy23]

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

[ncrlelia]

Hi @Tommy23 

Please find attached my suggestion.

Hope it helps.

Best Regards,

Lelia