quintiles

  • Thread starter Thread starter vishen
  • Start date Start date
V

vishen

I want to find out quintiles in excel sheet (2003 version). Please send me
feedback how to use function for that and what is the method to calculate?

Regards
 
Hi,

use percentile and this formula gives the first quintile

=PERCENTILE(A1:A20,0.2)

Mike
 
Hi,

There is no QUINTILE function, only QUARTILE and PERCENTILE functions. But
you can use the PERCENTILE function to calculate the 20%, 40%, 60%, 80% which
are effectively quintiles.

If that isn't good enough you could create a custom VBA function for this
purpose.

Cheers,
Shane Devenshire
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Quintile Returns 4
Quintile Lookup 3
Sorting into quintiles 1
Quartile / Quintile Function 1
Converting percentiles to quintiles 3
Quartile funciton...quintile? 1
HELP still needed - BOXPLOT OF Deciles 2
using the =page! feature to transpose a row to column 0

Back
Top