Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to calculate the deciles from a grouped data

Bitopi
7 - Meteor

Hi Everyone, 

 

I have a frequency table. Can you please help me to calculate the deciles out of the classes? 

 

I have also attached some sample data as an attachment for reference.

 

Any lead will be highly appreciated..!! 

 

Thanks in advance..!! 

 

 

2 REPLIES 2
PhilipMannering
16 - Nebula
16 - Nebula

There's probably a much more elegant way of doing this, but see if the attached seeeeeeeems right...

PhilipMannering_0-1643031371132.png

 

Bitopi
7 - Meteor

Thank you for the workflow. But when I ran the same above workflow for a different frequency distribution, I can see that 2 different decile values are present for the same class interval. Is it possible to have 2 decile values in the same class interval?  

 

I have attached the Sample data and the output that I am getting as an attachment for reference. 

 

Any help will be highly appreciated...!!!!!!!!

 

 

Labels
Top Solution Authors