quintiles

[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

 

[Mike H]

Hi,

use percentile and this formula gives the first quintile

=PERCENTILE(A1:A20,0.2)

Mike

 

[Shane Devenshire]

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