Calculate Decile (Distribution of Data)
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Tommy23
7 - Meteor
‎08-05-2022
10:36 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Labels:
1 REPLY 1
ncrlelia
11 - Bolide
‎08-05-2022
09:12 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
