Quartile funciton...quintile?

[Sarah]

Hi there

1. I like the quartile function but I actually need quintiles. Is there a
way to force the function to break up the range into 5 instead of 4?

2. Instead of returning the value at the top of the quartile (or quintile),
I would prefer it averages the range in the specific quartile. How would I do
that?

Thanks!

 

[Bernard Liengme]

Use PERCENTILE for first question
Note that
QUARTILE(range,1) = PERCENTILE(range,0.25)
QUARTILE(range,2) = PERCENTILE(range,0.5)
etc
It would follow that
"QUINTILE(range,1)" =PERCENTILE(range,0.2)
"QUINTILE(range,2)" =PERCENTILE(range,0.4)
etc