ExcelBanter - quintiles

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - quintiles (https://www.excelbanter.com/excel-worksheet-functions/211208-quintiles.html)

vishen

quintiles

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

quintiles

Hi,

use percentile and this formula gives the first quintile

=PERCENTILE(A1:A20,0.2)

Mike

"vishen" wrote:

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

Shane Devenshire[_2_]

quintiles

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

"vishen" wrote:

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

All times are GMT +1. The time now is 03:51 AM.