[Excel] quintile

jean -  
chopine Posted messages 20 Status Membre -
Hello everyone,
I have a problem with Excel and I hope someone can answer. I have been searching in vain for the quintile formula in Excel. Quartiles divide a population into 4 parts and quintiles into 5. If you have any tips to give me, I would be very grateful.
Best regards,
Jean
Configuration: Windows XP Internet Explorer 6.0

1 réponse

chopine Posted messages 20 Status Membre 20
 
Hello,

There is no Quintile function in Excel. However, you can use the Percentile function. If you want to divide a data series into 5 parts (hence the quintile), your percentile will be 20% for the first part, 40% for the second, and so on.

I hope this helps you!
7